Search results

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

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

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

Hi, I currently have a form which is used to return almost 100 columns from a table for a user to review. By selecting a reference from a combo box, it then returns the relevant column entries from the table below. At the moment I am using a dlookup to return these, however, it is too slow at...

Hi, I have a split multi user database with a user form being used to input date into 3 tables. On occasions an error will occur when submitted a new record which is run time error 3167 - record is deleted. What is the cause of this? And is there any way to catch it in the code? Thanks

Hi, I have a large access form which is used to input data to a table and sometimes ometimes this form needs to be printed as one page. Printing the form itself isn't really working due to its size as it is printing as multiple pages and not been able to get around this by tweeking the...

HI, I'm currently migrating an excel scoring document into an access form. Within the excel file there are 8 line items which are scored with Yes/No/NA. A formula is in place to sum the total applicable and divide by the no of fails to give a %. So far the access form is built but i need to...

Hi, I'm using a form to add new records to a table. The issue I am having is that all of the entries from the form are being added as a new record to the table minus one, for some reason it leaves the column in the warehouse blank. On some instances it adds the data correctly but not always...

Hi, I'm trying to combine a dlookup and dlast to return a value. Currently I have the Dlast below which returns the commitments from last meeting field for the last entered record. I need to add a bit into the formula which references the agent selected in the form I have to return the last...

Hi, I have a table which contains fields agent and month no, also Call ID. =DLookUp("[CallID]","OperationDataWarehouse","[Agent]='" & [Agent] & "' AND [MonthNo]='" & [Month2] & "'") I am using the above dlookup to return the Call ID for the agent and month no selected in a form. Is is...

Hi, I have a form with a few text boxes which users are inputting lots of text, usually over 255 characters. This is then submitted as new records in a table into fields formatted as memo. The issue I am having is that anything after 255 characters is cut off. How can I prevent this from...

Hi, I have a front end access form which is updating a back end table with new records. This is published on Sharepoint and users are having no issues simultaneously adding records. I added some columns the other day to the back end table, following this I made a change to a record in the...

Hi, I have a VBA code which submits details from a front end form into a back end sharepoint list. The code is quite large so I've had to split it into different modules and call them. I need each of the modules to update the same line in the table. The first module uses rec.addnew. To add...

Hi, I had a front end form and back end table, the form was used to add new records to the table. It previously worked fine, however recently i've noticed that the VBA code is running fine without any errors but no records are being added. Currently just a local database but tables and forms...

Hi, I currently have a split database published to Sharepoint with the data being stored in lists. Currently about 20 users are operating a front end form and adding data simultaneously to a back end table. I need to add some extra buttons to the front end form and extra data collection...