Search results

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

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

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:

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

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

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

I'm autonumbering my form by going into the properties Default Value and entering the following" DLast("[ID]","ICAR_Table")+1. It works fine in my form until I start moving the input boxes into a usable form format. Doesn't make sense to me why it would work until that happens. Any ideas why it...

On my startup form I've put a command button to open form. The form that I'm opening is set up to autonumber each new form. My question is how do I set it up so when the button is activated it goes to a new form with the sequential next number instead of opening to the first form?:eek:

I'm new to Access so I'll have some really "dumb" questions for most people but what better way to learn. My first question is when I use a form as my startup page how do I make the startup form maximized when opening the database for the first time? I've tried many different things but can't...