access control name from the sub
I have several same controls on the form like spin buton.
Because it runs exactly same logic, but its name, I would like to have one
even code called by all the controls.
I need to know the name of the controls to do some actions.
I tried to use name, but it gives me the name of the form.
I tried self but VBA does not recognize it.
How can I access the control name from its events?
Your information is great appreciated,
Multiple controls cannot share the save event procedure; however, you can do
what you want easily.
Since you have a form and a subform to deal with, my suggestion would...How to Recover Deleted Sent Mail?
While trying to delete very old "Sent" mail I seem to have deleted all
"Sent" mail. Is there a way of recovering this mail?
Have you closed Outlook since deleting the old sent mail?
Next time, archive the items you want removed from your active .pst file.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Sidney Friedman as...Pivot Table row comparison
I'm trying to compare an old customer schedule with their new schedule
and highlight the changes with colour or by hiding a row. My pivot
table looks like this
Prod Sched wk1 wk2 wk3
A old 3 2 3
A new 3 4 3
B old 2 2 2
B new 2 2 2
So in the above example I'd like to colour the cells for wk2- Product A
in yellow, and hide the product B rows as there has been no change in
Can someone give me some advice about how to do this
Thanks for your help
How about an alternative???
Your raw data looks kind of like this:
Prod Sched wk# qty...Cannot delete subreport
I am using Access 2003 and have a report I did a while back with a simple
subreport. I want to remove the subreport but for the life of me can't figure
out how to do it. Any help would be greatly appreciated. Thanks.
When you say "remove the sub report", what do you mean? Do you want to
delete the entire subreport control containing the subreport, or do you want
to keep the control, but change the report contained in it?
The first is easy - select the control by clicking once on it once, then
For the second, click the control once, then set ...Exchange 2003 External email question
Company has one email address, which is a POP3 email account.
Receiving email is ok via the POP3 connector. Sending email from ONE
account is ok via the SMTP connector.
But I would like to be able to give 5 people the ability to send using the
same email address. I thought I would just be able to type the same email
address in on the Email Address tab of the user's properties in AD, but I get
a message saying the email address is already in use.
The company needs to use Exchange because it wants to share diaries.
I hope this makes sense - basically what I want to do is give 5...add news reader to Outlook 2003
Can anyone tell me how to add the newsreader button to the go menu in
Thanking you in advance
It's a known issue in Outlook 2003 where the News command disappears if
Outlook is chosen as the default newsreader. Try the following -- it seems
to work for many:
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you launch
it, clear the "Always perform this check..." box and then click the No
bu...problem with outlook 2003
im having a strange problem with outlook 2003.
almost everytime i send email, or forwared them to people
in my contacts list they get the mail empty.
either the subject of the email is gone from the mail,
and then when people try to open this email the computer
gets stuck (it happend in different pcs with different
versions of office on them from 2000 up to office 2003).
the other problem is when the email reaches the people im
mailing them (and the subject is not removed from it),
then the email is recieved empty.
all my attachments are gone from the email.
its dosent matter...pulling table modified date
hey all, i'm trying to set the value of a text box on my form to the Created
Date of a table in my database. its not the recordsource of the form. any
also I forgot to mention the table is in a different database
"Ted" <firstname.lastname@example.org> wrote in message
> hey all, i'm trying to set the value of a text box on my form to the
> Created Date of a table in my database. its not the recordsource of the
> form. any ideas?
You could get the creatio...Rule for Deleted Items
I am being told that there is a rule in place on my Exchange server that will
not empty the deleted items folder every 30 days for certain users in my
organization. I found a recipient policy in System Manager that says "Users
Excluded from Mailbox Cleanup" but it only shows 2 users and not the 3 I was
told about. But I have confirmed that the missing person has email in her
deleted items folder going back to 2005 so it must be working. Is there any
other location I should be looking? Also, we just had someone come in and
migrate our Exchange environment from 2000 to a new...cannot delete message from deleted items
I have a message in my deleted items folder that when
choosing delete opens the McAfee box warning of potential
virus and wants me to choose open or do not open, but will
not delete. I have tried choosing another file and
holding ctrl and choosing the file I want deleted and then
choosing delete, I have tried moving it to the desktop but
it will only copy there, I have tried every form of delete
possible. I need help. Anyone know how?
Can you empty the deleted items folder entirely? Or turn off the McAfee
scanning temporarily to see if it makes a difference?
Julie wr...I can not delete a duplicate personal folders list #2
amazing that there isn't an easy fix for this. The instructions provided
simply don't work ( tools-email accounts-view change email accounts-deliver
to new account-finish-close outlook and reopen ), and none of the other
offered explanations have worked either. As this is such a common problem;
why hasn't microsoft provided a very EASY fix? I am more confused ( and
frightened ) and don't want to make the problem worse!
Your profile is corrupt, probably based on an incorrect migration of your
Create a new mail profile and configure it to use your exi...Manipulating Pivot Table Data Fields
Have a question regarding the Data Field in pivot tables. I have a number
of rows that have repeating values. What I want in the Data Field (Sum) is a
count of DISTINCT values in the column.
FR065817 |----> counted as one
FR066154 \___> counted as one
FR066158 -----> counted as one
FR066159 \___> counted as one
However I need all the data in the table as I'm using other columns for
different fields in the pivot table. Is there a way to do this? If I have
to split the table somehow, I'm willing to do...Unable To Read Certain fields in Linked Excel Sheet to Access
I am using Acc 2003, but Acc 2007 should work the same (I think).
I have linked an excel spreadsheet into my Access database. Almost all of
the fields are available and can be read.
There are a few fields that I can see in Access, but its in Excel. These
fields were using a VLookUp function in excel to get the value from another
Also the linked excel sheet has fields that I believe should be text (in
Access), but its was set to be a number. I am unable to change this.
Is there a way to resolve this issue for me ???
I also assume that if I was to rea...Retrieval of Deleted Items After Being Deleted from the Deleted Items File
I deleted a number of important emails from the deleted
items file in Outlook 2000. This may sound stupid, but I
completely emptied the deleted items file instead of
deleting them one by one. Pretty stupid, huh.
Anyone. Can they be retrieved?
Sorry for sending this again but I seem to be computer
illiterate and it has taken me some time to explain the
unless you use Exchange server with deleted retention enabled, you are most
likely out of luck, but you can try something that might help....
http://www.outlook-tips.net/howto/r...RPC Error in Outlook 2003
I am encountering an RPC error as I try to connect to my
exchange server. When I try to resolve my name I get a
timeout error and when I try to open outlook I get the RPC
error. Could you provide a solution?
Without telling us the exact error, the only guess I can come up with is you
are missing one of the following registry keys.
Due to the Sw...Refreshing fields in table cells.
Situation is as follows ...
A document header contains a text box.
This text box contains a table.
The table has a field in each cell (20 fields in total).
How do I select all these fields in VBA to refresh their values?
The text box (and the table therein) are in a building block that is placed
in the header using a macro. I know the cells can refresh because I see the
refreshed values if I do a print preview, but I want to see them while
looking at page Layout just after I have defined new field values. Field
values are applied via a user form and it also here after pressing...Access 2003 multiple if then statement help
I am having a problem constructing the proper clause for querying my
database. I have multiple values used in computing daily averages of
constituent data for measurements. An example of my table for my table
[tbl_data] is shown below;
Constit Value AdjConstitValue UseIterpolated DoNotUse
S1 1300 1258
[x] [ ]
[ ] [ ]
[ ] [x]
Using an if statement I put together a statement for the query to
display the AdjConstitValue if UseInterpolated is checked and that
works f...Delete macros
I am using Excel 2002. When I click on Tools->Macro->Macros... i see 2 macros. The problem I am having is that I can't delete these macros, the delete button to the right is grayed out. How can I delete these macros?
maybe the macros are protected. Try hitting ALT + F11 to open the VBA
editor and try to delete the macros / modules there
> I am using Excel 2002. When I click on Tools->Macro->Macros... i see
> 2 macros. The problem I am having is that I can't delete these
> macros, the delete button to ...deleting email in outlook, freezes before i can delete
i have a file with pics that symetec scanner says is to large.
i can receieve email but cannot send any.
it freezes before i can delete and says non responding.
I want to re-raise the old issue of Fax numbers showing up in the Outlook
Address book when one is sending an email. I know that this can be stopped
by prepending the Contact's fax number with a letter so that Outlook doesn't
see it as a valid fax number and therefore doesn't list it. What's always
puzzled me, however, is that this fix doesn't work if the fax numbers are
changed using an export to CSV...Problem with popup form on a single record
I have a record that has a form for a user to enter information into. If the
user needs to add additional information, a popup screen (popup and modal)
comes up for them to add additional information. Both forms service one
record. Occasionally, and I can't seem to define it exactly, I get an error
message saying that another user (I'm the only user) is trying to update the
record and I have three choices: Save the information, write it to the
clipboard or dump the information. The last time I saved it, I corrupted the
entire database and had to start all over again.
The...make table not replacing table on back end
I have split my database and distributed the FE to users
The database has an ODBC connection to Lotus Notes.
I create a make table query called q00NonconformMKTbl to dump the data from
the Lotus Notes ODBC connection to the tNonconformance table.
But since the database is split when i run the Make table it is only
updating on my instance of the FE.
Is there a why to do a Make table and specify to delete and recreate the
table in the BE?
It was making me crazy until i figured why only my db was updating with
Instead of dropping a tab...How do I unrestrict access to files Information Rights Mgmnt?
Yesterday I was working on an excel spreadsheet and could not do "print
preview" without being questioned about Information rights Management in MS
I could not get past this so I went ahead and set up a couple email
addresses of people who could access this file.
Now the software will not properly authorize my opening this file as it
cannot verify my email address. I do not know how to unrestrict the file so
that I can continue working on it.
...OK to delete Deleted Items folder?
I'm afraid I'll have to delete my Deleted Items folder in Outlook 2000.
When I try to empty the folder I get a "The messaging interfce has returned
an unknown error. If the problem persists Restart Outlook" message. Is it
possible to delete the entire folder and replace it with an empty new one?
Will it create any problems?
Not possible. Run scanpst.exe against your pst-file to scan it for errors
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Se...How to delete chart
I created a histogram and want to delete it. I select it and the faint double
border apperars. There are no square handles like in 2003. Then I press the
Delete key. The faint double border goes away replaced by a single thin black
border. The chart is still there and is not able to be selected at all.
I entered "delete chart" in the Excel Help window, and there was nothing at
all on deleting a chart. Ditto for "remove chart." I got no help searching on
the internet either.
I have Excel 2007 and Windows XP Professional
When the border changes, can you press Delete a...how to view 2 tables in design view side by side (access 2007)
I used to use access 2003 and was able to show side by side two tables in
design view. How is this done in access 2007.
Click on the Office Button, at the bottom right click the Access Options,
select Current Database, under Applications Options - Data Window Options
unselect Display Document Tabs and select Overlapping Windows.
You will need to restart Access to take affect.
Build a little, test a little.
> I used to use access 2003 and was able to show side by side two tables in
> design view. How is this done in access 2007.