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

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);

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

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

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

I have currently migrating my applications to Access 2007 ADODB from Access 2000. Most of what I have done now works. I am having a minor problem with one of my forms though. When I save the form, and close it using DoCmd.Close acForm, Me.Name, the code closes the access application. The...

I have currently migrating my applications to Access 2007 ADODB from Access 2000. Most of what I have done now works. I am having a minor problem with one of my forms though. When I save the form, and close it using , the code closes the access application. The following is the code that runs...

Hello Please can somebody help me. I have two tables, tblPupil and tblFSM. I have created a new field in tblFSM called schoolYearID. The tblSchoolYear is a brand new table. The fields in tblFSM are fsmID, surname, forname, dateofbirth, schoolyearID. The fields in tblSchoolYear are...

Hello I am currently having the above error in my code. I have searched the forum, but there is nothing similar. When the system gets to the code in RED, the above error is displayed. Please can anybody help me. Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim rstBatch As...

I am currently have the subscrpt out of range error when I run the code below. The error occurs when the code in red is run. I could not seem to find a similar problem here. Please can anybody help me. Ade Do While Not rst.EOF For I = 1 To CountList If CodeList(I) =...

Hello I am currently running some code, but I get the above error when it gets to the following SQL statement SELECT [MEAL-SERVICE-PRICE], [MEAL-TYPE-CODE], [WEEK-ENDING-DATE], [WEEK-ACTUAL-NO], [MEAL-TYPE-NAME], [CLIENT_SCHOOL_MEALS-CC] FROM qrymealsales WHERE [MEAL-TYPE-CODE] = 'M001' AND...

Hello I am having the following problem with my code. When it gets to the bit highlighted in red, it gives the following message. Too few parameters, Expected 20 Private Sub create_journal1C() ' journal1 - free pupil meals Dim Count As Integer, client_school_cc As String, meal_price As Double...

I am currently migrating my Access Application from Access95 to Access2000. I am having problem with the following code. Sub journal_header(batch_no As Integer, journal_no As String, j_date As Variant, post_year As String) '2. put values into tbjournal_header Dim db As Database...

Hello Please can someone tell me what is wrong with this code. Dim intApplicant As Integer intApplicant = DLookup("[ApplicantID]", "tblMedicalClearance", "[ApplicantID] = " & Me.ApplicantID & " And [PostNumber] = " & Me.PostNumber) = Me.ApplicantID the bold code generates the...

Hello I am currently working on a recruitment system. As part of this system, i am using the mail merge functionality. What I have done is create a table that contains data used for the mail merge. This table has userID as one of the fields, so as to identify the user currently writing data to...

Hello I have created many sub forms to a main form. I access these sub forms via tabs. The main form diaplays full details of a Job Applicant and the sub forms display other information about an applicant. Now one of the sub forms is the posts that the applicant has applied for. When I first...

I am currently having some problems. I have moved an Access 97 application from windows NT to windows 2000. I have some mail merge data that are temporarily created by a query, before being dumped to a word document. Now when the query is called, I get the following message "Cannot update...