I have a table (and forms) to track lease information. One of the fields is labeld TENANT.
I want to be able to create a unique ID for each lease file I create with the following format..
1st three letters of the TENANT name, followed by a 3 digit number (i.e, Tradewinds Contracting would have...
All of a sudden my database will not let me create an MDE file. Access hangs forever before I manually shut it down. I have modified the database but can't find the problem. Does anyone have any ideas as to why I can't create the MDE file now? BTW, I am in 2002-2003 format.
Here's what I have and what I want to do:
I have a form called "Daily Deposit Info". The form has individual entries for various fees, such as Deposit Info, Prox ID Fee, Mag ID Fee and a few other fee fields.
I want to:
1.) On the form I would like to have a calculated total for that...
I have a form with several entries for varying fees, such as Prox ID Fee, Mag ID Fee, Gate Card Fee, etc). Each have their own box for entry.
I want to add a calculated text box that will add all these fields together. However, when I have did this it seems to be adding the value in ALL...
Ok, guess I haven't been clear enough.
Here's what I have done:
1. I have a table titled "Daily Deposit Info"
Table contains fields such as Mag ID Fee, Prox ID Fee,
Deposit Amount, etc..plus other fields such as Date
and Name of Person paying the fees.
2. I have a Form...
Let me explain further.
The form displays the contents of the table. For some reason I can't display the results of the query in the form because it is based on the table that the form is based on.
Am I making this clear? i hope so.
Ok, that's what I have attempted to do:
I have the table with all of the input fees.
I created a query based on that table and I get the sum values I am looking for.
Here's my problem:
On my form I want to add a field that shows the Total fees (from the query) but am having problems...
Help Please..I'm about to pull my hair out.
I have a table, called Daily Deposit Info.
The table has fields for the following:
Name
Date
Deposit Amount
ID #
Gate Card #
Prox ID Fee
Mag ID Fee
Gate Card Fee
Parking Permit Fee
and other "Fee" fields.
Here's what I am trying to do:
I have the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.