Search results

Pat, How do you determine or find the names of relationships between tables? I looked in the Relationships menu and could not find anything.

Interestingly enough, they DO work without the semi-colon at the end..... turned out my problem was solved by putting brackets around my table names and around my field names.

I've got a piece of code that contains a few queries. My problem is that some of the queries work, while others give me a "Syntax error in INSERT INTO statement" message. I'm going crazy trying to figure out why some queries work, but others don't. If someone could take a look and offer a...

I had problems similar to this several years ago with Access 97. The cure was to remove MS Office, and then, from the Microsoft site, download a program that also cleaned out MS office items that did not get removed, and then reinstall MS office. Have you checked to see if MS Office still...

mstcyr, Thanks for your reply! What I ended up doing was writing a Visual Basic snippet of code that took care of what I wanted to do. However, I will save your suggestion for other times in the future that I'm sure will come up. Thanks again, and have a great day.

I have two tables..... one table is my "master" table, and the other table is a table of all of the records I want to delete from the "master" table. I tried setting up a query where I match up the records and then running the query to delete records, but it did not work. Does anyone out there...

Hi, Jerry..... What I ended up doing was putting my queries, related tables and modules into one .mdb, and then manually opening up each of the other .mdb's and copying in a module I had made from that one .mdb. In turn, I would run the module that would copy in my needed items from that one...

Jerry, I don't quite grasp what that'll do, but I'll play around with it and see what gives. Thanks so much for all your willingness to share knowledge and to offer help!

Pat, Thank you so very much. Sorry I didn't respond this last Friday. I appreciate your willingness to help others.

Jerry, Sorry I didn't get back to you on Friday. Question.... Will what you suggested take care of the transfer database issue I encountered? The reason I ask is because you advised to make a Make Table query, and my problem was with the transfer command. And again, thanks so much.... I...

Pat, Thank you so very much!!! That was the code I was looking for! Another question...... I have a project comprised of about 150 .mdb's. How would I, within a .mdb, cycle through those 150 .mdb's and in turn delete a certain relationship in each one? I only ask because I just don't want...

I know you can manually delete table relationships in an .mdb, but I was wondering: Can you programatically delete table relationships? If it is possible, how would it be done? Thanks in advance to all you nice folk who reply.

Hi, Jerry..... I got the thing I've been working on to loop through my databases, pull in queries, modules, run all the queries, modules and stuff I needed to run. However...... when I tried doing the Transfer Database Export function to export out my newly altered table back to the database...

Jerry, Sorry to bother you again, but..... I've got another "fun" headache and I'm hoping you can help me out once more..... I've got a bunch of Access .mdb's and here's what I would love to be able to do automatically for all of them: Do while I've got a bunch of .mdb's Add a field to a...

Thanks!! I'll play around with that and see what comes up.

How might I go about inserting a new field into a table programatically? What I want o tbe able to do is: Open a table Insert a new field, including its type (char or num) and length Thanks to all of you fine folks on this wonderful forum!

Jerry, Just wanted to say thank you so much for your help! I was able to modifiy your code and queries successfully. You saved me several hours of headache and heartache. Thanks again! :)

Jerry, If it's not asking too much, would you mind sending me one of your append queries, perhaps "qryLCP_Append_SupportSales?" I'm havng a bit of a quandary on making the connection between the code you sent and the append query. Thank you so much! Looking forward to your reply:)

Thanks for your reply! I'll modify it and give it a shot. That was fast! And appreciated..........

I have a project that contains about 200 very small .mdb's. For reasons that make no sense, I have to keep all these little .mdb's separate. What I'm interested in doing is to run a query against a table in each of the .mdb's and if I find a certain record in the table within each .mdb, have...