Recent content by JamesN

It is an ACCDE file. I've got lots of error handling in place but struggling to locate the error, the code runs but on the odd time it just stops but no error pops up so unable to debug. On one instance it kept dropping out of the code but when the user closed the form and re-opened it the code...

Thanks Ranman, it definitely sounds like it is the bug you have mentioned as there are no errors appearing. Is there any way around this?

Hi, I have an access front end database with the tables connected to sharepoint lists. Witihn the database is a main form which is used to score various metrics, if required the user is then prompted to open several other separate forms to select some further details. Data is taken from...

Hi, I am trying to convert a report to a PDF and attach this straight into an email and send it. I have managed to convert the report to the PDF and attach the file to the email but not with the correct name. I need the PDF to be named using the value stored in a text box on the input form...

Checked in control panel and it is set to double sided in settings. Does the VBA need amending?

Hi, I have a database which has 2 different reports (Print Form and PrintForm2) They are printed via a button in a form (code below) DoCmd.OpenReport "PrintForm", acViewReport DoCmd.PrintOut DoCmd.close acReport, "PrintForm" DoCmd.OpenReport "PrintForm2", acViewReport DoCmd.PrintOut...

Liddlem, we have been using sharepoint lists to store our data for around 6 months now. Before trialling this I had no idea if it would be effective but we've not ran into any issues. The only thing which can be a bit difficult at times is when you link your tables to the share point list you...

Thanks for the response. I didn't explain the setup very well, I don't have it published to Sharepoint or anything like that, I also just use Sharepoint just as a BE server only with the front end file just sat on Sharepoint to be accessed by the team. Managed to pin point the problem, was...

Hi, I have a multi user access database hosted on Sharepoint. I've noticed recently when I am saving the file locally to make an amendment to the front end form, once I make the amendment and save and re-open, I am getting an error message stating 'Microsoft Access has stopped working'...

Hi, I'm currently setting up a database using Access 2010 as a front end and have synced the data tables to Sharepoint 2013. The main front end form simply adds new records to one main table, whilst the other forms run SQL queries to update columns in the same table. I'm not using any...

Hi, I'm currently setting up a database using Access 2010 as a front end and have synced the data tables to Sharepoint 2013. The main front end form simply adds new records to one main table, whilst the other forms run SQL queries to update columns in the same table. I'm not using any...

Hi, I currently use a form which needs to create and send an email to multiple email addresses dependant on the department selected in the form. I have a tabled called 'PCFLMList' which stores a Department column and an email address column. My code at the moment creates and sends the email to...

Hi, I have set up an Access database with various tables stored stored as lists on Sharepoint 2013. There are thousands of records added each week and I am currently creating backups manually. What is the best way to create automatic daily backups and how would I go about doing this? Thanks

I have created another form and added the sub form in here, this form is called LookupForm and the sub form is called VarianceLookupForm. How would I reference this from another form called VarianceScorecard, I basically need to confirm if the values entered in the VarianceScorecard form match...

Thanks for the suggestion, I will give that a go. Would it be possible to reference each value returned in sub form via VBA as I need these individual values to be added to another table and checked agains the values entered on the main form by the user?