using a variable for something
I am using the following line to write to a text box on a different form that
Forms![sheet2]![HVD] = Me!Text14
I would like to make this line more generic and use a information from the
current form to substitute for part of the line:
Dim tempDiv As String
tempDiv = Me!division
Forms![sheet2]![tempDiv] = Me!Text14
Is there a way to do this or a different set of commands to write to the
object on a different form.
Thanks for the help.
You can code like this:
Dim txt As Textbox
Set txt = Forms!Sheet2!tempDiv
txt = Me.Text15
If you need to pass the text...Hiding Rows Using IF Statement
I would like to be able to hide a number of rows based on the response to a
The response to the question is a list box with either "yes" or "no" as the
choices.. If the response = "no" then I would like to hide the next 3 rows,
otherwise do nothing..
Is there a "hide" command of some sort that I can use as part of an IF
statement or will I have to use a macro?
Larry, see my response in your other post - must be done with VBA code, and I
provided code there:
http://www.microsoft.com/office/communi...unable to connect to the server
Unable to connect to the server. Outlook is unable to download folder from
the IMAP e-mail server for account aolimap. Could it be I did not set up my
e-mail account correctly and if so please help?
I'm not too familar with AOL's mail usage with other mail clients but I
found this page that might help you:
"Maria" <Maria@discussions.microsoft.com> wrote in message
> Unable to connect to the server. Outlook is unable to download folder from
> the IMAP e-...Using the Join function on lines from an AutoCAD import
I use Visio 2007 and I have a problem joining lines and then filling the
resultant shape on an AutoCAD import.
So, I imported my DWG file. I've done a convert once it imported. I've
discovered that there's a layer called DWGEntityColorOverrideLayer and that
this has to be ticked to allow Visio to recolour lines, etc.
I've got a selection of lines and arcs that touch up against each other to
form a single shape. I want to fill that shape. So I select all the lines and
use the Shapes > Operations > Join function and the join goes ahead but the
fill ...Using Excel DataBase to do e-mail merge
I'd like to send an e-mail to each person in my excel
spreadsheet. How can I do this Outlook e-mail merge.
Have you looked at the help files?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Dennis asked:
| I'd like to send an e-mail to each person in my excel
| spreadsheet. How can I do this Outlook e-mail merge.
...Mail Merge to Email using SFO
Everyone seems to recommend doing a mail merge to email from the web
client. However, you can do this from SFO - and for some of my
customers, they are more comfortable with the "Traditional" merge
process. Could someone please clarify if the only difference is that
MSCRM will not ttrack the body of the email - ie the Activity for that
email will just have "Word Mail Merge"? I would really appreciate
clarification on this issue - driving me nuts!!
Thanks in advance!
Yes, the difference is that MSCRM will not track the body of the email,
if you do it...Use Cell Containing Worksheet Name in Formula
I'm sure this can't be that hard, but I am trying to use a cell that
contains a worksheet name in a formula, but can't get it to work.
CellA1.value = "Sheet1"
Formula is VLOOKUP($A$1,Sheet1!A1:B4,2,FALSE)
but I don't want to use Sheet1, I want a reference to CellA1 that
contains the sheet name.
Any help would be appreciated!
<firstname.lastname@example.org> wrote in message
> I'm sure this can't be that hard, but I am trying to use a cell that
> contains a worksheet name in a formula, but...connecting excel to a database
how to prepare a form in excel so that it gets saved in the database
and we can fill it and send it to the database. and we can retrieve it
for future reference?
Why not just create a form in Access?
> how to prepare a form in excel so that it gets saved in the database
> and we can fill it and send it to the database. and we can retrieve it
> for future reference?
On Jul 6, 7:53 am, bhanu <bhanupriy...@gmail.com> wrote:
> how to prepare a form in excel so that it gets saved in the database
> and we can fill it and send it to t...Change Address Fields using Combo Dropdown List
I have a Form based on a Table called "VoterInformationTable". The Form has
Name and Address Text Fields from the Table. I use Combo 48 to bring up a
new record on the Form. I have another Combo called "cmb_Addr_Change" that I
want to use to change the address of a record to another address I select
from the combo dropdown List.
A friend wrote the following code. I am getting a run-time error '3144'
Syntax error in update statement cmb_Addr_change.
Could someone check the statement below for errors.
Private Sub Cmb_Addr_Change_AfterUpdate()
Dim SQL_Text As S...Formating excel multiple paragraphs and colums using one source of data
column #1 product names separated by category names.
column#2 prices corresponding to products.
Final sheet is basically all product pricing.
To print this out i need to create lay out on sheet # 2
This sheet would have three vertical frames.
this frames would have two columns(one for product names one for
Sheet #1 would project the content to sheet #2 in such way that if
sheet #1 content changes all the content would get formated in number
#2 sheet accordingly .(This content will have multiple pages within a
How can I achieve that?.
...using a name label within an index function
I have defined a name label which contains a path to an external lookup
If I put the path in each formula in each cell the formula looks like
this: INDEX('c:\directory to workbook\workbook.xls'!MYDEFINEDRANGE;10, 12)
I want to use it like this:
But this doesn't work. I'm using Excel 2002. Please help me.
not possible with Excel's build in functions. Have a look at:
"Floran Stuyt" <nospam@nospa...How do I write text on a bar chart using VBA
I have a worksheet with various bar charts. I want to write text inside the
bar but cannot figure out the correct control name to modify the text. Any
help is appreciated
You can add a data label to the data point.
.HasDataLabel = True
.Caption = "Hello"
.Position = xlLabelPositionCenter
.Orientation = xlUpward
'' and more if desired
Peltier Technical Services, Inc.
> ...A) 140 fields in a record -- OK ?? --- B) Do empty fields use disk space?
1 - I've got a record with 140 fields - should I expect any problems
because of so many fields in each record?
2 - How does Access treat fields in which the user enters no data? if
it is a text field with 50 charcters of space allowed... does Access
see that it is an empty field... or a field in which on a few
characters are entered... and compact it... or does it simply save 50
bytes for the field even though none or only some of them are used?
thanks for any help.
1) I can't imagine a properly normalized table that would require 140
fields. 30 fields is considered a large n...Group DB columns to be used in pivot table
I have the following problems to prepare the DB.
I need to create a Pivot Table and my source DB is Excel.
Headings go from Column A to AT, but only columns A to N will be used to
play around with the pivot, while columns O to AT are only to input values.
How can I:
1) Transform the many columns O to AT in one field called Product so that
once placed into the Column part of the Pivot I can see all the headings from
O to AT
2) How to make all the O to AT cells active so that the user can enter
values and see the changes or analyse using the A to N fields?
A B C D E F G H I...Outlook can not connect to Exchange Server
The OWA and POP3 work fine on my Exchange Server 2003, I can use Outlook to
send/receive emails via POP3 protocol, but there's an error when I try to
use MS Outlook connect to Exchange directly, the details:
1. I open the control pannel, User Accounts --- Email
2. Creat a new email account, select email Server "Mircrosoft Exchange
3. Input the Server IP address: 192.168.1.1, then, check name, done! there's
an underline under the user name and Server name, so I think the connection
is no problem.
4. Finish the settings, open MS Outlook 2003.
5. When I open the MS ...How do I connect to our Microsoft Exchange server for my emails?
I have installed Outlook 2007 and it will not connect to my company's
Exchange server from my house. It will connect though if I'm at the office.
My IT guy said everything is configured correctly on my machine. What am I
It's hard to say wtihout knowing your configuration for remote access. Do you
have a valid internet connection? Are you using VPN? Are you being challenged
for your credentials? When your IT person tests your remote access, does it
work? Are there any error messages and/or numbers?
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outl...Sending Mail using SMTP via Exchange Server
We have recently installed Windows Small Business Server in our company and
we are beginning to investigate using Microsoft Exchange. We have set up a
couple of test accounts and we can receive mail fine by using the POP3
connector in Exchange Server Management but we have been unable to send any
mail at all. I have written several test email to send in the test accounts
and after spending a few seconds in the outbox they appear in the sent items
folder but are never actually received. This morning I received a Delivery
Status Notification for each of the sent emails saying that deliver...Using Dates and Numbers
Here is my problem. im trying to figure out how to add
days to dates. for example if it is august 12, 2004, i
would like to create a function that lets me know the
date 12 days from now. basically a function in which i
could put in a starting date and then type 3 days later
and find the new date.
If I understand correctly, in A1 enter the date you require, in B1, =A1+12
will give the date twelve days on,
"Andrew" <email@example.com> wrote in message
> Here is my problem. im trying to figure...Access 2007
I’m using access 2007. I would like to use one of my reports as the body of
an outlook 2007 email message. I’m able to export the report as an HTML file
but can’t figure out how to use either as body of the email message. Is this
possible in VBA? Can anyone help with an example or sample code if possible?
You can send HTML e-mail using Outlook automation. Sample code can be found at
However, you will first need to read your html file into vba so you can use
it as the subject v...Using calculated filenames
Ok, Here's another thing I'm having trouble getting to work. I would
like to concatenate a file and cell name to use to retrieve a value. I
have a master sheet that contains a filename value in a cell. I would
then use the filename value contained in that cell to call a value from
another sheet. Here is an example of what I mean:
['FILE_SALES_JUNE_2006' is concatenated, cell contains value...]
I would then use that value to call a concatenated cell value from
Sales_June_2006.xls!S_1001...VBA Quotes using IIF
In CODE 1 below, I have a working SELECT statement that is the RowSource for
a combo box named cbotrackID. I'm trying to write it out in VBA, but I'm
having a lot of trouble with the quotes. I didn't put my failed code in CODE
2 because I didn't want to confuse anyone.
Can someone help me convert the SQL in CODE 1 into a VBA statement that I
can use in VBA to set the RowSource with a code version of the sql?
CODE 1 **********
SELECT t.trackID, t.trackNum, [trackNum] & ") " & [trackSong] &
IIf(IsNull([trackTime]),""," (" & [...64-bit ODBC driver for MS Access
I have several websites that use MS Access as the backend. I've now replacedmy development machine and installed Vista 64-bit, with Office 2007.I am able to continue to develop the sites (Dreamweaver), but I'm unable totest them locally due to the lack of an 64-bit ODBC driver.I've read various discussions regarding recompiling for x86 32-bitenvironment, but that doesn't work for me as this is IIS based, not a VB.NETor C++ application.Can anyone help me with a pointer or two in how to get around this problem.The ideal situation of course is for Microsoft to produce a 64-bit ODB...Using the registry in Vista.
I haven't started programming to target Vista yet. (First, I need to buy a
new computer that has Vista.) Currently, depending on my program, they run
on either XP or Server 2003.
Can I access the same areas of the registry in Vista? I've been putting
everything in local machine. Can I continue to do that?
If I can't, what do I do? If I write a service... They start up before a
login. Right? So how do I use the registry in that case?
>Can I access the same areas of the registry in Vista?
You can - if you (the user running your program) has permission to do
>I..."Office for Mac 2008" on the Microsoft "Home Use Program"????
When will "Office for Mac 2008" be available to the "Home Use Program"? Thanks...
All flavors of Office 2008 were released today, including the Home & Student
package... What do you mean by "Home Use Program"?
<Matt@officeformac.com> wrote in message
When will "Office for Mac 2008" be available to the "Home Use Program"?
Home Use Program (HUP) is a program MS has with some companies that provides copies to the company's em...Using Excel with multiple monitors
I'm using Excel 97 on Win2k with 2 monitors. No matter what I try, I cannot
increase the width of a workbook to more than the size of a monitor. Its
like the window has a maximum size.
Is there a solution?
I use two monitors for audio work, and have to restore (non-maximize) the
window, then manually adjust it (drag the borders) to fill the two monitors,
and leave it that way (non-maximized). The same seems to be true with
Excel. Mine is a Radeon 7500. I've asked a colleague, who has a
two-monitor setup. If I get anything back, I'll reply again.