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

Hi This is the rest of the code that i can that relates to the priting of the report - i just cant see how it knew which labref to print before i upgraded it? Option Compare Database 'Use database order for string comparisons Dim res As Recordset Dim st As Recordset Global lab_ref As String...

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

Hi I have a report that worked fine in a previous version but since updating no longer prints the required record. I've tried reviewing the code below but I can't seem to find how it sets which record to print? What i ideally need is to replace the current code to prompt the user for the...

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 I have inherited a database and have upgraded it to 2003 and i have come across a problem with how a report is run that i can't seem to get to the bottom of! The report menu has the following code attached to the print button but i need a way to get it to ask for the lab reference so that...

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