Search results

Ok, if in the future someone has this problem and finds this post DO THIS: CREATE-> MACRO->macro -> ACTION: OpenQuery, Action Arguments: (chose the qry u made) save the macro. add the button and make it run this macro. THAT'S IT! I should've done this hours ago:cool:

yay I'm not the only person with this problem.. I think I'll realy try to do a macro and be done with it. Thanks for all the help!! :)

what I want is to push a button on a form to run the DELETE qry. so I made a table, made a Delete qry like I showed in my first post, and then made a form and I'm trying to put the button on it. so I need to chose the function for button, I chose Miscellaneous -> Run Query, and then there...

I did something called ODBC.. I don't know what ADP is. but I just tried to run a del qry from a form that is based on a DB I made in access, and still it's not on the list!!! Is there something wrong with my computer? lol..I'm starting to think so!

the only user at the moment is me..so I believe I have all the permmisions lol umm, when I make a regular query (no path through), I don't see it on the list. but if I run the qry from the side bar it works fine. Once I change it to path through, I DO see it on the list, but it gives me errors...

SQL server 2005 access 2007...I managed to make the stored procedure..I think lol but I can't find a way to add it to my access...

thank you very much for replying, can you please explain how to do that in more detail or direct me to a place where it's described, I'm kinda new in all of this.

Hello, I have a DB I made in Microsoft SQL server, and I connected it to access, and now I'm making the interface for it. I created a Delete query. I want to put a button in my form that runs this query BUT it's not working! I successfuly done this with selection queries. but when I get the...

Hey everyone, I'm trying to import a table using xml file into my access project. First I exported the table the easy way and saved it on my desktop, and now I'm trying to write a vb code for a button on a form that will import it. I made 2 different codes ( I'm trying!!! lol) in one I write...

thanks for the reply, but can u mark the words that I need to replace? like the actual name of the table I want to export etc. and also what exactly do I do with this code (where to put it?!) and I didn't see any reference to a button click that makes the code run:confused: btw I want to...

Hey everybody! I'll start by saying I'm so happy I found an Access forum!!:eek::D Because I need some advice from people who know Access!:o I need to export 3 tables to an XML file. Just to let you know- I know nothing about XMLs and just started using access. I know I can do File-> Export...