Search results

Perfect. Thanks!

I'm trying to display a field from a form in a message box. Is something out of order here? MsgBox ("Your Work Order has been submitted. Your WO# is "& WorkOrderID.text" Please use the Work Order List to view the status of your Work Order. We appreciate your patience."), vbInformation...

I'm trying to create an on click event for a label where when i click it, it will only show records in the list box that have a particular station name. The listbox get it's info from a query. The StationName is a text field in one of those tables that is in the query. Here is the rowsource...

Prevent incomplete record saving I'm trying to prevent my database from saving incomplete records when users don't complete certain fields on the form. I put this code in the before update event but it still saves incomplete records. What am I missing? Thanks for the help! Private Sub...

There are six fields on the form all stored in one table. What else do you need to know? Each of the six fields is on the form. Theres a picture of the form.

I'm creating a work order submission form where I want the person submitting to have to fill out 6 fields before they can submit the saved record. I need a button that will check each of those fields and if one is isn't filled in, display a message box saying which field is missing. Then, if all...

Thanks for the advice! I think that's probably an idea I'll explore rather than go through each form writing the same code! Thanks!

Ahhhhh! Yes that makes total sense! Thank you so much!!!!

I'm trying to limit the access to certain objects on certain forms to just 3 users. I thought the code would be If Environ("username") <> "user1" Or "user2" Or "user3" Then object1.visible = false object2.visible = false object3.visible = false End if BUT it keeps giving me the Run-Tmie...

How do I make it so it only has one message box that lists the needed fields? And how do i make it so that they can just close the form without it saving the record?

Okay Heres the code I have: Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Me.SectorCombo & vbNullString) = 0 Then MsgBox "Please Select a Sector" Cancel = True Me.SectorCombo.SetFocus End If If Len(Me.StationCombo & vbNullString) = 0 Then...

So I enter that code in 6 times for each field?

I'm creating a work order submission form where I want the person submitting to have to fill out 6 fields before they can submit the saved record. I need a button that will check each of those fields and if one is isn't filled in, display a message box saying which field is missing. Then, if...

You were right. It was me.searchresults. Thanks Paul!!!!

I have a listbox displaying results from a string search in a text box of a query. Im trying to build an event where the user can doubleclick on the selected result and it will take them to that record. This is the code I have but it won't take me to the selected record in the form. It takes me...