Search results

  1. I

    sorting grouped records in descending order

    I have a query which sorts the date field in a record in descencing order, yet when I create a report which groups these records by date the groups are always in ascending order even if I select ascending (by day, year or month etc) in the report wizard. Anyone know what is going wrong?
  2. I

    check if record exists

    Can anyone tell me the SQL code to check to see if a record exists or not? eg if a record exists where a particular field matches a textfield on a form, then update database else msgbox ("error")
  3. I

    matching strings except last character

    Hi, I need to create a query using two tables which matches the first twelve characters in a string, but ignores the last one. eg 9781904024415 in field1 of table1 matches 9781904024419 in field1 of table2
  4. I

    merging tables

    I have two tables with identical fields. I would like to merge them together without duplicating any records - there is one field which can be used to identify which data is to be transferred: fields are: Barcode, Title, Author, ISBN, and Date Borrowed Table A has some records with data...
  5. I

    Reloading a form from a query with new conditions

    I have a form which displays data from a query - the query uses a parameter value to select a record to display Is it possible to put a button on this form which will re-load it asking for a new value for the parameter? thanks for any help, regards, Ian
  6. I

    command to update record from data in other table

    I have two tables - books and borrowers Books has a borrowerID field as does Borrowers (linked by a relationship) BorrowerID is unique in the borrowers table On the form where a borrower enters their details I have a button which opens a form displaying the results of a query for that...
  7. I

    Cursor in text box on form open

    As usual It should be obvious but I can't find it! I want the cursor to be in a specific text box on a form when the form opens. is there a way of setting this? (Many thanks to all the helpful users who have already helped me with the blizzard of queries I've posted over the last couple of...
  8. I

    new record uses previous record data

    new record to use previous record data Hi, I'm trying to set up a form for user data entry, where a field on the form automatically contains the same data as the previous entry. This would save time where there are a number of records to be entered where this particular field remains the same...
  9. I

    text box only visible when yes/no field checked

    Is it possible to make a text box displaying a text field on a form only visible when a yes/no field is checked? I have tried setting it a not visible and using textbox.visible=true when the yes/no field is updated, but this makes it visible for every record, not just the one where yes/no is...
  10. I

    dropdown list to depend on other field

    I'm trying to set up a database of books in a small library - each book has a prefix (Maths, English, Art etc) which I want users to be able to pick from a drop down list - I can do this, but the next field is a sub-category - is there a way of populating the dropdown list for the sub-category...
Back
Top Bottom