My quantity field is rounding off. When I put 3.5 it rounds to 4... I have tried changing the decimal places and format but no change.
any help?
tidwellbj
Last Activity: Mar 3 '08, 03:08 PM
Joined: Jan 17 '08
Location:
-
Field is rounding off
-
relationships and tables
I have 2 tables, one table is fixed prices and the other is where I want to store the quantities. I have been trying to create a form with a combo box so when you select a customer number the prices set for that customer will appear. I also need to add a quantity and Total Price field to the form. My problem is I have been trying to base the form off a query. I can not seem to get the query correct. When i select a customer in the query it stores... -
DoCmd.OpenForm Error
I am trying to open records from another form. In my combo box under row source I have:
SELECT QryMaint41M.Wor kordernum FROM QryMaint41M ORDER BY [Workordernum];
Then under After Update is:
Private Sub Combo24_AfterUp date()
DoCmd.OpenForm "FrmMaintWO ", , , "Workordern um = " & Me.Combo24
End Sub
When I choose a record the "Enter... -
Table 1 Name= tblequipmentpri ce
1. Description; Text
(Combo Box with rowsource "qryequippr ice"
2. ID; autonumber - PK
3. Unit; text
4. Price; currency
Table 2 Name= tblinstallqty
1. Idqty; autonumber - pk
2. quantity; number
3. ID; number
one to many relationship; ID from table 1 is one to ID table 2 is many.
query SQL...Leave a comment:
-
What do you mean? The combo box is set up as a lookup box from the table. The row source is coming from qryequipmentpri ces (query of table 1). How do I link table 2 to it?Leave a comment:
-
Relationship between two tables.
I am trying to set up a subform that has two tables.
Table 1: ID DESCRIPTION UNIT PRICE (ID=Primary Key)
This table is fix price, information will never change. "Descriptio n" is a look up box.
Table 2: IDqty quantity ID (IDqty=PK)
The relationship is one to many. Table 1 "ID" being one to Table 2 "ID" being...
No activity results to display
Leave a comment: