Recent content by john_gringo

You are correct. It is not bound to anything. I am entering a barcode value with a scanner and updating my record accordingly. Then I need to return to the same textbox, to scan for the next product. I was wondering if is better to use a combo box instead. I need a form to be opened with a...

This is my code. I tried to stop the code but the results were the same. I found a solution, don'tknow if it is correct but seems to work. I set all other objects' Tab Stop property to No.

Private Sub TextScaner_AfterUpdate() Dim StrSql As String Dim criteria As String Dim recordCount As Long ' Build the criteria string criteria = "([IDPARHEAD] = " & Forms![OrdersOpen]![ParheadID] & ") AND " & _ "([STR1] = '" & Forms![OrdersOpen]![TextScaner] &...

Hi I have a form with some textboxes and a subform. I use a text box to enter a number and when press enter I need to run some code and then return to the same textbox. Anything I try I am not able to do so. It is always put the cursor to another text box. I update the properties of all text...

So this is how you get to declare subform data as recordsets. With Me.SubOrderDetails.Form.RecordsetClone Works fine ....... Thanks

Can you see the updated one here attached in my previous reply?

I did... this is just a sample here is the updated.

I put this code... Private Sub BarCode_AfterUpdate() Dim IdVal As Integer Dim strSQL As String strSQL = "SELECT ID, OrderId, BarCode " & _ "FROM OrderDetails " & _ "WHERE (((OrderId)=[Forms]![Order]![ID]) AND ((BarCode)=[Forms]![Order]![BarCode]));" '...

yes, my scanner sends an enter.

Hi I got an Order Table and OrderDetails table. I have an Order form with a "BarCode" text box and a subform OrderDetails. I need some VBA code "AfterUpdate" for the BarCode text box to update the field CheckBox in the subform when the product's barcode is equal to the BarCode textbox. As you...

Ok....let me prepare it...

yeap, we are storing and distributing other's products, a warehouse.

So if I understand well, I should have inventory, inventory details and transactions tables and calculate on the fly and by each transaction update for example the table!product!quantity field to record stock on hand? Yes, we have items that expire as also a serial number for all the products...

Ok...I will store products (not mine) for customers that will be delivered by suppliers. We will store them and afterwards, we will distribute them, half by a transportation company and others by private transportation vehicles to the Customer Client (recipients). We will invoice customers for...

..........and what about Customers, Suppliers, Clients and Transporters, can I have a single table for all of them instead of one for each?