Search results

Is ContactID a numeric or alphanumeric field? Also you might want to remove the square brackets from around your Form and field names ie Forms!Formname.Fieldname. HTH SteveA

First of all, add a field to your company table that indicates a high priority customer (if you don't already have one) ie chkPriorityCustomer. Create a form and place the fields you want to view. For each form, highlight it and choose Conditional Formatting from the Format menu. Here you can...

PearlGI, I haven't been able to locate the OnTime event for Application. Can you please provide more information SteveA

It sounds like the Checkbox is unbounded (doesn't have a recordsource. If a field is unbounded the value will carry through to every page but is not actually being saved anywhere. If you want to save the value for each record you need to link it to a field in your underlying table. HTH SteveA

1. Create a main form with the recordsource being your employer table. 2. Write a query that links the Employer_Applicant_Application_Relate and Applicant table together. Make sure that the EmplAppID is included in the query. 3. Create your subform using the query from step two as your...

Maybe you can try the IIf function. This lets you nominate the value you want if the field you are calling is null. Have a look at IIf in Access Help. It covers the IIf function prettly well. Cheers Steve

Hi, Pat answered this question for you a couple of weeks ago. Please refer to the following link: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002363.html

Check out article Q179703 in the Microsoft Knowledge Base. It discusses custom security reporting for Access 97. HTH SteveA

Al, By placing the code in the BeforeUpdate event of the Form, it is only triggered when the user attempts to move away from the current record (whether it be closing the form or moving to another record). It will not trigger as the user is updating the individual fields unless these fields are...

When the user says they don't want to save the updates enter code like Me.Undo. This will reverse all the changes made and Access won't attempt to save the record when the form closes. This should also resolve the other errors. If not, let me know SteveA

The following formula calculates the number of minutes based on the fields you have available: =IIf(IsNull([FromDate]),0,IIf(IsNull([EndDate]),0,(DateDiff("n",Format([FromDate] & " " & [FromTime],"dd/mm/yyyy hh:nn:ss"),Format([EndDate] & " " & [EndTime],"dd/mm/yyyy hh:nn:ss")))/60)) It also...

Place the code in the BeforeUpdate event of your Form. The AfterUpdate event has already saved the data to the database, so it doesn't remember the old values. BeforeUpdate hasn't committed the changes yet, so the old values are still available. HTH SteveA

How do you know which records should have these fields protected and which shouldn't? Cheers, SteveA

I haven't used this but there is a PrtDevMode feature that Access supports that will allow you to set these type of parameters. You might want to check it out in Access Help and search the forum. I have seen this feature mentioned a couple of times. Cheers, SteveA

The Save option that you are setting for the Close action is checking to see if the layout of the form has been changed, not if the record has been changed. A quick solution is to add an extra line to your cancel macro before the Close action as follows: Action: RunCommand Command: Undo This...

I noticed that you are checking the tag fields for certain values and then protecting the fields. Am I correct in assuming that the Tag fields are being reset each time you change from record to record. If yes, the following code should do the trick: For Each ctl In...

Answered in General

If you want the previous code to work off the PF09, key set the KeyPreview flag to Yes on your form and place the following code in the On Key Up event: Private Sub Form_KeyUp(KeyCode as Integer, Shift as Integer) If KeyCode = 120 and Shift = 0 Then strDocName = "fAddlInfo" strLinkCriteria =...

No problems SteveA

Take away the quotes from your check. ie: If Me![DueDate] < Date() Then HTH SteveA