Search results

Yes, thanks Yes, thanks Gasman. Should have worked that one out for myself eh!

Being a 'new kid on the block', I'm green when it comes to forum form & etiquette. I'm not sure if I should be starting a new thread, continually following up an individuals replies etc. I'd like to be knowledgable enough in Access to be able to help others myself, but until then I'll have to...

Can anybody tell me where my query results have gone ? I've two linked files on my Access 2000, Recording and Media. The Media File has a Media Type field, which has been populated with three different values, - DVD-R, PRE, and RAM. I've written a query (see attached query) in order to list the...

Thanks very much Gasman.

Ah! Thanks for solving that mystery for me Pat.

Oh yes, thanks Gasman. Unfortunately I'm still using Access 2000. Would you mind saving the .ACCDB file to .MDB and resending. Thanks

Thanks very much Gasman. Where will I find the file you've uploaded?

Yes, despite the deletion message, no records are deleted. It also misbehaves when inputting the criteria for a pop-up, it asks me two or three times for the same input. I am suspecting (or hoping) that all these problems are the result of corruption, which through your perseverance, appear to...

Thanks for your observations June7. The Expr1 label never originally existed. It was Media, but somehow changed itself to Expr1. I've had to edit all the queries that it affected. You've already said that pop ups shouldn't be used as a user input for a query, which I'm going to put into practice...

Hi Gasman, I've had a busy few days away from the PC. Last week I tried many times to post screenshots and various attachments but all were met by aa error sign Saying "Oops! Something went wrong, this post identified as being spam. Contact an administrator" The files I were tryng to send were...

Hi Pat, does the AW browser have an overload switch that refuses to send any replies once it reaches a certain threshold? For the last three days I've been trying to send replies to online advisors but I just get a message telling me that my messages are spam. I've tried to attach JPEG...

Thanks JDRAW that's something that I wasn't aware of. I'm a retired engineer - You want it, I'll design and build it, but don't ask me to work with a line of machine code! Over the years I've loaded various versions of Access and ended up with 2000, which does the job without too much headache...

You're right Gasman, I'm not clear on the distinction between local and linked tables, neither do I have much idea as to the intricacies of the Access db engine, but of course you'll realize, that's why I'm here in the first place! It's true, there isn't a separate Media table in the storage...

When I open Access and select the DVD File, I then select Tables. In this menu I can select either Media Table or Recordings Table. Surely these are the two relational db's you're referring to. Surely, all the components of the DVD and Media files are contained within DVD File.mdb, if not, I've...

Here's the db in question.

The size of DVD File.mdb is 5.3MB. Is that too large?

Hi, I'm happy to post more info. Do you mean attach the .mdb file intact?

Thanks for your rapid response but I don't fully understand what you wrote. Perhaps, if I was more adept I would be able to fill in the gaps, so I'll have to explain exactly what I've got. The DVD File db consists of two relational tables, Media table, and Recordings table, and together they...

Hi all, as this is my first message I hope all you seasoned users will bear with me. I've used Access for several years to record various information about collections I have. Though I've had quite a bit of experience with the front end, I've usually had to rely on others when attempting...

Hi all, just a couple of words to introduce myself. I'm a retired engineer, and general creator with a passion for collecting. All collections eventually become unwieldy as far as data's concerned, and that's where Access 2000 comes in! My stumbling block has always been getting things to work...