Search results

  1. G

    Auto-populating a text box

    Hi all, I hope everyone had a good Easter. I have a very simple addition to make to my database, but I cannot figure out how to do it. I have a text box (TBDUEDATE) on my form that holds a date. I have another unbound text box that I need to display the words 'overdue' if the date in...
  2. G

    Search form

    Hi all, The question I have is quite specific. I have looked through the forum, and the big www, but I can only find general examples, and I just can't seem to make them fit my needs. Here is my set-up. Table name: T-Dates Fields in table: Date (e.g. 01/01/12), Day (e.g. 01), Month (e.g...
  3. G

    Resource booking database

    Hi all, I am looking to create a database to allow users to make new and view existing reservations of office resources (e.g. projector, conference phone, etc) and pool cars. I am stuck where to begin with this. My idea is to have a calendar style view (as in Outlook) that will allow...
  4. G

    Display message in detail of form when no records present

    Hi all, I have a form that is sourced from a query. Sometimes there may be no records to display. Is there any way of having a label in the detail of the form that states "No records available" for example. Thanks. Ged.
  5. G

    I'm not sure what to title this thread as, as I don't know where the problem lies.

    Hi everybody, Hope you're all well. Here is my set-up. I have two tables: 1. Equipment. 2. Test History. I have one query: 1. Due for testing. I have two forms: 1. Master. 2. Test request. I have a master form, where for each record (from the equipment table) I have a sub datasheet...
  6. G

    Record specific lookups

    Hi all, Firslty apologies for posting this if it has already been posted on the forum, but I really couldn't find anything in search that was what I wanted. Well here is my query. I have a list of items of clothing in a table. I use a form to enter data into a number of tables (visible in one...
  7. G

    Record specific query

    Hi everyone, I have a database currently in use. I want to create a query (from which I can create a report) to show me data relating one specific record, when run via a command button from the form where the selected record is active. Basically, I have a form, where each record relates to...
  8. G

    Data type mismatch error

    Hi all, I was wondering if you could help me with my error. I have searched for a response, but I can't figure anything out for my specific problem. I have set up a query, called 'Pending_calibration_EST'. This query is to show me records that are pending action by my team, for a...
Back
Top Bottom