Search:

Um ... not a good assumption.

By default nothing is trusted. Every folder and/or file must be explicitly trusted. This can be done manually or by executing trusted code. It is also by user...

The original answer was may partially correct. They said "...the second method the combo box is looking at a form based on a select query not a table ..." which is not a problem if the select query...

That really is not correct. A table can be empty, no records to look up, and it works. If the record source is a query (saved SQL) it works. There is a "bug" in the Access Combo box wizard. The...

Does the issue happen on multiple PCs with 2010 or just one PC?

It would help to know:
Are the databases split?
Are the front ends on the local hard drive?
Are the database in a trusted...

From within Access you can call a Windows API to get the current user. See: http://access.mvps.org/access/api/api0008.htm

I use this to auto log in to Access apps. I get the User name at start up...

I have seen forms and report become corrupted. You can try repairing the forum using this: Backing up and Restoring Objects I have had success repairing corrupt forms and reports with thi8s method....

That is only true if a Full versions of Access is not already installed.


Thee issue is with Access starting. It has not even go to the point of loading he database when it ask for the License...

I would urge you to run the Office Setup to see if Access was part of the install. Until you verify that it will be impossible to help you.

Did you first run the Office setup and make sure that the Full version of Access was not installed? If it is installed you will nee to remove it before you install the Access runtime

I would not recommend that as a good method for deployment.

I would highly recommend that you compress the database into a ZIP file before burning to a CD/DVD. This done outside of Access.

It...

When you compact, it is important to do both the front end and back end.

When I make back end changes, like add a date field, I do the following:

1) backup up the back end
2) Add the field....

Yes, I have seen it with the Home and Student. As far as I know this is try of all version of Office 2010 that do not include a license for Access.

FWIW: I have tried the built in Package and...

I do this using VBA and Outlook automation. The key is to set the body type to HTML. I loop trough a recordset and write the data into the email body using HTML Table tags to create the grid. You...

I understand that the MS Office Home & Student version is not a trial version. I was referring to Access only being a trial version. With MS Office Home & Student and MS Office Home & Business 2010...

Sounds like the trial version of Access was installed with the MS Home and Student Office. Try running the setup for MS Home and Student Office and remove Access if it was installed.

What database format? Also is it a web database?

I just looked in both a .mdb and .accdb and the default property is on the data tab for text box controls. Just like in 2007.

With which ...

See if this helps: How to reset the page number and the total page count for each group in a Microsoft Access report

Beej,

It is true a "typical" (common) use of a form/sub form is to show parent/child related child records. But it doe not have to work that way. A sub form (or sub report) does not have to show...

For the the most important reason to manually compile is make sure there are not errors when you can create a mde/.accde. I would never deploy an Access app without compiling it into an mde/accde.
...

It was easy to fix. I turn off the page header and footer on each sub report.

NOTE: If you view the report in Report view this sub reports will probably always show. They will auto hide properly...

Not sure why you need all that VBA code. I have never had to use any VBA code to do what you want.


:confused: I do not understand what this means.



Which event? I have never had to do...

Are the sub report control's Can Shrink property set to Yes? You will also need to be sure that each section that has a sub report is also set to Can Shrink = Yes.

If your database is opened every day then it could be set to send the emails the first time it is launch on a specific date.

You could also use the task scheduler on a Computer that is always on...

For efficiency I would use this:


Public Function StripHTML(zDataIn As String) As String

Dim iStart As Integer
Dim iEnd As Integer
Dim iLen As Integer

  really needs to be replaced with a space.

Try:


zDataIn = Replace(zDataIn," "," ")