Recent content by WorkDatabase

I have used VBA to import the data and its worked.

Using the external data option in Access. I have just counted the characters it appends up to and it stops at 255 characters which is the parameters for Short Text, but my table is set to Long Text before the import, so access is still using the rule of Short Text when appending or creating a...

Hello, When Appending data from excel spreadsheet, i have cells with a lot of text in cells. I have made sure my table is in Long Text when Appending. I dont get any errors and everything looks successful yet when i go to the table its only appended half the data. I was looking to see if...

Thanks for the information, I solved it using your information on how a form in add mode works. Should have known but just having a tired and lazy day. Thank you very much. I updated the code to open the form in Add mode but to update the existing record. Problem solved.

Ok, understand, what’s the solution?

It’s definitely not happening when I close the form without hitting the save button.

I have disabled the BeforeUpdate event in the code and it’s still creating that record.

The problem is that the blank record isn’t created at the point of opening the form. The 2 records are created when the save button is clicked but I can’t see anywhere in my code where this would happen.

The first bit of the code opens the form and pre populates the controls. Private Sub AddNewComment_Click() Dim strReference As String Dim strEmployeeName As String Dim dtDateTime As Date ' Get the filtered values from the subform strReference =...

Hello everyone, why is my form creating 2 records? I have a form that 3 controls are pre populated with data from a subform. The rest of the controls are empty and the form is in add mode. When I save the records via a button it creates the record that I have entered the data for and then a...