Pop Up Combo Box
I have 3 options in a combo: TS, CT, and MISC
Each one of these options has their own pertinent account codes.
What I want is the ability to choose one of the options (TS, CT or MISC),
and based on that choice, have another combo box pop up with a list of
corresponding account codes.
If you can help with step-by-step moron-proof instructions, I would be much
This is called "cascading combo boxes". A google search should return plenty
of links that will show you how to do it.
> I have 3 options in a combo...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...SharePoint (WSS) 2007 / Outlook 2007 - Alert
This is a multi-part message in MIME format.
We have setup a SharePoint Server (WSS) 2007 and are using the alerting =
After we changes stuff on WSS, an alert message is generated and sent to =
an email account.
This e-mail account is hosted on an Exchange 2003 server.
When using Outlook 2007 to open the e-mail, we get:
Cannot open this item.
Wenn using OWA the e-mail can be opene fine.
Does somehow have an explanation for th...selected row count of list box
Is there a way to get the selected row count of a list box dynamically as
the user selects rows? Delphi has an event called "OnSelectionChanged" but
Access is much more limited. I don't want the user to have to exit the list
box or click a button or anything manual in order to see the # of rows he's
selected. How can this be done?
I know about "lstCusts.ItemsSelected.Count" but not sure what event to use
it in to accomplish what I need.
Never mind. I did this and it handles both mouse and keyboard selections:
Private Sub lstCusts_AfterUpdat...disable Review toolbar which came up automatically when opening a.
How can I disable the Review Toolbar which comes up automatically when
opening a file?
In the Workbook VBA actions.
The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.
Right Click and select "View Code"
There will be two drop down boxes one that will probably say General
if this has never been entered previously.
Change the box on the right to Workbook.
Then Change the right hand box to "Activate"
Insert the following code
Application.CommandBars("Reviewing").Visible = False
exit the VBA screen and t...Importing spam list
I have a long list of spam email addresses that I want to
import into outlook. How do I do this? Do they have to
be separated by commas?
Where is this spam list generated?
What version of Outlook?
Where do you propose to import them?
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, Paul Ellis asked:
| I have a long list of spam email addresses...Smartlist Export to CSV
I've notice when I try to save a file as tab or comma delimited, it still
just comes out as a regular text file with no formatting. Only thing I can
do is export to excel and then save to CSV. Is there a problem with this in
Try exporting to Excel and then saving in whatever format you want.
David Musgrave [MSFT]
Senior Development Consultant
MBS Support - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft..."the wizard is unable to open your query in datasheet mode, possi
"the wizard is unable to open your query in datasheet mode, possibly because
another user has a source table open in exclusive mode. your query will be
opened in design view"
what this message mean ,and how can i solve it
Please provide more details as to what you are doing when you get the error,
what your database setup is (i.e. split Fe/BE?, multiuser?, version? etc).
Without more information, we can only guess.
>"the wizard is unable to open your query in datasheet mode, possibly because
>another user has a ...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Any FREAKIN' way to import DBX files into Outlook 2003
Importing via Outlook | Import from another Program or File
Importing via Outlook | Import Internet Mail and Addresses
Exporting from Outlook Express
Tried Many, many times...
Can Microsucks make this any more complicated...
It's a FREAKIN' DBX file collection
NO - No other Application has it Open.
YES - The Files ARE there
YES - the Internet Account IS there
Yes - I've wasted more of my time IMPORTING into Outlook Express in
VISTA just to RE-EXPORT back to Outlook. What a bunch of freakin'
Another 2 hours wasted - because one Microsoft applica...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Import reg files into Registry, without UAC
I've got a .reg file to be imported silently in a batch. The file contains
only entries in HKEY_CURRENT_USER, therefore can be imported without
This works well with the regedit /s switch on limited accounts, however on
admin accounts, elevation UAC prompt is still shown, even though it's not
How can I prevent this?
Jens M�ller wrote:
>I've got a .reg file to be imported silently in a batch. The file contains
>only entries in HKEY_CURRENT_USER, therefore can be imported without
>...Opening .prn files in XL2000
I am using a software that does not save data/reports in .csv or .xls
formats; only in printed versions. Is there a way to save the printed
report in a file and open the file in XL2000? If there is, how is the print
file produced, where is it saved, etc? A friend suggested setting up a
generic printer but didn't know how to go about it.
You may want to give that other software just one more chance--look under File
and see if there is a SaveAs option. You may find something upon further
But if you want to add a generic printer, I think it'll depend on your version
of win...How do I import from LotusOrg 6.0?Import command only has 5.0
I am trying to import my calendar data from Lotus Org V6.X. Under the file
command, it will only import from V5.X. Does anybody have any help for me
since I would like to convert to Outlook from Lotus Organizer.
DonAlbert <DonAlbert@discussions.microsoft.com> typed:
> I am trying to import my calendar data from Lotus Org V6.X. Under
> the file command, it will only import from V5.X. Does anybody have
> any help for me since I would like to convert to Outlook from Lotus
> ...Trying to open the current db in Access 2010 through Access Basic
I haven't programmed in Access Basic in quite a long time. Through Access
Basic coding, I use to be able to open the current database and then open a
table and walk through each record. Now I can't even open the database.
Does anybody have an example of how to do the following:
1) Open Workspace
2) Open Current Database (assume name is unknown during run time
3) Open specific table
4) Step through each record and access the fields
George C. Derkacs <George C.
>I haven't programmed in Access Basic in quite a lon...IF statement based on True/False that activates a certain list box
I've been asked to create a formula that will react to either "yes" or "no"
entered into a cell which will show options in another cell based on a
Cells D3:D5 contain the values Monday, Tuesday, Wednesday (list named BegWeek)
Cells E3:E5 contain the values Thursday, Friday, Saturday (list named EndWeek)
Cell A3 accepts either "yes" or "no" entry only from a list
If A3 = "Yes" then B3 will = drop down list BegWeek
If A3 = "No" then B3 will = drop down list End Week
I don't even know if thi...How to import a list of links into Excel?
Does anyone have any suggestions on how to import a list of links in to Excel?
Under the sheet "Date", there is a list of http links under column C, and a
list of name under column B, I would like to import each link into specific
sheet at cell A1. For example, in sheet "Date", there is a link www.cnn.com
in cell C2, and 1 in cell B2, so this link is imported into sheet "1", and
keep running the rest of links.
Does anyone have any suggestions on how to do it in Excel macro?
Thanks in advance for any suggestions
If you have numerics in...Help
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...how can I draw a box and whisker plot in excel 2002?
I have some data, and have worked out the minimum value, the 1st and 3rd
quartiles, the median and the maximum, but need to find out how to put this
together in a box and whisker plot
Bernard V Liengme
remove caps from email
"andywilson" <email@example.com> wrote in message
>I have some data, and have worked out the minimum value, the 1st and 3rd
> quartiles, the median and the maximum, but ...Need to show file properties dialog box
I need to show the shell's file properties dialog box. I tried
converting old vb6 code into vb.net but it gives me error. Here's my
Private Structure SHELLEXECUTEINFO
Dim cbSize As Long
Dim fMask As Long
Dim hwnd As Long
Dim lpVerb As String
Dim lpFile As String
Dim lpParameters As String
Dim lpDirectory As String
Dim nShow As Long
Dim hInstApp As Long
Dim lpIDList As Long
Dim lpClass As String
Dim hkeyClass As Long
Dim dwHotKey As Long
D...Text Box & Border Art
New Publisher 2003 user and getting quickly frustrated.
I have setup a custom page size of 6.5" x 4.5" under Page Setup/Print
Settings. I then created a text box of the same size, and filled it with the
text I wanted. I then want to add a border to this text box. So, I right
click on the text box, and choose Border Art under the Colors and Lines tab,
and select the border "Twisted Lines" and hit apply. All is good. Now comes
I hit print preview and about 1/8" around the entire page is cutoff. All
the margins are set to 0". I'm at a ...How to delete stuck file from "All Junk e-mail" Box ?
How to delete stuck file from "All Junk e-mail" Box ?
I'm using WLM on Win7. Thanks for any help.
"Jdr" <firstname.lastname@example.org> wrote in message
> How to delete stuck file from "All Junk e-mail" Box ?
> I'm using WLM on Win7. Thanks for any help.
try dragging it to the deleted folder.
"c.d." <email@example.com> wrote in message
> "Jdr" <firstname.lastname@example.org> wrote in message
> news:C29193...progress bar in dialog app
I have a dialog based application - which does a lot of number
crunching and launches the dialog.(launching time is around a minute).
The number crunching is done before the dialog even shows up on the
screen. I dont have a splash screen currently to engage the user. I
have decided to have a progress bar to display the status of
completion - just for launching time. I didnt want to create a status
bar and place the progress control there because the dialog itself
shows only after a minute.
So, I plan to have another dialog which holds the progress control,
displays the status and quit...Using CDC::DrawFrameControl() to add resize grip to dialog.
I am using CDC::DrawFrameControl()to add a resize grip to bottom right
corner of my dialog. Everything works fine until I change the
background color of the dialog to red using CDialog::OnCtlColor(). The
color of the gripper doesn't change to red.
My research thus far seems to imply that you wont be able to change it
scolour using this technique.
Andy Mortimer [MS]
Please do not send email directly to this alias. This alias is for
newsgroup purposes only
This posting is provided "AS IS" with no warranties, and confers no righ...Import excel but selected column for selected table
I want to import excel to access but I want selected column to appear in
For example i want to be able to specify column 1,2,3 to load in table 1 and
column 4,5,8 to appear in table 2..
May i know the way please?
Message posted via AccessMonster.com
May I know the way please?
Trever B wrote:
>Import to a temp table
>Run 2 append queries appending the data to the files you want
>> I want to import excel to access but I want selected column to ...