Recent content by John Lee

Thanks

Hi Thank you for your response, What I am trying to do is get a value from the latest record in the subform and assign that value to the a field in my main form. The problem is that for some reason access isn't finding my subform which is within the main form and the master and child fields...

I have a main form and a sub form of which I have linked through the child and master fields I want to obtain a value from the sub form and place it in the main form. In my Main form I have a field txtRiskMatScore and I want the value from the field txtScoreRating in my sub form to be assigned...

Hi, I tried your suggestion, but I kept on getting the same message, so a bit stumped at the moment, I'll go back and check through the database again to see if I can identify anything that may be upsetting the cart.

Hi arnelgp, Thanks, I'll give that a go, cheers

Good day, Folks, I have been trying to create the accde file for my database and I have been following the on screen instructions, however I keep getting the message "Microsoft Access was unable to create the .accde, .mde, or .ade file" I have check through were there is code written and...

I'll check that out, the database is not going to be holding huge amounts of data, it's not a big company, we have 30 employees and there will be a maximum of 8 users including me, it's based around ISO 9001 Certification Auditing.

The IT rep is the Finance Director and he was very very clear that no work is done outside of the cloud, so I'm feeling that I may not be able to deploy the database.

Thanks for your response, I'm not familiar with SQL Azure and as far as I'm aware they do not use SQL Azure, the company also doesn't use Citrix. I'll explore the remote desktop possibility, but I don't believe they have anything like that setup.

Is there any other options I could explore

Thanks for the clarification, that's that project dead in the water then

Can a split my MS Access Database work in the Cloud Environment. The reason I ask is that I have developed a database, and having watched the video by Richard Rost on how to do it, I approached the Company IT Rep and I have been told that I can't have a separate drive allocated for the split...

Hi I want to be able to always have the Manager job titles in each of my queries to be the first record, any ideas on how to achieve that, any assistance appreciated.

I did upload a word document with the code in it, however the problem was that I was referencing the wrong form, on checking several times and going through code a bit at a time, which was how I found my mistake.

Hi thanks for your response, I've found the problem and its now resolved