Recent content by inuman

Anyone knows a way to disable macro security from VBA code for Access Runtime 2007? Thank you

Hi there! I have a database containing records like these: ID Name Qty Price 1 Prod1 5 15 2 Prod2 10 10 3 Prod1 10 15 4 Prod1 5 10 I have to make a query to obtain the following result: Name Qty Price Prod1 15 15 Prod1 5 10 Prod2 10 10 (Cumulate the...

spoke too soon... now I have the correct result but I can't make an updateable query with stoc and tbl...

Thanks a lot PHV, it works great. What is the role of "WHERE stoc.cod Is Null" ?

tbl changes it's contents, so I want to run the update everytime I the form is loaded without deleting the current records in table stoc.

Thanks for the advice, it worked. Anyway, I was looking for a way to link a table without alter it's structure on the server. I want to update a local table with the records from a linked table, without modifying the linked table. But when I try to run an UPDATE RIGHT JOIN query, it says that...

Hi, I've searched for 3 days on the internet for an answer to this problem. I have a access frontend with a linked table to a mysqltable. I have to create the linked table through vb code. But the linked table does not have a primary key, so I can't update it, right? How to set a primary key...

Nope, just a subform which change it's content linked to the main's form field

How does it work for you? Have you put the Function in the subform's module?

No, a global module.

I use a module: Public gvarCountRec As Integer Function Counter() As Integer gvarCountRec = gvarCountRec + 1 Counter = gvarCountRec End Function And an unbound textbox on the subform with value: =Counter() In the main form's On Current event: gvarCountRec=0

I tried with Continous form but it gives the same error: First time I open the form it shows 1,2,3,4 (correct counter), but when I change to another record in the main form, the subform shows 1,1,2,3 (wrong counter). I don't know why the counter works like this...

I didn't think about this variant :P I think this will do the trick. I'll write again to tell you if it works. Thanks a lot!

Thanks for your reply, but I want it to be updatable. Is there a way to do this?

Hello! I have a form and a subform in Datasheet View which displays a list of records. I want to put a field in the subform which counts the position of the records, which should start from 1, every time the main form changes from one record to another. Subform should lokk like this: NR Name...