Search results for query: *

Hi Great - Thank you I will have a play with that tonight Ralph

Hi Is this report based on a query? If so you could change the join type to show all House Types from the House Type table Ralph

Hi Thanks for the response - this report is driving me mad trying to unpick it! There is not record source query as there report comes from a table. There is a the following filter applied: ([complete]=yes and [Lab ref no] between [Lab Ref From] and [Lab Ref To]) But i still cant get it to...

...' This routine sets all of the test parameters used in suites to ' invisible, then resets those used by the suite to visible. '********* SET VARIABLE AND PARAMETERS ***************** Dim mydb As Database, st As Recordset, res As Recordset, testname As String Dim myc As Control, tgrp As...

Hi Thank you for the suggestions but this just changes it to print preview - which is great but it still doesnt print the audit information out - i need to somehow get it to find the audit that i want to print and then print it? Thanks Ralph

Hi I have a report that i have inherited from an old database that i have upgraded from 97. The report somehow used to print out the last audit that was completed and print the details but since upgrading the database this no longer works. I would like the report to prompt for the lab...

Hi Thanks Pampers - will do Ralph

There is a labref field pointing to the correct field in the table but when the report prints - it prints nothing. There is a filter I've just found ([complete]=yes and [Lab ref no] between [Lab Ref From] and [Lab Ref To]) But i cant see how it knows what lab ref to print? Ralph

Hi Thanks for the information but i've tried this but it doesn't prompt - i've attached the procedure that calls this procedure as this might help! (I hope as i'm going round in circles...) I'd be happy to get it to work how it did before we moved it from 97 Private Sub...

...' This routine sets all of the test parameters used in suites to ' invisible, then resets those used by the suite to visible. '********* SET VARIABLE AND PARAMETERS ***************** Dim mydb As Database, st As Recordset, res As Recordset, testname As String Dim myc As Control, tgrp As...

Hi I have a report that i have inherited from an old database that i have upgraded from 97. The report somehow used to print out the last audit that was completed and print the details but since upgrading the database this no longer works. I would like the report to prompt for the lab...

...' This routine sets all of the test parameters used in suites to ' invisible, then resets those used by the suite to visible. '********* SET VARIABLE AND PARAMETERS ***************** Dim mydb As Database, st As Recordset, res As Recordset, testname As String Dim myc As Control, tgrp As...

Thank you that's done the trick! Ralph

Hi I've just retested the code and it does refresh the combobox but doesn't keep on the record that the user was inputting - it jumps to a new record or a previous record. How can i ensure that when I close form that the main form doesnt change record? This is the code: DoCmd.OpenForm...

Hi Thanks you both for your help and comments Ralph

Hi I have combo box on a form called SourceID and a command button that opens the Frm_Source if a user needs to add a new record. when the Frm_Source form is closed the SourceID Combobox doesn't refresh? My current code is: Private Sub Cmd_AddSource_Click() DoCmd.OpenForm...

Hi Thank you Gary that solved the issue THanks to all for the input Ralph

Hi I've been through the site and tried all the suggestions but must be missing something as can't seem to get it to work. I need a tab to be disabled if a control on anther tab is false. I have the following code: Private Sub Complete_AfterUpdate() If Me.Complete = True Then...

Hi Thanks for the quick response All sorted Ralph

Hi I have a database that i have inherited and i'm getting the an error on the following line of code: Sub update_system_record() DoCmd.RunSQL "UPDATE [system values] SET myt!last_num = (current_val + 1)" End Sub The code should update the system values table with the current value but...