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
--
cmungs
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.
--
Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com
"cmungs" <cmungs@discussions.microsoft.com> wrote in message
news:88EC7019-045F-4EF...
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?
...
Erratic results from query criteriaI 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:
Category
SubCategory
Company
I want to be able to select any OR ALL of the relevant fields. I have the
following criteria:
Like "*"&[Type Category otherwise leave blank for ALL]&"*"
Like "*"&a...
Excel 2003 Function HelpI need help coming up will a function that will average a range in one column
based on if the hours match. Here is my set up.
-------A-------B
1.....09:21....12
2.....09:46....24
3.....09:57....17
4.....10:04....22
I need to average column B if column A's hour is the same as the hour in a
cell in another worksheet.
Ryan Hicks wrote:
> I need help coming up will a function that will average a range in one column
> based on if the hours match. Here is my set up.
>
> -------A-------B
> 1.....09:21....12
> 2.....09:46....24
> 3.....09:57....17
&...
Excel Forms #5Once I have created a form (for entering data in a spreadsheet)...is there a
way to save the form for future use to avoid having to choose the columns
each time I want to enter data?
If you referring to Excel's Data, Form feature if you assign the name
"database" to the list you do not have to select the list to use it with
Data, Form.
--
Jim
"wheresleo" <wheresleo@discussions.microsoft.com> wrote in message
news:FA4C1EF6-FF2D-4EE3-837D-22814D6A9F34@microsoft.com...
| Once I have created a form (for entering data in a spreadsheet)...is there
a
| way to sa...
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
example:
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...
Excel 2004 security upgrade effect on macrosVersion: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Some of my macros that worked fine have stopped since I installed the latest security update. I'm now at Excel version 11.5.6 (09028), which has Visual Basic version 11.5 (080416). <br><br>As an example, even this simple recorded macro, to copy a text box, generates an error at the "ActiveSheet" line: <br><br>Sub Test_copy() <br>
ActiveSheet.Shapes("Text Box 38").Select <br>
&n...
Matching data in tablesI have two tables of data, some of the rows are duplicated in these tables i
want to find the data that is different.
will an advanced filter do this?
Chip Pearson has lots of info about working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm
Jo Davis wrote:
>
> I have two tables of data, some of the rows are duplicated in these tables i
> want to find the data that is different.
>
> will an advanced filter do this?
--
Dave Peterson
Cheers Dave
"Dave Peterson" wrote:
> Chip Pearson has lots of info about working with duplicates at:
>...
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
'description' column?
Thanks!
Are you saying you put that InStr bit as a criteria under your Description
field in the query designer? Try putting
Like "*ABC*"
as the criteria instead.
Alternatively, you could add a computed field to the query
InStr([Description, "ABC")
and then put >0 as the ...
Dual monitors, dual excelsI am trying to copy and paste from one excel to another. The reason i have
two seperate excels open is because i have dual monitors and that is the
only way i know how to get excel to show up on both screens. When i try to
paste it will only paste values and it will not paste the formulas. Also
when i try to paste special it does not give me the usual paste special
menu. How can I get around this problem?
Thank you,
Igor
If you open one instance of excel and arrange the windows nicely, you should be
ok.
I'd start with Chip Pearson's notes:
http://cpearson.com/excel/MultipleM...
default colours in excelHi all,
I am attempting to change the default colours used by excel for chart fills
and chart lines to something which looks better when printed, especially in
greyscale. I have attempted to amend them and save the amendments as the
default "book.xlt" template, but the old ones keep coming back. Can anyone
assist me? I am using excel xp/windows 2000 at work, excel2000/windows xp at
home (!)
TIA
Paul
Where did you save book.xlt? It should be in the XLStart directory.
Also try opening book.xlt directly, not via new, and see if your changes
have saved okay?
--
HTH
Bob Phillip...
Unexpected Error- Running Advance Find QueryI 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
errors out.
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
these fields...
"TJ" wrote:
> 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...
Removing a field From a Pivot TableI'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...
Calculate weight (ounces into pounds) in Excell?Is there any way to calculate weight (ounces into pounds) in Excell? I am
using the Home and Office version 2007.
Enter the weight in oz in A1 and in B1 enter:
=16*A1
--
Gary''s Student - gsnu200909
"BCraft" wrote:
> Is there any way to calculate weight (ounces into pounds) in Excell? I am
> using the Home and Office version 2007.
Sorry:
=A1/16
--
Gary''s Student - gsnu200909
"BCraft" wrote:
> Is there any way to calculate weight (ounces into pounds) in Excell? I am
> using the Home and Office version 2007.
...
Pivot Table Summary Error?Greetings,
Sorry, wasn't sure which subforum to post this in, as there's nothing
dedicated to pivot table.
My dilemma is as follows:
I have a spreadsheet where data is entered daily. For my example, just
imagine a spreadsheet with three columns: date, date, delay. Two date
columns are used for the pivot table.
The pivot table is displayed with month and weekly ranges as the row
headers. There is a field in the pivot table that is summarized as a MAX of
one of the source data columns.
Now, the problem I am coming across is the monthly summary MAX is not
c...
pass through queryIf a combobox is populated by a pass-through query, does it requery every
time the form is closed and reopened?
Thanks,
Sam
Yes.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Sam wrote:
> If a combobox is populated by a pass-through query, does it requery every
> time the form is closed and reopened?
> Thanks,
> Sam
...
Microsoft certificates in Users/~/Library/Keychains?While familiarizing myself with the Keychain Access utility and planning for
installation of Tiger, I found two Microsoft certificates in the
Users/~/Library/Keychains:
Microsoft_Intermediate_Certificate and Microsoft_Entity_Certificate
Were these installed with Office 2004 and what functions do they serve,
please?
Respectfully, Norm
In article <BE9173A2.B604%nnager@vnoxsxpxaxmv.fullerton.edu>,
"Norman R. Nager, Ph.D." <nnager@vnoxsxpxaxmv.fullerton.edu> wrote:
> While familiarizing myself with the Keychain Access utility and planning for
> installation of T...
a count field in a query?Hello,
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?
Thanks
Geoff
On Mon, 03 Dec 2007 08:54:00 +0000, Geoff Cox <<>> wrote:
>Hello,
>
>I have a query in which I would like to create a field which
>...
Saving Username and Pass with Web QueriesI 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?
Thanks,
Hend
--
Message posted from http://www.ExcelForum.com
Bump!
---
Message posted from http://www.ExcelForum.com/
...
Where does Excel store the orientation of PivotFields?Hi there,
I'm trying to find out where Excel stores the orientation of a PivotField,
especially once it has been draged into position.
Right now I'm using the
AcitveChart.PivotLayout.PivotTable("TableName").PivotFields() Function to get
a collection of all Fields within that Table. But even though all Fields are
in the collection each of them has the orientation "xlHidden" regardless
where I dragged them at the chart. The display of the fields within the
charts works perfectly fine.
Can Somebody Help me please?
...
Location of Grand Total in Pivot tableIs 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
they stays...
--
HTH...
Jim Thomlinson
"Rosemary" wrote:
> 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)?
...
Birthday query for many children in one recordI have a database for the church, it has one main flat table only.
Each record for the parents have field for child1 name,
child1birthday, child2 name, child2birthday, child3 name,
child3birthday - up to 5 children.
I am having difficulty trying to get a report to list the birthdays of
the children like this
parent name, child 1 name, child 1 birthday month etc. so you get
something like this:-
Parent John Smith, child Mary Smith January 3
Parent Fred Jones, child Bert Jones March 4
Parent John Smith, child Jane Smith March 6
Parent Harry Brown, child Jane Brown March 6
Parent Bert Taylor,...
Why am I getting virus protection error when load excel fileI just upgraded to excel 2003. When I try to old or new file I've create, I get virus file detection error
Hi!
Have you recently run these files through a virus checker? Just
thought...
Al
--
Message posted from http://www.ExcelForum.com
Try using Tools/Options/General and uncheck Macro Virus Protection
which detects any macro in a workbook - even if it is yours
--
Message posted from http://www.ExcelForum.com
Gary,
This is ambiguous. If you get an Excel warning to the effect of "This
workbook contains macros. Macros can be bad...," this is normal if the
workbook...
Unresponsive Query WizardHi there,
I have an Excel 2003 user who is using a spreadsheet that pulls data
from our SQL server.
When he opens it and refreshes the data it is fine, it pulls the current
data, but when he tries to edit the query, the Query Wizard does not
appear, he can see it on the task bar, but when he switches focus using
task manager everything is greyed out and nothing works.
I have tested the file from my computer and it is fine, which suggests a
problem with his machine or installation. Does anyone have any ideas?
Cheers,
Steve
Dooza wrote:
> Hi there,
> I have an Excel 2003 user who...
Another simple queryDear all,
I have a table that contains first names and last names in different
fields. Is there any way to write a query that will give as a result
the first name and last name in the same field?
I hope this makes sense.
Thanks in advance!
SELECT
[last_name_field] & ", " & [first_name_field] AS whole_name
FROM
[your_name_table]
Change the field and table names to whatever your actual fields and
tables are.
Cheers,
Jason Lepack
On Apr 23, 9:47 am, Homer <peter.a.r...@googlemail.com> wrote:
> Dear all,
>
> I have a table that contains first names an...