Recent content by John@backacre.co.uk

  1. J

    Finding matching records

    I'm not an expert but saw your question whilst searching for a solution to my problem! If you have used the query wizard to find unmatched, it uses only one matching field. However if you open the design view of that query, you can create other joins that then produces a result matching all of...
  2. J

    Editing non-matching records

    :(I have a problem that my brain can’t sort out and I seek assistance because my deadline is approaching fast. I have a Contact list that has about 800 records and Responses from a web form that is used to determine whether a contact will be coming to a number of planned meetings, (about 200...
  3. J

    Data not fixed in Combo Box

    Thanks for your suggestion PNGBill, I hadn't thought of that one. After thinking a bit more about your suggestion, I might try a got focus event to open a new record if there is already an entry, because the combo on the Northwind form is the means of selecting a customer for a new order. I'll...
  4. J

    Data not fixed in Combo Box

    I have used the Northwind Order Entry form as a basis for a project. All seems OK until the user accidentally uses the Combo to start a new order without first selecting a new record. The results could be disastrous as the wrong company would get the wrong order. It happens in the Northwind...
  5. J

    Define column headings based on data in another table

    I want column headings eventually to use in a data collection email. The headings required are a combination of Event_Name, Day_of_week and Date_of_Event, quite a mouthful. This text string I get with a standard query based on a table containing just the event name and dates for each of the...
  6. J

    Make a report that looks like a pivot table

    I had a suggestion from jassaal123 but a crosstab doesn't produce the result I need. the data I have looks like the following (much simplified). The Initial info where a task is allocated to a name. Name FriTask SatTask SunTask NA TC TC NB TC TC TC NC TC TC ND TB TB NE...
  7. J

    Make a report that looks like a pivot table

    I have about 600 people names and 60 ish tasks to allocate across typically 3 days. It seems easier and more natural to allocate tasks to people as the check box list is much shorter, and the tasks are stylised so there are few that have the same initial letter so the check box search is easy...
See more
Back
Top Bottom