Recent content by Lazy Days

I changed the code like you suggested as well as every other place in the database and then put in the following code. It doesn't show any errors but it don't work either and no message box shows up. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Quanity_Received = "NotNull" And...

I tried the following code but it shows a compile error and highlights the word Received after Quanity. Do I have something wrong? (I know I have Quantity spelled wrong) I was putting this on the Before update on the form. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Quanity Received...

I have one form where ordering information is entered, but everything can't be entered at the time of order. So I have another form that lets the user finish the information (quantity received and time received) once the product is received, this is usually anywhere from 2 to 6 hours later. I...

Never mind, I found an answer for my own question. In case anyone else was wondering, here is what I found: These are system tables that Access creates to hold info about the database. They were ALWAYS there and are there for any new database. The reason you never saw them before is because you...

I was looking at some sample databases yesterday and since they were in a zip folder, I just told it to open in access instead of downloading and saving them. After doing this, there were some tables showing (in every database on my computer) that were not there before. They are all grayed out...

Thanks Bob. That is what I needed to know

I have a query set up something like what you are wanting. My query looks at different shifts or all of them. Here is the criteria I have set for it. Like "*" & [Enter a Shift or Press OK To See All Shifts] & "*"

I have the following code for one of my action buttons. My question is when I want an icon to show beside the message, what are the different options for different icons? In this example I have Exclamation, but I am not sure I want to keep it as this. Private Sub Command18_Click() On Error GoTo...

To set it where they can't see previous records, open the form in design view again and go to the properties. Set Navigation Buttons to No

Create a macro. Set the Action to "GoToRecord, Object "Form", ObjectName "the name of your form" and Record "New". Then open the form in design view and go to the properties, on On Open, select the down arrow and then select the macro you just created. When the form is opened, it will be at a...