Search results

I have searched on the internet and found a link that looks promising http://superuser.com/questions/41877/microsoft-access-there-was-a-problem-sending-the-command-to-the-program Let us know if this works for you.

Private Sub MySub() Dim lngCount As Long Dim strCriteria As String strCriteria = "[Nom]" = True strCriteria = strCriteria & " AND [ID] = " & Me.[ID] Debug.Print strCriteria lngCount = DCount("*", "XXX", strCriteria) Debug.Print lngCount 'other code here to use the value returned from lngCount...

Here is a link to my favorite search form - I use this in all my apps. http://www.allenbrowne.com/ser-62.html

I see this message when I have been using A2010 and then I open A2007. After I click OK, Office 2007 installer runs and I can open the database I want using A2007.

You can pass the CaseID as OpenArgs with the open form method. When the form opens it sets the Default Value of CaseID to what is passed in open args. In the before update of the opened form, set the value of CaseID to the default value. DoCmd.OpenForm “InspectionFormName”, , , , ...

Perhaps you can trap that error in the form's error handler. Create an event for the form's error event and put Debug.Print Err.Number, Response Put a break point on this sub and run the form to see if it gives an error here.

Have a look at this code - it prints table properties to the immediate window. http://www.allenbrowne.com/func-06.html

Here is one way - not quite sure if this is what you want. There is a sample search form with a text box for start date and another textbox for end date. When user clicks in the start date textbox a calendar pops up, user selects a date and it appears in the start date textbox. Similar textbox...

From your description it sounds as if you could use the after update event for the combo - I assume you have code for this event? Check for null values like this: If Not IsNull(Me.[ComboName]) Then 'code to do something here Else 'trap the null value here and do nothing End If...

tblIssues, tblIssueDtls and tblIsuItems are the main tables. tblCountries and tblIsuCategory are lookup tables. To make a form with tabs, you can start with the wizard-created main form based on tblIssues. Delete the subforms and put a tab control on the form. On the first page of the tab...

Use an error handler to trap that error, or instruct the users to press Esc to when they want to delete a wrong selection from the list or let the users put up with the error message. Do you have any code associated with this? If yes, post your code so we can show how to use an error handler...

If you have error handling for the NotInList code, set it so that the error number you get for trying to select a null value is ignored, or just use Resume Next for error handling for that sub.

My other suggestion is to use Access and vba to make a copy of the csv file after it has been updated and before it is overwritten. You can use FileCopy - look in vba help for FileCopy.

If you have the option to overwrite the data in the CSV's - this would be the easiest way to put new data into the same CSV each time without writing any code. To prevent duplicates - easiest way is to look at the access table that stores the imported info from the csv. See if you can create a...

Easy way is to create a table called tblEquipment - autonumber primary key and a text field for the equipment type. It will have 3 rows - laptop, licence and peripherals - and you can add more rows later if you get different equipment types. Use tblEquipment to create the sql for the first...

Yes, that is the same thing that I am saying. If the OP doesn't have any way for the switchboard form to know the values to place in the OpenArgs, it won't work.

Yes, you can pass the parms from the switchboard - but only if you already know what the values are for both parms. 'start code ------------------ Private Sub BtnName_Click() Dim strArgs As String strArgs = "xx" & "|" & "yy" DoCmd.OpenForm “[FormName]”,,,,,,strArgs End Sub 'end code...

This is called synchronised combos. Do a search on Access World Forums for 'synchronise combo' and you will find plenty of posts about this.

You can put buttons and code on forms, but you can't do that with tables and queries. Perhaps the easiest way is to simply click on the table to bring it in front of the form.

Here is a link to my favourite search form http://www.allenbrowne.com/ser-62.html I use this search form in all of my apps.