Search results

Worked a treat. Thank you very much indeed.

Hi Colin That is fantastic, you have saved me a huge amount of time, it would have taken me an age to figure that out, I am getting better at queries but not the complicated ones like these. However.. I ran the last query to delete the 18 records but I get the error message 'Could not delete...

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

Hi Again If you look in the TC51 Faults table I attached, you will see that devices have a different asset tag number, so in the table, there are several devices from the same returning store. See 4 lines below, these are just one of the dups, all is same except ID. I did try a composite...

Hi Thanks for the help. The query was supposed to return results based on all fields been the same, so every field duplicated. It may be that when someone submits an update to the original data in the main table that that particular field isn't copied to the new table, hence it just adds the...

Many thanks for the quick response. It doesn’t matter about the primary key because this table has no relationships, it is simply used to get stats for an excel report. Regards

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...

Hi Again I can't remove the date as this is needed to get stats based on month etc. Not quite sure what a Boolean is. Newby still, although looking for a good access book to read. Regards

I did have more than one field selected in the index, so a composite it was. Still not solved my problem though. Back to the Delete query then. Help appreciated with delete query as mentioned in earlier post. Regards

Hi Again Not sure what you mean by composite (still learning, the hard way). I did create an index in the table and it worked fine, it blocked the dups as expected, the problem is that every time the team over click the submit button, thus trying to create a dup, I get a popup error message...

Hi Thanks for your response. The table was created to monitor specific faults of returned devices and keep a total of each fault. Lets say a device comes in in Jan with a fault, that fault and date is recorded in the table against that device (asset No). Now, 3 months later the same device...

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...

Many thanks for your time. That was exactly what I was looking for, just wasn't sure of the Criteria bit (still learning). One more question though, I click my button and the report opens but it opens in a new tab, I have to close the report to get back to my original form. Is there a way to...

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...

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...

Hi Thanks for your response. I'm still learning and am not quite sure where to put the above to run the update. Instructions on where to put it would be really helpful. I have tried a couple of places but to no avail. I assume I copy as is but replace [field] with my field name? Many...

The new field is set to Text but as I copy them they lose the zeros as this was just the format of the original field and not the number itself. Could I, in a field formatted as Text run something that takes all numbers wether they have 2, 3 or 4 characters and convert them to an 8 digit...

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...

Thanks for your response. I'm a newbie but learning fast. How and where do I put this? Format([MyField],"00000000") Regards

You are right, its not a number. We have asset tag barcodes with 8 digit numbers (00000001 - 99999999), if I edit an entry using a form by scanning the barcode, it inserts all 8 digits, but if doing bulk entries we scan them all into a spreadsheet then import, it saves loads of time, but then I...