ChipR,
Im working with excel 2003 and access 2000. Earlier I made it work running one command. I wrote a batch file to open my excel table, and I open the batch by running the command. It is working now, but I still want to figure out the other way.
Did you setup your securty for macros at low? (because I tried that and it didn't work) or did you put it at high and added a digital signature?? (which I didnt try because im...
User Profile
Collapse
-
-
Open Excel from Access Command and auto_open macro
Hi all!!
I need help, I have been stuck for a few days on this one. I am trying to open an excel table from a command button in Access. The excel table has an auto_open macro, that is supposed to run everytime I open excel.
When I navigate to the excel file, and open it, it autoruns the macro with no problems. When I go from Access hit the command, the excel table opens with no problem, but the macro does not auto run on start.... -
Sharing Pivot Tables in Access
I really need help!!! I dont know if its possible to share pivot tables, or see pivot tables in other machines that the one where the tables were created.
This is what happens:
I created a database to track different daily results. In a form in that database I added a pivot table, this table lets me see the results, sort them, and everthing a pivot table should let users do. Below the pivot table on the same form I... -
Thank you guys for the answers!! Really helped me to get things going with this db.Leave a comment:
-
Show Status of Updates to users
HI to all I need help. I have created a database that updates information daily, in order to start the update I have to run three queries (append, make and update). I already added the code to run the queries at the same time with the push of a button, but I would like to display the users information showing if the information was updated correctly. Just a window maybe displaying "Update successful!", that way the users know that the update...
No activity results to display
Show More
Leave a comment: