Search results

I am using the DoCmd.TransferSpreadsheet function below and it works fine except it uses the QueryName to Name each Tab of the SpreadSheet. Is there a way to give the Query an Alias Name so I can have each Tab of the Spreadsheet Named something more meaningful? Below is my code Private...

Unfortunately not.......

If I have a Qry with more than 65,000 rows how can I export it into excel and have any rows after 65,000 drop into another worksheet in the same workbook? Any help is greatly appreciated.....

I have created an Access Project and I am trying to connect to SQL Server Express 2008 and I am getting the following Message: The New Database Wizard only works with Microsoft SQL Server (Versions 6.5 SP5 or Higher). Please log onto a SQL Server data source. Anyone have an idea what I can do...

I am trying to execute a data definition Query that will change the data type in one field of a table and I am getting the "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" error message. I don't really want to permanantly change the registry cause I don't feel...

Thank you!

I want to only show records in the first query that don't exist in the second query. However I am getting a syntax error 'missing operator'. I can't figure out where my syntax is off. SELECT [1 Sum with Unique Key].Key1, [1 Sum with Unique Key].Patient_Name, [1 Sum with Unique...

I have a macro that is producing the error message: '3274 External table is not in the expected format' when it gets to the line of code that exicutes the 1st Transfer Spreadsheet method. Below is the code I am using: The only change is I.T. installed Excel 2007 along with 2003. The macro...

I set it to low and clicked Save and closed the db. when I opened the db is was set to medium again. How can I get the change to save?

How do you disable the Access Security Warning that pops up whenever you open an Access database? Attached is a snapshot of the warning.

Excellent, thank you Bob!

I have a series of Access Databases that I run reports out of each month. I would like to set up an excel worksheet from which I could kickoff all of the queries, is this possible and if so how? I don't want to return the results back to excel, I simply want to kick them off using a button in...

Thank you for your replies, I added the Username in the Path string and it worked! Again many thanks, I don't know what I'd do without this site......

Below is the code I am using. I am trying to create a workbook and export queries to the workbook but I am getting an error stating several possible reasons: 1. Path doesn't exsist 2. File is being used by another program 3. Work book I am trying to use has the same name as an open workbook...

How do I initially get the name of the current database I am in using vb code?

I would like to set the Dim of a variable to the Name of a database. Basically the name of the database is "Grp 11 BDR" I would like to be able to extract the "GRP 11" from the name of the database and use it in the name of an Excel file I am creating so it will look like this: xlBook.SaveAs...

I used the NZ() Function and it worked like a charm..... Thank you all for your suggestions, I appreciate it......

I am using a form to prompt a User for a Group Number and Referring Location. Once the User Enters a Group Number and Selects a Referring Location they click a button and an Excel workbook is created and named using the Group and Location they selected on the form. I am using an If function to...

For some reason the code below creates the Excel Workbook and then stops and doesn't continue on to the Docmd statements. Am I missing something after the the SaveAs statement that saves the workbook and names it? As always, any help it greatly appreciated Private Sub Command3_Click() Dim...

sorry I was using quotes around the variable.... It worked like a Charm! Thank you both for your help, I appreciate it.