Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skd2726

    list box error

    YEP - that worked!!! thanks
  2. skd2726

    list box error

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

    nee a field on form that can look up data OR let me add my own data

    It worked ... thanks so much!!!!
  4. skd2726

    nee a field on form that can look up data OR let me add my own data

    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?
  5. skd2726

    e-mail reports

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

    e-mail reports

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

    e-mail reports

    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!
  8. skd2726

    Calculate a percentage then store the results in another table

    ...$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...
  9. skd2726

    Adding Values from Combo Box to Value List

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

    Making A Search Form

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

    HELP!!! - Error in program - Don't know VB

    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?
  12. skd2726

    Help -I need to take out dashes in SSN

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

    Help -I need to take out dashes in SSN

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

    Help -I need to take out dashes in SSN

    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?
  15. skd2726

    Help -I need to take out dashes in SSN

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

    Export Secifications

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

    help - I need to add zeros to beginning of a field for every entry

    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?
  18. skd2726

    Pulling records

    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;
  19. skd2726

    Pulling records

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

    Pulling records

    Also, we are doing this in a query

Part and Inventory Search

Back
Top