Replies

Al,

In the 64bit version of Windows 7 you have two Program Files directories. One for the 32bit applications (ProgramFiles(x86)) and one for the 64bit applications (Program Files).

In the On Open event of the form, put the following code:

Code:

If Me.Recordset.RecordCount = 0 Then
    MsgBox "There is no data"
    Cancel = True
End If

No problem Silverback. As long as you haven’t lose anything.

I’ve tested your code and I have no problem. Can you post a stripped version of your DB where the error occur ?

In the format property you can enter 4 formats separated by a semicolon. the fist is for the case the field is positive, the second if the field is negative, the third if the field is 0 and the forth if the field is NULL
Something like $#,##[GREEN];($#,##)[RED];”Zero”;”Null”

See if the function TotalField2 in the Module1 if the attached DB do what you want.

I’ve moved this thread to Beta Software

Hans mean the Tab Control on your form:

Then I think you’ll have to use automation to open Outlook from within Access.

Have a look at Link Outlook contacts to an Access database – Help and How-to – Microsoft Office Online.
When finished the linking, you can use the linked contact table as any ordinary table.

Note: Office 2010 is BETA and all beta questions should be in http://lounge.windowssecrets.com/index.php?/forum/69-beta-software/

I agree Dave, Moved to Beta Software

I have no idea how it come that you don’t have code in the archive DB’s. It is totally impossible that when you delete code in one DB, it also disappear in another DB.
The only ways to remove all the code from a object (form or report) is
1) in the VBE press CTRL+A end then Delete
2) in design view set the property Has Module to No

I’m out of idea here.

Just thinking. Are you sure you have imported the object from the old DB into the new DB, and not from the new one into the old one ?

Deleting the code in one DB will not affect another DB. Do you have a third copy of the DB or a Backup ?

In the Project Explorer window, have you double click on the object name ?