Search results

Thanks.. Thanks, I'll give that a try.

I'm not sure that will work, as the matching I'm talking about is getting the navigation buttons to align with the selections in the combobox's drop-down list. The 'textbox' that contains the number is the built-in box between the navigation buttons I was talking about.

Hmn..well, not exactly, (I looked at the Zip, thanks). Ok, I have the ComboBox, by using the mouse wheel, I can click on the box and scroll through the drop-down list of names just fine. By doing so, it also increments the navagation buttons to the corresponding record number, (Access...

Well, you see, here's the thing; this small form just has three controls on it. (I forgot to mention the Command button) First, the ComboBox with the drop-down list of 435 names. A command button that read "Go to Record" and the standard navigation buttons at the form footer. When the...

I have a form with a drop-down (combo box) with a list of 435 names. It also has standard navigation buttons on the form footer. My question is, how can I 'tie' the combo box with the navigation buttons so that the box can control the record number in the navigation? That is, if I select a...

Hmmn..you know what? I neglected to mention that when the form itself is opened, (the requisite Graduate, Faculty or Undergraduate forms) the tables referenced by them are already set up for editing. So basically I just need the message box to open the form to that record. Would the code as...

Well, once again, they're leaning toward have an InputBox whereby the name is entered and the form is then loaded to that record, (not using a ComboBox, though that would make an interesting addendum). As a matter of fact, I tried it first using a ComboBox first, but the compiler didn't like...

Rich: the explanation is actually due to the request of my supervisors (University types with pre-set ideas as to how a database should be set up). I just conform to their wishes. It took a -lot- of lobbying on my part to get the normalization down to just -this- level. You wouldn't have...

Would that be just once at the beginning of each function, or before the reference to each table listed?

Hmmn..I tried swapping .addNew and .Edit in one of my backup copies, but I get a run-time error telling me that it would create duplicat values. Is this because the .Update commands are still present?

Hello, I have the below code to display message boxes (one box per type of record, Undergraduate, Grad student or faculty) to add a new record to a database. Basically, when I enter a name it inserts the new name in four separate tables and opens the corresponding form to enter the subsidiary...

Showing my supervisor this thread probably won't help. The faculty always get the last word, and they're higher up the "food chain" than even her. Trust me, they want this in addition too. I don't know why they want it, but as the lowest-ranking member of the "chain", I get to do this -their-...

Oh, I should point out that I don't intend to use the other two tables (redundant) to provide any data to run my form, I'll keep that same design of just using the tables I originally intended to run it. Basically, when someone enters data into a field on the form, I need it to update the...

Oh Rich, believe me, if I could explain it to them without getting them all offended, I would. When I came here, the database was set up so each table had it's own ID number. The faculty table had a "FacultyID" number assigned to each record, Graduate had "GraduateID", etc. I immediately set...

Yes, though I'm beyond the teeth-grinding stage. *banging head on desk* So, back to my original question, is there an easy way for a field on a form to be copied to multiple tables at once? It seems the faculty would like the "convenience" and "quick reference" of looking at one table that has...

Ok, I've spoke to my supervisor (she) told me that the request actually came from some higher-up Faculty members, as well as a related, separate office which will also use the database and the addition of all those redundant fields was their decision. So, I'm pretty much stuck. (Did I mention I...

Yes, I know I don't want to add it, but my supervisor wants the database set up that way. So I either need to find a way to do it, or meekly try and convince them that it doesn't make sense, especially since I made a nice set of forms and switchboards that render those other tables pretty much...

Ok, I've asked similar questions to this in the past, but I need to re-vamp this department database once again, under a new set of criteria. Is there an easy way for a field on a form to be copied to multiple tables at once? For instance, on my "Graduate Student" form there's a field called...

Ah, you know what? You're right. I'm trying to cram too much into this. Your previous suggestion will work well with my revised plan. Thanks so much!! I'm going to try to relax now and stop obsession over this.

Well, the filter was my first thought. I disabled it by the properties box, but that didn't work. The right-click you suggested worked, though the form now seems to order everything by MasterID number, ascending, instead of in alphabetical order by name. I keep working with the properties of...