Recent content by ulieq

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.