Search results for query: *

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

Oops it is working and it's not. When I add the .movelast command into the routine I cannot enter any records because there is no current record and when I delete it and just use the code indicated first it goes beyond my limit of 5 records. Does anyone have any more suggestions..this is all...

It works...thanks to Paulf and GeekGirlau. I made one modification by putting the GetrecCount in Afterupdate not beforeupdate or on openform. Then I could start with 0 records and enter five more. This gives me all I need and completes my project. Great help. :-V

Thanks, this code is almost working. I have no records in there yet, so when the form is opened I get a messahe that there is no current record and to debug. When I do this (.Movelast) is highlighted. This makes sense there are no records. How can I get around this when I attempt to enter that...

Thanks Jebry that worked really well. Thank you to everyone who responded to my queries...they helped bring my app to its conclusion.:-v

Excellent info there EvetsNosliw....your suggestion number 1 solved my problem. Thanks for the help. Firebolt Any suggestions on how to highlight and then unhighlight checkboxes or labels next to checkboxes when the user tabs into them? That will complete my application and make the users...