Hi,
I am creating an inventory management database.
I have three tables in this database, Products, Orders and Order Details.
I have a form Order Entry in which i create an order to be shipped to a client.
This form is created using a query that combines all fields of Orders and Order Details table.
The upper part of the order entry form is used to enter basic information such as the order...
RamanS
Last Activity: Nov 28 '07, 07:20 PM
Joined: Jun 12 '07
Location:
-
Update Quanity on Hand
-
How to update a recordset
I have this procedure, which opens two recordssets r1 and r2. But there seems to be a problem with the function because the loop does not end and it freezes my ms access application.
can someone please help me.
Private Sub cmdUpdateInvent ory_Click()
Dim db1 As Database
Dim db2 As Database
Dim rs1 As Recordset
Dim rs2 As Recordset
Set db1 = CurrentDb... -
Sorry, i meant i want to restrict the user from selecting the product twice in the subform. -
Check for duplicate records in subform
Hello,
I have a form to enter my shipment recieved. The main form has info such as shipment ID, supplier info, etc.
The subform has the following fields
productrecieved
productquantity recieved
the product recieved is a combo box which displays all the different kind of products currently in the product table.
my question is how can i restrict a user to select the same product... -
I should have been more clear in my initial question. Actual, my form has 3 tabs, and depending on which tab i have clicked the lables colors changes. so with your replies the code would have worked if all labels were on one tab.
thanks.Leave a comment:
-
Looping through controls and setting property
Hi,
I have a form with 10 labels named (label1 to Label10). Is there a way where i can loop through these controls and set their background colors using vba?
It very lengthy to write 10 lines to set the colors each time a user selects a different color.
Thanks. -
Syntax Query in Update Query
I have these variables:
Dim str1Year As String
Dim str5Years As String
str1Year = "1 Year"
str5Years = "5 Years"
and this query statement
If Me.frmEvergreen .Value = 1 Then
DoCmd.RunSQL ("UPDATE tblQuotes SET tblQuotes.[EvergreenWarran ty]= str1Year WHERE (((tblQuotes.[QuoteID]= '" & Me.txtQuoteID.V alue & "';")
ElseIf Me.frmEvergreen .Value... -
How to automatically scroll up to the Form
I have a form with 2 tabs and a header.
Tab1 has some text fields on it and button.
At form load the 2nd tab is not visible.
When i enter some text in the fields under Tab1 and then click the button, the set focus is set to Tab 2 and tab1 disappears.
the problem is that when the tab 2 appears, the form does not scroll to the top. Instead the scroll bars remain in the middle.
Is there way, that when... -
Wierd Combo Box Behaviour!
I have created a combo box with the following properties:
RowSourceType: Value List
RowSource: "0%";"10%";"25% ";"36%";"37 %"
Bound to column: 1
Limit to List = Yes
Default Value = None
Format: Percent
Decimal Places: 0
Column Count: 0
Control Source: Discount field in a table.
When i load the form and select a value... -
Complex VBA function required!!
This is a very complicated scenario, and i hope someone can help me. I want to write a vba code based on the following scenario.
A cabinet can have a maximum or 11 shelves.
Max number of net cards i can have on the shelf is 3
Max number of trunks i can place on the net card is 2 trunks in each card (6 trunks on a shelf)
Technically, if i have a total of 6 trunks, then i would need only one shelf. But it... -
How to Round Integers
I have this formula in my code
Me!QuoteDetails Subform.Form![Quantity] = Round((Me.txtTo talTrunks / 2), 0)
if me.txtTotalTrun ks = 5, then the result i get is 2.
But the actual value is 2.5. I want to this number to be rounded to 3 and not 2.
That means if the result is a decimal number the quanitity should not decrease but increase for example:
if the result = 5.6 or 5.9 then... -
How to populate a form text box using a query
Hi,
I am trying to populate a form textbox1 using a sql query. The query takes the "where" parameters from another textbox2 located on the form. Please see the syntax below.
When i try to run the query, the textbox1 does not display the result, but instead shows the select statement. Am i doing something wrong? please help.
...Code:Me!QuoteDetailsSubform.Form![ProductDescription] = "SELECT
-
Thanks a lot for your replies. But I guess i was not clear in my explanations. I want to group (to have a plus sign next to a product category) records belonging to the same product.
Thanks,Leave a comment:
-
How to Group Records in a Form
Hi,
I'd like to know if there is anyway I can group records in a datasheet view ms access form. For example, i would like to view all records grouped by their product type after i finish entering all details and clicking refresh.
Any type of help would be appreciated.
Thanks.
No activity results to display
Leave a comment: