Search results

  1. I

    Prevent toggle true if another field is empty

    how do I stop people clicking a toggle button to false if another field in a form is empty? Thanks
  2. I

    Delete query help, example attached

    Hi All In my example db I have created a query that looks for dups in a table and copies the results to a new table. Is what I am trying to do is delete all the dups except 1 from the main table. It was suggested to do it this way then create a delete query to delete all the entries in the...
  3. I

    Delete query based on data from another table

    Hi All I am trying to delete dups from a table whilst leaving one entry. I have created a query to find the dups and then copy them to a temp table. This shows me one of each dup in the table. I am now trying to create a delete query using wizard (not sql) to delete the dups in the main table...
  4. I

    Open report based on Asset Number in form

    Hi All I have a form that I use to search and modify asset info. If I for example search for the asset 01234567, the form is populated with the current table entry for that number. Is what I want to do is add a button to the form that when clicked will run a query and then show a history...
  5. I

    Best practice for saving Form data to 2 tables.

    Hi All. I have an asset tracking database. Table 1 is used for tracking asset information and is often edited using a search form and submitting any changes. I want to create another table so I can keep a count of asset faults. As the Faults field in table 1 changes as and when a device is...
  6. I

    Copy data from Field to Field

    Hi All I have a field in my table containing numbers ranging from 00000001 to 00039999, the zeros are there because my numbers could go to 99999999. I set the format of the Field to Number with the format as 00000000 to allow zeros to be displayed, as when I import the numbers, access was...
  7. I

    Adding leading zero's to numbers in a field

    Hi All Is there an easy way to add leading zeros to existing numbers in a field? Example:00001562 or 00054621 (always 8 characters) when entering the numbers manually I don't have a problem but if I import from a spread sheet, access removes the leading zeros. I have tried setting...
  8. I

    Question Entering data into a form

    Here is one for you brain boxes... I have a form into which I scan a serial number in one of its text boxes, I can then select search and am presented with a report relating to that serial number. All simple so far. Now for the dilemma... The barcode I scan consists of 15 characters like so...
  9. I

    problem using navigation form

    Hi All I' a newbie to access and need help with a problem. I have a search for that runs a query to list info related to a serial number, this works fine when opened on its own. The problem I have is when I insert it into a navigation form it comes up with an error when hitting search. the...
Top Bottom