Search results

I have an insert into statement that is 1,082 characters. Is there a way to get around the line limit? I've tried using " _" in the code to signal a continuation on the next line, but it doesn't like it. What are my options? Thanks.

I've tried using this code, but I'm not getting something right. Let me try to explain as briefly as I can what I'm trying to accomplish and perhaps you can help me: I need the maximum ticket number (TicketNum in the RepairInfo table) that has the same asset number (AssetNumber) as the user...

The form is unbound and the auto-numbe field (TicketNum) is populated after the user clicks on a button to create the record, so unless I'm misunderstanding something, I can't use the first option. When we manually entered the ticket number, I was able to use that to open the next form. Now...

I realize my code is very amatuerish. Even though I am very new to coding, I do know names should be meaningful and I was lazy. Shame on me. The Command54 button is on the frm_StudentInfo form. The data entered into the fields on the StudentInfo form is written to the RepairInfo table...

I'm not sure what I'm doing wrong ... here's the code for the button: Private Sub Command54_Click() Dim strSQL As String strSQL = "INSERT INTO RepairInfo(FirstName,LastName,StudentSite,AssetNumber,SvcTag,EquipDesc,SubmittedBy,School,StudentID) VALUES(" & "'" & Text4 & "'," & "'" & Text12 &...

I have a table that used to require the user to enter the ticket number, then clicking on a button would create that record and open that ticket where user enters more info about that ticket. Now the ticket number is auto-number (I got that part to work with an append query) ... but the code...