Search results

1. Open Microsoft Access using the "Start" menu. 2. Point your mouse on the toolbar and right click. 3. Click "Customize" 4. On the "Commands" tab, look for "Tools" on the categories. 5. Drag the "Option" and "Startup" commands on the Toolbar. 6. Exit Microsoft Access 7. Open your DBase, then...

Thanks for your inputs Rich! Any idea on how to do such? Thanks again!

I am currently handling an insurance operation. I have 5 Sales Executives (SE) who receives certain percentage of commission for each sold insurance policy. SE receives their respective commission on a pro-rata basis. Meaning, if they give 4 equal monthly payment scheme to their clients, they...

Thanks Bob!!! :-)

I have a query which i would want to show records between January 2004 and September 2004, assuming the [Current Month] is October 2005. The idea is to have a listing of sold policies between the first month of previous year and the month (of previous year) prior to the current month/year...

Wow!!!! It works!!!! Thank you so much Dave!!!! Hooray to you!!! :-)

Hi Mark, I tried the code but it doesn't work. The calculated field still reflects a negative value. Sheila

Thank you very much!!!

Please help. How do i convert a negative value to zero in a Form? :confused:

It works! Thanks Allan!!! :-)

Is there a way to split the field record into 2? My field name is structured like this: De Jesus, Sheila I would want to separate the last and given name. I hate to do it manually because my record currently is now close to 5,000.

The join in 3 and 4 is PolicyID. I did have data in tables 1, 2 and 3. I hope the attached Relationship would help.

Hi Rich! I tried adding another field and make it as my PK on Table4. But still the records can't be saved. Is it your birthday today? If it is.. "Happy Birthday!!!" Sheila

Thank you very much for your inputs Rich!!! :-)

Hi Bob! Thank you so much for the inputs!!! I hope this is not too much to ask, but, (forgive me for my ignorance) how do i use the codes in query? Sheila

I have 4 tables with the following fields: Table1 - CustID, customer information.... Table2 - CustID, VehicleID, vehicle information.... Table3 - VehicleID, PolicyID, policy number information Table4 - PolicyID, premium collection information The bold/underlined fields are my primary keys in...

Also, i tried to enforce referential integrity on the "Plate Number" but there's an error message saying "No unique index found......." Thanks again for your inputs!

Hi! I made some modifications on my tables based on your inputs. It works. Except that, now i'm facing another problem. The field name "Plate Number" in Table2 is being edited a month after encoding. Once the user edit such field, Table3 adapts the changes but all the data previously encoded...

Thanks very much for the inputs!!

My db has 4 tables and forms Table/Form 1 contains customer information: ID, Name, Address and Contact Numbers Table/Form 2 contains vehicle information: ID, Vehicle Model, Plate Number, Chassis and Engine Numbers Table/Form 3 contains insurance coverage data: ID, Plate Number, Policy Number...