Search results

I do it by calling code, as follows: Function Copyright() As String 'Allows the authorized user to access Copyright Search Database Dim stAppName As String stAppName = "MSACCESS.EXE H:\Access Databases\Copyright\Copyright Search.mdb" Call Shell(stAppName...

Try the following: Private Sub PROJNUM_BeforeUpdate(Cancel As Integer) On Error GoTo PROJNUM_BeforeUpdate_Err If (DLookup("[ProjNum]", "tblProjectHeader", "[ProjNum]=Forms![frmRegistrationForm]![PROJNUM]")) Then Beep MsgBox "The Bizman Number you entered already exists...

An easy way is to open word, and use your drawing toolbar. Get the 4 block arrows, one pointing each way. Then copy each of these arrows in a graphics program, such as Paintbrush, positioning the arrow where you would want it to appear. Save this as arrow.bmp. Next on your report, on the...

I don't know how your tables are set up, but this should be quite easy to do. First create queries to display the information. 1 query would have the District and the corresponding Health Coordinator, your label would be based upon the field Health Coordinator. For the second set of labels...

If you are trying to sum, put =Sum([NWT]/2000) in the footer section of the report.

For the sake of this example, assume that your existing combo box is called Patient ComboBox (showing the PatientID and LastName) and that you want to add the selections to your table Appointments. RecordID is the name of the field that is usually your primary key field...

If you want to edit existing information within your table, then you would have to use a "Find" Method to move to the specific row within the table to edit the information. Look up Find in the help files as there are a number of ways to achieve this. One of the ways you can do it is to set...

In the Control Source for your text box for the address field, put this code: =IIf(IsNull([PreferredAddress]),[WholeAddress],[PreferredAddress]) and keep its Visible set to Yes

Usually receiving the "Error" message means that you have a naming problem. When you are using fields for count and sums, make sure that you are referring to the correct field Name, and not the fields Controlsource.

In your subform, create a text field (if you have not already done so) to calculate the quantity x unit price. Call this field ExtendedPrice. In the footer of your subform, create a text field and in the control source put =Sum([ExtendedPrice]). Name this field OrderSubtotal. You can choose...

If your first subform is displaying multiple invoice numbers, then your form is working correctly. Your second subform is displaying all the records related to the current invoice record selected, which in this case would be the first line on your first subform. To show the next set of records...

The code that I posted will take the information entered and transfer it to the specified table within the fields stated. I am assuming that your main form within your tab is using unbound text boxes. You would have to still place a command button, or use an After Update after filling in the...

The easiest way is to build your form with an Add button and keep creating records, using the main BeneficiaryID as the primary key, but if you are using this form mainly as a holding form for the information only, then you would have to create a recordset as follows: Dim rstBeneficiary As...

There are a couple of things that could be wrong here. Is the second subform in continous form view or just single form? Are you using the correct field for linking? Is this a one-to-many relationship? Check out these things first. I suspect it could be that you have set your default view...

While in design view in your form, choose Insert.....Picture from your main toolbar. You can then reposition this picture anywhere within your form. The picture insert that you are using within the properties of the form, is used mainly for background pictures, watermarks, etc.

Sounds to me as though you are using the forms recordset to display your report. Set up a new query for your report and do as I said previous. If you are still having problems, you can e-mail a small database with your report and I will fix it for you.

If it is A2K, then check out Conditional Formatting with the field. You can find this on your main tool bar under Format. Here you can set up 3 different colours depending on the resulting status. Good luck.

Are you sure that you are looking at a report and not a print-out of the form. Take a look at the coding behind the command button and see what it states.

Top right hand corner with the BIG FINGER. PDF Creator Evaluation - Click Here, then it will take you into a another screen and click on products. [This message has been edited by Carol (edited 08-03-2001).]

In the query for your report, in the criteria line for the checkboxes, state Yes. This will only pull records that are true or have been ticked.