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

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

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

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!