Search results for query: *

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...

Hi! I had to work with some files and make a function to browse for those files, select them and process them through code. I've read a lot of posts and solutions, but none of them worked for my Access XP database. So I tried to find a solution myself and here is the one that worked for me...

Thank you very much both Golom and Remou. Golom: your solution works like a charm! Thank you!

Thank you very much Remou, your solution works, but I have a very long query and when I add the code it gives this error: You tried to execute a query that does not include the specified expression 'fieldname' as part of an aggregate function. This is my query: SELECT Comenzi.IDComanda...

Hello! I have a query which returns something like: Code | Quantity ------------------------- aaa 2 bbb 3 aaa 4 How to select records to look like this: Code | Quantity ------------------------- aaa 6 <=== which is the cumulated...

When I try to publish to Microsoft Word it gives me this Error/Warning: "Microsoft Access could not find the database on the server. Verify that the database name is correct." How to solve this? Is there something which should be installed for this to work? Thank you!