Recent content by Bust_Ed

Googled to microsoft.com ;-) In general: 1. Select all unmatched records in second table. 2. Append this records in first table. 3. Update first table with changed records in second table. That's it.

Ok, how can that be done automatically? Usually, i need to update table, but time to time there's need of adding new records, that appeared in linked table. Should i detect number of rows and if that differs use Append query, adding new records? Or there's a simpler way?

Hi, I've table TblMain with data and another table Tbl2009, which is linked to excel sheet. I need to update TblMain with data from Tbl2009 with update query. Problem is, that update query doesn't create new rows, only updating existing. Please advise if that can be avoided. Thank you.

Yes, it didn't work. When i'm marking one checkbox, script changes property for fields on ALL records, not on current record only. That works perfectly, if i have one record on form, but my form is continuos...

That won't work. I have five records. They're all on one form. If i check one checkbox, script will change all "product" and "amount" for ALL records. Is there a way to use script only for current record, not to whole form?

Thanks. Fixed that, but what to do with that changing one-to-all... ^(

Fixed checkboxes, but no luck with script. Checking ONE checkbox, and ALL "product" become enable and ALL "amount" become disabled... Why does this happen?

I have another problem. I've switch my form to "Continuous Forms" view. Now it shows multiple records. But when i'm marking checkbox on one record all other checkboxes get's marked automatically... [solved - forgot to choose control source]

I've found solution Dim varAmount As Variant varAmount = DLookup("amount", "products", "product = product") Me!Amount = varAmount Works perfectly. Thanks for your help anyway.

Now i've stuck on next step... I've wrote this sub: Private Sub product_AfterUpdate() strSQL = "SELECT tbl_product.amount FROM tbl_product where tbl_product.product = """ _ & Me!product & """" Me!amount = strSQL End Sub When i'm changing "product" it says, that "The value you entered isn't...

Thank you very much, worked like a charm.

Hello. I'm totaly newbie in access coding. I've created my first DB, two tables and a form. Tables are: tbl_product product|amount pr1|100 pr2|200 pr3|250 etc... tbl_subproducts subproduct|amount|add|product sub1|100|no| | sub2|250|yes|pr3| frm_subproducts is used for filling values. Main...