Search results

Alright, all of the LOOKUPS have been converted to Text Boxes. One last thing...I've got the subform on the table that shows the Master Table, but it won't update automatically unless I manually open the Master Table. Is there a way to make it do that?

Sorry Bob, I got a little confused by what I'm trying to do here. Is that all done within the wizard or are there more steps involved? I also noticed that the listbox returns numerical values for the months, area, year complete, and further problems. I assume it has something to do with...

Hmm....I deleted the Referential Integrity between the two tables and inserted that code into the Form's BeforeUpdate Event, but it came back with the error message "Method or data member not found" pointing to the .cmbFurtherProblems. Not sure why that's happening as that's what its name is...

Hey Bob, No real reason for the clock. I was skimming various websites for tutorials, saw the clock one, and decided to give it a go. I'm still in the "little kid" phase of Access...any little function I can actually get to work amazes me...:) Any ideas on my quandary?

Alright...I think I got it working as it's supposed to. A couple of other questions: 1) I have one combobox that only appears when a "No" checkbox is checked. It works fine if you've checked the "No" box and fill in the next field. I can't get it to work if I check "Yes" and don't fill in...

Hey John, thanks for the quick response. Just for clarity, I'm supposed to add that expression to each field? I attached a picture, so you could see what I did. If that's correct, how do I add that to the OnClick Event of the button on the form or do I even add it to the OnClick Event?

Hello (Access) World, I'm having some trouble figuring out how to use the append query with a command button on a form. Basically, all I'm trying to do is fill out all of the fields on the form and have them populate into the master table. I figure this is something simple, but I've just...

Bump it on up

I'm trying to figure out how to create a form that queries a table for a variety of different fields. If you take a look at my Access file, what I'm trying to do is create a form that has 7 different input fields (M-Number, E-Number, W/O Number, Month Completed, Year Completed, Precision...