Search results for query: *

I have created a button that I want to fine a specific record based on its serial number. After the record is found I want a query to be executed based on the serial number that would record what time the button was pushed. What is currently happening is when I click on the button. I get a...

Is there a way of tracking a person by their login? My forms currently have a list box with the asking the person to click on themselves. If there was a way of transferring who they are currently logged in as it would make my life easier.

I need a For Next loop to count the amount of times a instance occurs. I will warn helpers this is the first time I have tried to create one. What I am trying to accomplish is to have a counter keep track of defects. When I have a defect a person will click on a button that will call this loop...

I created a module that will not work. Public Sub LookupValue() Dim X, Y As String On Error GoTo ERR_txtRefDesig Dim FormName As String Dim TableName As String Dim FormEntryTextBox As String Dim DisplayTextBox1 As String Dim EntryTextBoxFromTable1 As String Dim LookupValueFromTable1 As...

I have created a module called LookupValues. I have been trying to call this module from a form. I can't seem to get the scope correct so the call statement works: Here is what I have: From the Form: Private Sub RefDesig1_Exit(Cancel As Integer) 'Call LookupValue (0) End Sub From the...

I am trying to pass a variable from a form to a query. I am using the following code: UPDATE TblPAQ3280Process SET TblPAQ3280Process.LaborTI1 = Now(), TblPAQ3280Process.CodeName = "PAQ3280", TblPAQ3280Process.Status = "Incoming Inspection", TblPAQ3280Process.JobNumber = "PAQ" & "Now,mm,dd,yy,"...

I have the following code which gives me a compile error Syntax error. Private Sub txtRef_Desig_Enter() =DLookup("[Part_Description]", "TblPartsList", "[txtRef_Desig]=Forms!frmInitialInspection![txtPart_Description]") End Sub My form Name is frmInitialInspection The entry textbox on this form...

I am interested in appending records to multiple tables at the same time. I have the following code: Public Sub txtSerialNumber_Enter() Dim txtSerialNumber As String Dim SerialNumber As Long Dim newrecord As DAO.Recordset Set newrecord = CurrentDb.OpenRecordset("TblLotNumber") Set newrecord =...

I have a procedure that I was hoping to pass a variable (The enter the serial number variable). What I need is to enter the serial number once and have all the procedures execute. Private Sub btnrwk1dspTT_Click() On Error GoTo Err_btnrwk1dspTT_Click Dim stDocName As String ' Define...

I have created a form using one table. I need to input information into another table using the same form. Using the expression builder I came up with the formula =TblReworkTime!SerialNumber for the control box. How can I fix this?

I am having problems with a remote user not being able to log off of Access properly. The user gets hung up and cant log on again.

I am having connection issues with the Citrix server. When the remote clients try and log on they get to the The Starting application window remains at checking newer client version, I am rebooting the server once or twice a week.

I have the following query that does not update: UPDATE TblPAQ3280 SET TblPAQ3280.InitialInspectionTT = [IntialInspectionTO]-[IntialInspectionTI] WHERE (((TblPAQ3280.SerialNumber)=[Enter Serial Number])); What I am trying to do is get the value of the record IntialInspectionTO and subtract it...

I have set up a searching function on a form. It works well finding records initially. The problem I am having is if I am on record 355 and I try and find record 325 I get the message that the record is not found. I know the record exists. So how do I change my search function to go backwards...

Does anyone have suggestions for a timer program that would be controlled by a form with a start and stop command button. And I would like the elaspsed time to show up on the form.

I need to create a module (for the first time) that adds a specific amount of serial numbers to the database. I will have the form ask for a first serial number and a last serial number What I want is for the loop to create the amount of records I have asked for Ex. First record = 255 Last...

When entering new records into my database I am trying to avoid duplicates. This is the problem I am having. I have a field code name, another field serial number. A final field unique serial number in which I combine the code name with the serial number with a query. The problem is with this...

Hi, I am trying to create a query that will delete duplicate records. I have done the first step and identified the duplicates. I copied an existing table and created a query to delete the duplicates. The problem I am finding is the query is deleting all the duplicate records even the original...

I have an initial number which I must combine with a type of unit to create a new unique serial number. The problem comes when I try and enter a new serial number from a form that I have constructed for this purpose. On the form I have the code type in a list box, based on another table. The...

I have created a form to lookup components in a table. The problem I am having is the table I have has multiple designation in the same field. Ex CR2,CR4,CR18 If I am looking up a field that has one designation in it I am fine. But if the field has more than one designation in it my Dlookup...