Thanks Stewart for your reply
Tried your suggestion but I am getting a Run time Error 2450
'Microsoft Office Access Cannont find the form 'Pay Run Earnings New' (this is one of the subforms) I think this is because the subform is not open at the time because I got the same error when I tried setting the values of the text items in the main form before the 'DoCmd.Openform
vegeta456
Last Activity: Jun 13 '08, 11:25 AM
Joined: Mar 6 '08
Location:
-
Ok.
What should happen is that the sub procedure
sets some text items on on the form 'ErrorPayAdvice '
The form is then opened and the and the records in the subform displayed. The subform is based on the query shown and returns rows related to the the employee number in the master form.Leave a comment:
-
Unbound Master with bound detail subform based on a query
I am trying do display some data in a continous subform which is part of an unbound form.
The master form is supposed to display a error discription window. To do this I call the following sub procedure
...Code:Public Sub display_error_payadvice( LegacyEmpNumber As String, FullName As String, EmployeeNumber As String ) DoCmd.OpenForm "ErrorPayAdvice" Forms!ErrorPayAdvice.[employee
-
Sorry about the delay in getting back, I was ill - pneumonia. That worked thanks very much obvious once you know. Problem for me being a newie to Access is that I asked someone how to do, did who probably did not know.Leave a comment:
-
Unable to read past teh first record in ADO recordset
I have a really strange problem. I am using Microsoft Access 2003 under Windows XP Professional.
I am trying to read a CSV file using VBA in Access using the following procedure.
...Code:Public Sub GetCSV_FileData() Dim cnn As ADODB.Connection Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim f As Integer Dim NumberOfRows As Integer Dim RowNumber As Integer Dim strSQL As
No activity results to display
Leave a comment: