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 derfloh 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. 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
  16. Yukonbanzai

    User defined entries in a report

    Obviously I mucked something up. Tables that I have are "Data" - contains the names of the cadets(students) Have created the form "frmSelectCadet" List box is named "lstCadets" This is the code behind the On Click Dim frm As Form, ctl As Control, vData As String Dim varItm As Variant Set...
  17. Yukonbanzai

    Attendance Table

    I've got an existing table with the people in it and I've created a table with meeting dates that are given ID numbers. I just can't seem to grasp how to put them together to keep track of attendance. tblData LastName FirstName tblDate MeetDate DateID
  18. Yukonbanzai

    User defined entries in a report

    I have a report that lists information about students for going on trips. I need a way that the user can decide which students names will appear on the report. Students that are not on the trip shouldn't be on the report. Any help appreciated
  19. Yukonbanzai

    Attendance Table

    Not sure of the most effecient way to keep track of a groups attendance. The group meets once a week. There are between 20 and 40 people. Need to be able to mark every person as either "present", "excused", "sick", or "awol". All personal information is currently in a table named "Data". If...
  20. Yukonbanzai

    Counting multiple values in a field

    Thanks again Works just the way I need.

Part and Inventory Search

Back
Top