Search results

Awesome!! That did it, thank you SO MUCH.

Thank you for the reply, but it generates an Error "item not found in this collection". I'm pretty sure I need to include the fields in the recordset statement, but I can't figure it out.

I have a report that exports to PDF with the shipment number as the filename, but I want the file name to include the values from two other fields [CSR] and [facility] in the same query. Nothing I do works. Any Help?? Private Sub Command30_Click() Dim db As DAO.Database Dim rs As...

Awsome! Of course. Worked like a charm. thanks

Hello Everyone, I'm trying to get a Dlook up to compare a 3 character long text string in one column in a query to a column in an unrelated table and if they match to return the word "Match" Is Dlook up the wrong solution? Table name "Altos" Table Column "AlCode" Query Field Name "Altos1"...

Oh man, that's why I couldn't get it! I was focused on the subform! Thank you so much. Too many hours staring at a screen, makes for permanent brain farts. Thank you again.!

I've tried changing Me.[PanelBuild].Form.RecordsetClone to include the field on the subform, but I don't think the syntax is right?

I'm sorry, but I don't understand? I'm getting data, but only from the first record over and over again.

Hello Everyone, I have a sub-form in datasheet view with several records, the first two characters of each record make up a product code, that is then copied to a field on the parent form. I can split the first two characters from the first record. I've tried everything I can think of to loop...

The problem lies in what happens to the data after the import. You are correct though, I have the import set to the = as the delimiter. But the data winds up in the same column.

Please let me know if posting in the wrong place, and let me say thank you upfront. I have a strange text file that contains values separated by a 2 character abbreviation. ie. "PN" and "QT" I can import just fine, but I can't seem to get the data to separate into separate columns. This is...