Search results

I have a command button on a continuous form that opens a report for an individual in my fishing club with the following: Private Sub Command22_Click() DoCmd.OpenReport "rptMembersLedgerDebitsAndReceiptsTEMP", , , "Surname='" & Me.Surname & "'AND FirstName='" & Me.FirstName & "'" End Sub...

Dear All Happy New Year I am trying to find a way to use VBA to name and export a report. I have a continuous form displaying records with a button to generate the report when I need to. I am using the following VBA for the onclick event of the button to open the report: DoCmd.OpenReport...

Dear All I have a main data entry form for my fishing club that is based on a parameter query using two parameters. I have another continuous form that allows me to see at a glance who has paid up and who hasn't. I would like to have a button on the continuous form that uses the two parameters...

Dear All I have a form with a series of buttons that when clicked export data to an Excel spreadsheet using VBA like this: Private Sub cmdOpenEnterMembersDebitsAndReceipts_Click() DoCmd.OutputTo acOutputQuery, "qryAccountantSubReceiptsAfterYearEnd", acFormatXLSX...

I have a form to show debits, receipts and a balance for members of my club. The form is based on a query (qry3 which calculates balance from the output of qry1 and qry2) that is itself based on two queries (qry1 and qry2 which calculate the sum of debits and receipts) to produce the required...

I hope you can help. I have a small database I am using to track ledger debits and receipts for members of my angling club (110 members). Some members have bar spending some do not some have made payments for this some have not. The structure is a members details table with separate linked (by...

Dear All, after quite some time away from this group I find myself in a state of confusion and in need of help after resuming my use of Access........I am treasurer of my angling club and have a data base to record items members have from the bar and other items including their subscription to...

Dear All I am trying to use this code in a new database having used it in another to generate a list of records in an unbound list box (ListContacts) by typing the record number or surname in an unbound control (TextSurname): Private Sub TextSurname_AfterUpdate() If...

Dear All I have three tables: Event related on to many with Procedure Procedure relates on a one to one basis with the description of the procedure in a table called ProcedureCodes. I wish to have a query which outputs three columns: Event - Prcedure1, Procedure2, etc - Description1...

I have some code for a button on click event to open a form and select the record which corresponds to a value in an unbound text box. The code is: Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I have a number of forms where there are memo fields containing several paragraphs of text. I have set them up so that the on-update event triggers the MSOffice spellcheck box/dialog to open so the text can be corrected. All works fine but the box/dialog always opens in the middle of the...

Dear All Im confused again and need advice. I have a text box with vba in the on update event to populate a list box. The code is as follows: Private Sub TextSurname_AfterUpdate() If IsNumeric(Me.TextSurname) Then ListPts.RowSource = "Select [tbl-patient details].[Patient...

I have a number of forms where there are memo fields containing several paragraphs of text. I have set them up so that the on-update event triggers the MSOffice spellcheck box/dialog to open so the text can be corrected. All works fine but the box/dialog always opens in the middle of the...

Seasons Greetings All I have a minor niggle I am struggling to iron out. We have a database recording patient records and I am trying to stop people including me....!!! entering new records when the record already exists in the database.....it seems it is easily done after a hard day at the...

Dear All I have a continuous form and have set up a right click popup menu on the record number control to allow me to print from a list of reports which works fine - it was set up using the Tools/Customize method. The reports are based on queries which ask for the parameter record_number. I...

Dear All Not sure if there is a solution to this but here go's I have two subforms on a main form linked by parent/child. The first subform is a table view listing records. The second subform is not visible until a control on the first subform is clicked whereupon it becomes visible showing...

Dear All Your help would be much appreciated once again. I have two subforms on an unbound form. Subform1 has a list of clients as a continuous form. Subform2 has detail of each client and is set to invisible. The forms are linked with a common child/parent field. I am trying to get subform2 to...

Dear All Your help would be much appreciated. I am running Access 2003 and have a database where I have a tab form listing a series of records. To aid user visualisation I would like to set the row background colour so that it is different depending on the value shown in TxtBox Events_place...

Dear All More help needed if there is a solution. I have a form with a list box on it. When I select a record it opens another form with the full record using the OnClick event with the following code: Private Sub ListPts_Click() On Error GoTo Err_ListPts_Click Dim stDocName As String...

Dear All I have an unbound list box which is populated from an unbound text box. I wish to use the OnClick event of the list box to open a form with the full record of the row selected in the list box. The code I have so far is: For the unbound TextBox: Private Sub TextSurname_AfterUpdate()...