Search results

I want to create a field validation rule that requires the user to input a policy number in a standard format. The format has a fixed length of 13 with three underlying components. The first 3 digits identify coverage, the next 7 are the policy number and the final three must always be "-00"...

The syntax I use was actually correct. 7670 was a result for two dates that were 21 years apart, so problem resolved. Thanks again !!!!!!:)

I have two date fields. I want to subtract them to determine the number of days elapsed. The dates are in the following format: Dateserial(Year,Month,Day). When I subtract them I get 7670 as the result when the number should be 365 if they are a year apart. How can I subtract the dates in a...

Totally agree, the data is provided to me by an independent team that should not have permitted any null values in the first place.

I think I know what the issue is now, something wrong in the denominator calculation, the Nz syntax works great.

Thanks, I understand the syntax now but have a very subtle problem. I have the following field: (Nz([Field1],0)+Nz([Field2],0))/Nz([Field3,1). I tested the numerator to make sure all null values for Field1 and Field2 are 0, however when these fields are embedded in the above calculation the...

I understand the syntax now, you can disregard my previous posting. Thanks !!

The Nz function is a very powerful function. How can I use it to interpret all null values in a query field as 1.0. What is the syntax if I use the standard Nz function ?

I have a query that reads from a table where the fields have many null values. On of the query fields is a calculation that multiplies several fields in the table. If the table field has a null value, the calculation results in an error. Is there a way to quickly correct the null value issue...

I selected a property so that my database will automatically compact and repair on close. Is there any risk that the database will be corrupted if a user shuts down their computer before the compact and repair is complete ?

This is a win win for everyone. I think the MS Access Forum is fantastic as well as the members that contribute. Thanks again !!!

This is fantastic. I always believe that progress lies in the hands of the good and wise. The members of the MS Access Forum are all very wise samaratans and I am extremely grateful for all your help. I mean this with the utmost sincerety. :):)

I have one final question. I have been trying to understand this for quite some time. I always get outstanding responses from MS Access World Forum and greatly appreciate the Forum. What is the incentive for members to provide such outstanding expertise. I ask this question respectfully...

I have a table in MS Access 2010 that is a link to an external data file in .csv format. I assumed that it was not possible to append data to a linked table until recently. I appended 3 records to the linked table and discovered that the 3 records were appended to the table and the external...

I think you answer is exactly what I was looking for. While the scenario is slightly different, I think there is certainly a parallel in what we are both trying to accomplish. I will need to add the three requeries for the forms as you also needed multiple requeries for each list box...

The form datasource is a query that reads from a table. The query criteria is an "ID" field that uniquely identifies each record. When the form is opened, it incorrectly opens the ID from the prior transaction instead of the current transaction. I found that when I added both refresh and...

Test findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all...

You are spot on Eternal. I was able to decompile and compact. I later found the actual cause was very simple. I stepped through each macro step and discovered new code that I just added yesterday. The code was accurate but missing the openform action that was needed to evaluate the code...

I following your instructions by inputting: C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE/decompile I received error that pathway could not be found. I navigated to this exact location and found MSACCESS.EXE, so I don't know why I'm getting this error message.

Thanks, I will try this, I appreciate the quick response !!