Problem with Access to Multiple Users

**gatsby** · 02-19-2013, 08:09 PM

Originally Posted by June7

What are you calculating - Rate?

I don't understand multiplication by year.

Maybe the AfterUpdate event of each of Amount, Year, Escalation:
Me!Rate = Me.Amount * Me.Year * Me.Escalation

Or the BeforeUpdate event of form.

i will be calculating the Amount in Design Engineering... whenever a user choose a Year (in the combobox) the Amount in Design Engineering will change because of the values (%) change per year for the Amount. like for example:

the Amount in Design Engineering is 440, if the user will click Year 2010 (115% change) so it will be --- 440 * 115% so the Amount in Engineering will change to 946 because of a 115% increase.... if the user will choose PO in Rate Basis (946 * 110%), the Amount in Design Engineering will change to 1986.6 because of 110% increase.....

Also, how can i include a value from a field in other table? because Amount in Design Engineering calculation should be [Weight] * [Year] * [Escalation] wherein [Weight] is in another table.

it is kinda complicated thats why i really need help. been stuck here for weeks now

thanks you very much!

**June7** · 02-20-2013, 03:29 PM

Might be able to use DLookup to retrieve the weight from another table. I would have to know more about your data to be more specific.

I still don't understand why you show Year in the formula. Why would you multiply by 2010?

Year is a reserved word and should not use reserved words as names. Better name could AnnualPercentage.

**gatsby** · 02-20-2013, 07:42 PM

Originally Posted by June7

Might be able to use DLookup to retrieve the weight from another table. I would have to know more about your data to be more specific.

I still don't understand why you show Year in the formula. Why would you multiply by 2010?

Year is a reserved word and should not use reserved words as names. Better name could AnnualPercentage.

Actually the Year name in my DBS is RefYearName....

im sorry i should not multiply it by Year BUT percent in the Year which is the Escalation (EscName), my bad! Amount in Design Engineering will be multiplied with the percent (EscName) per Year because every Year item increases based on the percent given on the data.

the another table that i mentioned is in tblDescription. i need to get values from tblDescription because Amount has a calculation which is Unit Weight (tblDescription table) * 850 * EscName (TableHighLevel1 table) * Contingency Field (TableHighLevel1 table). its not only Design Engineering but all rows from Design Engineering up to As-Built Final Documentation <----- these can be found in High Level Cost Estimate tab control form....

the database plainly change values or the Amount as the user choose what Year (multiplied with the % in the Escalation field) and also the Rate Basis (multiplied with Contingency field).

thanks June7, i hope you could help me with this.

**** by the way, how to delete files in the "manage attachments" window? i have 3 files there already and when i attached the latest version of my DBS here it says i exceeded. so i want to delete the previous attachments. i deleted also the attachments in my Settings tab but still in "manage attachment" window it still has 3 files. i want to attach my latest DBS so you can check my data thoroughly.

**June7** · 02-22-2013, 04:22 PM

Refer to Access Help or Google for more info on domain aggregate functions (DLookup, DCount, DAvg, DSum, DMax, DMin, etc).

As far as I know there is no limit in this forum on total attachments. I haven't hit a limit yet. Certainly should be able to have more than 3 files.

The only way I know to remove files is to create a subfolder, move files into that folder and then delete the folder. However, if the file is attached to a post it might not be allowed to be deleted. You can edit posts to remove attachment.

**gatsby** · 02-24-2013, 08:45 PM

Originally Posted by June7

Refer to Access Help or Google for more info on domain aggregate functions (DLookup, DCount, DAvg, DSum, DMax, DMin, etc).

As far as I know there is no limit in this forum on total attachments. I haven't hit a limit yet. Certainly should be able to have more than 3 files.

The only way I know to remove files is to create a subfolder, move files into that folder and then delete the folder. However, if the file is attached to a post it might not be allowed to be deleted. You can edit posts to remove attachment.

i have 3 files already 121.1KB , 287.1 KB , 150 KB respectively in my account... and now, i am going to upload a 1.9MB file but it says:
your file of 1.99MB bytes exceeds the forum's limit of 500KB for this filetype.

**June7** · 02-24-2013, 09:23 PM

That is limit for a single upload, not total of files. Zip the file, 2mb zip allowed.

Be sure to run Compact & Repair before any upload.

**gatsby** · 02-24-2013, 09:32 PM

Originally Posted by June7

That is limit for a single upload, not total of files. Zip the file, 2mb zip allowed.

Be sure to run Compact & Repair before any upload.

yup i did Compact & Repair it already... my new file is 1.9MB only so obviously it doesnt exceed 2MB.... while the error says i should not exceed to 500KB for this filetype - that im not sure what it means...