Search results

This question was posted below but some additions have been made by the client and so I need to ask again, (please bear with me) I have a field in my customers table named: mc# This field is a unique nuber for each customer. What I want to set up is a combo box that: (1) when the user...

For an example of exactly what your trying to accomplish look in the developer's Solutions database. It is one of the free databases that come with Access (97'). Looking in: programfiles/microsoftoffice/office/samples It sould be in there. Once in the database select (sample reports/...

I'm sure this issue has been discussed on this forum many times but I couldn't find the answerwhen I went back through the last couple of weeks in this forum, (or in help). If someone knows the answer to this I would appreciate it! I have a table for customers. In order to keep the integrity...

Absolutely possible, and it works fine. I have run it where I enter in Gas in the poducts table and set its unit price to $1.87. Then when in the form you can select Gas from the product field, the db automatically updates the unit price field with $1.87 and all you have to do is enter the...

Charityg, You had it right the first time. It's an unbound txtbox to a bound txtbox on the main form. Both are on the main form. BUT, I still couldn't get your code to work. Even more interesting is that I have used code just like the one in your previous post before on a different db, and...

I TOTALLY AGREE..... But, The problem with putting Gasoline in with the products (even though this is where is SHOULD be) is that in the subform with the products the line total calculation is: [Unit Price]*[Quantity] This works fine for the other products becuase the the user selects the...

Have you tried to set the default value for these fields to what you what repeated in them i.e.: defaultvalue = "Smith"

KevinM, The equation is this: Total: Sum(([Quantity]*[Unit Price])+[Gasoline Sale]) It doesn't work because if I have ONLY gasoline sales... and no product sales... the null values do not let the calculation preform. I get a total value sum of (blank). If you think you can solve this...

If anyone has read my previous thread they know the pain I am in... this problem could be the solution to all of my problems so any help on this is FULLY APPRECIATED: My question is this: Is it possible to write code for an unbound txtbox that could evaluate a previous field and preform 1 of 2...

KevinM, I hear what your saying and that is a very valid point. The reason for wanting to store this info in the table is so I can do a totals query: (I need to produce queries to calculate employee sales for week, month, year, ect..) I have tried to produce these queries by reproducing the...

Russ, I have basically the same set up as you do but with one little difference: I have a main form with a subform. On the main form we have one bound textbox named "Gasoline Sale". This box is on the main form, and is the one that will be used most often. On the subform we have the...

Charity, I tried to set up the before update again... but it still didn't take. I can't for the life of me figure out what the problem is here. I'm sure it has something to do with null values, but my expertise is limited so I am not sure. If you think you could figure it out by taking a...

Kevin, That didn't seem to do it. I'm not sure if I did something wrong or if there was an error in the db. When I tried the button I didn't get any kind of a response... IF anyone has an idea of how to transfer this value please make a suggestion... Thanks in advance....

charityg, I tried the expression: boundfieldname=me!unboundtxtbox in the before update field for the form but I get the error message: Access can't find the Marcro: boundfieldname=me!unboundtxtbox If you have any other suggestions please let me know I'm on a short deadline.

No I can't... I'm already too far down the line. I tried to use a set value macro but I keep running into problems with Null values. If you have any suggestions PLEASE HELP!!! I've gotten myself into deep doo-doo here!!!

Create an unbound text box on the form and enter this as the ControlSource: =Sum([FieldName])

I'm sure this is a simple question for most of you but this has been driving me bananas.... Please Help. My problem is this: I have an unbound text box that preforms a calculation on a form. What I want to do is store this value in a table for later use. The problem is I don't know how to...

Chris, My reciept report is based on my sales table. Is this my error? I have the transaction ID as the linking field. Are you saying that I need to create a query based on the table and link the info from there?? Please help.... very confused!!

Anauz, I realize that this message thread is old, but your code is exactly what I'm looking for. If its not too much trouble I would appreciate a copy. Thanks in advance, Kevin e-mail: STONGK@state.mi.us

I have a form which calculates sales. At the end of this form I have a command button which I want to use to print out a reciept of the transaction. The command button is linked to a report name "receipt". The problem that I'm having is that when you click the command button it prints the...