Search results

Thanks for your clear and concise reply Pat. What you say is perfectly correct and I empathise with your logic. If I were in a commercial environment where the historical integrity of the data was critical, then to a 'T', that would be the route I'd follow. However, as I appreciate you realize...

That's exactly what I'm trying to acheive. I'll give it a try. Thanks.

Thanks, so busy writing I hadn't noticed the code. Should I cut & paste it into the criteria of a query under the 'Disk' field?

Yes jdraw I already use various queries that search by these fields, but I can't search for data in fields that don't exist, because they've been deleted!

Yes, it will appear on every record relating to that disk.

I do always. A disk can hold up to 100 separate recordings, though in practice the average is 3 - 4.

I clearly, haven't described my problem very well. I also realize that I'm communicating with you and others who have a far greater depth of experience in Access programming than myself. Let me describe the practical side of what I'm trying to acheive. I'm a retired engineer with no background...

Hi, attached is a screengrab of Recordings Table. The datatype of the Disk field is highlighted as in this instance, I think it's the only field that's relevant?

Thanks, but there's never a Null value in the Disk field. ie. In the attached screengrab, it shows that I've deleted the faulty disk number 488, and can now replace it with a new disk, and new titles. I just need to be able to quickly locate these missing disks.

No Minty, I don't need to know what was removed, or when.

Good morning, I use Access 2000 to store details of recordings on DVD discs. There are well over 1000 discs on file and sometimes a disc may get damaged. These, I physically remove from the collection and also remove the record from the Recordings DB, which leaves gaps in the collection where...

Ok Gasman thanks, I'll give it a try.

Yes, of course Pat and many thanks. Even though I don't use forms, I suppose there's nothing stopping me creating one just to run the query!

Thanks for your detailed reply Pat. I was intending to change all instances of pop-ups to combo or text boxes anyway. You mention their use with forms, but as my usage is always personal I haven't got much use for forms anyway. Can I use text or combo boxes directly with a query?

Thanks MajP, that was just what I needed!

What's the SQL Plog?

On Access 2000, I want to produce a query by a complete match on one field, but also by a match on part of the text string of another field which is entered in a pop-up, ie.to query the Title field and list all records containing the string 'Ship' . I've tried different expressions but none...

Sorry, forgot to mention I'm using Access 2000.

I've been dogged by this problem on separate occasions for quite a while now. When I run the attached query it prompts me to enter the Media Type as expected, but when I do and then press enter, it repeats the prompt so I have to enter the Media Type twice before it lists. This is annoying, and...

Query selection in Access 2000 Just a note to thank the contributors whose stamina was endless and 'lit the way' in helping to solve this problem! I've still a huge amount to learn, but fewer problems to solve, thanks to you.