WHAT IS NAME
WHY ARE TELL TALK
Migrating from Exchange 5.5 to 2003 in the same Exchange Org. I am
successfully migrating public folders but the forms associated with these
public folders are not showing up when connecting to the new server. How do I
migrate the forms?
...Small Name Box
The name box in MS Excel is rather small and narrow. Is there a way to
expand it ?
"Adrian" <firstname.lastname@example.org> wrote in message
> The name box in MS Excel is rather small and narrow. Is there a way to
> expand it ?
...Check Name in a Specific Customer Record
Have to use the after update event of a combox rather than the notinlist
event to allow for a third option. Combobox is Combo111 which has a control
source [Contact Name].
The combo has a list of names etc which have already been filtered to a
tblCustContacts has records with fields of Last_Name, First_Name, RecordID,
RecordID is unique.
User enters a name "Fred Jones"
Jones is filtered out.
Now I need to check if Jones is in the list associated with that particular
If not - user can choose to add to the list adding details ...Object variable or With block variable not set
I'm trying to put a command button on a form using the command button wizard
and I am getting this message "Object variable or With block variable not
set". I cannot figure out what's happening. I tried opening different
instances of Access and am getting the same problem with some but not all of
my .mdb files. Hope someone can help.
Its hard to think what it would be with no example...
did you edit the code generated by the wizard? or is it the wizard producing
Can you paste the code here?
"laura" <replyto@gr...Use of Worksheet Tab Name
Want to put a new name on a worksheet tab (which I know how to do) and
then reference that TAB on the work sheet. For example, if I name a
worksheet XYZ, need a process where I can say Cell A1 (or whatever) =
TAB NAME (XYZ or anything). How do I do that?
=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255)
In article <Grampa425.email@example.com>,
Grampa425 <Grampa425.firstname.lastname@example.org> wrote:
> Want to put a new name on a worksheet tab (which I know how to do) and
> then reference that TAB on the work sheet. ...sharing variables between dialog boxes
I have a dialog based application where i want to share variables between 2
dialog boxes. More specifically, i have a dialog box with a menu option
settings. On pressing that a new dialog box is invoked. This new dialog box
has a edit box and save button. User will write into that edit box and press
save button. When ever he presses save, the dialog box will close. Now i want
the contents of the edit box into the main dialog box from where that dialog
box was invoked. How should i go about that???
The class that wraps the 2nd dialog and displays the edit control ...get computer name, desktop and my document
I would like to get computer name, desktop and mydocuments folder
using VBA for my applications.
Any function available to do this task?
Your information is great appreciated,
See http://www.mvps.org/access/api/api0009.htm at "The Access Web" for how
to get the computer name, and http://www.mvps.org/access/api/api0054.htm for
how to get the location of special folders such as Desktop and MyDocuments.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"iccsi" <email@example.com> wrote in message
news:1f8...Report Generation Variables for Date
I'm trying to define a filter in a report, using the last month start and
last month end as low and high limits. Can somebody tell me the name of
this variables, like <Today> is self explanable.
this is all I have:
<MonthStart> first day of month
<WeekStart> date of first day of this week
<LastWeekStart> date of first day of last week
<YearStart> first day of year
<Now> current date/time
<ReportDate> date of report
"Alvaro Guzman" <firstname.lastname@example.org> wrote in message
news:7C2DA569-6C0C-420C-9F49-4FC...Using Popups to supply variables
I sue this macro to find and replace a number in column I
Selection.Replace What:="5.95", Replacement:="2.95", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
I'd like to replace the values in the macro , requesting variable input
via popup. Can someone help?
Effectively , there would be popups to request the column , the search
number and the replace number.
If it could also cycle back to the beginning on completion ...Form/Subform Problem
I have a bound form with three subforms. Subforms are all displaying in
Datasheet View. I am able to make column width changes to all subforms
(double-click right border or manually type in a number or drag to size), but
after closing main form and reopening, changes are saved on only two of the
three subforms. I have checked Properties of all subforms (numerous times)
and have everything identical except for the Record Source (Query of each
subform). Before closing, I click File/Save on the MenuBar and the Save icon
on the Toolbar (I get a working Hourglass on both for three+ second...3 linked combo boxes in a form Options
Thank you for your response. Unfortunately, the option you suggested
did not produce the desired result. Perhaps if I explain further
I am trying to do, you can offer some alternatives.
Shopcbo based on Shopqry based on Shoptbl. Columns in the table are
ShopName and ShopID. The shop same is self explanatory. The shop
is a field a created to match up with a field in the equipment
Areacbo based on Areaqry based on Areatbl. Columns in the table are
AreaName, AreaLink and ShopName. The area link is a field created to
identify each area that a piece of equipment belongs to...Enumerate Controls on a Form
I would like code that would enumerate all controls on a form
returning their names and types.
You should be able to figure it out from the code at:
Arvin Meyer, MCP, MVP
"tcb" <email@example.com> wrote in message
>I would like code that would enumerate all controls on a form
> returning their names and types.
> Thank you.
Try the TOOLS - Analyze - Doc...create a form that collects parameters
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in acess 2007.
i refered the link below
in this some mistake is there in the macro can somebody help me out.
if any template for search form is available please let me know.
Maybe something like this:
This could be very helpful too:
Al...Form to report
I have a form with a listbox and 2 graphs. When an item is selected on the
listbox, the chart displays the appropriate informatiom. But when the
"preview report" button is selcted at the bottom, the form displays graphs
for ALL items in the listbox...not the one selected. I am missing passing
something to the report but I don't know what.
Here is the code behind the button:
Private Sub Command20_Click()
Dim stDocName As String
stDocName = "rptTrend_HF"
DoCmd.OpenReport stDocName, acPreview
Message posted via AccessMonster.com
ht...Change the servicecalendar form
I need to change the service calendar form. This form should be customizeable
under Serviceactivity and under Ressource. But when this form is opened the
result is the Ressource-form and the Serviceactivity form.
I also need to make changes to the sevicescheduling form - is this possible ?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-base...OLE field on form
How do I get an ole field on a form to display full frame. At the moment,
all I can get it to do is show a small (and rather blocky) verion of a .bmp
file, with the file name underneath. It won't display .jpg at all - only
the file name.
I've played with this for a while now.
"Paul Doree" <PaulDoree@discussions.microsoft.com> wrote
> How do I get an ole field on a form to display full frame.
> At the moment, all I can get it to do is show a small (and
> rather blocky) verion of a .bmp file, with the file name
> underneath. It won...Names on worksheet
I have a worksheet full of names to reference cells. They
are no longer of any value and the VBA they work with is
not required and will be removed. With the removal of the
VBA (and it must be removed because it causes problems
with the way we use the worksheet) the names keep wanting
to access the code. They also activate the "links"
Is there a quick way of deleting names rather than one at
a time? I will have a number of files each with a number
of worksheets in them and each one has to have the names
Sub DelN...Sendinng mail showing a different sender's name
At my work, we use Outlook 2000.
I have my normal email mailbox address firstname.lastname@example.org , but I also
have access to another mailbox "email@example.com"
When I send emails, the mesage always automatically shows the sender as
Is there a way to set the default sender to "firstname.lastname@example.org " so that
the receiver sees that name and not "andre". I do not want to individually
modify each email sent using the "FROM" feature, as this would be time
consuming. In my Outlook on my personnal computer, I know h...Outlook 2007 New Form and Importing
If I create a new form in Outlook 2007 with fields that match custom
fields I created in ACT will I be able to import the data in those
custom fields from ACT into Outlook 2007?
Outlook does not support importing custom fields without VBA code to do =
so. See http://www.outlookcode.com for examples.
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, BobB asked:
| If I create a new form in Outlook 2007 with fie...Need to import select Access data into Excel using two variables
I have a large amount of data in Access, more than Excel can manage. The
data consists of many columns; has Col_1 as unique key 1,2,3,4,5,6,7,8 etc…
and contains data that includes Col_2, Col_3, Col_4 etc….
It takes a combination of Col_2 and Col_3 to get the data I want. Col_2 has
duplicate values and Col_3 makes the subset unique.
One more thing… Col_3, Col_4 etc…may have blanks throughout the table and
can’t be changed. I don’t own it.
I want to be able to open Excel, type “Number from Col_2” into Col_A ,
“(Number fromCol_3) or (blank)”into Col_B and have the Col_4, Col_5 etc… d...Newbie question on variables
I had a coder write me a VBA which was rife with errors and he disappeared on
me so I've spent the last few days somehow managed to slog through and make
fixes (don't know VBA or coding)
However I am stuck on my last fix.
Essentially there are a # of functions within a larger one
I need to set a variable inside an if/then statement and store it in a cell
on the WS to access in a later function.
Based on how he wrote to cells I did this
wsCert.Cells(targetCertRowNumber, 300).Value = "Name"
which worked inside other functions
However I get this error
...Code to clear all CheckNBoxes when a Form loads
I have 20 CheckBoxes on a Form. All are set to Triple State = No. When the
Form opens, all CheckBoxes, except one, always has a solid green square in
the middle. I check off all CheckBoxes, close the Form, and all will have
the tiny green square in there again. Is there some setting that manages
this? If not, can I add a snippet of code to clear all CheckNBoxes when the
If this information was helpful, please indicate this by clicking ''Yes''.
I'm not sure why they're acting like that, but you can proba...Name Parsing
I have a field that contains lastname MiddleName and
firstname as one field, for example:
Smith, Joe, Robert
Chan, Mary, Julie
I want to parse out the name field to:
As the example shows, the name field may not have the
full name. The problem, I have in parsing is when the
field only has a last name.
is true when the NameField doesn't contain a comma and therefore
contains only the last name.
Parsing data out of a field this complicated is IMO eas...How to un-concatenate a field with full name
I have a filed called "Contact" that has the full first and last name - is
there a way to break this field into 2 fields - "first name", 'last name" ???
How do you find where to split the field?
Take a look at "InStr" function in vba
> I have a filed called "Contact" that has the full first and last name - is
> there a way to break this field into 2 fields - "first name", 'last name" ???
> How do you find where to split the field?