Problem with vba directory function
We have an access application that has a button when clicked opens an excel
worksheet showing all exported data based on code
The access sql system is in Citrix with a single front end copy.
Here is the code part that is throwing the error for just one user.
Rest all are working fine
Dim strSourceFileName As String
Dim WorkBookName As String
strSourceFileName = "c:\CarLogOutPut\CarLogExportTemplate.xls"
WorkBookName = "c:\CarLogOutPut\CarLogExport.xls"
If Dir(strSourceFileName) = "" Then
MsgBox "CarLogExportTemplate.xls doe...Connection Problem 03-20-08
I'm new to access programming so I'm probably making some obvious mistake.
The following code comes from 'Beginning Access 2003 VBA' by Denise
On page 130 of the book you can read:
1. Create a new database by selecting File ?New ?Blank Database and
specifying Ch5CodeExamples as the filename.
2. Create a new table in the database by selecting Tables from the Database
Window and clicking the Design button. Alternatively, you can select the New
button and then choose Design View
from the list. The table should be named tblContacts and should have the
fields i...default appointment times problems
When i re-open outlook and go to the calender, all the appointments times
have changed to 1am on the start day - 1am on the day after it waqs meant to
finish. So a 12 day appointment is now shown as over 2 days.
How do you change the default appointment time settings so an appointment
which is just typed into the day is from 9am - 5pm for example and will stay
as a 1 day event when opening and closing outlook?
All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it
All day appointment change to 1 -1 if you change the time zone or DST
settings aft...Word Documents
Operating System: Mac OS X 10.5 (Leopard)
Hi, How do I make tool bars appear automatically upon opening a new document? Each time I open a new or previously saved document I have to re-open my tool bar. I have been unable to find where I can make the tool bar freeze in place and open when I open documents. I am a college student with lots of papers to write. This gets cumbersome after a while. Please help. Thank you Wendy.
Click the oval button at the right end of a document window to turn off
Apple's poorly documented & unidentified 'minimize...Counting words............
How can I give the total of how many times a word appears in a column?
Smokey_Vol's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29717
View this thread: http://www.excelforum.com/showthread.php?threadid=495182
have a look at
"Smokey_Vol" <Smokey_Vol.email@example.com> wrote
in message news:Smokey_Vol.firstname.lastname@example.org...
>...how do you rotate a visio drawing in word?
It's easy to insert a visio drawing into Microsfot word, but it doesn't seem
possible to rotate the drawing...?
zoom out to see full page, hold ctrl key down, place cursor via mouse to
corner of drawing page, see cursor pointer change to curved arrow, drag to
rotate page, angle shows in bottom left corner of screen, angle accuracy
controlled as usual.
"TJ" <TJ@discussions.microsoft.com> wrote in message
> It's easy to insert a visio drawing into Microsfot word, but it doesn't
> po...Can't See Word Check Boxes in Outlook
I have a Word Document that I wish to send via the File->Send To->Mail
Recipient once it is filled in. The document has questions that require the
User to select a check box for the different selections (Excellent, Good,
Poor, Very Poor). When I send the document, the check boxes show up in
Outlook, however when the email arrives the check boxes are no longer there.
Is there a way to have the check boxes show up in the email, or, are they
somehow being stripped?
...how do you insert a document in words 2007
I need help inserting a document in Office 2007, please help.
Insert - Object
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Likita Rucker" <Likita Rucker@discussions.microsoft.com> wrote in message
>I need help inserting a document in Office 2007, please help.
If you click Insert > Object and pick Object from the dropdown, you'll
get only the first page of the insert because an "object" can't cross
a page boun...Please help me solve my problem
Hi, I Have a cell say a1 that has a continuously changing number it
in and I want to track the highest number that it prints, and the
same for the lowest number in cell a2. I would like these results to
show up in the cells below them
Im very new to programming and your help would be much appreciated
On Mar 5, 1:01=A0pm, Sacha David <sach1...@googlemail.com> wrote:
> Hi, =A0I Have a cell say a1 that has a continuously changing number it
> in and I want to track the highest number that it prints, =A0and the
> same for the lowest number i...Compress pictures in word 2000
How can i compress the pictures in my document using word 2000. I can not
find it in format picture and am now at a loss
Thank you for reading my post. Hopefully you can answer my querie
...how to only show first 20 words of a memo field
I have a memo field on a form, how can i show the first 30 characters and
add 3 periods after the first 30 words.
Message posted via AccessMonster.com
Use the Left function and add 3 periods:
Left(string, length) & "..."
"sheniece via AccessMonster.com" wrote:
> I have a memo field on a form, how can i show the first 30 characters and
> add 3 periods after the first 30 words.
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums...Copy / Paste of Floorplan shapes in Visio Automation problems
I am working on a .Net (FW1.1) application that has a hosted Visio
drawing control. Copy and paste from most existing Visio drawings to
this hosted control works fine. The exception to this rule is Visio
floorplans, where copying and pasting of most shapes is OK, but walls
go totally screwed up (all over the screen, nothing like their original
Our client needs to be able to copy and paste the floorplans into this
container control without the walls breaking; they have a large
investment already made i.t.o. existing floorplans.
Page scaling and size is the same as the exi...Problem moving mailbox between administrative groups
We have a big problem. We need to move mailboxes from one adm group to
other, and at ramdom we receive a MAPI Error
Error moving messages
The MAPI call failed
MAPI or an unspecified service provicer
ID no: 80004005-0000-00000000
The Exchange 2000 organization is in native mode (All E2K)
Any thoughts. Thanks in advance
...Managing Popup Reminder Windows in OL2000
I get a lot of popup reminder windows because I set a lot of follow-up flags
on my email messages. Sometimes I have a whole stack of them cascaded on my
screen. If I don't want to deal with them right away I minimize them.
My question is:
Is there any way (option, rule, VBA, whatever) to have these reminder
windows appear automatically minimized?
Thanks in advance for any help.
...Ability to merge windows into tabs and move a tab into a new windo
I often find myself wishing that I could do two things with IE:
1) Take two IE windows, each with one or more tabs, and merge them together
into a single window with the tabs from both. This would help reduce
clutter in my taskbar.
2) Take a tab and convert it into an IE window of its own as often times I
want to be able to see two web sites at the same time (side by side), which I
can't seem to do if they are tabs in the same window. Either that or some
sort of 2 page view where you can see two tabs side by side and can navigate
Would like to se...dropdown list problem for newbie
i have a column(A) where each cell is a dropdownlist(same list). if
person chooses an item from that list...can it return a correspondin
my drop down list corresponding value
so for a specific cell...lets say A1, i choose building from th
dropdown. i want it to return a value of 1174 in cell A1.
is this possible? if so please help?
enags'...Word as Editor in OL 2003
I'm trying to use Word as my html editor in OL 2003. I must have changed a
setting and now the text I see is about 18 pt. Arial instead of the 10 pt.
Arial I see if I use plain text. Is there a setting I can change? Thanks.
"hank" <email@example.com> wrote in message
> I'm trying to use Word as my html editor in OL 2003. I must have changed a
> setting and now the text I see is about 18 pt. Arial instead of the 10 pt.
> Arial I see if I use plain text. Is there a setting I can change? Thanks.
...previewing windows files in Outlook
Is there a way to preview or auto preview Windows
documents using Outlook? I have placed shortcuts to
various windows folders on my Outlook bar. When I open
the folders in Outlook, there is no AutoPreview or
preview pane feature. I would like to view these files
in Outlook without having to open each file. I use
Peter Henderson <firstname.lastname@example.org> wrote:
> Is there a way to preview or auto preview Windows
> documents using Outlook? I have placed shortcuts to
> various windows folders on my Outlook bar. When I open
> the folders in...IHTMLDocument::Write method problem
I am using IHTMLdocument and its method. My aim is to extract the body
of a IHTMLDocument after loading the local html page ( saved file )
to IHTMDocument. So I just read the file into buffer , created a safe
Array and used IHTMLDocument::write method to write the contents of a
file to IHTMLDocument. It worked fine for many web pages, But when I
tried it for web page
application became NOt Responding.When I debugged the application , I
found that the IHTMLDocument::write method never returned and thats
why my ap...sharing problem
I have a strange problem.
I have 13 exchange users an Exchange 2000 (english)
All the users were migrated when I installed Exchange 1 year ago.
a month ago 2 users left and were replaced by 2 others so I added them
to exchange. All users are using Outlook 2000 (dutch) and are sharing
their calendar. When I share the calendar of the 2 new people
everybody gets the share in their outlook but when they open it it
gives an error that it can't open the share. The strange thing is also
that thier shares are in dutch (postbus) and all other shares are in
english. I made a workaround b...Problems consuming a webservice in Excel2003
I am not a MS-Office expert but have been tasked with trying something
new to me. If there is a better place to ask this question, please feel
free to point me to it.
I have built a Webservice in Delphi 2007. It works fine with a client
built in D2007 and with a generic webbased client. Now I would like to
consume it using Excel 2003. The final goal is to fill a statistics
spreadsheet with a set of indicators calculated from inside a separate
I have installed the Web Services Toolkit and followed the quick
http://weblogs.asp.net/erobillard/archive/2005/07..."Alt - I
About two weeks ago when I was trying to insert a row I found that my "Alt -
I - R" function was not working. After asking around, I found this has
happened to other people.
Can anyone help tell me what I have done or how to fix this problem...so
that I can use "Alt - I - R" in order to insert a row?
If the worksheet protection is enabled ALT + I + R along with many other
commands will not be available.
Check at Tools>Protection.
Gord Dibben Excel MVP
On Mon, 2 May 2005 16:57:04 -0700, "Doug" <Doug@discussions.microsoft.com>...Problem with CSocket.Create() on windows 2003
i'm creating a CSocket object and calling its Create Method in a DLL and
call this dll from an asp page..but i get an exception on Create(). This
only happens with Windows 2003. the code is working fine with windows 2000
server. Also when i created a simple MFC dialog based application (exe) and
called .Create() for it there..it worked fine even on 2003. Can someone
please tell me if there is any issue with the CSockets in windows 2003
calling in a dll and how can it be resolved. I've also tried using
CAsyncSocket but the problem persists. Any help is appreciable.
Thanx and regard...Exchange 2003 SP2 Install Problem
I've experienced this problem with three different SBS 2003 servers.
When I install Exchange 2003 SP2 it fails to stop the EXIFS service and this
causes the installation to fail. I did think it could be related to GFI
Mail Essentials or Security but I've uninstalled both and it still fails.
On Fri, 5 May 2006 14:25:29 +0100, "Spenceley" <email@example.com>
>I've experienced this problem with three different SBS 2003 servers.
>When I install Exchange 2003 SP2 it fails to stop the EXIFS service...Form/ subform link problems
My parent form holds information about a part and my subform holds ordering
information for that part.
Up to now I have linked the child to the parent via PartID : RecordID and
Component Name : Component name. This is great as it shows the component name
on the subform after it has been found on the parent form.
The only problem with this is if the user changes the component name it does
not keep the order information for the same item with the old name.
I want to link purely on the partID : RecordID so that whatever else is
changed the order information history still shows.
When I do t...