Recent content by skd2726

YEP - that worked!!! thanks

I have a report that is based on a list box in a form - the user is to pick items from the list box and then a report runs filtered on the list box ...I have tried it 2 ways ...both ways I get an the following error "EXTRA ) in quiery expression '(Name =)' HELP!!! First Way: Private Sub...

It worked ... thanks so much!!!!

I need a field in a form that can do one of two things .... if the field contains a badge number then add the corresponding employee name from a table or if the field has no badge number then let me add my own employee name Is this possible?

Thanks to all especially mkov - you are so helpful. This site has saved me - again!

Ok, not to sound stupid, but where do I put this code, I'm assuming somewhere in the report but where?

I'm not the original poster, but I have a db that I need to email reports from and we use Lotus Notes - can you post the code to use Lotus Notes...p. l. e. a. s. e. thank you!

I have 2 tables: PurchaseOrderTbl & LineItemTbl PurchaseOrderTbl contains information on each PO like vendor, total amount, etc. etc. LineItemTbl contains information on each line item of the purchase order - I need this separated because different line items can be charged to different work...

TO RICK39: HELP - I tried your idea and it lets me enter a new data, but I don't get the message box and it doesn't keep the entry in the table...here is the code I added to my combo box in my form Private Sub Craft_NotInList(NewData As String, Response As Integer) Dim db As Database, rs As...

I would like this also my email sandy.dickson@fluor.com I'm working on a project similar to this today and need this badly...thanks

We are getting this message: Error No.: -2147467259 [Microsoft][ODBC-Driver Manager] Driver's SQLSetConnectAttr failed SQLState: IM006 What can I do to fix this?

Well, I am guilty of doing things the hard way, but this time I ended up just writing a Trim statement to get rid of all the dashes and it worked just fine! Thanks to everyone for the tips.....

Figured out a "beginner" way to do it - I just changed the input mask on the field with no dashes to include dashes and then I ran the query to compare the 2 fields...thanks for all the help, I would like to know exactly how to do it the correct way if someone doesn't mind taking the...

Well, I'm too much of a beginner for this, I put the function in the Access module, and the formual in the query, but when I run it I don't get any results at all - what am I doing wrong?

I have a field that was imported from Excel - I need to compare with another field - the one imported from Excel has dashes and the existing field does not. I know that I can use a trim statement, but I can't get it to work: here's an example is: 123-45-6789 needs to be: 123456789 Can...