Recent content by firebolt

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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