Search results for query: *

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!

...$80.00) in the field LineItemAmount in the LineItemTbl (I need access to calculate the Line Item amount) i.e. LineItemAmount = $20.00 (purchase order total amount from PurchaseOrderTble * percentage from LineItemTbl entered by the user) I don't mean to ramble - just want to draw a clear...

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

I tried the suggestion from jebry on Sep 30, 2002 NewTextField: Format([mytable]![mytextfield]," ") and also the leading zeros one the leading zeros works fine, but I can't get it to put in the leading spaces... here's what I used newreason: Format([table1]![reason],&quot...

I have a db that all the fields are will be exported in txt format into another system, in one field the users will enter a 5 digit number but when it exports in txt format it needs to export as an 8 digit field Example: user enters 12345 exports as 00012345 Any suggestions?

Never mind, I got it: SELECT Table1.member, Table1.time FROM Table1 WHERE (((Table1.ID) In (SELECT TOP 3 tbl.id FROM table1 AS tbl WHERE table1.member = tbl.member ORDER BY tbl.member, tbl.time DESC))) ORDER BY Table1.member, Table1.time DESC;

I tried it but I'm doing something wrong: SELECT table1.member, table1.time FROM Table1 WHERE table1.id IN (SELECT TOP 3 tblgbt.id FROM table1 AS tblgbt WHERE table1.time = tblgbt.time ORDER BY tblgbt.member, tblgbt.time DESC) ORDER BY table1.member, table1.time DESC; my table: ID...

Also, we are doing this in a query