Recent content by EileenL

I have a sample contract I have a sample contract I used for a leased database if you are interested I'm sure you can modify it so that It fits a purchase instead. If you give me your email I can send it to you. Thanks Eileen :)

The formula is this Assign to each number in the vehicle identification number its actual mathmatical value and assign to each letter the value specified in the following; A=1 D=4 G=7 K=2 N=5 S=2 V=5 Y=8 B=2 E=5 H=8 L=3 P=7 T=3 W=6 Z=9 C=3 F=6 J=1...

9th digit check vin there is a specific calculation that you use to check to see if a vin is valid To each letter there is an assigned number, then there is a weight for each position of a digit in a vin which is then multiplied by the actual number all of which are summed and then divided/11...

I have a table that I would like the system to run the 9th digit check vin on after the user enters the vin. I not that versed in the coding so I was wondering if there is code already out there that i can add to Access Module and call it from the vehicle information screen. thanks Eileen :D

Is there a standard date range that is normally pulled? If there is a standard date range that is normally pulled why don't you set the default start and end dates based on the current date. For instance I pull a report for policy expirations normally 90 days in advance so I set the default...

Subform Is your subform data from a query? if so set the order in which you wish to see the records on the query for the subform data if it is a sql statement you will need to include in your statement the order and the field

Thank You!!!!! That worked great Thanks for the code what a time saver! :)

Having a bit of trouble There use to be a kb article that described how to delete linked tables programatically and I can't seem to find it. I have two BE databases and one FE database that links the BE there are many table and I would like to delete all linked tables at once. Any help would...