Access combo box control by another data field
I use a combo box in a form with look-up from a table for selecting data.
But, I want to only see a selection of the data in the table, depending on a
value in another field in the form.
I the combo box table I have ID, data1, and data.
data1 is the one that shall be equal to the other field.
1, 1, text1
2, 1, text2
3, 2, texta
4, 2, textb
5, 2, textc
I have tried using the standard query that comes with the combo box, and
then adding a WHERE statement testing against the data fiel in the form, but
it does not work.
Any suggestions anyone?
Check this link on &...AP Credit Memos on checks
Does anyone know of a solution to ignore Credit Memos (selectively) while
selecting checks? I have an issue where there are large amounts of credit
memos (hundreds) on a few select vendors. When we run the select check
process we want to restrict based on Credit Memo "due date" which in GP does
not apply. Has anyone run across this before and what was your solution?
...Network Check before Moving from Exchange 5.5 to Exchange 2003
I'm going to be moving from Exchange 5.5 to Exchange 2003 shortly, and
already have a Windows Server 2003 AD environment in place, with a seemingly
happy ADC connecting to Exchange 5.5.
I'd like to make sure that my Windows 2003 environment is optimised before
making the move to Exchange 2003, specifically I want to look at AD
replication, FSMO roles, DC/GC placement and anything else that you can
Does anyone have some tools/scripts/checklists that I could use for my
project. If I have to go through my environment manually I can, but I'm
hoping that there is ...Sales Stage Code
In the SalesStageCode field there is the "OnChange" event which we understand
provides the ability to add java script changing the probability field to a
numeric value dependant upon the stage that has been selected.
I am looking for code that will look at the SalesStageCode (eg, qualify,
negotioate etc etc) and depending on the stage input a percentage number into
the probability field.
An example of this could be somthing like:
If SalesStageCode = Qualify
then Prospect = 10%
I am not sure of the exact code. Does anyone know of this?
here is an example
==...Disable or Lock check box after initial check
I have a check box that, when clicked, adds today's date to a table field.
Private Sub CkBoxCIComp_AfterUpdate()
Me!CIComp = Now
After the initial check in the box, I would like the check box to be
disables so they cannot check again and change the initial date that was
entered on the initial check.
I also need a msg to contact the admin for assistance.
Can anyone tell me how this can be done?
This will not work in a continuous form, but in single form view, try
Private Sub CkBoxCIComp_AfterUpdate()
Me!CIComp = Now
Me.CkBoxCIComp.Locked = True...Forcing WMP to use the file names I have used
How can I force WMP to use the names I have given my sound files, like
"Lecture on Dystopian Futures" or "Rain sounds" rather than the original
names they did have like DS400789? It's very irritating of WMP to ignore me
In WMP's Options, make sure "Rename music files using rip music
settings" (on the Library tab) is checked.
Tim De Baets
> How can I force WMP to use the names I have given my sound files, like
> "Lecture on Dystopian Futures" or &...How to export VBA source code as text
I have an Access 2003 application with over 100 VBA code modules.
Short of calling up each one in the VBA interface and ^A^C then ^V to
a text editor, is their a faster way to dump all the source code into
a text file on disk?
The "print-to-file" feature appears to create a massive file of laser
printer commands, which is not usable.
Thanks in advance,
Look on the File menu: there's an Export module option.
There's also an undocumented SaveAsText command you can use. Check my
February, 2005 "Access Answers" column in Pinnacle Publication's "Smart ...Outlook password checking
For some reason my Email account information changes. I
find out it has been changed when I send/receive. A
dialog box with a username/password pops up and the
server is changed to localhost and the username is
changed to <username>/<servername>. Also, once my mail
has been sent and received successfully it still asks me
for this password.
It is not Outlook that is doing this but your AV or firewall that you have
set to check incoming mail. Uncheck this option and the annoying behavior
will go away.
Milly Staples [MVP - Outl...checking if an item exists in a custom collection
I have a custom collection and I will add to it few class objects.
How can I double check, through code, if an item has been added or not to
...Check for Alpha characters
I would like to check if the first three characters are alpha, if so
remove them. The alpha characters will be any combination.
BEFORE - ABC123
RESULT - 123
The alpha will not be the same or I would use:
Thanks in advance for ANY assistance
TimE's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=213
View this thread: http://www.excelforum.com/showthread.php?threadid=48363
It would help if you posted a larger representati...Help revising slow code
I am using the following code to remove all the lines in a worksheet that
have a zero value in Column H. Because there are thousands of rows in the
worksheet, this loop takes forever! Does anyone have any suggestions for
doing this more quickly? Thanks!
Dim Firstrow As Long
Dim LastRow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
...Printing my own checks
Has anybody printed their own checks with MS Money?
I'm thinking about getting something like Versa Checks.
MS Money is supposed to have some but I haven't seen it yet.
Have there been any problems with this?
I'm paying most of my bills online.Any suggestions are very
...Linking Position Codes to Payroll Codes
I have read in the help how to link position codes to payroll codes. I am
wondering why I would do this? What is the value in linking a position code
to a payroll code? Does it have any affect on payroll.
The idea is that a position has certain pay codes that can be used and you
want to avoid having users pay executive bonuses to hourly warehouse clerks,
as an example.
Charles Allen, MVP
> I have read in the help how to link position codes to payroll codes. I am
> wondering why I would do this? What is the value in linking a position code
&...Help with SQL- SupplierList cost into Item cost field
Hi, re-posted! See below.
Hi, thanks for that- it worked perfectly. There is just one snag however and
I didn't think of it until I was testing. Many of the suppliers use specific
currencies so the information I need copied from the Supplier tab is actually
the Local Cost. When I view the SupplierList table, Local Cost doesn't
appear as a column. Is it just a calculation based on exchange rates for
information or does it actually exist somewhere within the database? Your
help once again would be much appreciated.
> Hi Tara - backup your...How to use DigiSDK
I plan to do something using DigiSDK to drive Matrox DigiSuite card. But
obviously I'm a newbee in this area. Are there any rescources or manual on
how to do this?
Senior Project Manager
This guy programs the subtitle systems in DigiSuite SDK and develops it by
Visual C++. May be he can help you.
"Sam" <firstname.lastname@example.org> wrote in message
> I plan to do something using DigiSDK to drive Matrox DigiSuite card. But
> obviously ...I need to get Excel to check dates for membership expiration and flag member if
Well ive came up with another problem that i need solved again so i have
come back to the message boards.
If none of you guys remember me I am the secreatary of a Bass fishing
club in my area. My members are all supposed to be members of the
B.A.S.S.. What I would like excel to do for me is check their
expiration dates on their B.A.S.S. membership to see if they are still
good. If not then flag their name on my standings sheet so i can remind
them to renew their membership. All I have done is put the expiration
date of each member in another cell beside their name. What i would
like it to do ...Check rules on record before update
I am designing a layer of classes for database access. I want to implement
functionality to have a record checked against database integrity rules
before I am actually writing it to the database.
I would want to do something like this:
recordset.Edit(); // or Add, whichever
if( !recordset.WouldUpdateBePossible( mydata ) )
MessageBox( "you now already typed something illegal" );
....; // Some time goes by
Edit(); // or Add
....; // actually write the fields
Obviously I would want to do this to evaluate what a user enters in the UI
and...How to Clear History of ' Reciently Used Templates' ? #2
Can anyone tell me:
How to Clear History of ' Reciently Used Templates' ?
The Task Pane only shows two templates, so if you open two different templates they'll replace the current items.
Or, you can edit the Registry (make a backup of the registry first!):
(instructions for Excel 2002)
1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 10.0, Excel\Recent Templates
5. Double-click on Template1 or Template2
6. Delete the file name and path in the Value Data box
7...Change colour of a field
Are you able to change the colour of a field dependant on the fields current
value in datasheet view. When the output from a query is opened, I want to
be able to have differeent colours for different values.
Ie when the value in a field is hertz I want the datsheet view to be green,
yet when the value is Custom Fleet I want the colour to be Green...
Am I able to do this from the Datasheet view (output from a query)??
many thanks in advance ??
You can use Conditional Formatting on the field. You are limited in the
number of options you ha...Changing default printer using VBA
I want to put a statement in my code that changes the default printer to
what I need it to be. Please, what is that statement?
In Access 2002 or later, this is trivially easy.
Just set the Printer object, e.g.:
Set Printer = Printers(0)
Set Printer = Printers("Microsoft XPS Document Writer")
To reset to the default Windows printer:
Set Printer = Nothing
For earlier versions it is more involved. See:
for Access ...need textbox to show only portion of a field
I have a field(Attchmt) that hold the location of a file...see bellow as an
example of data.
Using the data from the field(Attchmt)
How can I display in a form(f020Attachments) textbox(AttchmtName) only the
document name? ProjectQuality.doc
Thanks in advance
You should be able to use this ---
But I had to use this ---
Build a little - Test a...how to put in sql code
first of all many thanks to Klatuu who has already helped me a lot!!
I create my SQl code by means of some string concatenation. I do this so i
can use the values of my field to create my SQl code.
The problem is that some of these fields are double-populated
eg. field location contains England and Brazil.
My string creates "IIf([Table]![Location]" & [Location] & ",'OK', 'problem')"
how can i populated the field location so that it is SQl-code?
as =(Brazil or England) does not work
as =Brazil or = England do...What to use
I have worksheet with foods with many nutrients. Another worksheet has days
of week, meals are entered and the nutrients of each meal are totaled for the
day and week. Using formulas with the Lookup functions is alot of work and
this would be easier if the foods were treated as objects. I've never used
VBA, would it help here?
Quite honestly, this sounds more like an application for a database than for
Excel. Have you considered using Access? It does more intuitively what Excel
requires VBA to do.
"denton" <dento...How do I make a tessellation using Microsoft Digital Imaging?
I would like to use photographs to make a tessellation. How do I do using
Microsoft Publishing or Digital Imaging?
Maybe with Digital Imaging but you'd be better off posting in that
newsgroup. Publisher is not a photo editing program.
MVP Microsoft [Publisher]
"skg47" <email@example.com> wrote in message
>I would like to use photographs to make a tessellation. How do I do using
> Microsoft Publishing or Digital Imaging?
"JoAnn Paules [MVP]" <jl_paule...AREA CODES
HERE IN WEST TEXAS WE ARE IN THE PROCESS OF CHANGING OUR
IS THERE A WAY TO SEARCH AND REPLACE AREA CODES WITHOUT
DOING IT ONE AT A TIME VIA THE EDIT CONTACT FUNCTION
Press your caps lock key 3 times
"JPROYE" <JPROYE@SBCGLOBAL.NET> wrote in message
> HERE IN WEST TEXAS WE ARE IN THE PROCESS OF CHANGING OUR
> AREA CODES
> IS THERE A WAY TO SEARCH AND REPLACE AREA CODES WITHOUT
> DOING IT ONE AT A TIME VIA THE EDIT CONTACT FUNCTION