Search results

Place your index in the Report Header of your report. Set the page break to go to a new page after it prints the report header. That way it will only print on the first page.

I was called in on a consult. The database was on a server with no security. A couple of employees who thought they knew Access had been making changes and of course they messed it up. "How long will it take to fix it" asked the Manager. "I don't know" came my reply. "Why don't you know?"...

With your subreport in design view, check the properties of the sub report. Find out the name of the table or query that runs the sub report. It sounds as though you may have missed updating the query that runs the subreport.

These functions are available as macros. Create a minimize macro and a maximize macro, then put command buttons on the form set to run the appropriate macro.

This is a unique question - Congratulations. Could you explain why you wish to do this as I don't see what the purpose would be.

Are you sure this shouldn't be in GEEK TOYS?

I do this frequently by way of a macro. In the query for your report enter in the criteria line for the field you wish to use on your form to generate the report: [Forms]![FormName]![textboxname] Where FormName is the name of the form you are using and textboxname is the name of the textbox on...

Rich: While your instructions for making tea are correct, try finding loose tea on this side of the pond.

Reminds me of an episode of Cheers when they got a big screen TV. The installation instructions were on a video tape. The regulars were making book on how long it would take the person installing it to realize they couldn't view the tape until the TV was installed.

Wardy: You can learn just about everything in Access through trial and error EXCEPT SECURITY. Do not enter these deep waters and uncharted territories without a detailed step by step guide. I have been doing Access Security for 10 years and I still have my guide with me when I do it. May I...

See...I told you someone would come up with something.

You could always leave the tea bag in a little longer.

I recently had a similar problem. If you have the name of the horse and the country in the Name field, you can do this using an update query PROVIDING ALL OF THE COUNTRY CODES ARE 3 LETTERS. Do a search on the Right() function. This will allow you to transfer the three letter country code to a...

Generally speak (but not absolute) in this situation you would have your customers in one table and your sales in another. When you wish to enter a sale you would use a combo or list box (the most popular method) to enter the customer info and then you would enter the sale info. While there...

It sounds like you are using the "runtime" version. Do you have the full version of Access on your computer?

In the criteria of the date field enter: > [Enter Date] square brackets required. The query will prompt you for ENTER DATE Enter the date and any record with adate greater than the date you entered will be returned.

Rule when when pitching an idea to a superior. In their mind, if it is such a good idea, THEY would have thought of it.

Is there any special reason why you are assigning your teams a number? I ask because you have already assigned them a colour. Likewise, the doctors have names, why use a number to identify them? 1. Set up your entry form with two combo boxes. The first selects the team. This will narrow down...

Emma: DO NOT ENTER THE DARK WATERS AND UNCHARTED TERRITORY OF ACCESS SECURITY WITHOUT A DETAILED STEP BY STEP GUIDE. I have been doing Access security for almost 10 years and I still have my guide with me when I do security. I would recommend: http://www.geocities.com/jacksonmacd download...

You would have to include the fields you wish to use in the calculation in the query. The source of the data would usually be the table although you could use another query as the source. This is called a sub query. I am attempting to tell you that you do not require the expression builder...