Search results

I have a problem where I was trying to create a Macro to open a Excel dcoument from Access and run the Excel Macro, all from switchboard. And it works. When I activate the Macro from Switchboard the Visual Basics screen appears and have have to press the play button for it to work. Is there...

I am trying to create a macro that will open and excel file and run the excel macro, and then run the Access macro in the data base. I currently have the macro built in excel and it runs perfectly. Not sure if it matters, but I am transferring data from text, to excel, and then importing the...

I have 4 different sites with their own data source and have created 33 Queries for the first site. Is there a way I can copy the queries to the other sites instead of recreating them manually? All sites have their own data that is in the same format. All the information is in the same format...

I have a data base of over 40,000 accounts. When I run my quires I am able to find accounts that may have errors and have them reviewed. Is there a way to exclude those accounts when the query is run again? Something like a table of exceptions to the query? I am unable to remove the data from...

I am rather new to access and only have a public education, so be gentle. My problem is I have made two tables within access. The first one is names and other information (5800 accounts). The second one is names and phone numbers (2300 accounts). The names are in the system exactly the same for...

I am rather new to access and only have a public education, so be gentle. My problem is I have made two tables within access. The first one is names and other information (5800 accounts). The second one is names and phone numbers (2300 accounts). The names are in the system exactly the same for...