I am going to post this again. I haven't had any response and with the amount of post daily I think I may have been missed. My database has roughly 40...
I need to import data from one database into another. The dbs are near identical, but there are dozens of tables with lots of records in them. How can I do...
Yes it is quite an old form. I was thinking of re-doing it by copy/pasting all the controls and the code over to a new form, but unfortunately there are...
Clive, got in early this morning and found your reply - that did it! thanks. I had attempted something like this - but was putting the quarter first. That...
While working on one form (main form), I call another form to work on (not a subform). When I call the second form, I minimize the main form that was open....
If you are using a button to switch between forms, you could apply the following code to the button's on click event: Form.Visible = False This would make the...
Thanks for the welcome. Yes I was thinking more of a push scenario with the other message. (I would have replied to the other one to keep the thread together ...
It always helps us if you post the code you have so we can show you how to edit it, but I'll give it a stab without yours. From the Main form that is opening...
Hmmm... without an idea of your schema it may be hard to give a definitive answer. In situations that I have been in that I needed to do similar things I have...
It would help to know what event you are using to minimize your "main form". If you are clicking a button on your main form that opens another form, you can...
Gav When you import a table, you get the table itself. You don't have the option of data only. You could do it using code, but the time it takes to write the...
Thanks Bill, I was copying and pasting the data from one db to another, as I had updated the forms, but needed to re-split the database with the new interface...
John, Okay, I'm back at this. Will this code work against a form that has linked subforms then? Is there some type of "virtual query" that happens that my ...
Hello all, I have been recently experimenting with splitting my database into a front end and a back end for multiple users. I have a quick question regarding...
I am guessing that you have a foriegn key that matches the primary key in your tables from what you have said. In the relationships window, right-click on the...
This is a repost. I am looking for a sample of a db with a Bill of Materials (BoM) system. Or, I am looking to talk with someone who has experience with this. ...
<embarassed type="slightly">Oppps... I was looking in threaded view and replied to a message that was a few years old. </embarassed> ~Jamey ... want. ... other...
Not sure I like that query, but if it does what you want then I wouldn't screw with it. However, I note that it doesn't return the person I input. In any...
Hi, I'm have a query form that has the following: Site name: (dropdown list) Beginning Date: End Date: Engineer: (dropdown List) I would like the user to be...
Cheryl, I do this all the time. What you need is a Form with some text boxes (or combo boxes or whatever) which will create the SQL statement (query) which...
Cool thanks. I will look into that. As far as the query goes, I would love to know a way to improve it. I know that I will need this to go at least 10 levels,...
Hi Linda, Thanks. I will give it a try with my form. Cheryl ... boxes ... (query) ... behind a ... [Supplier], "'", ... [CustName], "'", ... end ... Then ... ...
Put your relationshps in the back end and they will appear in the front
end. The reverse will not happen. Steve
________________________________
From:...
Adam, There are a couple of BOM samples here http://www.mvps.org/access/resources/downloads.htm Darrell ... [Non-text portions of this message have been...
Well, I've never had to do this type of recursive thing, but it was interesting enough to play with. I've uploaded an updated version of your file to the file...
Thanks. I knew there had to be a better way. I just now have to figure out how this module works. I am very new to VBA and I will need to rework this to fit my...
On a form I have a combo box with the data coming from a query with 2 columns one with name of employee and the other with wage. Now I am trying to have...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
