Search results

Thanks, it took me a while to figure out the difference between headers but it worked great!

I have a report that has several blocks of data that normally will fit on one page. If I have a lot of data that expands the blocks enough all the detail data below the header will print on the second and/or third page. How can I set up my report so that the detail information will stay on the...

Thank you for your reply. I'm really not a strong Access user so forgive my ignorance. You told me to put in some code but I'm not sure where. In the Query under VendorName? Does it go in the properties or do I build the code? Thanks again.

After reviewing my query that I set up I found a major flaw so my first post was inaccurate. :) I've attached the new query to show what I do have. What I'm looking to do is create an average of each suppliers quality rating for the past 12 month period and be able to create a new report the...

I have a database which tracks ontime delivery and rejects by suppliers. What I need to do is be able to group the data from each supplier for a years time so I can find the percentage of on time and percentage of rejects. I've created a query that when I went to Summary Options it allows me to...

This is the first expression: Expr1: IIf([DAYS LATE]<=0,0,1) Second:Expr2: 100-([Expr1]/[Count Of Suppliers])*100 Third:Expr3: 100-([Rejects]/[Count Of Suppliers])*100 And Last which gives me what I need: Expr4: ([Expr2]*0.4)+([Expr3]*0.6) I need the first expression because the table has some...

This one should be easy for all you brainiacs out there but it perplexes me. I have a query where I'm calculating two separate percentage by building an expression then I have to combine them to create a total percentage by taking 40% of one and 60% of the other. This works fine but seems there...

I tried this but did not work probably because I'm not sure where to put it. I had my query open in Design View and put it under the date in the criteria section but got a "Data Type Mismatch" error. Removed the name Format and received a syntax error message. Tried to create an expression with...

Yes, that's why I'm on this forum to learn. I'm signing off tonight and will try this tomorrow. Thanks for the information. I'll let you know if everything works for if I have more questions.

Yes, I have it set up to input the dates but I need the count of receipts by supplier per month.

This one should be easy but can't get it to do what I want. I have a query that tracks receipts from suppliers by the month. What I need to do is create a query that counts the total number of receipts by supplier per month. I've done this before but can't figure out how. :confused::confused:

Mike375 Thanks, works just as I wanted.

I have a form with several text boxes that at times requires large amounts of data, several paragraphs worth. What I need to do is be able to hit enter for the next paragraph without going into the next text box. Just as I did in this box or any Word document, hit enter for the next paragraph...

Tried that but got a Compile Error: "Method or Data member not found" and then .listbox was highlighted (& me.listbox)

OK, I'm going to try again and hopefully explain it better this time. I've created a database to create reports to track problems that happen within the company, each report is numbered in sequence. The report gets the data from a query so I've created a command button where I can input the...

My boss asked me to create a database for collecting certain information and creating reports which I've done, I'm just trying to make it user friendly plus I enjoy learning new things. I know a little more than the basics of Access but have no experience in VBA which makes what I'm trying to do...

I couldn't get it to work, I see Name in brackets so I assume that I would put the form name in there but what about all the places that same name? Sorry, this must seem like a pretty ignorant question but I'm not a programmer and no nothing about VBA.

I have a list box of all open forms on my startup page. How do I do set it up so that I can click on the form number to open that form? Access Help says to go into properties under data control/source and input the source. I've tried that but probably input something wrong. The form is...

Worked great, thanks for the help. I'll be posting more as I progress in this database.

I've tried playing with this but continue to get an error, as I said before VBA is a not my cup of tea and is very foreign to me. I tried changing to the form name and using Openargs and LastForm but only errors. Could you be a little more specific in what I need to input?