Run A Silent 'SELECT QUERY' In The Background

Mar 27, 2006

Facing a small little problem -

I have searched the forum but to no avail...

I have designed a macro which runs a two separate OpenQueries, Save and Close statement based on a timer in an attempt to mimick the running of a silent 'SELECT QUERY' in my Access 2003 database project.

Is there a cleaner way to silently run this 'SELECT QUERY' in the Background and thus without the using the Open and Close query commands, to prevent the as my screen slicing effect as a result of this.

Thanks.

View Replies

Run Query In The Background

May 26, 2006

Hi

I am looking at being able to run a query but would like the results not to be displayed. Ie I would like the query to run in the background. I open the query using a command button from a form.

thanks for any help

Paul

View 4 Replies View Related

Queries :: Change Background Color Of A Query Cell If Certain Criteria Met?

Aug 14, 2015

Is it possible to run a query and have the background color of the query field be highlighted if a certain criteria is met?

I'd like to use the expresion builder if possible.

For example if the values in field A and field B do not match, then field C should be a yellow background.

If this is possible, how is it done?

View 1 Replies View Related

Queries :: Running Query In Background And Return Result In Control

Sep 11, 2013

I have several queries that perform an audit on data. I want to create a form that has two buttons, multiple labels and textboxes. When the first button is pressed, it runs all queries and returns a count of the records within each query into the corresponding textbox. Then I want a a button that will clear all textboxes. I don't want to see the queries, I just want them to run in the background and the count results to be populated in the textboxes.

So for example, it would return:

Check1: 3
Check2: 6
Check3: 2
Check4: 0

View 3 Replies View Related

Change Field Background Color Based On Query Results

Jun 24, 2014

I would like to change the background color of a field that is the result of a Unique Values query. I am trying to get a list of invoices where all the line items are approved. I can't seem to get it to work the way I want because if even one invoice line item is approved it will show up as approved.

Is there a way to change the background color of the invoice field to red if ANY of the Approved line items are = False

View 7 Replies View Related

Queries :: Select Query To Gather Results Of Other Select Queries

May 11, 2014

I'm fairly new to Access. 's various select queries containing useful and useless results. I want to create a select query that will pick out all the useful figures into a 1 row table that can then be pasted into Excel.

e.g Existing Select Query 1 returns 1 row showing Average Age, Average Price, Total rainfall
Existing Select Query 2 returns 1 row showing Average Weight, Average Salary, Total snowfall
Existing Select Query 3 returns *2* rows: It returns Distance from London, Hours daylight and population for Town A and Town B

I want a select query that returns 1 row showing (6 items):

Total rainfall, Total snowfall, Town A Distance from London, Town A Population, Town B Distance from London, Town B Population.

I've been able to handle getting Total rainfall and Total snowfall. But I cant figure out how to get Town A Distance from London, Town A Population, Town B Distance from London, Town B Population to appear in the same row of the same query results as Total rainfall, Total snowfall.

View 3 Replies View Related

Background

Feb 27, 2005

Hi

I have a form, which users print out. On the screen, it has a light grey background, but I do not want this to be printed as it is just a waste of ink

Is there anyway of making the background colour "screen only"?

Chris

View 4 Replies View Related

Background

Mar 4, 2005

hello friends
if anyone of the access gurus here had a chance to download and use the Form demo from Microsoft website you would have notieced that the background is actually a bmp picutes of cloudes. Can anyone tell mehow they manage to put that pictures in the foms. i tried using the autoformat but the autoformat has specific formats and not the one i saw in Forms Demo from Microsoft webiste.
Please tell me how to include pictures like these in the form.

View 2 Replies View Related

Union Query - Generating From A Select Query ?

Jun 23, 2006

(This is a modified repost - which hopefully makes sense) I am using Access2003. I am trying to set up a fast method of creating a union query. I have a jobs table that stores info about jobs with a separate table for each job that pulls together info from elsewhere when a review is conducted. The tables are as follows (and are linked from a paradox DB) :-

Table Name: jobs
JobID (J000001, J000002, etc)
Status (Live, Filled, etc)

Review Tables

Table Name: J000001 / J000002 etc
Consultant: (Joe, Terry etc)
ObjectID: (RoberI, SmithJ etc)
Status: (H, P, D, R etc)

The jobs table contains information about jobs, including a unique code (JobID) that identifies the job. There is also a status filed that tells us whether the job is Live or closed etc.

The first time a job is reviewed a new table, a review table is generated, and the name of the table is the same as the JobID for that job. So Job J000001 has a review table with table name J000001 etc. The review tables may contain information with the same ObjectID (as they are unique fields from a third table � the candidates table)

I would like to generate a union query for all jobs in table jobs with a status of live. I can do this manually, if I review a list of live jobs, with the following sql expression;

SELECT ObjectID, Consultant, Status, "J000001"
as [JobNo] FROM J000001
UNION SELECT ObjectID, Consultant, Status, "J000002"
as [JobNo] FROM J000002
UNION SELECT ObjectID, Consultant, Status, "J000003"
as [JobNo] FROM J000003;

I can then append the info into a new table. However this query is run at least twice a day and things change.

I would like to know is there a means of automatically generating sql for the union query based on results of a query of the jobs table ?

Any help greatly appreciated.

View 2 Replies View Related

Bug With Wrapper Select Query On A Union Query

Sep 14, 2007

I have the following query:

SELECT UnionTable.groupby, UnionTable.SeqID, UnionTable.Actual
FROM (

SELECT VAP1.groupby, VAP1.SeqID, VAP1.SomVanbedrag as Actual
FROM qryVoorplaatActualPillar_Forecast AS VAP1

UNION

SELECT VAP2.groupby, VAP2.SeqID, VAP2.SomVanbedrag as Actual
FROM qryVoorplaatActualPillarIST_Forecast AS VAP2) AS UnionTablewhich is two select queries called UnionTable and a wrapper.
Access handles this very well. Until you look at the SQL statement. If you don't pay attention Access stores the next query
SELECT UnionTable.groupby, UnionTable.SeqID, UnionTable.Actual
FROM [

SELECT VAP1.groupby, VAP1.SeqID, VAP1.SomVanbedrag as Actual
FROM qryVoorplaatActualPillar_Forecast AS VAP1

UNION

SELECT VAP2.groupby, VAP2.SeqID, VAP2.SomVanbedrag as Actual
FROM qryVoorplaatActualPillarIST_Forecast AS VAP2]. AS UnionTable
Now when you want to execute the query you get an errormessage.
Has anyone seen this before? Is this a known bug or is it a feature? Is there a workaround?

View 1 Replies View Related

Combining Select Query And Count Query

Jul 26, 2006

Ok, hope you can help me with this one.

I have a select query that pulls data from one table that includes the following data

MOS Grade Required Authorized

I have a separate count query that pulls data from another table and counts the following data

MOS Grade Assigned

How do I combine these 2 queries so the results I get will be

MOS Grade Required Authorized Assigned

For instance:

Select Query Says

MOS Grade Required Assigned
25C E4 1 1
42A O3 1 1
38A E7 3 3

Count Query Says

MOS Grade Assigned
25C E4 1
42A O3 1
38A E7 2

I want the results to read

MOS Grade Required Authorized Assigned
25C E4 1 1 1
42A O3 1 1 1
38A E7 3 3 2

Hope you can help.

View 5 Replies View Related

Crosstab Query Built On A Select Query

Jun 18, 2015

I have a crosstab query built on a select query.It works perfect. However, when I try to use the "Between [BegDate] And [EndDate]" it tells me access engine can not recognize it.If I use this in the actual select query it works fine. But when I try to use the crosstab query it gives me the above error.

Also, I'm using two undbound textboxes on a form for [BegDate] and [EndDate]. I have the syntax correct in my select query and it works fine. But it won't work with the crosstab query.

View 3 Replies View Related

Access Background

Dec 20, 2005

I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or something to that affect. I assume its becuse the sample is a newer or older access than im running(XP)

Sorry to rehash old threads but i cant get the info from them.
Can anyone help..Grey sucks ha

thanks

View 7 Replies View Related

Run Pop Up Message In Background ?

Sep 9, 2006

I want to run a pop up message "invisibly".

I have a flash file that jerks when run in access
but if i run it with a pop up it runs fine so I want
to run the pop up but, keep it hidden.
Without using minimize.

View 2 Replies View Related

White Background JPG

Jul 30, 2007

I am trying to put a jpg of a logo onto the top of a form and no matter what I do, it is imported with a white background! I have put it on a transparent canvas in Adobe photoshop, which usually works when I import it into word and other programs, but not access. I have tried looking at the properties of the image in access, but it says that the background is transparent. Help!

View 1 Replies View Related

Row Background Colors

Feb 13, 2007

I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings?

I have found examples of how to change the color of alternate rows, but I can't find anything that would tell me if what I want to do is possible.

View 1 Replies View Related

Background Problem

Apr 6, 2005

I have a .gif I set up as the background, but it doesn't stretch for the full length of the form. As you can see in the picture, at the bottom where the record selector/scrollbar would be, my background picture is not filling.

Any help would be appreciated.

View 7 Replies View Related

Form Background

Aug 3, 2005

HI

How can I use/set an image (picture) as a background in a form? I can't seem to find this option...

thank you

regards, Miha

View 6 Replies View Related

Tab Background Colour

Apr 26, 2006

This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(

View 3 Replies View Related

Background Of A Form

Jul 6, 2006

pls Help,
I knw how to change the background of a form. but i need a particular file for the background. and i want to knw where the file is stored?
the file which i want is a texture file in a WORD. i.e. in word when we try to set the background of a page, the option Background gives us some textures for the background. i want a file called "water droplets" as a back ground in access form.
from where can i get the texture file?
i searched the whole Microsoft Office folder in c:program files. this file is not there. then where are this texture files stored? can anybody help me to find this file pls?

View 6 Replies View Related

Background Colour

Oct 18, 2006

Hi
We have created some forms using (in some cases) the form wizard.
As you may know you have to select a "Background Style" when using the wizard.
Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect.
Can anybody help us out please ?
many thanks
ajm

View 1 Replies View Related

Form Background

Nov 23, 2006

I have a master form with a picture as the background with a timer event that fires every 5 minutes. I have a subform (a clock) with a timer event every second to update the text. How do I make the sub form background transparent so that I see the master form back ground?

I did it this way so I didnt have to update the master form data every second.

help would be much appreciated.

regards

View 3 Replies View Related

Background Color

Dec 13, 2006

hi every one

i have an application and the user was asking me to give him the ability to change the backcolor of the main form
i had done that with one color option.

but now he wants to mix two colors together
any one can help me with that , if code or sample would be posted, that would be appreciated .

thanks in advance

View 6 Replies View Related

Change Background Of Txt Box

Feb 28, 2007

I have some code here that is changing the color of a txt box in my form based on the value in the text box. Everything is working great. The only problem is that I have a sub form with many tabs and many, many txt boxes. I would have to replicate this code hundreds of times....

Does anyone know a better (LESS CODE) way to look in the form and change the color of a txtbox based on a value. Something more generic. RIght now I am targeting specific txt boxes...

I just want a general statement that targets the entire form

THANK YOU ALL FOR YOUR HELP.....THIS IS A GREAT FORUM AND LEARNING TOOL....

CODE:

Private Sub Lower_Level_Concession_Inside_COUNTERS_AfterUpdate ()
If Lower_Level_Concession_Inside_COUNTERS = "2" Then
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 255 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 65535

ElseIf Lower_Level_Concession_Inside_COUNTERS = "1" Then
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 255

Else
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = False
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 12632256
End If
End Sub

View 3 Replies View Related

Modules & VBA :: Programmatically Find And Select Item In Multi Select List Box

Apr 23, 2015

I have a multi slect list box (simple) and I need to find and select an item using vba - e.g., the bound column is the ID field and I need to select a specific ID (which will be different each time) as opposed to selecting the 100th record for example. How do I do this?

View 2 Replies View Related

Change Background Colour !

Jan 24, 2007

Hi,

I'm currently using MS Access 2002.

I use forms to display client info and i would like to know if the following is possible, and if so, how ?

When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.

eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.

Kinds Regards
Chris

View 4 Replies View Related