Search results

You may have null values in there. Set a default value to a number or 0 for a simple solution.

1. split database 2. give each a front end 3. make your most child tables have complex auto IDs or GUID

This method only enters data into an unbound textbox. How do I save that textbox to the correct field?

Nice. Next: How to use relative file paths FROM the datbase backend? ^_^ thanks!

Thanks. I got that to work. Now how do I get that file path to be inserted into the text box?

Actually, I got an error "Invalid Outside procedure"

i still cannot get this to work. I use 32bit office 2010 and windows xp. I put the code under the onclick event of a button. Does the name of the button have to be changed to something?

I would love detailed instructions in how to make this work. Copy and paste to module means nothing to me. Thanks.

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...

No, just make the default value $0.00.

lol this is a great way to protect your files just in case you think your company will be firing you!

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...

lookup in table vs. lookup in form, someone detail the difference if any.

Date() works. There is probably another issue going on.

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...

I thought this topic could help me solve the issue of putting the foreign key in a popup form, but reading through, then looking at the database, I simply cannot figure why 3frmPProductSubsub is in any of the expressions. Can someone help me out? Is 3frmPProductSubsub needed to make it work...

This macro does to add the primary key of the parent to the child. http://imageshack.us/f/688/clipboard01cry.jpg/

I really would like macro ONLY as its more transparent to noobs like me and coworkers.

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...