Search results

Hello, How much slower is it really to use dynamic queries. In Access and Access VBA books which cover ADO you always see recordsets built with SELECT queries in VBA. These queries, which I assume are the definition of dynamic queries, as they are built on the fly with parameters supplied by...

I came across the following line in a piece of code :- Set RS = CurrentDb.OpenRcordset (SELECT * FROM mytbl;) I feel confident enough to assume that this is not ADO, but is it DOA or something else. There seems to be so many ways to interact with tables/queries (ADO, DAO, dynamic queries in...

When working in VBA is a connection string really necessary, even a simple one like CurrentProject.Connection. In Excel VBA assumes you are working with the current file Is it necessay to have a connection string every time in Access Thanks Phil

Hello, What is the difference between the Screen object and "Me" Dont they both refer to the active form? Is there any difference really? Thanks Phil

What is a stored query? Is it just a query that you create in design view that is saved in the db (and thus compiled) that you can execute in vba with :- DoCmd.OpenQuery or is there more to it? Thanks Phil

Hello, Is it possible to create stored procedures in Access. I know you can run stored procedures in VBA that reside on an SQL back end. I know that you can create stored procedures on an Access Data Project (but my understanding is that from Office 2007 Microsoft is not supporting ADP)...

Thanks for that, it was very helpful and a very clear analogy. Is there anywhere I can find resources about setting up Access as a true back end?? Thanks again Phil

Hello, I have been reading about access development and how access cannot act as a true back end. Is there no way to run the queries on an access db on a file server then use a separate access db to link to these queries only thus avoiding sending all the data over the network but just the...

Hello, I am using access to try to build a mangement reporting "application" I have set up my tables for each manager etc etc The sales, costs etc data comes in the form of an excel download from the accounting system. However it includes a lot of repeating data i.e. the manager name. I am...