Recent content by Aristillus

Ok, here is the basic SQL which was auto generated from the update query. Not amended it in any way. UPDATE [observation-transfer] SET [observation-transfer].ID = [observation].[ID], [observation-transfer].[Modified Grade] = [observation].[Modified Grade], [observation-transfer].[Final Grade]...

Where would I find that? I just created the query using "create query in design view", used "convert to update query" and then manually typed in the destination fields.

Thanks, I agree about the function. Shouldn't affect the operation though, I don't think. I also assumed a typo, but I have checked and everything is as it should be. Every field comes up as a required parameter though, not just one or two.

Hi, The issue is that each time I resolve one part I come up against another obstacle. Never sure whether to plod on or start again! I have a button which exports the code to a txt file in csv format, using some VBA code. That works fine because I can open the txt file in notepad and check it...

Ok, I'm getting a bit bogged down here and can't seem to make headway. What seemed like a simple task is proving a nightmare! Can someone tell me if I'm doing this the wrong way: 1... An inspector enters his records into his local database on his laptop 2... He clicks an "export" button which...

Spikepl, I hear what you're saying but I'm on a steep learning curve. I was getting hung up on PKs because this is what Access uses to automatically append and/or update records. I assume that if i used your method of Inspector ID plus datestamp I would have to write some VBA to work out what...

It may be that I am missing something fundamental here. Let's imagine for simplicity that there are just 2 inspectors, A & B. Each has a laptop loaded with a brand new empty copy of the database. In a central location on a server there is a third copy of the database, again brand new and empty...

The "inspectors" in this case are have to tick and comment on certain crieteria being met. If the criteria are not being met, they don't get a tick in the box (literally, on the database) but they wil be tasked with putting the problem right, at which time the record will need to be amended and...

Gemma/Dave, Updating changes to the main database IS the problem, or rather it is a problem unless the user's laptop "knows" the new PK. as I don't want to keep copying the database both ways (the users are not IT-savvy and just click a button to export the data they have created/edited into a...

Nanscombe, Thank you for your idea. I am unable to work on the database for a day or two but as soon as I can I will look at the file you posted. Thanks for your time.

Lagbolt, Thanks for that! I think I have achieved similar using my input form, although you seem to be saying I can do this directly in a table? I will try this when I get some time.

Spikepl, already tried the search route...wading through dozens of posts which do not match my problem, and after hours coming across one that does, only to read an answer that says "don't use calculated PKs" is a very frustrating pastime. I did however find an answer on a different site and am...

Sorry, I should have added that the main database cannot be distributed out to all the checkers because of a confidentiality issue which means that each checker is only allowed to see the checks they did themselves. Also, the checkers have no knowledge of Access so i need to keep things easy for...

Lagbolt, my quip about the access fraternity was not meant to be taken seriously. However, my problem is serious as I am totally stuck. Thank you for your suggestion, but it seems very long winded and complicated. My idea of using a calculated PK from a quality checker ID and an autonumber will...

Hi, I'm hoping someone can help with a problem that I've been trying to solve for some time. It seems to me that my problem can't be that uncommon, and yet I can't find a solution anywhere. I will simplify what I'm trying to do here for the sake of clarity. I have one table with around 30...