Timer for Queries?
Does anyone know of a macro or add-on that I could use as a simple timer for
queries? I don't like to use the CPU time in the Task Manager because of
it's inaccuracy when not receiving full CPU usage.
THanks for any suggestions
Exactly what are you trying to accomplish? Are you trying to cause a query
to run automatically every so often? If so, you will need to use the timer
event on a form to do that.
Microsoft MVP (Access)
"cmungs" <firstname.lastname@example.org> wrote in message
news:88EC7019-045F-4EF...Erratic results from query criteria
I am getting different results from running the same query with the same
selections. One moment it is all behaving as expected, the next it has gone
haywire. (I have done what appears to me to be EXACTLY what I have done in
another database, where it works perfectly every single time.)
In a query I have, amongst others, the following fields:
I want to be able to select any OR ALL of the relevant fields. I have the
Like "*"&[Type Category otherwise leave blank for ALL]&"*"
Like "*"&a...How do I create a B&B reservation system in Excel?
Trying to create a reservation system for 6 room B&B in excel. Does anyone
have template or know where to get one?
...Multiplying Columns in total
How would one go about multiplying Column A in sheet1 with Column A i
sheet2 to make a new column in sheet3
Yavarow's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1608
View this thread: http://www.excelforum.com/showthread.php?threadid=27534
"Yavarow" <Yavarow.email@example.com> wrote in message
> How would one go about multiplying Column A in sheet1 with Column A in
> sheet...How do I create a grading system in Office Excel?
Many teachers use computers to build their grading policy and generate the
grades that their students get for each semester. Can I do this in Excel?
If so, how is this done?
Miss Dunkley, this should get you started,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Miss Dunkley" <Miss Dunkley@discussions.microsoft.com> wrote in message
news:7...How to create odd graph
I have a spreadsheet that has a number of values entered each day. I
would like to create a bar chart that will take the values for the
corresponding day for the past month or so and graph the average. So,
there would be seven of these charts. Each has a 0-1AM, 1-2AM, and so
on. The value for each of those time periods will be the average of the
values for that day of the week over the past month. Mondays chart
would have the past 4 Mondays, etc. Each time a new day is added to the
spreadsheet, the chart for that day of the week should "jump" forward,
and use that days data whi...Update Query ?
Is there a way to
1) Assign events when adding in data thru an update query
for example if you append a bunch of data into a table could you then do
some kind of an update query to say if there is an initial event and no
others tag this one Renewal 1 etc.. the only real data you have to go on
would be Customer A and the total amt .. the event, renewal event and the
delta would all need to be added in
Say Customer A comes in with an initial deal
then Customer A renews their deal
So, the data would look like when you're done.:
Year Custo...create dataset from stored procedure
I have a tsql stored procedure I want to drag from server explorer onto an
xsd file. I get the error ' xml schema could not be interpreted'. The stored
procedure does a select from a udf, that's it.
"vickilynnpgc" <firstname.lastname@example.org> wrote in message
>I have a tsql stored procedure I want to drag from server explorer onto an
> xsd file. I get the error ' xml schema could not be interpreted'. The
> procedure does a select from a udf, that's it.
...How to create a cutomized view in outlook
hi all , i would like to create a view in the INBOX let say for exampl
if 6 April 2004 , i would like to have all my email received wil
categorized all in this date . i have tried to created a customise
view for my inbox , but this inbox keep giving me the view let say fo
6 April 2004 11:00 AM
- SmilePop Easter bunny 06 April 2004 11:00 AM
6 April 2004 12:00 PM
- Linda Teo 06 April 2004 12:00 PM
i have a link that i have created a view for the inbox for the View 1
This is the link
I would want my view to be in this way
i have an account spreadsheet. with a column heading reading status.
How can i tell excel to highlight all cells containing status "I" fo
inactive in red, and status "A" for active in green
Message posted from http://www.ExcelForum.com
You would use Format>Conditional Formatting for this.
Select the column in question(I'll assume A).
Format>Conditional Formatting>Formula is:
enter =A1="I" Format>Pattern Red>OK
Add =A1="A" Format>Pattern Green>OK
Note: you can use up to three conditional formats(four if you count...design query match anywhere?
In the design query I want to match the letters "ABC" anywhere in the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0
How else can I match ABC (upper and lowercase) to anywhere in my
Are you saying you put that InStr bit as a criteria under your Description
field in the query designer? Try putting
as the criteria instead.
Alternatively, you could add a computed field to the query
and then put >0 as the ...Unexpected Error- Running Advance Find Query
I am getting a message that says "Unexpected Error An Error has occurred"
when I am running an advanced find query on two custom entities. It seems to
be when I have certain custom fields included in my view that the query
Any help on this would be greatly appreciated. Thanks so much.
Just wanted to add that I seem to get errors when there is a 0.00 amount in
> I am getting a message that says "Unexpected Error An Error has occurred"
> when I am running an advanced find query on two custom entities. It se...It it possible to create a database in Access for this:
Im trying to create a database, but not having much luck. Im new to MS
I would like to use a switchboard that people open - it will be used
by at least 6 people - so when they open it they have 3 or 4 options
to choose from - nice a simple - not confusing for anyone on where to
go or what to do.
On that i was going to add a form to fill in details on clients. Then
from the information that is added in that goes to a table.
Such as Name, Number, DOB, location will be filled out for each
client. Under that - 10 drop down menus to click on different jobs.
Each job goes into a sep...Inventory trans created through RMA missing serials
We are having random issues with inventory transactions created through
RMA generating without the serial information. The inventory
transaction then does not post through. The Edit List shows error: The
serial numbers and extended quantity for this item do not match.
The item is listed on the transaction, and all the other information
(customer, site, etc) appears to be coming through. The RMA does have
the serial number in all instances. This does not happen on all
inventory transactions; appears to be random. Not tied to RMA type,
site, item, customer, etc. Does not appear to be any pat...Removing a field From a Pivot Table
I'm working with a pvt table in excel. Right now there are several
fields in the pvt table, including the month different entries are made
and the account that made them. When i hit the show detail button in
the pivot table i get the detail all of the entries grouped by month
and by account on a separate sheet. I want to continue to do this, but
i want to also be able to get a second view where i hit the show detail
button and only see the detail grouped my account (month is either
hidden or totally removed from this list of data in the pvt table and
the rows that composed the different...pass through query
If a combobox is populated by a pass-through query, does it requery every
time the form is closed and reopened?
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
> If a combobox is populated by a pass-through query, does it requery every
> time the form is closed and reopened?
...Creating a transparent picture control
I have added a picture control to my dialog and set its type to bitmap.
I then imported a bitmap to my resouce and set my picture contol to
display this image. I'd like this image to be transparent, so that the
white background does not diplay. How do I do this?
Thanks for your help,
> I have added a picture control to my dialog and set its type to bitmap.
> I then imported a bitmap to my resouce and set my picture contol to
> display this image. I'd like this image to be transparent, so that the
> white background does...a count field in a query?
I have a query in which I would like to create a field which
increments by 1 for each record selected, so if there are 10 records
selected by the query, this column would show numbers 1 to 10.
Ideally I would like to have some text in front of each number, say
invoice1, invoice2 etc.
From a previous posting I realise that this is frowned upon but it
would be the simplest solution for my problem!
How can I do this?
On Mon, 03 Dec 2007 08:54:00 +0000, Geoff Cox <<>> wrote:
>I have a query in which I would like to create a field which
>...Using categories, task, etc to create reports
I would like to summarise/quantify information from Outlook, using existing
fields. For example: the # of tasks and phone calls that belong to a
particular Category; or, the amount of time spent for a category or for a
contact, using date ranges. Is there anything existing in Outlook? is there
a way to do this in Outlook? Any suggestions?
...Create and populate a SmartArt graphic
I'm trying to create an organizational chart on the fly in VBA. So what I'd
like to do is add a SmartArt Hierarchy graphic to the worksheet, and then add
names into it.
I've tried adding a chart and then looking through its components in the
'watch' window as well as searching around online, but I haven't made any
progress in creating or editing it from VBA. Any ideas?
Any ideas on where to start? Or is this impossible?
...Tracking Email in CRM and Creating of Contact
CRM 3, OUtlook 2007 & v3c
When I press "Track in CRM" an email from a contact that is not in CRM it
adds it to CRM but does not notify me that the contact (email) is not in CRM.
I have to then go back and open it in CRM to check if the contact exists or
has been matched to something.
Is this correct behaviour? We have previously been using Salesforce.com and
it will prompt you to add or join to a contact in that situation.
This is by design, it would be very disruptive to prompt the user each time
There are a couple of workaround for you.
1) Use the CRM Addr...why does Word display my field codes upon opening?
I am using Office 2007, and version 11 of Reference Manager. When I open my
document, both the Reference Manager fields and the page numbers display with
the cryptic words in [brakets]. I must Select All and 'toggle field codes'
every time. Can I have Word open with the fields already 'toggled'?
Office Button>Word Options>Advanced then uncheck the "Show field codes
instead of their values" in the Show document content section of the Word
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unle...Saving Username and Pass with Web Queries
I am pulling data from a website that requires you to provide a usernam
and password everytime you visit the site. Excel has cachin
capabilities, but everytime you close excel and try and open up th
spreadsheet again, it can't login.
What is the fix for this?
Message posted from http://www.ExcelForum.com
Message posted from http://www.ExcelForum.com/
...Location of Grand Total in Pivot table
Is the a way to show the Grand total next to the selected Field as opposed to
the right now column ( I am using a file that had data results by Date)?
You can not move the grand totals. They is where they is and that's where
> Is the a way to show the Grand total next to the selected Field as opposed to
> the right now column ( I am using a file that had data results by Date)?
...Create a pdf with web links from file created in excel
How do I preserve web links I created in an excel spreadsheet when I convert
to a pdf?