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...
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...
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
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.