Search results for query: *

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...

The file size for my Excel spreadsheet doesn't make sense for the amount of data that I have in it. I was wondering if there is a function to compact an Excel Spreadsheet. Please advise!

I can't seem to get the parameters of openning a recordset correct. Can someone please send me some information regarding openning a recordset?

Do not understand what this means, "e.g. (air code assumes dimensioned variables for recordset and connection and using ADO)" What is air code? What is ADO? I did the code above and got the following error: Object Required. Sorry I am still really new to VBA.

On click of button, I want the VBA to check if an id exists. I know it sounds simple, but I tried the following and its not working.... If IsNull("Select * From TItemXRef where TItemXRef.ItemNumber = Forms!FU_TItemXRef2.SITMTxt") Then MsgBox "The PeopleSoft Item Number (BK Number) you...

THANK YOU, THANK YOU, THANK YOU!!! I got it to work. Your example really helped me out and I was able to do it. And its a lot easier this way. I am excited about my training. I hope they don't cancel it! jossimon