My report is pulling from two tables, but the report only seems to be looking at one table. Here is how the tables look:
CSR Table
MMSJob - PK
InDate - Date
CCSR - Text
CClient - Text
Error Table
PID - PK
ErrorDate - Date
Error - memo
MMSJob - Number
What I am trying to do is count the...
I am having problems with one of my find record command buttons. It only sees the first record, if I put in another job number for it to find it says that that record cannot be found. This is the only form that I am having that problem with, this is also the only form that has all of the...
I wrote code to check for blank fields that I want populated, but it doesn't seem to work. Can anyone help me out here? Thanks.
Private Sub Form_Close()
Dim strmsg As String
If IsNull(LOEmpID) Then
strmsg = "Please enter your employee ID"
ElseIf IsNull(LOLast)...
I only want the record that was just created to be in a report that is e-mailed to my supervisor. Is it possible to do this or will I am I stuck with all of the records in the table? How would I go about fixing this?
Thank you
learnasugo
I am using Access VBA code and trying to select a record from an unbound combo box and I keep getting an error message that says "No current record" Does anyone know what that means? Here is the code.
Private Sub Combo58_AfterUpdate()
' Find the record that matches the control.
Dim rs...
I was trying to create a combo box that would find a record on my form based on the values of a field that I selected. When I selected the field and clicked next it said "No value given for one or more required parameters" What does that mean?
Thanks
learnasugo
I am having problems with my database because my foreign keys are empty. Is there a way to make them auto-increment just like an autonumber?
Thanks
learnasugo
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.