Search results for query: *

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

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

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

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

I have the following code: DoCmd.RunSQL "Delete * FROM TTempOrderImp WHERE (((TTempOrderImp.RprtQty)=0 Or (TTempOrderImp.RprtQty)<0));" This code runs fine, but when I want to run a different procedure with the table TTempOrderImp I get a bug that states, "The database engine could not lock...

I have a form (FrmLabels) and a subform (sFrmLabels). I want to put a checkbox on the subform and then print labels for the lines where the checkboxes are checked. How do checkboxes work? How do I know on the backend if they are checked or not. I have inserted the checkboxes but when I view...

I have the following code and it looks right to me but it keeps bugging out and saying, "Object Required" If IsNull(TUnMatchDC.ShipTo) = False Then DoCmd.OpenForm "F_UpdateDCX_Ref2", acViewNormal, acEdit End If Its a simple enough If statement, but this is the second "Object...

I have the following code and I am getting an error that says "Object Required." The debugger is highlighting the line "If NZ(TorderImpFilter.Shippable, 0) > 0 Then" What am I doing wrong? Private Sub Crt_ExportFile_Click() Dim i As Integer Dim StrSQL As String If...

I am executing queries in VB which deletes data... each time I am deleting something I get a pop up asking if I am sure that I want to delete X number of records... How do I get these pop ups to stop and just have the queries do what they are suppose to?

I am new to VBA. I have a table that holds the following information (Item#, Qty). On the click of a button, if Qty > 1, then I need to create a record in a separate table for each Qty. If Qty = 1, then only one record should be created. Example: Item# 1,2,3,4,5 Qty 2,1,3,2,1 Perspectively...