Search results

Put it in the Report Footer, unless you have specific groupings set up and have allowed for Headers and Footers for this grouping, in which case put it in the Footer of this grouping.

Put the formula that Rich gave you within the Report Footer section and make sure that you substitute "Checkbox" with the actual name of your field.

Are you sure that this field is set up as a memo field and not a text field. Go into the tables and check the field type. If it says text, then change it to Memo. If it states memo, then there must be some coding behind the report that restricts the input. We would need to know this coding...

Have not heard of that happening before. Java is enabled through your browser. If you are using Netscape, click on Edit/Preferences/Advanced and make sure that you have Java Enabled. If you are using Microsoft Internet Explorer, go into Tools/Internet Options/Advanced. The only other thing...

Just use [Enter Location]and you should get results. You are using like with a location and a wildcard. Unless the criteria you are asking for is present in all instances, you will receive no records.

You must remove the autonumber type from your field and then do a compile. Then you can add autonumber back as the field type and it will start back at one. But if you start any records or delete any, you will consistently have gaps within this field.

Go into the properties of your text field and change the format to how you want the date displayed. If you just want the month displayed, then enter in mmmm. You might have to set your input mask depending on what format you choose.

What you are looking for is called Query by Form. I have made a small database with this set up as an example that I could e-mail you, which you could incorporate into your work. I need to know what version of Access you are using before I send it.

Are you trying to do a search? The reason I'm asking is using "Like" along with wildcards is usually reserved for performing specific searches for further editing, and validation in select queries and can involve some complex code especially if you are requesting from more than one field and...

What is the criteria that you are asking for.

I usually put the full path in of a dummy file stating "No PDF Available". This then becomes the default for all the files and is stored in the same directory where all the actual files will be stored. As the files are added, the users can just type-over over the actual file name, but not the...

Go into your table on which you want to store the file and create a new field with a Data Type of Hyperlink. You can then call this field from within your form. An easy way I have found to use this is to already have the Directory setup in the field by using the fields default value. Please...

There are 2 ways to achieve this. The first and easiest is to prompt the user by using the Parameters within the actual Query. Open up your query and click on Query and then on Parameters. Input your criteria with the Data Type. The 2nd is to make a custom dialog box that prompts the user...

Sounds as though you have A2K. Try this, click on your description field, and click on Conditional Formatting. Condition 1: Field Value Is Equal To Status Condition 2: same Condition 3: same Replace Status to the actual Status Value.

Substitute the names to the ones actually contained within your form, example: If your form is called Employees, substitute this for the MainFormName. If your field is called EmployeeID, substitute this for the ControlName, etc.

To register an ActiveX Contorl, go into any database and follow the steps: 1 - Click on the Main Toolbar "Tools" 2 - Click on ActiveX Controls 3 - Scroll down and highlight the control that you want to register - In the bottom portion of the box, it will show you where the file is located. 4 -...

Can you not split your database and just create one table for Countries, with a CountryID and CountryName field where the 40 countries are predetermined ahead of time. That way, no other user would have to create the same table on their database, they would all be referencing one table.

I have placed an answer in your other post under "Tables". Please post your question under 1 topic only. If you are unsure of the topic, then put it under the General section.

Put the following in the Control Source of each text box that you would like customed labelled: =DLookUp("[Field1]","CustomFieldName")

I have taken a look at the solutions report that you are trying to imitate. This might seem redundant, but have you set your query definition ahead of this line. I'm only asking, because if the error is trapped on this line, then something is not set up correctly for it to continue, and it...