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.
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.
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.
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
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.
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.
(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 ?
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?
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.
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
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.
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!
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.
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.
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.:(
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?
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
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.
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 .
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
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?
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.