Recent content by John Lee

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

Good day folks, I'm trying to reference a field in a form from a report, the problem I'm having is that the code keeps saying that it can't find the field in question, but it does exist, I've checked several times and can't work out why it is not finding it, I've attached the snapshots I took...

The problem with a cross tab query is that it requires a value to calculate and there are no values to calculate, unless I am mis-understanding how it works

Good day folks, I have a spreadsheet (example attached) that I want to recreate in an Access report, can anyone help me with this at all, I've also attached an example of what I've been able to achieve in Access so far, but if it is possible I'd like to re-create the attached spreadsheet look...