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!

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

Recent content by Yukonbanzai

  1. Yukonbanzai

    User defined entries in a report

    Not sure if this is relevant or not, When I close the db and reopen it, the form works fine. It just seems that its not deleting the previous selections. Russ
  2. Yukonbanzai

    User defined entries in a report

    All the error and parameters are gone. Only thing left is that when I run the report, the names from the last run remain. Example: I run the report for cadets a,b, and c. Close form after printing. Open form and run for cadets e,f,and g. When I veiw the report, it shows a,b,c,e,f, and g.
  3. Yukonbanzai

    User defined entries in a report

    DID the Stop thing and ran ?vData. It returned the exact name I had Hilighted.
  4. Yukonbanzai

    User defined entries in a report

    Code as follows: DoCmd.OpenReport "Medical Data", , , "InStr(1, Cadet_Names(),[Cadet_Names])>0" I'm in Whitehorse, Yukon, Canada. Right next door to Alaska, go there all the time. Russ
  5. Yukonbanzai

    User defined entries in a report

    Got rid of the parameter request by making the record source for the medical report the qryData as you said to. (missed that one) Now I get a blank report eventhough I've selected numerous names.
  6. Yukonbanzai

    User defined entries in a report

    When I click the report button I still get a parameter request for "Cadet_Names". Also curious if the "qryData" should end up bring up the entire "Data" table?
  7. Yukonbanzai

    User defined entries in a report

    Deleted the DIM part, no problem Pasted the code into a module. Has name of "Module1"
  8. Yukonbanzai

    User defined entries in a report

    I've put the code into a module. What exactly do I have to do to remove the vdata from the DIM statement. Deleting it doesn't work. Sorry for being so dense
  9. Yukonbanzai

    User defined entries in a report

    I've created the queries "qryCadetNames" and "qryData" Following code is behind my command button. Getting a pop up to enter parameter "Cadet_Names" Private Sub cmdRunReport_Click() On Error GoTo Err_cmdRunReport_Click Dim frm As Form, ctl As Control, vData As String Dim varItm As Variant...
  10. Yukonbanzai

    User defined entries in a report

    The row source in the list box is SELECT Data.[Health Care #], Data.[Last Name], Data.[First Name] FROM Data ORDER BY [Last Name];
  11. Yukonbanzai

    User defined entries in a report

    Before I change things, The list box that I currently have is showing the cadets full name. If I can get rid of the "enter parameter" pop up, it should be OK??
  12. Yukonbanzai

    User defined entries in a report

    The field for the cadet name is "Last Name". Also have a field for "First Name". Tried entering a cadet's name and it printed out fine. Is there also a way to add the first name? Have multiple last names.
  13. Yukonbanzai

    User defined entries in a report

    I still get the pop up "Enter Parameter Value" for "vData" If I click enter without entering a value, it prints the report without any information, just the headers, etc.
  14. Yukonbanzai

    User defined entries in a report

    Also forgot to say that with the above code I get a pop up that requests "Enter Parameter Value" and "vData
  15. Yukonbanzai

    User defined entries in a report

    Forgot to mention that the report name is"Medical Data
See more

Part and Inventory Search

Back
Top