Recent content by seashton

OK, I figured out the Union query and it is working as it should but how do I add the "SharePoint linked table name" as a field so I can identify which table the record originated from? Can the Union query be used to update my master table and then add the "SharePoint table name" as a field in...

What is the best method to use? I have been tasked to retrieve all the data from many SharePoint tables (anywhere to 30 to 100 tables that I have found so far) and they all have identical field names and there are no primary keys. These tables contain supplier surveillance records from many past...

Thanks, I'll try that...

Modifying Bob Larson’s code… his code works fine, but I would like to modify this code a little so I can export to sheet2 of a specific “named excel file” so I can link certain sheet1 cells to the sheet2 cells I just exported in from access. Can someone help me on what to modify in the code...

THANKS...The code works fine, but I would like to modify this code a little so I can export to sheet2 of a specific named excel file so I can link certain sheet1 cells to the sheet2 cells I just exported in from access. Can someone help me on what to modify in the code?

I have a Customer table of products used which uses 14 Yes/No fields and I want to use one report that will show all customers that uses a specific product but the report should also show all the other products those customers use. The report I made opens a form with a list of all the yes/no...

Found answer... Disregard last request, Found that the "Default Database Folder" needed to be updated also under Tools / Option / General tab. Thanks anyway javascript:smilie(':)') smile

Need help ascertaining why after changing folder names (shortened) that I am consistantly am getting an error message when opening the database(s) that are linked. The message: "Microsoft Access cannot change working directory to... (gives old path folder names). Verify that the drive is valid...

You are correct, the table's records are deleted first and then the query re-runs requiring a new date range criteria be entered and that data is then used in a report. If I enter the same date range again a different set of records are found, but they are still 20 records apart from each...

Delete & Re-Create an AutoNumber Field Is it possible to Delete & then Re-Create an AutoNumber Field using code so it will start numbering with 1 again. I will then use this table in a query to ascertain the the 20th record to post in a report. It works but when I Re-run the query I get a...

Where is "allow shortcut access key" setting located at? I looked under Tools/startup and did not see it there and it is not under the "advanced" button of the Startup either. I am using Acess97.

Is it possible to stop a user from using the keyboard shortcut (ctrl "P") to print the report they are viewing? I want users to be able view reports but not print them. I have eliminated the print icon and the file menu/print function but do not know how to stop user from using the keyboard...

Does anyone know how to stop a user from using the keyboard print command (ctrl "P") on Report Preview. I want users to be able view reports but not print. I have eliminated the print icon and the file menu/print functions but do not know how to stop the Ctrl "P" keyboard command? Thanks

I don't know if this is possible or not but I want to add "all the data from a field from all the records prior to the current record" on a single form . Then "the result of this calculation would be used in another calculation on that same current record. How can this be done? Any help or...