Search results

Oh, yes, of course! Thank you very much. I guess it was just too obvious. :)

Btw, the weird thing is, if I open the form in Add mode, it does go to the foreground. Or is that because the Add mode makes my form a pop-up type form?

Ah, that's a neat idea. How then do I make an entire form in/visible? Just like controls on a form? And once the board is invisible, will it still be in front of my form? In other words, instead of clicking on the form to edit something would I actually be clicking on the invisible switchboard?

Ok, thanks. So is there another way, or is making my edit form into a pop-up form my best bet?

How can I tell it to do nothing after the Then statement? I only want to check silently if records already exist. If they do, nothing is to be done, but if they don't, an action is to be performed. Never mind, I found a solution.

It's wizard built. If I make my other form a pop-up form, will that cause problems with other pop-up forms that may get launched from that form?

Hello, I have a query where I would like to include names from a name table. The problem is that I get this "ambiguous outer joins" error when I try to include it in my query. I have a main table, the name table, and a join table with the IDs from both of the other two tables in order to model...

You could always just enter the date as text in a text field, could you not?

Of course then you have to make sure that the users get the new version of the front end after you've made changes to it.

Hello, I use my switchboard to launch a search form, which then starts another form to edit records. Everything works fine except that after I click on the record I want to edit, the switchboard window not only remains open, but also is in the forground in front of the record I want to work on...

How are you entering them into the table then? I don't have Publisher, so I used a PowerPoint file, a PDF file and a JPG file for a little test - in all three cases just dragging the file into the table worked. Dragging also worked when I used a form for data input.

Hm, if you want to create a standalone "program", then you may need to look for help in a programming newsgroup. With Access, you can create forms that access other SQL dbs, but for this to work, all users have to have Access installed on their computer. Or you need to purchase a special version...

Oh man, those are a lot of different questions. Let me try to answer some of them. Forms are used to enter data into your database, and also to display some information. One way of looking at a form is actually called the Datasheet View, which does resemble a spreadsheet. You sound like you...

No, Publisher ought to behave just like any program that has its extension registered. That's handled by Windows, not Access. That the program opens but not the document sounds to me like Publisher can't find it. Where is your hyperlink? In a table or on a form?

Oh, and by the way - "final solution" doesn't sound so good since that term acquired a certain notoriety about 60 years ago.

Glad I was able to help. That guy has a number of interesting things on his site, it's worth browsing around a bit.

Yes, Bob, I would like for this code to run once, and then never again because I'm using it to create new records in a child table based on the parent table's record ID. So I figured I should try to check the table I am creating the records in for the existence of records with the current parent...

I am using this method: http://www.lebans.com/mousewheelonoff.htm

Hello, On my main form, I have a combo box, and in its After Update event, I have code to execute an append query. It is intended as a one-time thing, to run when a new record is created, but I just realized that it is easy to trigger this more than once, which then of course messes up the...

No problem at all. What you were able to tell me was very helpful and solved a problem I would not have been able to take care of on my own, so I am happy.