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!

  • Congratulations dencom 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: *

  • Users: jeffmorl
  • Content: Threads
  • Order by date
  1. jeffmorl

    Access; "Find Record" button produces "Not A Valid Bookmark" message.

    I have a single form that users have been using for months and months. All of a sudden, when someone does a search for a particular record ID, it fails and produces a Not A Valid Bookmark message that won't go away. The user then has to red 'x' out of the application. Using MS Office 10, Access...
  2. jeffmorl

    "Find and replace" produces "Not a valid bookmark" message

    I have a single form that users have been using for months and months. All of a sudden, when someone does a search for a particular record ID, it fails and produces a Not A Valid Bookmark message that won't go away. The user then has to red 'x' out of the application. Using MS Office 10...
  3. jeffmorl

    User can't update db

    I have a multi user (15-20 at a time) db on which users enter time (and other data) into a form which updates a table. The db has been working with multiple users for about 18 months with no apparent problem. Until today. Now, when someone tries to enter their time into the db and move on to...
  4. jeffmorl

    Change radio button value

    Haven't been able to find the answer to my problem yet. If it's out there, please point me in the right direction. I have a report parameter form where a user selects a value from a combo box and then a begin date and end date. On clicking a 'submit' button a barcode report is generated and...
  5. jeffmorl

    Validate user input in combo box

    I must be looking in the wrong places because I haven't been able to find an answer to my question. I have a user input form that populates an "equipment" table. On this form, I have a combo box bound to a separate table. The user can pick a value from the combo box or enter their own value...
  6. jeffmorl

    Strange characters on report

    I've searched the site for problems regarding "strange characters" but haven't found this particular problem. I have a parameter input form which retrieves a set of records that meet those criteria, e.g., area name, beginning labor date, ending labor date, problem code, and building. The...
  7. jeffmorl

    between "dateA" and "dateB" not returning values

    OK. I've been using "between "dateA" and "dateB" for a while now and have a situation where the records with dateB don't appear in the query results. Here is the sql code I'm using; SELECT T_DMZ_EQUIPMENT.ITEM, T_DMZ_EQUIPMENT.TRANS_DATE FROM T_DMZ_EQUIPMENT WHERE...
  8. jeffmorl

    Set print flag to "Yes" if record has ever printed

    I have an Access db form that collects workers hours, work order numbers, dates, etc. as well as an internal time stamp. Each week I print a bar code report based on the time stamp parameter, e.g., print only the records that fall between two date ranges. It has come up that now I want to be...
  9. jeffmorl

    Query not working as expected

    We keep track of a worker's hour and whether those hours are "overtime" or "regular time" with an "earn_code" value. I had a query with input parameters built in, but that didn't give supervisors enough prompting. Thus the use of an input parameter form. On the form, a supervisor can enter a...
  10. jeffmorl

    capture input parameters at "on no data" event procedure

    I have a report that a user can print from input parameters. Sometimes there is no data returned and for that I have an "On No Data" event procedure to throw up a message saying so. Is there a way to capture what the input parameters were to pass along and make the message more meaningful...

Part and Inventory Search

Back
Top