I want to add a new string inside a cell without deleting its previous value. The goal is one asset is part of multiple kits like a resistor. So i need a cell inside resistor asset with multiple value like (kit 1, kit 2, kit 3).
Question:
If I add a new kit with a resistor asset, i have to update that cell inside resistor asset. But when i do a update query it replaces the current value of that cell to the value of 'Update...
ifclick
Last Activity: Mar 23 '16, 03:40 AM
Joined: Mar 26 '15
Location:
-
Thank you for that. What i did was mix undo command and close command in one macro so every data was erased before closing. -
How can you force close a access form that has active validation rule
Problem is when I type a lot of data in a form with validation rule and I changed my mind I want to close the form. However, it would not let me since the validation keeps on running. I can erase the data in text boxes but that will take long time just closing the form.
- I wanted to have a close button that can override a validation rule without receiving to many error messages.
- I can also build a clear button to delete the data
- I wanted to have a close button that can override a validation rule without receiving to many error messages.
-
i forgot to post the WHERE clause
i did some research it says you can add a datetime/timestamp to the table that would store the insert/updated time of the record, and query based on that.Code:WHERE (((Kits.[Date of creation])=Date()));
i actually added a column that says the date() However, when you create multiple records with the same barcode ID in the same day the amount that i want to update will be doubled.Leave a comment:
-
Run a query to update only the current record of table 1 to another table
Idea is to only update the new record called amount that reside in table 1 and update it to table 2.
I am trying to update amount of assets in a kit. So table named kit is the source and asset table is destination.
The problem I am having is query keeps updating every single record on kit table to asset table.
...Code:UPDATE Assets INNER JOIN Kits ON Assets.[Barcode ID] = Kits.[Barcode ID] SET Assets.[In Kit]
-
I found how to make the combo box invisible and visible once you choice an input.
http://bytes.com/topic/access/answer...ox-create-code
However, I am not familiar with late binding in VBA....Leave a comment:
-
Can you add a combo box after click a button to a form?
I am new to access but i have a little bit of SQL knowledge. I am just wondering if you can add a combo box in a running form without going to design view.
The idea is "I want to borrow an multiple asset from asset table and save the Barcode ID of asset to Borrow Table." However, in a form you are limited on the combo box that you input in design.
Is there any possible way in VBA or SQL query to do this t...
No activity results to display
Leave a comment: