Search results

Apostrophe in Excel worksheet name It looks like you are replacing the name of the table to "TFN's 3Q". The actual name of the table is "Toll Free Inventory". "TFN's 3Q" is the name of the Excel worksheet. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TFN's 3Q"...

Apostrophe in Excel worksheet name It is failing because the name of the worksheet of the excel file that I'm trying to import has an apostrophe in the name. The name of the worksheet is "TFN's 3Q" instead of the usual "Sheet1". Please help.

Apostrophe In Excel Worksheet Name This is the line that's failing: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Toll Free Inventory", "c:\Tiger\Marita\Sears\Test.xls", True, All, useoa

Apostrophe In The Excel Worksheet name Hi, I already have double quote in between the file name. My syntax is below: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Toll Free Inventory", "c:\Tiger\Marita\Sears\Test.xls", True, All, useoa Please help. Thanks.

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...

Hi Paul, Yes, the graph is based on the same query that works fine.

Yes my form is open. That's why my select query works fine. Any idea?

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...

I ran all my queries and it's all ok. I double checked my grouping in the report and it's also ok. There is no field called Date anywhere. Only when I run the report that it is being asked to enter the parameter value. I don't know where this is coming from? Help.

Hi Rich, The #NAME? is not the issue. Only a couple of user out of 23 were getting it and I think it's because I used Date as a field and this is a reserve word in Access. The problem I'm getting now is the "Enter parameter value - Date" that keeps popping up eventhough I'm not using Date as...

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...