Excel combo box
Is there an easy way to maintain a date format from the original cell
through selection via a combo box?
Message posted from http://www.ExcelForum.com/
If you add the items yourself--instead of using listfillrange, then the combobox
from the control toolbox toolbar will keep the formatting:
Private Sub Worksheet_Activate()
Dim myCell As Range
.ListFillRange = ""
For Each myCell In Me.Range("a1:a14").Cells
or if you want...Need only one DLL instance to run...
if two apps load the same DLL - LoadLibrary(...) - system will create to
different instance of the DLL...
Now, in my DLL i've a CList and i need it to be visible to all instance and
Is there a way!?
I need the dll to remain loaded till machine reboot!!! Is it possible!?
>if two apps load the same DLL - LoadLibrary(...) - system will create to
>different instance of the DLL...
>Now, in my DLL i've a CList and i need it to be visible to all instance and
>Is there a way!?
It'll be difficult to share a ...How do I copy pages so that formats also arrive at the destinatio
Whenever I copy a worksheet to a new page, I have to reset the column widths,
Bold selections, alignments, etc. How do I copy so that the non-text
material appears at the destination? "Paste special" doesn't help. Thanks
Why does PasteSpecial not help?? Seems it has everything you're asking for.
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.
"Peg" <Peg@discussions.microsoft.com> wrote in message
news:DC00EE5B-02A6-445A-97CC...in box header telephone bent arrow and envelope
messages in inbox: those with a telephone, bent arrow, and an envelope will
not open, I cannot delete. I can read them from web mail, but I want to down
load and/or delete. any help out there?
what type of email acct do you have? is outlook online?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange ...credentials to run this report are not stored
I'm getting this problem when I try and create a timed subscription.
Error: ...credentials to run this report are not stored.....
ok I created another folder under the same folder where I'm having this
loaded the report and I have no problem. I even moved the current folder
with that report in it. Creted another folder with the same name
and still the same problem with that named folder. With a different name for
the folder I have no problem???
I'm stuck here.. almost all post just talk about storing the credentials,
Already done and works...How to copy macro from template into document programaticaly?
There is one template. By this template I'm creating new document. I
need to copy one macro from this template into this document into
module ThisDocument. How?
Just one macro? There are others that you do NOT want copied over? You do
know, I assume, that procedures in a template can be used in a document
cloned from that template - as long as the .DOT file is available.
To answer your question though, you could put that procedure into a exported
file (as a separate module perhaps), and then as part of your template
Document_New(), import that file into the newly c...Combo box multi autocomplete
Hi am very new to access and am making fair progress, but have struck
a problem. I have a database with an old existing table and am
creating a new table and form for it. On the new form I want to combo
box select a value (say name) from the old table and have it auto
complete other fields (say customer number, telephone number, address)
on the form and store these into the new table under slightly
different column names. Any direction would be much appreciated..
Why would you want to store the data redundantly? That's seldom a good idea.
In any case, remember that your combo box can co...Excel Validation Drop Down Box
Is there any way to increase the size of the text in the
validation drop down box? If the sheet is zoomed to say
60% the text in the box is not readable.
No, but you may find this helpful:
In article <firstname.lastname@example.org>,
"Mike S." <email@example.com> wrote:
> Is there any way to increase the size of the text in the
> validation drop down box? If the sheet is zoomed to say
> 60% the text in the box is not readable.
...run time error 10-22-03
I am having a lot of trouble when I open up word I get
run time error 52 in VB. I have tried uninstalling word
and reinstalling it. WE have tried deleting the macro
but still to no avail can someone help me please?
...Repost: Error running Report in an Access 2003 db from Access 2007
Ok, clarification - ignore the code from my original post, some of the
reports do work. The ones that don't are reports that I have being filtered.
Here is the code from one of those buttons:
Private Sub Ok_Click()
On Error GoTo Ok_Click_Err
'using the customer sub form for customer state report to filter the
report, clicking ok will open report for selected state
Dim stDocName As String
Dim stLinkCriteria As String
If Not IsNull(Me.Search_Results) Then
stLinkCriteria = "[StateOrProvince] = """ & Me![Search Results] & """"...xp desktop and start button missin
cant get into to windows even in safe mode have to go to task manager to open
In task mgr,locate "new task",type: cmd In cmd type: CHKDSK C:
After,you may want to type: Sfc /Scannow Install xp cd,exit the menu
page.Once its thru,remove xp cd,type: CHKDSK C: /F Agree to restart,type:
EXIT Restart pc.
> cant get into to windows even in safe mode have to go to task manager to open
...Automatically run macro
My name is Mike and i have a question about microsoft excel macro's.
Attached is a copy of the excel sheet im working on. Below the excel
sheet is the macro I built. Some of the cells contain given values and
some cells are calculated from formulas. Cell (G4) is my given
value...it is related to cell (C32). The point is, I plug a value into
cell (C10) and it runs through the rest of the calcs in the other
cells and gives me a value to cell (C32). I built a macro that works
as a goal seek pretty much. The macro makes cell (C32) equal to cell
(G4) and gives me the value for cell (C10). I wan...Excel Continuous Running Total
I posted a message earlier and have received a partial solution.
I want to keep track of how much stock prices go up or down with a running
total of how much they go up or down over several days until the direction
For example, if price go up 10 on Mon, 20 on Tues, 30 on Thurs and down 10
on Fri I want my running total column to show a positive number of 60 and
then a red number of 10 and continue adding the amount of the total of the
down days until the market shows an up day.
The formula I am now using total the first and second day but does not do a
running total count if t...display changing label caption on form as sub runs w/o screen flic
let's say i have this routine
label1.caption = "Starting ... "
label1.caption = "Getting there ... "
label1.caption = "Finished! ... "
on my form, i have label1 right in the middle
what happens is sometimes the message will change, and then sometimes it
wont, or it will show the first one, skip the second and jump to the third
etc etc etc
so it is inconsistent.
is there a way to make sure the label caption displays consistently, on
time, wh...mail merge wiht Office xp
I liked the old mail merge in office 2000. Can i configure
office Xp mail merge to work like office 2000?
...Money 2002 will not run
I had been using Money 2002 for approx. 3 yrs on my home pc (Dell Dim 2100,
XP Home Ed. w/SP2). Last year, it simply would not launch. No error message,
no splash screen, no app opening, no process listed in Task Manager. Just....
The only change that was made to the system since M2k2 last ran was
upgrading my a/v solution from Trend Micro PC-Cillin to TM Internet Security.
I have tried disabling every aspect of the Internet Security product, as well
as completely un-installing the app, and then attempting to run Money, but
the same thing (nothing) happens.
I was considerin...Xp Vs Win98 style
I use VisualC++ 6. I have seen that the applications created with my VC6 the
windows, buttons and all results with win98 design. How is possible to
convert this kind of style in the new XP style with flat and colorized
You might search the Web for manifest and XP themes. If you are still using
VC6, then you need to create a manifest file (which can actually work as a
separate file instead of being linked into your EXE as a resource). Things
are a bit different with VS 2005.
"Milkas" <Milk...Re: Workflow just wont run automatically, i have to run them manually
Yes, but i realized what i was doing wrong. I assumed [bad idea] that if i create a case and hit Save & Close the first time, taht the rule will run. In order for the rule to run automatically, it has to be Save, once it saves it, then Save & Close.
Thanks for your reply.
Did you check the workflow monitor to see if the rules get triggered
correctly and complete sucessfully ?
Have a nice day,
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://...Copy Import/Export Specifications
Is it possible to Copy Import/Export Specifications from one table to
Dia 's Muire duit
In the File/Get External Data/ Import dialog, choose the database, then in
the next dialog, check the options button and select the import/export
"Joseph Meehan" <sligoNoSPAMjoe@hotmail.com> wrote in message
> Is it possible to Copy Import/Export Specifications from one table to
> Joseph Meehan
> Dia 's Muire duit
P...copy meeting invites
I am trying to figure out how to copy a meeting and not move it. It is not
recurring with any consistency due to availability.
I invite a distribution list and agenda/open items created for 1PM on
Monday. How do I create a followup meeting on Wednesday at 11AM without
moving the Monday meeting or starting from scratch.?
"jmac60" <firstname.lastname@example.org> wrote in message
> I am trying to figure out how to copy a meeting and not move it. It is not
> recurring wi...Outlook Still Running
I am running XP Pro with Office 2003 Pro and sometimes when I exit out of
Outlook, Outlook.exe and Winword.exe stay as processes still running. Does
anyone else have this problem and what can do to make sure this does not
Thanks for your help
Remove ABCD from Email address to reply <neil154ABCD@earthlink.net> wrote:
> I am running XP Pro with Office 2003 Pro and sometimes when I exit
> out of Outlook, Outlook.exe and Winword.exe stay as processes still
> running. Does anyone else have this problem and what can do to make
> sure this does not happ...Cant Restart XP Home Edt / Desktop doesnt reload / Blank Screen
Thank you All in advance for your responds.
My laptop froze and I had to restart it using the on/off button. During the
reboot, I saw the windows logo showing on my screen while loading just like
normal, however, my desktop never reloaded. Now, It appears a blank black
screen after the reloading process. No error messages either. I push the F8
button to access the "advanced options menu" during the restart. I tried safe
mode, Last Known Good Configuration, Start Windows Normalls but none of those
options worked. I didnt want to get into more technical stuff without...Copy Local Message Rule
I've created a complicated message rule for filtering that I would like to
put on other client machines. Can I copy it?
Is this possible?
WIn2k server/ Exchange 2k w/all current SPs.
...combo box in a query
Is it possible, do you think, to insert a combo box into the criteria
section of a query? The user of the query will have a lot of units to
choose from in the query and it would be easier for the user to have a
drop down box to make a selection from. Can this be inserted into the
query so that it appears and is functional when the query is run?
If so...how would a novice go about it?
Not directly, but you can enter a reference to a combo box as a parameter in
the query. Create an unbound form with a combo box on it which lists all the
possible values in o...Very strange problems while running Great Plains on workstations
I notice that a few workstations in an office I support are having
problems when they run Great Plains. Excel, Outlook, Word and
Dynamics.exe are showing in the Application event log as being Hanging
or Faulting. I also see Fault Bucket errors, but when I search online
I cannot find any information online.
Here is one of the Fault Bucket errors:
3:15:35 pm 28-Sep-06 Application Hang None 1001 N/A
Fault bucket 296734104.
Also, these workstations are experiencing problems printing PDF files.
Has anyone out there seen this behavior and if so, how can these
problems be fixed?