Search results

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

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