Recent content by jossimon

How or where do you Truncate a table? Does anybody know?

At least you are amused... here is my code. stText = "Ticket Status: " & varStatus & Chr$(13) & Chr$(13) & "Ticket Number: " & stTicketID & Chr$(13) 'stText = stText & "Received Date: " & RecDate & Chr$(13) stText = stText & "Received Date: " & RecDate & Chr$(13) & "Assigned To: " & varName...

I am getting an error that simply says, "Reserved Error." what does this mean???!!!

This did not work either. The user enters the drop-down, and then selects Complete. On enter the field would not be = to Complete or StatusID=5. Any more ideas?

This still does not reset the StatusID to null. Any more suggestions?

I have the following code: Private Sub cmb_status_AfterUpdate() DoCmd.SetWarnings False Dim CancelUpdate As String If Me.cmb_status = 5 Then If IsNull(Me.CompleteDate) Then MsgBox "Cannot update Status to Complete until Complete Date and Time to Complete are populated." CancelUpdate...

You guys were right on. Thank you for your help!

My VBA Code looks like this... strSQL = "SELECT " strSQL = strSQL & "T_Tickets.TicketID , " strSQL = strSQL & "T_Categories.TicketCategory, " strSQL = strSQL & "T_Employees.USERNAME AS [User]," strSQL = strSQL & "T_DEPARTMENTS.DEPARTMENT, " strSQL = strSQL & "T_Tickets.Issue, " strSQL = strSQL &...

I created this query in a normal query screen... using their Query Designer. Looked at the SQL Statement and cut and pasted it into VBA. The query worked when run from Query Designer but not in VBA. I know the problem probably lies with the "(" and the fact that there are two subqueries in...

I am executing the following: Me.RecordSource = strSQL The error I am getting is "There is an error in the FROM clause

I want to copy a SQL string from a query I created into a Variable string in Access, but when I try to run the SQL string I get an error. My query has a lot of inner joins and is complex, and I am guessing that the syntax for VBA SQL is not the same as the SQL Statement in the Query window...

I created a subform in my main form. The subform lists out the details of a ticket. the main form asks for the ticket number. I want the subform to show the details of the provided ticket number when the user pushes "Find Ticket". Sounds simple enough, but everything I have tried has failed...

Getting the following error on my database and not allowed to enter VBA Code for a form. PLEASE HELP!!! "Error accessing file. Network connection may have been lost.

I am adding a record to a table. The primary id on the table is ticketno. I simply want a msgbox that says, "Ticket # _____ has been successfully created!" I might be making this more difficult than it has to be.

I am using a form to add a record to a table. I want to then retrieve the Primary Key, "Ticket Number," after the table has been updated. I am not up to par on Recordsets, but I am pretty sure I just need to get EOF of a recordset and select that field in a SQL String. How do I get the EOF...