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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JimmyRa

  1. JimmyRa

    Import from Excel

    I want to import data from Excel, but let the user check if it is OK on the way in. I have tried throwing it into a tmp table, and listbox to allow them to pick and load. Access, of course loads all the empty lines from the Excel, and doubles up lines in the tmp table as well. I tried deleting...
  2. JimmyRa

    Running a query from a form

    I have a 'query form' which asks the user for dates, some codes, etc, and then runs a query based on these. The query uses [ >= GetStartDate() and <= GetEndDate() ] functions to retrieve the screen entries. Worked fine for a while, but now gives me a 'last operation was cancelled' messagebox...
  3. JimmyRa

    lsitbox requery problem

    I have a form based on an 'Events' table, with a (not enabled) list box displaying 'staff involved'. The rowsource is a query, which calls a VB function to get the current EventID, which is the key to both tables. There is an unbound textbox which can be used to add a staff member, using an SQL...
  4. JimmyRa

    Update query - number fields

    I am trying to do a docmd.runsql to update a database with a few number and date/time fields, from info in VBA variables. I keep getting 'syntax error in statement' All the text fields work OK, using " txtfld = '" & txtvar & "'" etc, but what should I do with " numfld = " ???? or " datefld =...
See more

Part and Inventory Search

Back
Top