Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ralphralph07

    Issue with Report Parameters

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

    Show extra records in report

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

    Issue with Report Parameters

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

    Issue with Report Parameters

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

    Issue with Report Parameters

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

    Issue with Report Parameters

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

    Setting Parameter on a Report

    Hi Thanks Pampers - will do Ralph
  8. ralphralph07

    Understanding VBA Code attached to a Report?

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

    Understanding VBA Code attached to a Report?

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

    Understanding VBA Code attached to a Report?

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

    Setting Parameter on a Report

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

    Upgraded Reports Issue

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

    Requery Combo Box Issue

    Thank you that's done the trick! Ralph
  14. ralphralph07

    Requery Combo Box Issue

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

    Requery Combo Box Issue

    Hi Thanks you both for your help and comments Ralph
  16. ralphralph07

    Requery Combo Box Issue

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

    Disable Tab based on value from another Tab?

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

    Disable Tab based on value from another Tab?

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

    UPDATE Issue

    Hi Thanks for the quick response All sorted Ralph
  20. ralphralph07

    UPDATE Issue

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

Part and Inventory Search

Back
Top