switching between open tables, queries
I recently upgraded to Access 2007 from XP and I'm frustrated by the
inability to alt+tab between open tables and/or queries in a single database.
Is there a new way to do this, or a way to restore the old alt+tab keyboard
...Deleting multiple rows in Datagrid
I am using Datagrid with Checkbox and other data fields. In addition
to the datagrid i have a button labelled 'Delete'. When i click on
all the checked rows must be deleted from the database. Can anyone
by giving sample
code or any help in this regard will be appriciated.
...Query against Outlook Calendar
Can I run a query against my Outlook Calendar?
In what manner? Instant search and Advanced find queries work against the
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/sho...Inserting a blank row between rows of data
I have three Excel 2007 lists, around 200 rows each. I've now found I need
to insert a blank row after each list entry. Is there any easy way to do
this? I'm pretty decent with Excel, but don't know VBA. I thought of
recording a macro, but didn't know how to edit it so that I wouldn't have to
repeat the same action 200 times for the first list. Can anyone help?
Microsoft Certified Trainer
Microsoft Certified Professional
Select a list and run this macro.
'David McRitchie, misc 2001-06-30
Applicati...How To Stop Acces From Update The Record When The Subform Query Is On Focus?
I need to know how to stop acces from update the record when the
subform query is on focus?
Chipcom <firstname.lastname@example.org> wrote:
> I need to know how to stop acces from update the record when the
> subform query is on focus?
If you mean that you want to keep the main form's record from being
saved when the subform gets the focus, the only ways you can do that
1. Have the main form be unbound. In that case your own code has to do
the job of reading the record, assigning its field values to ...Send As? (cross)
Can anybody tell me how to allow a member of a (W2K AD domain) security or
distribution group to Send As (using the From field in Outlook) the group -
meaning that replies to this email will return to the group. I've tried to
do it on the Groups Security tab, adding the user and allowing "Send" - but
this doesn't work right away - should I perhaps restart the server or
stop/start the mailstore?
Jakob H. Heidelberg
...Change Color of Worksheet Tabs?
Excel 2003. Can I change the colors of the tabs along the bottom with
worksheets names on them so they will stand out from one another?
Thanks in advance... Bob
Yes- Right click on the tab and select tab color.
"Bob Newman" wrote:
> Excel 2003. Can I change the colors of the tabs along the bottom with
> worksheets names on them so they will stand out from one another?
> Thanks in advance... Bob
Had a play around found it must have something to do with the " N" (th
leading space) If I take out the space it works, has VB not got a $ ...Crosstab Query to produce a report with row field with multiple s.
I'm trying to mimic an excell spreadsheet type summary report with a crosstab
query that has a project number in the first row, SumBudgeted Rev,
SumProjected Rev, SumActual Rev in the second row that belong to that project
number and the Columns are Dates in "mm-yyyy" format. The value field is
Actual Rev minus Budgeted Rev divided by Budgeted Rev. The object is to show
monthly totals of revenues per project number with a calculated column at the
very end in percent. Sorry about the display name all of the good ones are
There is a solution for a monthly crosstab...Tab control questions
Using Office 2003 and Windows XP;
When using a tab control:
1) Does it wrap automatically so that the tabs are more than one layer deep
if additional tabs are inserted?
2) Is there a way to control when the tabs wrap to a second row or where the
break will occur or is this just automatic (i.e. whenever it runs out of
3) I'm sure I won't get anywhere near it, but what is the limit on the
number of tabs?
Thanks in advance.
On Dec 17, 10:45 am, XP <X...@discussions.microsoft.com> wrote:
> Using Office 2003 and Windows XP;
> When using a tab control:
...Query on Group field in Pivot Table
I have a large database wherein under Date column, data is in the format "Thu
Oct 1 12:00 AM".
When I use Pivot Table Under OPTIONS->GROUP-> Group Field is disabled.
I used this to group Date field to either present data by Month, quarter at
Can anybody guide me why this seems to be disabled here.
I want to present my data only by Monthwithout changing the format ""Thu Oct
1 12:00 AM".
Check you Data Source of your Pivot. it should come up like
"Sheet6!$G$1:$I$821" and not like "'\Documents and...Worksheet tab names
Is there a way to reference a cell inside a worksheet to tell me th
name of the worksheet? I have say 6 different worksheets in a file
named Sales,Costs,etc and when I print the worksheets I want cell A1 t
disply the worksheet name
Ron Wilson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2729
View this thread: http://www.excelforum.com/showthread.php?threadid=46795
Ron, here is one way, file must have been saved
=MID(CELL("filename",A1),FIND("]",CELL(&qu...form creating new row in table1, looking for field value in table
Please can someone help as I have been battling all week with this problem,
and haven't had a response.
I have a form which uses some data from table1 to create an entry in table2
(i know duplication is bad, but as this is a live database, and i am working
on a new section, this makes this complicated task easier), which works fine.
however, i have a third table that has the unique ID from table1 and table2
in order to show when a table1 row of data is needed in table2 via a
checkbox. This third table3 is created when elsewhere.
The problem lies with bringing in the unique ID value...Printing the Tracking tab from calendar event
We cannot find a way to print the tracking tab
information from a calendar event. This is the page that
lists all invitees and the status of their attendance.
Would appreciate any help someone may have. We have
already tried screen captures but if the list is too long
for the screen, this is of little value.
Wachtell, Lipton, Rosen & Katz
51 West 52 Street
New York, NY 10019
Tel: (212) 403-4357
...Excel 2007 convert into tab delimeter text file with extra tab spa
Sub: I have excel 2007 trying to save as tab delimeted text file having an
I have saved my excel 2007 as separate Tab delimited Text files. I see extra
tabs stored in the tab delimited text files.
But when I do the same with excel 2003 it works fine there is not extra tabs
stored in my tab delimited text file.
My excel 2007 conveted to tab delimited text file looks like as shown
below(Extra two tabs at the end of the each record).
Appreciate your help in advance.
Rega...LDAP Query Builder?
Are there interface tools to help build LDAP queries? Google is not
forthcoming with them.
"Dogs may have kept us company on the hunt, but it was the cats who insisted
we invent houses and discover fire." -- Khiem Tran
...How do I filter columns and rows for a certain word in Excel?
I want to set up a filter so if a row has a certain word in any column, it
shows up. Is this possible? If so, how do I do it?
I would use another column and put a formula like:
=countif(a2:m2,"*" & "whateveryouwanthere" & "*")>0
Then filter on True/falses.
(And adjust that range to match your data.)
> I want to set up a filter so if a row has a certain word in any column, it
> shows up. Is this possible? If so, how do I do it?
...Restricting access to Exchange tabs
So, when I was running Exchange 5.5, I went ahead and delegated all
permissions to various OUs to local support staff. That way, they
could handle managing the accounts of the users they directly
Now that I am ready to go to Exchange 2003, I've realized that this
setup gives the local support staff rights to disable OWA access and
all those other things you can modify on the three Exchange tabs in
the ADUC (or the DSA).
So, ideally, I would like to know how I can change their access to the
three Exchange tabs to read-only. Or, do I have to revoke all rights
and s...cross reference two
I'm need to write a formula based on information in a table - as an example:
High Performing Location Market Area Non-Market Area
1 $1,000,000 $750,000 $500,000
2 800,000 600,000 300,000
3 550,000 400,000 200,000
I want to lookup the information in the top row and on the left column, then
multiply by a factor referenced in ...Cross Refernce: "Insert reference to" attribute
When selecting different types of cross references, the "Insert Reference
Type" always goes to "Entire Caption" for Tables and figures. I alway use
"Only Lable and Number". Is there any way of setting this as an option to
come up by default.
I asked the same question a few months ago and got the following macros,
courtesy of Macropod (Word MVP).
Dim I As Integer
For I = 1 To 8
For I = 1 To 5
SendKeys &...Creating an End of Year total Query.
I am trying without much luck to create an end of year totals query. I have a
table that looks like this:
Month Lease BblsRun PricePerBarrel
1 Home 10 65.00
2 Home 12 68.00
3 Home 15 72.00
and so on.
I can easily make a query to multiply the BblsRun by PricePerBarrel by the
month, but since the price changes every month, I need a query that will give
1 grand total for the year, just one entry for each Lease is all I need.
Thanks in advance
Build your query as per your design below and save it. The build a second
query with the fi...Round up a decimal in a query field
Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Function:round([tablename!fieldname,2]) I think. It may be
> Hopefully this is an easy question. How do you round up a number in a query
> field? Excel has the ROUNDUP function, but I can't find anything similar in
> Access. Can anyone help?
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the numb...make first few rows print on every page?
I have the first few rows of my sheet frozen so that I can scroll down the
long columns (about 3 printed page lengths) without losing sight of the top
I would like to be able to set it so that those top rows print at the top of
Is that possible? It would be a great deal easier than trying to repeat the
heading columns at periodic intervals down the page becasue i don't know how
to figure out where I would repeat them to make them be the top rows of each
consecutive new page. Hope this makes sense.
Click File > Page Setup > Sheet tab
Un...Aligning beyond "Joining" in query--forcing blank rows to appear
I'm using MS Access 2002. I want to design a query that forces a certain key
table's number of rows to be repeated in each query result, even when some
elements in other tables do not report data for certain items on the key
Background: I'm updating a big benchmarking database that I previously
slogged through Excel to clean up. This time I want to design better queries
in Access before exporting the data to Excel for statistical analysis. The
data involves 2,500 data items per electric utillity per year, with 200+
utility companies on the list, going ...Appending Many Tabs into a single Tab
I need your help with a problem.
I have a spreadsheet with MANY tabs. Each tab has the same fields but
is for a different account. Is there a painless way to append all of
these tabs into a single tab? I eventually want to import the entire
spreadsheet into Microsoft Access. I very much would appreciate your
Regards Ron de Bruin
<email@example.com> wrote in message news:firstname.lastname@example.org...
>I need your help with a problem.
is this the program that i use to create a cross reference for names,
addresses and telephone numbers? i want to be able to pull up either of
them and get the belonging information for a customer. as you can tell i am
a newbie. thanks for info in advance.
Depends upon how your data is laid out.
If you have 3 columns..........name, address, phone no.
Just use autofilter on any of the three columns.
Gord Dibben MS Excel MVP
On Tue, 7 Jul 2009 07:53:01 -0700, damegood
>is this the program that i use to create a cross reference...