Recent content by kevin19

Hi Arnel I tried the code but there seems to have a bug. I just use the update all query for now which is working fine. However, I am trying to run a make table query where I can prompt the user to input the table name to be saved. Getting lost. Trying to find a way to create the...

Thanks gemma and galaxion! will look at it.

Thanks Arnel! My saviour again. What more can one say!!! I have created a button to unselect all the records. It works but I am unsure whether I am doing it properly. I am applying an update query to set the checkbox to False but the query obviously runs through all the whole table. This may...

Hi Arnel Thank you very much for your great help previously on the auto selection. Now I need to display the total amount of the selected records in a text box in the form i.e. Checkbox ID Qty UnitPrice True 1 2 £5 True 3...

Hi Galaxiom Thanks for your help. I am still not getting what I require. I am giving this a break for now as I have a more immediate problem to resolve first. I wonder if this is simple. How can I create a combo box that displays the TypeIDs in a form and after selecting from this combobox a...

Hi again Sorry I do have multiple records i.e. ID PayType Amount 101 Card £10 101 Card £5 101 Cash £20 101 Cash £10 101 Cash £15 I just need to return 1 record Id 101 Card £15 Cash £45 Can this be...

Thanks Galaxiom I have tried it but it is not returning just those records that have both cash and card payment types. I merely want to display all the records with those IDs that have both cash and card payment types and not records that have only cash or card payment types. I am sorry I may...

I have a table with a transactionID that has a payment type field for cash and card i.e. ID 1 payment type cash, ID 1 payment type card. These are 2 separate records. How do I create a query where I can identify the ID which has both cash and card payment type? Some ID only have cash; some only...

Thanks Arnel once again! What more can I say! Works Great!!

Thanks Arnel! Works a treat..... Only thing is that I keep having the Write Conflict Dialog box appearing each time I go to the next record??? Any idea?? Thanks once again.

Can anyone kindly show me how to auto tick or set checkboxes of other records having the same TransID when one has been ticked? Please find attached a screenshot. Thanks

Hi Bob! Is it not possible to store the value if there is no relationship between the 2 tables? How should it be done in my case? Kindly advise. Thanks.

Hi Bob Been having a really hectic day. Silly billy me! It is the SupplierAcRef table. I just checked. It is in the db. Should you seek further clarification, kindly post it. Thanks.

Thanks for your prompt response. If you noticed on the suppliers invoice form, the values from the supplier name combo box is by selecting from the supplier account ref table. When you select the supplier name from the combo box, it will automatically push the supacref value to the supacref...

Thanks Bob!;)