Search results for query: *

For various reasons we needed to make our Access database an MDE file. It appears that each MDE is specific to Access 2000, 2002, and 2003 meaning there will need to be a different front end for different computers. In order to create a nice smooth install process I want to write a program...

I need to be able to run a set of queries and determine if each one returns at least one record. There are so many that executing using a DCount or a recordset.recordcount is extremely slow. Is there any way to quickly determine if a query returns at least one record?

We are trying to create a web-enabled reporting system. Their is a database somewhere on the client's network which we cannot have access to but the client can. The data must never be uploaded to our server, it must stay local. The client would log into our website. Our website would need...

For some reason the upsizing wizard does not convert 99% of our queries from MDB to ADP. Is there anyway to automate this process so I don't have to go through each query individually and rebuild it in ADP/SQL-Server?

I am looking for a way to hide query definitions from the user. We want them to be able to run reports off of these queries but not see the SQL/design view of the query. We also want to prevent them from viewing the reports in design-view. Using user-level security I can prevent the user from...

I have a list box as follows (VBA/Access 2003) Label Above: Items proceeded by * are labels and may not be selected. The box contains something like: *Category 1 Item 1 Item 2 *Category 2 Item 1 Item 2 *Category 3 *Subheading 1 Item 1 Item 2 Item 3 Item 4 *Category 4...

I have created a variety of reports that use the Microsoft Graph Chart in Access. Unfortunately, they do not work on anyone else's machine. I have looked for references but can't find any that are appropriate. Does anyone know how I make these work on other people's machines? I am using...

In order to reduce the runtime of some Access reports I am populating a table with query data and having the report pull from that table. The two steps to the process are 1) Removing the old data/deleting the old table. 2) Populating emptied tables and building new tables. This has reduced...

There are 2 queries and 1 report. 1) Query1 does the same thing as Query2 in a different way. 2) Query1 runs in 12 seconds. 3) Query2 runs in 4 seconds. 4) Report tied to query1 runs in 7 seconds. 5) Report tied to query2 runs in 20 seconds. Does anyone have any idea why this would...

I decided to merge a large number of queries into 6 because each set did the same basic thing to a different field in the table. The way I did this was to create a global variable and a function that would return that variable. I had the front-end set that variable (say to "PCP" or "BF"). I...