Search results

Hi, I'm importing from Excel to Access using the DoCmd.Transferspreadsheet command. It works except when there is an apostrophe in the Excel worksheet name. Is there a code to automatically remove the apostrophe? Please help. Thanks.

Hello, I constantly have to import an excel file to Access. In this file it has a field called Region. This field has numbers in it such as 3000 then several blanks than 3095 then several blanks, etc. I would like to replace the blanks with the same number that it follows such as 3000 should...

Hello, I'm getting the following error when I'm trying to create a graph: The Microsoft Jet database engine does not recognize '[forms]![frmname]![comboboxname]' as a valid field name or expression When I run my select query it works fine. I have used/done this before without any problem...

Hi! I used a field called Date by mistake in my database. Some of the users are getting #NAME? when I put Date() as the default value so I changed it to NewDate. Now I'm getting "Enter parameter value - Date" when I run the reports. I have changed all my queries and grouping in all the...

Hi! I have a main form with a subform. I would like to get a total from my subform to put in a field on the main form. I tried the following but it doesn't work: forms!frmmain!sfrmsubform.form!total Please help. Is it possible to get the default value from a query instead of the above...