Search results for query: *

I have some code that runs when a user click the close button at the top of the form: Private Sub Form_Close() If IsLoaded("frmContactdetails") Then DoCmd.Close acForm, "frmSelectfromINvoiceListing" DoCmd.OpenForm "frmContactDetails&quot...

Dear All - I need help! I am trying to make a show a folder in Outlook as an Address Book using the following code: 'Add folder Set myFolder = myFolders.Item("All Public Folders").Folders.Item("Report Distribution") myFolder.Folders.Add stOfolder, olFolderContacts 'Make...

I currently have a make table query doing this job and it works fine. But now I want to pass a variable (lastupdate stored in a table) to the query and can't see how to do it? Can I replace the query with VBA? and that way pass it the variable? Any and all help would be appreciated. Thanks Nicky

The problem is this. I have a main form with a company id (comID) and two subforms: subContactsbyCompany and subSubscriptionsbyCompany. These subforms each have their own SourceObject i.e. two separate queries which link to the company ID in the main form. Each form works individually. But...

Hi, I'm trying to use the Undo example in Microsoft Help (see below) on a form to reset the values of txt controls but keep getting the following error: Run-time error '424' Object Required Can anybody help me? Poctok *** Example from Help - Private Sub cmdUndoEdits_Click() Private Sub...

I am importing excel spreadsheets into access using a static filename - this all works fine. Now I want to be able to let the user choose the file to import. I can do this with a text input box but would like to let the user see the file selection window - let then use the window to select a...