Topics Search

Running of Update Queries when I open the Database

Running of Update Queries when I open the Database
Views: 38
I need to be able to run an Update Query when the database is opened. I have the AutoExec macro already but the rest is what I need to figure out
Sponsored Links:

More topics


Running an update query

It seems there are many ways to skin a cat running SQL in VB. Here's my very basic question.

I have two update queries in my Access database. Query_Update_Avail and Query_Update_NotAvail. The queries simply set the value in a field to Yes or No indicating the line item is available or not. The queries work fine.

I have a checkbox on my form that when checked I would like to execute the Query_Update_Avail. When unchecked it would execute the Query_Update_NotAvail query. Both suppressing any warnings regarding "you are about to update X records"

I'm sure this is simple but I just need the syntax

Running Multiple Queries Simultaneously?

I need help with running multiple queries that are in relation to each other to perform one function, in addition to that, being able to use one parameter in those queries performing one function.

ATM I have to click each query and input the same parameter 2-3 times. It is quite painstaking to do. Everything in my database is functional, I just couldn't find a way to shortenit.

One function has different types of queries: Update, Append, and Delete.

Open form with subform No Update

I have built a form, with a field called ID and four subforms, each on its own page, each of which display a query based on ID. As it is now, when I open the form, it runs the 4 queries with the empty field, then when I update the ID field in the main form, all 4 queries run.
What I want is 1) to open the form with no queries running, giving chance to insert an ID in the main form
2) for each query to run only when its page is selected

running multiple update queries with one command, query, etc

people. I need urgent help.
I have many update queries in access 2003. I have to run all the times and I would to create SQL, VBA or combination of both to create a process where I can do this by just one query, button, function etc. I can't do this in a macro because the list of these update queries can increase or decrease at anytime and then I would have to update the macro. It defeats the purpose. All of these queries start with common name "0010 01."

I want something where it says look up queries if it starts with 0070 01 then Run it.
Using this following SQL

FROM MSysObjects
WHERE Name Like "0010 01*";

I can come up with the list of queries but I am not sure how utilize this into VBA or anywhere else to automate the process to meet my requirements.
Like I said earlier I want something where it says look up queries if it starts with 0070 01 then Run it. I am open to other options if you have any

Database/Queries Running Very Slow?

I am making an Ms-Access database for Real Estate Management? I have succeeded in doing all that which is enlisted below, the problem is that the database is running very slow? I don't know what can I do now? The queries is running very slow thatmakes me to wait too much, I want to make the database run very fast?

Sharing an Access DB with multiple users

I created an access database for the sole purpose of sharing approved data with my entire company. The end users will view the data in a Form which utilizes several tabs and also gives them the ability to run pre-set queries out of the Form.

The Form was created using several queries which were built from tables off of the server. The tables update every day,

The problem I am running into is that it takes about 2 minutes to open the DB (the DB opens directly to the form and all queries run immediately to update), which is annoying to end users and might deter them from actually using the tool.

I have tried moving the DB to SharePoint, but that did not work due to the size of many of the tables.

Storing Information From Queries?

I'm working with a 1gb database and have about 20 queries that analyze and summarize the database in different ways. I tried running a separate query that runs all 20 of these queries, but it's just too much for my computer.

Is there a way to, maybe, write a macro that runs each query individually, and stores the result from each query? Any ideas on how to automate the running of these queries, and store the results?

Creating Action Queries - Update, Append and Delete Queries

Most Microsoft Access database users will use database queries to request or question information from one or more of your database tables. In Microsoft Access certain queries can also be used to change data as well as display or retrieve it.
These queries, defined as Microsoft Action queries, will allow the user to update data (Update Query), delete data (Delete Query) or add data from one database table to another (Append Query).

"Remote query" on DB open

I am trying automatize the update of several tables residing in a few different databases.

I would like to be able to open one database that then launches the update of several table creating queries in other databases.

My experience with vba for access is limited, so I was wondering if such a thing was possible

Problem with sharing use of Access database - will new version help?

We have three computers, one running Access 2007 (on Vista), one running Access 2003 (on Windows 7) and one also running Access 2003 (on XP).

The database we used is stored on the Vista computer and shared across a network.

We would like three users to be able to open the database at the same time, at least for read-only access. At the moment, when the Vista computer has the database open, the other two cannot open the database.

If one of the others opens it first, the Vista computer can open the database but cannot save changes.

When the Windows 7 or XP computers open the database file, they always get a "Do you want to open this file – Unknown publisher” warning, and need to click to continue. I have not beenable to resolve this issue by looking at permissions, etc.