Search results
-
T
Sub totals on forms
I did what you had suggested, but the subtotal is reading the numbers together, rather then adding them together (eg. 141516, when it should read 45) Also, I have 10 fields that would be added to get a sub-total. Many times less then 10 fields will be filled in. I would like the sub-total to... -
T
Sub totals on forms
On my form I have a sub-total field. I simply want the sub-total form to sum all the price extended fields for each product. I have tried the formula me.subtotal=me.field1+me.field2, etc. But no total is appearing in the sub total field. Thanks in advance for any help someone might be able to... -
T
Multiplying two fields in a form
On my form I have a sub-total field. I simply what the sub-total form to sum all the priced extended fields for each product. I have tried the formula me.subtotal=me.field1+me.field2, etc. But no total is appearing in the sub total field. Thanks in advance for any help someone might be able... -
T
Multiplying two fields in a form
I would like to multiply one field (qty)with another field (price). I have tried using the expression builder, and I have put in the code =[Quantity] * [unit price] But despite this, access leaves the field that is to show the calculation blank. Thanks in advance for any help someone might be... -
T
Drop-down menu on form
Jack, Nevermind with my second request. I was able to figure it out using tab order. Thanks again for your help. -
T
Drop-down menu on form
Thank you. I was able to create the drop-down list I wanted. Now the problem I am having is that when I tab, the form moves to the next record rather then the next field. Any idea as to what I need to do? Thanks in advance for any help you might be able to provide. -
T
Drop-down menu on form
I am trying to create a drop down menu on a form. The drop down menu would be in a field where a person would type in their name. I would like the person to be able to use the drop down menu to simply click on their name. Thank you in advance for any help anyone might be able to provide. -
T
Startup on forms
I have created a form, and I would like users of this form to come to a new record when they open the form. Currently, the first record (e.g. 1 of 10) is the first record users see. Additionally, I would like to have the form come up completely maximized. Thanks in advance for any help anyone...