Search results

  1. V

    Printing from a form, seperate reports

    Thank you very much After realizing how brain dead I am, I change you code and made it work. It works great. Now my routes can go to different reports. Thank you again
  2. V

    Printing from a form, seperate reports

    Okay I think were getting closer I understand what your doing, but now it gives an error "Item not found in this collection. This is the recordsource for the form ' set record source in SQL to point to data in main.mdb ssql = "SELECT DISTINCTROW Tugger.[PartNumber], "...
  3. V

    Printing from a form, seperate reports

    Maybe I'm not clear I have a continous form say with 6 records. Record Route 1 1 2 2 3 1 and so forth. When I press my print button I need it to loop through these records only and then print out the report that the route matches. Record 1 Route 1 to...
  4. V

    Printing from a form, seperate reports

    Sorry I have access to the front end of the program and I'm linked to a sql and canot copy tables, so I cannot post the database. This is the command on the form. Maybe this is where I'm going wrong? Dim ctl As Control For Each ctl In Me.Controls With ctl Select Case .ControlType Case...
  5. V

    Printing from a form, seperate reports

    Okay Now explain what you mean. I have tried to filter he reports, but the same thing happens. It prints all the records whether they are route one or two from the if statement that goes true.
  6. V

    Printing from a form, seperate reports

    I have a form say with a control called route. What I have been trying to do is print out report for each route. (I have a different report for each route) I have a command button on the form with if statements, but it prints all the records from the the form to whichever If statment is true...
  7. V

    Random Pick, but grab identical records

    Thanks Left Join works great. Such a simple solution.
  8. V

    Random Pick, but grab identical records

    I need to randomly audit parts in a warehouse. I have the code to grab random records. No problem there. The problem is the part might have mutiple locations, so I need a way to grab a random part and then check to see how many locations it's in and make sure it grabs all other locations that...
  9. V

    access project queries

    Information Sql 2005 and access 2003 thx
  10. V

    access project queries

    I'm trying to modify a query in project but I get this Error and not sure where or how to fix this problem. I've been searching Microsoft Web Site. You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released...
  11. V

    Using Last in Query

    Explanation What I have is a form with a person id number and then in the details I list the programs they have attended only showing the last date they attended. They attend these programs every year or they might miss them, so that's the reason for the last date. Then what I would like to...
  12. V

    Using Last in Query

    Not sure? Tnak you Darren Bartrup and Brianwarnock for your assitance. BrianQarnock, I'm not sure how the temporary table would work. I can see how it duplicates information, but how would the original table get update or joined.
  13. V

    Using Last in Query

    Thanks. Read the the link. That make sense. I'll just create am seperate entry form. I was hoping I could show the last date on this form and then add a new entry. thanks for your help
  14. V

    Using Last in Query

    Any Other Suggestions Any more ideas on how to make these queries updatable? thx dmh
  15. V

    Using Last in Query

    Thank you I understand how to get max and last now, but the problem still remains, when you run this queries they are not updatable. Add / Update or Delete. Iwould like to be able to add to the list. Seeing what the last date it was held.
  16. V

    Using Last in Query

    I thought I had on the first message. Oops!! Thanks for your help
  17. V

    Using Last in Query

    Thank you Thats works great for one record, but I need all the records for one clockid showing the last date for each program code. I tried a few options, but all i get is errors.
  18. V

    Using Last in Query

    I have a query where I need to use last record, but the problem is this prevents the records form being updatable. Add / Update / Delete. Query is the recordsource for a form. I have tried sub queries, seperate and in the exsiting query to no avail. Any guidence would be apprecited. thx...
  19. V

    Indentify a page index (tab)

    WOW -- Thanks! Such a simple solution to something that was driving me crazy! Thank you!
  20. V

    Indentify a page index (tab)

    Clear up confusion. I think it's me asking question. The equal sign is not there. Please look at attached database. The form is contacts, the tab attendence. This record in the list box stays the same no matter which record you go to. Thats what I'm trying to fix in the query. The query is...
Back
Top Bottom