Search results

Hi I am currently having a problem, whereby the system hangs for about 3 - 10 seconds when it steps to a date assigning code. The code is below, with the affected one in bold If IsNull(Me.HistoryDate) And IsNull(Me.HistoryTime) Then Me.HistoryDate.Value = Date...

Thanks Spikepl, you suggestion reduced the time to between 2-3 second.

I have the code below, that writes data into a table. It takes 37 seconds to create 1000 records. Please can anyone suggest how I can modify the code to improve the time it takes to create those records? Many thanks Private Sub cmdStartDateTest_Click() Dim start As String Dim...

Please can any one help me to convert this statement to work in Ms Access. It works perfectly in SQL Server. UPDATE tblCarMileage SET tblCarMileage.NI_NUMBER = tblEmployee.NI_NUMBER WHERE tblCarmileage.employee_number in (select employee_number from tblEmployee);

Yes I did include it.

Thanks DCrake, I have done exactly that, create a macro and then use the code generated, however, I get a different message. It is attached as errormessage2.jpg The code generated by the macro is below Selection.InlineShapes.AddOLEObject ClassType:="Word.Document.8", FileName _ :=...

Error using Access 2007 to Open word 2007 I am currently developing an application using MsAccess 2007. As part of the development, I need to create a word document that draws tables and enter data including links to the table. When I run it with Word 2003, everything works perfectly, but when...

Thanks BobLarson I have made use of the Access connection. However, I am beginning to realise that I may have to migrate the database to MSSQL 2005.

I have recently migrated a MsAccess application from Access 2000/SQL Server 2000 to Access 2007/SQL Server 2000. When I logg into windows as an administrator, the application starts ok and I am able to use it. When I log into wndows as a standrad users, the application hangs for about 2 minutes...

Hello Please I will appreciate some help with ACCESS 2007 and SQL Server. I am currently migrating an Access 2000 application to Access 2007 adp. I need to send 2 parameters from a report to a stored procedure. The values of these 2 parameters are derived from a sub form. I have defined the sql...

Thanks boblarson. I have decided to change the way I add records to the table, by making use of the ADODB.recordset, but I am still having the same 2105 problem. Below is the code that I am currently using Dim company_id As Integer Dim cnn As New ADODB.Connection Dim rst As New...

I have created a form, when I add the first record, it works perfectly. After saving the first record, when I attempt to add the second record, it complains and gives me the error 2105. Can this be because the saving of the record has not been commited to the SQL server database? The code that I...

JamesMCS Thanks for your help. I have found the code (which is part of the save code) that is causing the problem. When I run the code below ' Change default editing to disallow adding new recs. frm.AllowEdits = True frm.AllowAdditions = False 'Lock all detail...

Thanks very much for your help. It is still not working, but I will see if I can try something else out. If it ever works, I will let you know what I did to make it work.

Thanks, yes I have tried that, but I still get the same result.

It is just this form that is causing the problem. Also it does not always quit when that code runs. It only quits if I have a record that has just been created. If I save a record that has just been updated and then close the form, it closes in the correct way.

Thanks, I have searched every where within the form and could find nothing that warrants the from to quit access. This is really strange, this is why I had to come and seek some advice on this forumn.

The value that prints from me.name is "frmReview", which is the name of the form that I am trying to close.

Yes, when the code is run, the form quits access.

No I don't, but thanks for asking.