Change table text column lookup list
I must add a column using vba and need to change the lookup list.
Set tdf = DB.TableDefs("TableName")
Set fld = tdf.CreateField("FieldName", dbText, 50)
The FieldName column need a lookup list whose
Display Control is a combo box
row source type is a value list
row source consists of a list as in Item1;Item2;Itemn...
Can this be done using VBA when the column is created.
>I must add a column using vba and need to change the lookup list.
>Using: ...Message colour ?
Someone recently sent me a email that shows up red in my message window ( I
don't use the preview pane ).
I don't have any message rules that would change the colour of that message
or anything like that and the priority of the message is normal.
Anybody have any ideas as to how this is done ? OL 2002.
It's done with the default automatic formatting rules -- View | Current View
| Customize Current View | Automatic Formatting
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
...Fixed Asset- change in cost basis
What is the process to increase or decrease the cost basis of a fixed asset?
I have some that the cost basis need to increase & some that the value needs
to decrease. Will the depreciation "catch up"?
You change the cost basis in the Asset Book card. When you click Save
to save the changes you will be warned that you have changed a
depreciation sensitive field and asked if you want to continue. Say
yes - you have 3 choices as to how you want depreciation recalculated
Reset Life Recalculates depreciation from the date it was placed in
service to the date the as...Need to change comission settings
I need to change the comission setting on all inventory items so comission
will be based on the sales rep's comission schedule.
Also, is there a way to make this the default setting?
Hi Meralee....you'll need to run an update query so all items in your item
list get flagged as "base commission on sales rep schedule"....
backup your database first and if possible update after hours
connect to your db with so administrator
query - new
set commissionmode =1
this will udpate all your items in your item list
My store ops (v2) defaults to sales rep comm...554 delivery error after changing DNS settings ?
I recently upgraded AD from 2000 to 2003 by prompting a member server and
making it a DC and transfering all roles, catalog etc... (old DC not
demoted yet but is switched off). This new DC also hosts DNS and WINS.
Im running exchange 2003 on an additional 2000 member server in this domain.
Im receiving emails ok (i.e smtp pushing email to me - not using connector)
but when sending email i get the following return:
'firstname.lastname@example.org' on 13/09/2005 14:42
There was a SMTP communication problem with the recipient's email server.
Please contact your system administrator.
Greetings from Downunder
One of my colleagues sent me this, something of a puzzle.
She is using XP and Office 2003:-
In My Documents I have a folder of PPTs of hymns and songs that we use in
church. I file any new songs here making sure that they are a golden yellow
text on a very dark blue background. This is the way it has been for about
This morning I went to use some of them in the presentation for this coming
Sunday - and would you believe they are now ALL pale yellow on a black
background. Every last one of them - and each song is is a separate PPT
...Dates changing in MPP?
When I enter my receipts I obviously use the transaction date for the date
of the sale. However, I just noticed that a lot of my dates have changed by
a few days when I compared against the Visa statement. Is there an issue
where MPP changes the date? Even downloaded transactions match against the
transaction date before I accept them or I'll change it.
In microsoft.public.money, Geekster wrote:
>When I enter my receipts I obviously use the transaction date for the date
>of the sale. However, I just noticed that a lot of my dates have changed by
>a few days ...GPO for change of "Show this address list first" ?
is there a way to change the setting in the Outlook address book over GPO ?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Udo Lorenz" <Udo Lorenz@discussions.microsoft.com> wrote in message
> is there a way to change the setting in the Outlook address book over GPO
...changing bargraph colors
I have the following code section:
int a, b, c, d;
in = fopen("teststring.dat", "rb");
fread(bars, 30, 1, in);
d = (cr.Width()/30);
for (b=0; b<30; b++)
a = ((bars[b+0x30]*10)/14) + 1;
pControlDC->Rectangle (c, cr.Height(), c+2, cr.Height()-a);
The file teststring.dat contains 30 bytes data in t...Imported Form Changes
This is a multi-part message in MIME format.
Access 2007 sp2.
I hope I explain this ok... Here goes.
When I want to discard changes made to a form by importing a form form a =
the imported form takes on all the characteristics of the form I want to =
As an example, lets say I remove a command button from Myform in my main =
I then import Myform from a backup knowing that this form still has the
command button...changing the server response for SMTP
If I telnet into my server via port 25, the server responds with "220
server.mydomain.local Microsoft ESMTP Mail Service...."
I want to correct this so it responds as my correct FQDN, which would be
I swear I must have done this a dozen times in the past on other servers by
checking the properties of the SMTP Virtual Server, Delivery, Advanced, and
typing the correct name in the FQDN box.
However, I've done that, stopped and restarted everything, rebooted the
server, and it still shows as the ".local" name.
Where else should I be...can i match a colour to its wavelength in nm
I have no clue what nm means?
Mary Sauer MSFT MVP
"aquakem" <email@example.com> wrote in message
Mary Sauer <firstname.lastname@example.org> was very recently heard to utter:
> I have no clue what nm means?
Won't do it.
http://members.cox.net/astro7/color.html claims to have a FORTRAN program
that will do it....changing a series 'value' label to 'none planned' ? #3
Thanks, that worked fine, now displays None Planned if the figure is 0.
neowok's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5940
View this thread: http://www.excelforum.com/showthread.php?threadid=274120
...Colour Rows in Datasheet based on three criteria
I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
thanking you in anticipation
On Mon, 17 Dec 2007 09:05:01 -0800, PMK <PMK@discussions.microsoft.com> wrote:
>I was wondering whether it would be possible to colour r...Why is colour printouts not same colour as in word?
When I print my logo from Word the colour is correct. When I copy it to
Publisher and print it from there the colour comes out wrong. What could be
Try importing the image rather than copy/paste.
Mary Sauer MS MVP
"DvdM" <DvdM@discussions.microsoft.com> wrote in message
> When I print my logo from Word the colour is correct. When I copy it to
> Publisher and print it from there the colour comes out wrong. What co...Change bkgnd colour for some words in CRichEditCtrl?
I'd like to be able to change the background colour for some of the text
in a CRichEditCtrl. I'm comparing two files side-by-side in these controls
and need to be able to highlight some text to illustrate the results.
I could just change the text colour and make the font bold and/or
larger, but highlighting similar to when text is selected would stand out
better, especially if I could also change the text colour to suit.
Is this possible? (I've seen it in some programs, but don't know if a
CRichEditCtrl was used.)
Any help appreciated,
...See last changes in sqlserver
This is probably a novice question but I cannot find it: Say you are
debugging a program, you replay the error, and you want to see which
database files are effected, how can you see that? Is there a way to get the
latest changed date for a entity, is there a log file where you can see
which statements where executed the last five minutes? For example my
database exist out of customer, product, order, company files/entity I want
And then conclude:...Change formulae easily?
I have to change a great amout of formulae from a simple
=A3/A4 to either
The cells are spread all over the sheet, sometimes in one row or line,
sometimes grouped together or sometimes individually placed anywhere on the
Is there an easy way to change these formulae faster then individually
change each cell? Even changing each cell individually would be easier if
there was a way to wrap the old formula between the necessary alteration.
(PS: ASAP has a Macro that can alter the formula, but it can only add
something at the end...Changing column views
When I go into view-> columns and change the columns that I want to see in my
view, it only saves the changes for that session. IE when I go back into
Mail later it has reset to the original columns! How do I keep the view
changes that I want permanently??
"Vic33" <Vic33@discussions.microsoft.com> wrote in message
> When I go into view-> columns and change the columns that I want to see in
> view, it only saves the changes for that session. IE when I go back into
> Mail later...Change Range in macro
How can I change the range in the macro below for sending email to recpients,
I want to change the range to sheet3 and email addresses that are input into
Here's the code:
'Working in 2000-2010
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim Sourcewb As Workbook
Dim Destwb As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim OutApp As Object
Dim OutMail As Object
.ScreenUpdating = False
.EnableEvents = False
Set Sourcew...colour recognition
hi guys, i may be chasing the impossible here, but here we go anyway. ive got
cells in my spreadsheet formatted so that they change colour depending on
what value is input. basically, i want to know if its possible for excel to
recognise how many cells of a certain colour i have and then display the
results numerically. is this possible?
yet again, your really helping me out and it would be greatly appreciated.
If you're using Format|conditional formatting to color those cells, then I think
it would be easiest to just duplicate those rules in helper cells and then use
those helper cel...Removing Border lines and colour for All sheets
is it possible to write a macro to run every sheet and just remove
border lines and colours for all cells in a sheet for every sheets in
I know macro is like this but can't really think how I can loop this.
Can anyone help?
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borde...Message icons have changed in Taskbar
Opened Outlook messages displayed an "Outlook" icon in the taskbar
Opened Outlook messages display as "Word" icons in the taskbar
Problem - the user cant tell the difference between open Outlook messages
and open Word documents, they open multiple of each and quickly become
confused, very annoyinig (the problem AND the user!!)
Any ideas what may have caused this and how to "unwind" ?
Outlook2003 latest SP and fully patched
Apparently some recent patch caused it - I don't know which one, only that
several people have complain...Code to change label colour
I want a label control of a tickbox on a form to change colour if it is
checked, assuming the checked value is YES. I've tried this code but it
Private Sub txtwithdrawn_AfterUpdate()
If Me.txtwithdrawn Is Yes Then
Me.txtwithdrawn_Label.ForeColor = 255
Can anyone help me here.
Sorry for posting too swiftly, realised that checked value should be = True
and it worked.
"Tony Williams" <email@example.com> wrote in message
>I want a label control of a tickbox on a form t...changing message reply
When sending an email through Outlook, I want to use
Comcast as my out going mail server and AOL as my
incoming mail server. Can I set that up through Outlook?