Search results

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

Cracked it. cheers

Thanks for the response CJ London. How would that fit in with the DLast formula in my post? Apologies i'm not familiar with how to phrase the two together

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

You were right CJ London. I didn't use the ADO method as I wasn't familiar with it but I built an SQL query which adds the commentary based objects into the table at the end and that is adding them fully without truncating Appreciate the support

I found on the below link about a limit to characters when storing tables in a Sharepoint list. is this the issue? https://technet.microsoft.com/en-us/library/cc262787.aspx

All of the fields storing lots of comments are saved as memo datatype. I thought this was correct for storing lots of comments in Access 2010? Currently not getting any run time errors, all that is happening is that the first 255 characters are being added to the table and anything after that...

I've never used the form recordsource or ADO method before. Just to add - the form also includes bound objects in addition to unbound. Would it be possible to use the method I have used below but add an extra bit in for the comments? Also, i'm finding that a local copy of the database will...

It is being submitted using the below... Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("Select * from TrialDataWarehouse") rec.addnew rec("Comments1") = commentsfield rec("Comments2") = ucncommentsfield2 rec("Comments3") = ucncommentsfield3...

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

Thanks all for your help. I've deleted some of the columns from the back end database, over 50 which were no longer being used anymore. This has fixed the issue. Will bear the other tips in mind if I encounter the issue again or a related one

Even without changing any data in the table, when opening it, right clicking and clicking save I am still receiving the error?

Getting this error when changing any field. There are a mixture of text, number and memo columns, when making any changes I am ensuring a text is changed to a text only, number to number etc. Not adding any data just simply changing data, eg changing a text column such as "Met" to "Not Met"...

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

Would rec.edit or rec.update work?

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

Think its clicked, do you open the table you want to be linked and then complete the above process? Tried it with a few different tables and it appears to be uploading the selected table only?