Ok spoke to soon.
Access doesn't like a database object in the sourceobjectname (DB). It appears to be looking for a table name in the current database.
I am having trouble finding code to make this work.
I need to export a table from one backend database to another backend database in code. The code needs to be run from the front end database. If I use the DoCmd.transferdatabase It transfers the link table deffinitions not the backend table...
I tried defining the parametes in the query and that did not solve the problem. If I export the query to a Excel file I do not have an issue. This seems to be an Access limitation, Microsoft sugests using a query like this (in the Northwind.mdb sample)
SELECT * INTO...
I have a query that I need to export to a .txt file. The query uses three fields from a form to identify which records to export. When I try to export the query to the .txt file I get a "Too few parameters. Expected 3". I know this is a result of the information from the form, when I hard...
Runing a query is not an option there is not a way to identify records 25-31 from the rest of the records. What I am trying to do is simlar to what happens when you use delete records. I can slect records 25 through 31 by clicking on the record selector for number 25 then holding the shift key...
I thought about using an iff statement. The problem I am running into is how to identify whish records were selected by the user. If I have 50 records that display on the form, and I only want to select records 25-31, I can highlight the record selectors for the records that I want to change...
I have a contionus form bound to a select query for a table. In the table I have a Yes/No field. I want to be able to select a range of records in the form, then update the YES/no field to yes for the selected records. A similar effect as highlighting 5 records then hiting the delete key. I...