Search results

Does anyone know if it is possible to limit file attachment size or number?

To create an amortization table, I am trying to calculate the months between two dates, without the user having to enter any information. Mo2Exp: Round(((DateDiff("d",Date(),[a].[expire_date]))/30.5),0) This is the formula I've been using, but there is an issue with it: Because I am using...

Date Parent LICENSE: L_ID, Duration (# of months), other stuff Child LICENSE_PERIOD, LP_ID, L_ID, Cost, Expire_Date Issue: I already have a double field index on LP_ID and Expire_date in the child so that a duplicate will not be posted but... How to: How to add an additional validation so that...

Why: So that I can reuse tables, such as addresses, phone numbers, email, etc. How can I do it? Currently I have a Licenses table that has an autonumber PK, and that PK is the FK in many of the noncore subtables such as the ones above. Now I want to create another table for Permits, and I...

Been browsing the net all night for this, and I see the idea floating around,but it's usually with ugly VBA code. Here are the two tables. Parent: Licenses Child: Periods Now, I can set up a button on the Parent form to open up a child form that popups using the OpenForm edit. But if I...

Do any of you know why Access (2010 here) is making duplicate tables then renaming them _1 in the relationship chart? These tables don't show in the table list. Thank you.

What are the pros and cons of unicode compression in tables for access 2007 and later? Thankx

I have a very simple code that I got from Microsoft to Confirm record changes. Now, on each of my forms, I have to put that code into the before update. Can I not just make 1 module and refer to the module in each before update? There has to be an easier way. I at least got to the create...