Search results

Worked like a charm! But are there any ways to do like: Like Between [Enter Starting Date] & "*" And [Enter Ending Date] & "*"? Because the field's date time format is "dd/mm/yyyy hh:nn:ss AM/PM" Let's say if I enter 25/02/2012 and ends at 26/02/2012, it won't show records with Transaction Date...

Ahh thanks for your help! Will use that code. :)

SELECT Transaction.[Transaction ID], Transaction.[Transaction Date], Transaction.[Member ID], Transaction.Quantity, Transaction.[Product ID], Products.[Item Description], Products.[Selling Price], [Quantity]*[Selling Price] AS [Amount (S$)], [Amount (S$)]*0.07 AS [GST@7%] FROM [Transaction]...

Date/Time. Using format "dd/mm/yyyy hh:nn:ss AM/PM"

The Transaction Date field is in the dd/mm/yyyy hh:nn:ss AM/PM format. jiajian.sg/IMG_001.png jiajian.sg/IMG_002.png jiajian.sg/IMG_003.png But now it doesn't show any records...

Hello there! I've created a query that allows users to input the criteria. In this query, there's this field called Transaction Date. A criteria is also set under the Transaction Date field to be: [Enter Specific Transaction Date] However when I run the query, e.g. I entered "25/02/2012", all...

Still stuck... will anyone help me out? :X

It's a datasheet form, there's only 1 text box but you can enter multiple rows of data. jiajian.sg/access2.png

Yes, both Product ID and Quantity in TransactionProductsSubform are related to the Inventory table and the Transaction Products table. But they don't apply to the same record. jiajian.sg/test.png let's say I input row 1 Product ID, Quantity: 5, 10 row 2 Product ID, Quantity: 6, 3 when I click...

The user will have to input the values manually. Yeah I'm using SQL, but I don't really know how to update the Inventory table using the source. o.o

yeah, that's what I want. but it only loops the first row of txtProductID and txtQuantity, is there any way to make it loop through all the textboxes in the Transaction Products subform? (it's a datasheet form, the entire column of Product ID has the same name - txtProductID, same goes for the...

Yeah. Whenever I run the code, I want it to loop through row 1 (5, 10), row 2 (6, 3) and so on. But currently my code just loops through the very first row (5, 10).

Hey there! I've been having problems with trying to loop through textboxes in my form. My code will loop through all textboxes in Transaction Product where the SQL will update the Inventory table. But whenever I run the code, it just loop through 1 row of textboxes only. I've really been trying...

Hello, I'm currently learning basic VBA for my O Level Coursework (7010 computer studies). I've some problems with VBA so erm I need help. :X I created a Module called inventoryCheck, and there's a public function inventoryCheck(). I want this function to be executed everytime Access opens, so...