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 firebolt

  1. firebolt

    Multiple selections: FAQ181-5497

    Hey there dhookom, Great news, I got it to work. My Where statement above should read ... Where=pricing.ID, number. I was usung the query as my source, but it had to be the table I had created. It works fine now, exactly what I needed. One other question...do you have a routine or FAQ that...
  2. firebolt

    Multiple selections: FAQ181-5497

    Sorry about that, I missed putting that Tag Value in. Here it is; Where=[print customer].ID,number. I thought I could use the Primary key - ID to select multiple records. I think this is the only one I need. When I do this, it now prompts me for a value, I enter a number, but get all of the...
  3. firebolt

    Multiple selections: FAQ181-5497

    Thanks dhookom, I am using a list box called lstcustomers. It has 3 sources of data, ID, Customer and job_number from a query called print customer (this query contains all 29 fields required on the report). Job number and customer are text fields, ID is an autinumber for my primary key. The...
  4. firebolt

    Multiple selections: FAQ181-5497

    I'm still trying to understand the code; it tells me to create the TAG for the where statement, but that may be my error as I have not completed that section yet. Working thru line by line to debug. Firebolt
  5. firebolt

    Multiple selections: FAQ181-5497

    Hi looking for some help on this FAQ from FancyPrairie. I'm using the module, but unfortunately my selections will not print. Thank you, Firebolt
  6. firebolt

    Updatin field in a 2nd table

    Yes, that's great Richard this worked for me. The minimal coding works for me. However, as I build more into this program your total solution may provide the best format in the end. The code gives me other ideas as well for certain features we have currently worked on. Great, thanks for ALL...
  7. firebolt

    Updatin field in a 2nd table

    Thanks Richard...The tblestudent has fields for amountpaid...coursefee...basicfeee. Also amount_due. Amount_due=[coursefee]+[basicfee]-amountpaid. The record is stored with the studentid. My problem is that some students who owe $60.00 may pay only $50.00. I want to have them pay this $10.00...
  8. firebolt

    Updatin field in a 2nd table

    Hi, Im doing some calculations in a table for school registration. When a student purchases a book, I want to also charge the outstanding registration fee. Once I do this, how can I update the table containing the amount paid with the outstanding fee added on? I'm using a query to select fields...
  9. firebolt

    Print page ? to page ?

    Excellent G. Holden this should do the trick. Thanks, Firebolt
  10. firebolt

    Print page ? to page ?

    Thanks GHolden; I should be more specific. When I choose a button to print a specific report (which i use a preview to check) I would like to receive a prompt that asks me to select the pages to print, similar to the one found when I choose print from the menubar and I change the properties...
  11. firebolt

    Print page ? to page ?

    Hi, I have a report that has 150 pages. I would like to tell the printer to print the first 25 pages, perhaps the next 15 and then 20 or 15 for example. How do I accomplish this task using reports, macros or VBA? Thanks, Firebolt
  12. firebolt

    Random List of people

    Bob this looks fantastic, I will copy this code to my database and see how it works. I think this will give me the flexibility within my current setup that I'm looking for. Thanks, Firebolt
  13. firebolt

    Random List of people

    Thanks Butch, that makes alot of sense and I will give it a go and see how it works out. I think you're right that creating another table will make the best possible solution. Firebolt
  14. firebolt

    Random List of people

    Yes that will work great, but I was looking for a programming solution that could regenerate random numbers which selects from the records already in the database. This is a simpler solution and should work well. Do you know any other method that could involve some code? Thanks, Firebolt
  15. firebolt

    Random List of people

    I have a database of 250 people who I want to print out randomly. I need to assign seats 1-5 to the first person, 6-10 to the second etc. for a concert. This is a lottery type application to make the process of obtaining tickets fairer. Can you provide support for this question?? thanks, fiebolt
See more

Part and Inventory Search

Back
Top