Search results

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

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

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

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

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

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