Search results

2.3 is not 2.3% .... 2.3% is 0.023 HTH RDH

If IsNull(Me![Phone]) And IsNull(Me![name]) Then HTH RDH

Add error handling to the code to capture the specific error code being generate when there is no files in the folder and handle this error accordingly. RDH

I would assume that he didn't have a way to test the code in Access 2000 and 2002 ..... There are features that are version specific and have not been carried over to newer versions. ...... such as the formatting of a MsgBox with VBA was not carried over. It can be still performed with a macro...

If I understand your question ...... To Requery a form that is not the current form use this example: Forms![YourFormName].Requery If you are trying to Requery a subform on a form that is not the current form .. use this example: Forms![YourFormName]![SubformControlName].Requery In the...

You can open the form in code using the "acFormAdd" argument of the DoCmd.OpenForm method .... ..... or if the form is used exclusively for data entry ... you can set the "Date Entry" property of the form to Yes. HTH RDH

I don't think that "orhaned" code from a deleted control will keep Access from creating an MDE as long as there are no errors in the code ...... This problem usually is from error in the code. Access must compile all code before converting and creating the MDE. If there is a problem in the...

This will work in Access 97, 2000, 2002. RDH

If the database is split ... normally only the Backend file (data file) is backed up. If this is your setup ... then take a look at the information at the location below. BackUp BackEnd Database (Split DB only) HTH RDH

If you decide to create the custon input mask .... be cafeful not to edit an existing input mask ... you create a new one instead. RDH

If this is in Access 2000 then go to the location below for information on this. Nothing Happens When You Try to Start a Microsoft Access Wizard HTH RDH

Rich is correct ..... you have a "Missing" library reference. This will cause Date(), Left(), Right(), Mid(), Trim() .... and many other common functions to error. If you check the library references in the app on the offending machine ...... I think you will find the problem. For more...

Go to Utter Access forums where I gave a solution to your question. Link To Possible Solution RDH

If you are storing "TimeStart" and "TimeEnd" in your table ... you do not store "Hours". You calculate the elasped time (Hours) "on the fly" dynamically when the value is needed. RDH

Use the following as the "Update To": "Studio " & [YourFieldName] Change "YourFieldName" to the actual name of the field you want to update. HTH RDH

If you are only entering time values without the date and the ending value spans past midnight you will recieve a neagtive result. Go to the following location for more information and a posible solution. Using DateDiff .... StartTime-EndTime Results in a Negative Number HTH RDH

Use the following as the Row Source for the combobox: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Like "*attendance") AND ((MSysObjects.Type)=1 Or (MSysObjects.Type)=6)) ORDER BY MSysObjects.Name; RDH

Open the form in design view and set the Data Entry property to Yes. HTH RDH

The expression will return the correct age based on the current date ...... I also have a feeling that the Date() function is causing the problem due to a library reference problem. I use a slight variation of the expression as the Control Source of a txtbox: = DateDiff("yyyy", [DOB], Date())...

If you convert to 2002 format you will not be able to work with the file in Access 2000. HTH RDH