Search results

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...

Good day Gasman, I've confirmed what you have said that the LACCDB file is not being generated, so I've requested the IT Company that looks after our system to make adjustments to those individuals profiles to match those who are able to open the database and generate that file, so that should...

Hi Gasman, thanks for your response and apologies for the delay in responding. No Richard has always been an engineer and has never served in the forces. That bit of code is run whenever the database front end form loads, it part of code that creates a record in my userlogin table to identify...

Thanks for your response, when I'm back in work tomorrow I will check this out accordingly.

I am planning on splitting my database for multiple users. however I've been conducting some testing on each workstation individually to make sure that they can access the database and view the parts of the database they've been set up for. The problem I have is that 3 out of 7 of my users are...

Yes, its my front end form, when the user clicks on the shortcut icon the code identifies the user via the Code: Environ ("UserName") End Code and then I declare the record set (Rs) and set it to open in the tblUserLoginID table. I don't understand why it works for others and not this one...