Search results

I solved one issue, but now you get an error whenever Address 2 is blank. I'm crashing and burning so I will try to help more tomorrow. Enjoy what I finished so far.

COOL!!!!! I can't believe I was actually able to help for a change!

Try this adding the code in red. Private Sub SelectMachine_AfterUpdate() ' Find record for Machine selected in SelectMachine combo box. ' Enable controls in detail section ' Go to SpecRate. DoCmd.ApplyFilter , "Machine = Forms!EditProducts!SelectMachine And SAPNumber =...

I never thought of that. That is very sneeky. Thanks!

I looked throught the forum before posting, but couldn't find much help. I created labels that when the mouse is passed of them, their font size and color change. However, they stay that way after the mouse pointer is moved off. How do I make them change back to normal after the mouse moves off...

email your db to me. I'll give it a whack crt052681@attbi.com

in Form view, set the boarder to the size you want it to open to. Then in design view, change the forms Boarder Style to Dialog. Now The form will open the same size every time, and the user cant change it. Keep in mind though, if you go to design view and change the boarder size, it will stay...

Behind the on click event of the command button on the switchboard put: docmd.close docmd.openform "Password" Then create another form called "password" containing a label that reads "Please Provide Password", an unbound text box called "Password" and a command button with the caption "Submit"...

Make a combo box using the wizard. Follow the steps, and it will set up exactly what you want.

I can't rally tell what you are trying to do. Can you attatch your database to a post.?

Cool. Thanks for the info.

Post your code and I will give it a whack!

I use me.YourComboName.defaultvalue = "" I have found that by using me.YourComboName = Null me.YourComboName.DefaultValue = Null or an equivelant makes the user press Esc to clear the field before they can close the form. Also can someone please tell me why you put Me. in...

There are plenty of posts here that will answer your question. do a search for "automatically update" or "lookup and update"

Works Perfect. Thank you very much Mile!!!

Because the focus is set to that combo box only when the form is opened. The user selects the value, then it is carried over every time the user starts a new record. After value is carried over, the focus is set to a text box, where it stays for every new record until the form is closed. I have...

This worked really weel for me Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec YourControl.SetFocus I placed the set focus command in there so the first controll that is entered, is always highlighted. I hope this helps.

How?

Text box lookup I am trying to make a form with only 1 text box. When the user scans a value into the textbox, the value is compaired to values that I have imported into a table. If "it" finds a like value in the table, it displays a message box stating it found a match. If it doesn't find a...

Got it!!!!! THanks