Search results

I am trying to open a secondary database from within the first. I am trying to use the code that you posted, Maritza. I put it as the event procedure for a command button. But it doesn't work for me. It gets caught on "strDataPath". I don't use VB very often. So, it is difficult for me to...

It seems that I was just making life more difficult than it should be! The real problem that I was experiencing was a faulty relationship. I ran several different tests and realized that it worked sometimes, and not others. The difference was in the cascading relationship in connection with...

Thanks for the reply, but your way is more or less what the database is currently doing. The problem is that I need the query that is appending the Order table (query1) to FINISH BEFORE the second query STARTS. The way the macro/script is read, all of the queries are run at the same time...

The "dialog box" will actually just be a form with an unbound combo box for each of the different parameters for the report. Create a query that has a all the fields on the table with a condition that it equals the value of the corresponding combobox. After the user selects the parameters they...

I am by no means an expert, but I would approach this problem by creating an extra form. The user would press a button with the 'OnClick' event set to open a macro that had 2 steps: save and openForm. The form would then have three buttons: exit db, open switchboard, or return to form (which...

I have a macro that is running a series of queries to append order information to an archive table. Since the order info is held in 3 one-to-many tables (Order, Line, Lot), they MUST run in sequence or else there will be a key violation. In other words, the Order must be written to the order...

Thanks! Thanks guys. I was on the right track, but I just couldn't complete the thought. Thanks for getting me out of my rut. For some reason I couldn't think about how to join the order table and the dispatch table. But now I think I got it. :)

I'm hoping someone will be able to help me get my brain around this problem I'm having! I think its probably simple but I'm just too stuck in it to see out. :eek: So, I have a database (big shock, I know) that is tracking order dispatches. Usually, there is just one order per dispatch and...

No, that doesn't work. That's what I was trying to explain in the last entry. Anyway, I found a solution or should I say a work-around. I simply copied the sql into a new query. And then switched to design view. I am still curious as to why this would happen, but I have found a solution.

I maximize the screen, scroll all the way to the bottom and slowly move my cursor up and down and side to side seeing if I can get it to change into the arrow with points at both ends. Nothing happens. It just remains as the regular cursor arrow. I try to drag the mouse over the area just in...

Yes, I'm sure. That was my first instinct too. I keep thinking that it MUST be down there. But, it definitely isn't. It looks like the person who built the query may have done so in the SQL screen. Is there any reason why this would cause the design grid not to show?

I am trying to finish an Access database that someone else started. In many of the queries, the design grid is missing. In design mode, I can see the tables and relationships being used, but the bottom portion is simply not there. I have tried scrolling to the bottom to check and see if it...