Recent content by dccjr3927

Thank you Galaxiom. That did the trick. June7 - Apologies for the linked tables. I did forget to convert them. The good news is Problem Solved. Thanks to everyone for their input and suggestions.

Here is the database. This copy only has the module with the code and the two test tables tables.

Yes. Date_Time is used probably 30-40 other times in this database. I cannot see where the field name would cause a syntax error. Likewise, all of the dates in this database are formatted mm-dd-yyyy. Neither has ever caused any issues. I discovered that in order to use the TransferText function...

Something like this? strGetDailyRecsSQL = "INSERT INTO tempExport (LarqOrder, LarqSerial) SELECT LarqOrder, LarqSerial FROM LarqData WHERE [Date_Time] >= #" & dteLastExport & "#;" Not really sure on the syntax for this, and a quick Google search yielded examples that were...less than clear. I...

I have a query strGetDailyRecsSQL = "SELECT LarqOrder, LarqSerial, Date_Time INTO tempExport FROM LarqData WHERE Date_Time >= #" & Format(dteLastExport, "mm-dd-yyyy") & "#;" but am getting Syntax error in date in expression 'Date_Time >= #'. I am sure I am just over looking something. Any...

Bingo! Perfect! Thank you. I knew I was missing something obvious.

So my iteration through the listbox works the correct number of times, however, my variables (strProcess, strSKU, and intQty) are not changing with each iteration. They are remaining the same (Row 0) on each record insert. For i = 0 To Me.lstMultiItem.ListCount - 1 varItem =...

Where would I use them in my code? I have never used either of those. What is the syntax.

The cbxSKu is returning: CE-WATCH-MCLIP-BLK The SaleableQty is returning: 9 Which is all correct. Oddly, though, there is a space in front of the 9.

I am trying to check qty on an item before logging a work order. The following line is still not quite right. If DLookup("SaleableQty", "Inventory", "Inventory.SKU = '" & Me.cbxSKU & "'") >= Me.tbxSKUQty Then . . Else MsgBox "There is insufficient item inventory to fulfill this order. Please...

How would I select all of the added items in the code? They are selecting the attachments from a File Picker, but none are "selected". Is there a way to code to select the first item, complete that iteration, delete that item, then repeat for the next?

The debug line for iAttachSQL is returning 'False' in the Immediate Window. Yes. The attachments (file paths) added to the listbox are on each users PC, and I am wanting to save the order number and file path for each attachment to the table. I also want to copy the attachment from their...

It is returning 'False' Since the list box items are not selected, do I need to cycle the selection, and remove each item as it does so? If so, how I code that?

I am having an issue inserting listbox items into a table. I have the following code. Ihave a table with OrderNo, FilePath0, FilePath1,...File Path4. My users should be able to select up to 5 items, and have them copy the file paths into each field from the listbox. If Len(Me.lstAttach &...