Recent content by A. Turtle

Hi Guus, yes database is normalised. The only piece of data that is repeated at this stage is an ID code which identifies where the data came from. At a later stage the data thus collected will be imported into the main database, but at this stage the users do not have access to that and can...

I may have found the reason for the PK one. That key is used as part of the Join statement in another query. Would this constitute a relationship? If so then I will have to find a way round that.

Hi Ken, thanks for the reply. Warnings are now off, and a Debug.Print with incremental number has been added after each query so that I can see where the warnings occur. One of the errors is caused by trying to change the value in a PK which it claims is part of relationship. That's odd...

I have an empty database, copies of which will be used in a number of locations. Before a copy is sent out to the user some data, specific to the user's location, needs to be entered into a total of 40+ tables . I have tried to do this using a series of Update and Insert queries in VBA, but...

I have an empty database, copies of which will be used in a number of locations. Before a copy is sent out to the user some data, specific to the user's location, needs to be entered into a total of 40+ tables . I have tried to do this using a series of Update and Insert queries but find that...

Thanks for the explanation but, if I can be forgiven for saying so, it does seem like complexity for complexity's sake. Other RDBMS's seem to manage with less convoluted methods - iirc.

Google gave me the wiki one, and also http://www.br549.org/ otherwise I'd have had no idea. What did we do before the web and search engines existed?

That was a high one - I'm 6' 2" and it went right over my head!! Maybe something to do with me living on the wrong side of the pond. I don't think that one has ever been shown over here.

Apologies Ken. It really is a bad day. I seem to have mislaid not only your address for the cheque, but your bank account details for credit transfer as well. ;)

To KenHigg Many many thanks. That was one combination that I apparently hadn't tried during my perm(x) from y exercise. And - IT WORKS!! <VERY HAPPY GRIN> To Uncle Gizmo Ooops, it's that kind of a day. That was a typo, corrected later, but before I had updated my browser and seen your...

Will someone please help with a definitive answer as to how to indicate that that a word in an Update query is a variable, and that it is the content of that variable that is to be written to the required field? I have a variable, strThisUser (the current user's name) - that I want to store in...

Hi Lagbolt, Done and working. There were other ways of presenting this bit to the users, but they were untidy, and imho offered far more opportunity for error. Hopefully this will minimise those opportunities. The users (unknowingly) and I will be grateful for a long time to come.

Hi yet again Lagbolt, I presumed, wrongly it seems, that in this context "SourceObject" was the object that was to appear on the main form or tab, i.e. the complete subform. To break down how I understood the command: "Me.SPS_Payroll.SourceObject = "frmSubSPS_Payroll" works "Me" is the...

Once again Lagbolt, thank you for your time and help. I have deleted SourceObject as stated, and control does indeed go white and says "unbound". However the error remains the same; "Compile Error: Method or data member not found", and the part of the command that is highlighted is...

Hi Lagbolt, Many thanks for the reply, but I am having problems using the example code you gave. The controls were deleted as you suggested, to leave blank pages. The pages have been named, without spaces. My version of the code for the first page reads: Me.SPS_Payroll.SourceObject =...