Access 2003 resets form variables during debugging while the form is open
I am using MS Access 2003. (FWIW, this is about an ADP project, not
A form has a variable that is initialized (by some function call) in
Form_Load() and then stays unchanged for the form's entire lifetime.
(In a language more advanced than VBA, it would be a constant, not a
variable; unfortunately, in VBA I cannot initialize a constant by non-
constant expression). Specifically, in my case it looks like this:
Private sTempFileName as String
Private Sub Form_Load()
sTempFileName = GenerateTempFileName(...)
I am trying to concatenate two fields and then add text in brackets to the
end. Here is what I have:
StaffFullName = ([Me.LastName] & ", " & [Me.FirstName] & " (Mgr)")
I want the end result to be: Smith, Mary (Mgr)
How do I achieve this?
What you've done will work. You can also use the "+" operator if there is a
possibility that there will be a missing first name:
StaffFullName = ([Me.LastName] & "," & (" "+ [Me.FirstName]) & " (Mgr)")
That will avoid an extra spa...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...fiscal year setting question
i know that the fiscal year settings get more or less set in stone, so i had
a quick question before i set it for my org.
in the template field, what is that used for? if i select 'quarterly', does
that mean i can only run reports on a quarter basis? what if i wanted to do
ultimately, my question is what is the 'template' field used for?
Fiscal year setting must be aligned to your company's accountig policy.
Fiscal year setting primarily defines sales quotas. When you set quarterly
periods, you can set quarterly quotas for mem...Outlook 2000 not opening.
I am having a major problem with outlook. Can anyone tell
why Outlook will not open when selecting it. When I check
in the processes there is an instance of Outlook.exe there
but it is not doing anything. When a different user logs
onto the machine Outlook will open fine with no problems.
I have deleted the users profile and recreated it but to
no use. I have tried comparing the local registry keys of
the two users and they seem to be the same.
Can anyone please help me as I have ran out of things to
Thanks in advance.
Does Outlook start in /safe mode? (I'm assumi...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...Preventing dissambly/decompiliation of MFC Apps and DLLs
I was wondering if there are any software products out there that will take
a compiled MFC app or MFC DLL and prevent the files from being disassemble or
James Simpson wrote:
> I was wondering if there are any software products out there that will take
> a compiled MFC app or MFC DLL and prevent the files from being disassemble or
> being decompiled?
> James Simpson
Whether or not MFC is used is irrelevant. There is no way to prevent or
even resist disassembly. If it is execut...a few basic question about resource files
I have an application that uses resource files to contain the string values
for each language.
I have created the required resource files in my project, but I don't speak
the languages I wish to have resources for.
What I would like to do, is somehow allow the end user to edit the resource
file themselves so they can set the string values as needed.
Is there a way to edit the resource files that ship with my application and
get installed ?
Is there a way to have external resource files (not embedded into my
application) that can be updated/replaced with o...Outlook 2003 rules question again
I have a rule so that after the e-mail comes in, it searches for specific
words in the e-mail header. I set up this rule to search for sober.worm
since I'm receiving a copious amount of spam e-mails which include the
sober.worm attachment. I set the rule to delete the e-mails indefinately
but it does not delete it. It just sends the e-mails to the junk mail
folder. I would like to have it delete the e-mails forever. What can I do
to achieve this?
Nocturnal @ http://www.randomfix.com
Also, I did get it to work a few times but the rule stops working.
Another thing is if ...Opening Multiple Web Links in a Column
I am very new to using web links in excel. A task I do very often is
open a list of different websites that are in various columns in an
excel spreadsheet. I am quite sure I am doing it the slowest way
possible, so I need some help please. Basically I have been clicking
on one link at a time. When I do this, the first website opens and
excel automatically minimizes, then I have to go re maximize excel and
then click the next web link and the same thing happens, etc... very
time consuming. I am wondering if there is a way, either through Excel
or whatever means necessary, to open all...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Cannot Drag Open Desktop Screen
I have a friend running XP MCE (2005) SP3 and he cannot drag an open
screen on his desktop by Left clicking and holding cursor on the top of
Any suggestions as to how to remedy this problem of not being able to drag
a screen will be appreciated
On Sun, 14 Mar 2010 16:48:43 -0400, "ColTom2"
> I have a friend running XP MCE (2005) SP3 and he cannot drag an open
>screen on his desktop by Left clicking and holding cursor on the top of
> A...calendar sometimes opens in month view
every once in a while (sorry that i can't be more precise), i find that
clicking on calendar, under 'all folders' , causes it to open in month
view. i can go back to inbox, and again click on calendar and get month view
again. for most of a day. then it goes back to opening on current day.
which it does most of the time. i don't remember if this happens after a
reboot, standby, or just for no apparent reason.
actually i prefer month view and wish i could make it open this way all the
any ideas about what it happening here?
...Opening Excel email attachments
When downloading excel files AOL says cannot find
suitable program.I then go online to find Excel but only
PC is XP version with Works Suite 2002.
A fe months back my dear wife was downloading Excel an
got board with waiting and shut down the PC!
there's no legal way to download Excel!!
You have to buy< an Excel version and install it on your
PC (or try to open the file with MS Works - but live with
the restricted functionality)
>When downloading excel files AOL says cannot find
>suitable progra...Time Format Question
I currently have time entered like this:
I need to look like this:
I've done a ton of research but nothing has worked so far.
With your values in column AA, try:
Gary''s Student - gsnu201003
> I currently have time entered like this:
> I need to look like this:
> 5:35 p.m.
> 9:02 a.m.
> I've done a ton of research but nothing has worked so fa...Question for Bob Phillips re Splitting Names from Cells
You gave the answers below for splitting names from cells:
Using these formulas on this example John A Doe results in John A an
Doe, is it possible to split it to show John / A / Doe in 3 separat
cells, I know I could use the formulas again on the John A result t
split them but I'd like to do it in 1 go
If possible could...Default User object security
Windows 2003 SP2
I am trying to fix a problem where delegation of control is not working
properly to usr OUs. I ca't seem to keep permissions on user account objects
that allow user accounts to be moved between OUs. I think it may be related
to protected account membership on the user objects themselves. ALso the
"inherit permissions from parent" is unchecked on user objects. Certain user
new user objects work fine and are inheriting. What are the default security
to use on user objects so that i can remvoe membership from protected groups
and how should I a...Security Role Issue 03-16-05
Anyone know why a User assigned to only 1 custom Security Role that has
restricted access for all Core records set to the "User" level?, e.g.
the user is assigned the "User Read Lead" privilege, they should
only be able to read Leads that they own or share.
However, it doesn't seem to be working, as if this user selects the
"All Leads" View, the not only can read other users' Leads, but can
also modify them!
Again this User is only assigned to this 1 Role.
Thank you, BryanK
This is a common problem. How long ago was this role created? Someti...Outlook Question
What causes url links not work? I'm experiencing problems
with it, and cannot get them to show the URL Links.
Clicking the Links doesn't help.
...MS CRM Security Service doesn't start
Hi to all,
I have a problem with my CRM 1.2 some days ago I restart the Win2003 server
where there is installed CRM, and now the "Microsoft CRM Security Service"
doesn't start up!!!
What can I do? I have not any event about that!!!
Can I re-install the CRM server and restore my sql database?
Thank a lot
I would apply the Update Rollup 2 for Microsoft CRM 1.2
> Hi to all,
> I have a problem with my CRM 1.2 some days ago I restart the Win2003 server
> where there is installed CRM, and now the "Microsoft CRM Secur...problem opening up program/file
I am having some trouble opening up Word. It was working okay until I
loaded some fonts to FontBook. Okay, now I removed all my fonts but I
still get this error message about corrupt fonts I have on my computer.
When I open Word, I see the blue starting-up window: Word:Mac 2004.
Right underneath the product ID #, I see that it is initiating... when
it gets to the point "Optimizing font menu performance" I start getting
this error windows popping up one after another. (E.g. The font M
TimesSmallText is corrupt and should be removed.) I keep on clicking
okay for a whole lot...Error: msaccess.exe has generated errors and will be closed by windows
I get error mesage "msaccess.exe has generated errors and will be closed by
windows" when preview report.
I'm using Access 2000 and Windows 2000.
...Office 2008 "Office Installer" could not be opened
Trying to install Office 2008...
When I double click the Office Installer icon....I get the following message:
The document �Office Installer� could not be opened.
I'm on a MacBook Pro. I've never had problems installing programs before. This is new.
Thanks for any help.
On 2/26/08 2:03 PM, in article email@example.comR9absDaxw,
"Dags@officeformac.com" <Dags@officeformac.com> wrote:
> Trying to install Office 2008...
> When I double click the Office Installer icon....I get the following message:
> The document �Office Installer� could ...Can not open additional mailboxes in my mailbox after a exchange 2003 rebuild database
To Exchange 2003 Gurus
I have a exchange server that serve a lot of users. 3 week ago I had
to repair the database with great success. But now I noticed a problem
that in the past I was able to acomplished
I can not open additional mailboxes in my mailbox.(right click on my
mailbox>properties>advanced>Advanced tab> and
when I click on add I get THE NAME COULD NOT BE RESOLVE. THE ACTION
COULD NOT BE COMPLETED.
This message appear eventhough I did not type anything
Here is more info
-I am able to open additional mailboxes if I use a computer with my
profile that I created before I r...