Search results

The date is manually entered. So how to include the time element?

No No time element in the date field.

In a same day, multiple transections of the same serial number happen somtimes. So the max() is not dependable.

The table has no time field. And sometimes more than one transaction of the same Serial Number happens in the same say. So the max() doesn't give expected result all the time. So I added the Stock Checkbox field to check it manually.

Please don't give up as we are almost there to solve it. I just want one simple thing to ensure that all the other records Stock checkboxes within the same Serial Number get automatically unchecked as soon as I click on any record's Stock checkbox within the sane serial number.

To avoid this problem I added the Checkbox Stock field to manually check it. But I want to uncheck the other records within the same Serial number Automatically by coding.

You are right. I already have experienced this problem in other project. So to avoid this problem please direct me to the right database way.

Which field record you mean if not entered correctly? The Stock field is a Checkbox which has only choice to click. Please give me an example of what you said "if the record is not entered in the right order".

I will this one and let you know tomorrow. Thank you.

I will try this one and let you know tomorrow. Thank you.

Please give me the Please help me with coding for this update query.

I understand what you are saying. But can we get the solution as I want?

The Max and also the Last function tried already. They do not return the correct result always. So I decided to add the 'Stock' field with data type Checkbox to manually check it for identifying the user who has the stock as received the stock lastly. What I want is like this -for the same...

1. There are several Serial Numbers and each serial number has more then one record. The objective is if the Checkbox of current record is Checked then if there is any previously checked record of the same serial number then that will be unchecked. 2. what would be the coding please? Thank you...

Scenario: on the Report the Expiry Cell color is: Green if the Expiry Date is between Now()+35 and Now()+180 Pink if the Expiry Date is between Now() and Now()+35 Red if the Expiry Date is below <Now() This function works fine as you see here on the picture below...

Issue: Uncheck previously checked record automatically as when the latest record is Checked. Scenario: The Table has a Column (Field) namely "Serial_Number" (text data type) while another field name is "Stock" (Checkbox type). The Serial_Number" field is not unique data type and can be...

Hello, the table has a filed namely 'Serial_Number' while another field name is 'Stock' (Checkbox). The Serial_Numbers are of the Instruments that we issue to users. When we issue the Serial_Number (instrument) to a user we press the Stock checkbox means the instrument with that particular...

This is Sazed. I do MS Access Database programming occasionally as when as it is required for my work and to help my colleagues.