Recent content by edtab

In the date source of a textbox on your main form: =[SubformName]![SubformTextBoxName] should give you the value of the textbox you want to capture which in your case is the sub-total.

This might work for you: Try using a "dlookup" to pull the email address from your source table matching Me!txtLastName on your form.

Review the border style property of your text boxes. They should be set to "Solid" and border color should have a value of "0" for black.

I presume you are using a version of Access earlier than Access 2007 which has the capacity to email your report directly from Access. If so, the quickest way (without programming) is to print your report using a pdf writer program which acts as a printer (e.g. CutePDF) then send it as an...

Try this: If Me.yourtextboxname = "You cannot change!" then Me.yourtextboxname.forecolor = vbred Else Me.yourtextboxname.forecolor = vbblack End If

Text boxes have tab index properties that can be manually set. Go to the text box and click on the "Other" tab. One of the properties you can change is the Tab Index #. If you change one, the other tab indexes would automatically change as well to adjust the numbering for all the text boxes..

Try: Private Sub Form_Current() Me.HealthIncome = DLookup("[Contracted Rate Per Year]" / 2, "subfrmComms2", "CommitmentID = " & Me.CommitmentID) End Sub

Try this: Private Sub Combo23_AfterUpdate() Me.RecordSource = "SELECT * from youtblName WHERE DateFieldName = " & Me.Combo23 End Sub Same goes with combo25.

Your query grid can capture the value of your two date boxes in your form as calculated fields. e.g. Date1:[forms]![FormName]![TextBoxName] You can do the same thing with the second date box and call it Date2 or whatever name you like.

It appears that in the recordsource of your second subform, you are missing the field image. Have a look at that first.

It sounds like you need to capture the CustomerID from you main form and store that ID in a foreign key in your sites table. It then becomes a one to one or one to many relationship. You can capture the CustomerID field by coding it in the OnClick event of a command button in your second form...

To point you in the right direction: First create a table to store your permanent contractor names (say tblPermanentContractors). Then you need to create an "append query" or an "insert sql statement" that will add the name in your form into the permanent contractor table before deleting it...

You need to filter out whatever has been selected in the prior dropdowns. You can do that in the query which you are using as the record source of your succeeding dropdown(s). You need to do that for all the dropdowns except the first one which will have all the names available to you.

Try this: In the AfterUpdate of your Amount field : If Me.InOut = "Out" then Me.Amount = Me.Amount * -1 End if

In your "Select" query design (on your DateField criteria), you need to reference two date fields coming from your form, e.g.: Between forms!YourformName!BeginDate And forms!YourformName!EndDate This will filter your data based on the parameters provided by your form. You can run this query...