Global variables - again
When I load my first form in the system, it reads in the following
parameters from my INI file.
the DOS Path to the Data
I store these two value in a global variable and only reference them from
that point on.
I use the user name to read in a row from the tblUserParm table that has all
of the settings for that user.
I use the DOS data path to get to different sub-directories under my Access
db directory. I will also use it to make automatically re-do my links, but I
am not at that point yet.
Is this an appropriate use of global variables?
Is there...Truncate Table Table variable
Sql Server 2005
I am using table variable with in a stored procedure and within a
table variable i am using identity field.
Sometimes I required to truncate the table variable to rseed the
identity, but truncate table variable, dbcc checkident are not
Declare @Columns Table(id Int Identity(1,1), [Name] VarChar(155));
Insert Into @Columns([Name])
Select * From @Columns
Truncate Table @Columns
Insert Into @Columns([Name])
Select * From @Columns
Ra...Title Bar Control
I would like to put a custom control on the title bar of
the main frame window. I know how to access the title bar
area to change the title, but I'm not sure how to locate a
control there. Any help to point me in the right
direction would be appreciated.
In the OnCreate method of your CMainFrame class,
m_wndTitleBar.Create(this, IDD_TITLEBAR, CBRS_TOP, IDD_TITLEBAR);
in the CMainFrame .h file
"Rick" <email@example.com> wrote in message
> I would like to...Environment variables
Are Windows XP x64 %environment variables% available to Excel and VB equations?
The general answer is yes, but you need to understand that there are
different views of the filesystem and registry for 32-bit programs as
compared to 64-bit programs and the OS. This also affects things like ODBC
sources as well.
<firstname.lastname@example.org> wrote in message
> Are Windows XP x64 %environment variables% available to Excel and VB
...Server config giving out Internal name
I received the following email after I tried sending an email. The fact that
it was sent back is not the issue. What is the issue is that it showed my
internal server name. Here is a snippit:
>Received: from unknown (HELO XXX.internalname.local) (XXX.XX.XX.XX)
> by name.name.net with SMTP; 10 Oct 2005 17:21:28 -0000
I changed some informtion. As you can see, the HELO statement contains my
internal name. As I understand it, it should not be passed. How do I change
this? I also believe that this my be the root of another problem.
Change fqdn in SMTP Virtual Se...How to stop highlighting items in Cedit control
I am using a Cedit control within a propertypage to display a list of status
messages as the program executes a series of actions. Everything works OK,
except that all of the text in the Cedit control is highlighted (selected?).
Is there a way to insert data into the Cedit control without having the text
Call SetSel(-1,0) for the edit control to deselect the text. You can do
this in an update routine.
"Brian Westcott" <email@example.com> wrote in message
>I am using a Cedit control within a propert...Wordwrap Edit Control
My app allows the user to check a short txt or log file. The text
file size is less than 100 characters, maybe less than 50.
It reads the file to a character array and I use SetDlgItemText to put
in into the Edit control.
Is there a way to using the Edit control settings to wordwrap text?
I know I can work around it by breaking up the character array (or
CString) writing lines that will fit. Or I can use a messagbox which
Thanks in advance for any ideas.
> Is there a way to using the Edit control settings to wordwrap text?
Use ES_MULTILINE without ...TEMP environment variable
Does somebody know what happens when I write in the 'TEMP' environment
variable more than one directory, seperated by a ';' (For example
'C:\windows\temp ; d:\temp')?
Does the OSs (98, 2000, XP) know to use BOTH directories as a temporary
...Selecting & copying a named range through a listbox
When i click on a button i want a listbox to pop up.
In this listbox there has to appear a list with named ranges.
The named range which is selected in this listbox has to be copied
Can somenone give me some code for this.
That's it !
Since your post is kinda vague I will have to ask some questions and makes
1.) Are you wanting to select multiple ranges to be copied from a listbox
or select a single range to be copied from a combobox?
2.) Where do you want the range copied to? Another worksheet, workbook,
somewhere else withi...List Control Images
I have looked all around, and still can't see why this doesn't work.
I want to simply insert an image in a column of my list control. I can't
seem to get my image past the first subitem, even if I use the LVITEM
structure. It will display the images denoted fromthe image list, bu only
in the first column.
Also when I use SetImageList for my control, The first image ion the list
always appears before any text I insert in the first column. If I comment
out the SetImageList function, no image appears (duh).
This article describes a CListCtrl extensi...business/membership card, diffent names on each?
I created a membership card using the page setup for a business card.
Is their a way to easily place a different name on each card. It is set up
for a sheet of 10. I would not mind typing each name in separatly.
Or is their a way to open the entire sheet of labels and type each name in
Compared to having publisher, just show the one card?
You could setup a data base or list and merge the names.
What version Publisher are you using? The above link is 2003 merge help. It is
about the same in 2007...how to copy or move controls between forms or from form to Tab con
I am trying to set up a more user friendly user interface for my database. I
have a main "switchboard" that opens on startup with buttons that open other
Sub "switchboards" based on subjects with more buttons to do stuff like open
reports, run queries Ect..
Ive ended up with a mess of these "switchboard" forms and all of this
me!close and Visible=false stuff to manage them and my users are rightfully
confused if menus just dissappear without the classic IE "Back" Button..
so i would like to migrate to a tabbed control on my main "s...Object variable or With block variable not set
I'm trying to put a command button on a form using the command button wizard
and I am getting this message "Object variable or With block variable not
set". I cannot figure out what's happening. I tried opening different
instances of Access and am getting the same problem with some but not all of
my .mdb files. Hope someone can help.
Its hard to think what it would be with no example...
did you edit the code generated by the wizard? or is it the wizard producing
Can you paste the code here?
"laura" <replyto@gr...Access Control variable values in one PropertyPg from another Pro
i am unable to access the property page control values from another property
// snippet of the code
CPropertySheet dlg(_T("Hellow"), this, 0);
one a; //First Property Page
two b; //second Property Page
three c; //third Property Page
if the first property page contains the ComboBox with some values i am
trying to acces the values in the second property page as
one* m_Main2 = (one *) GetParent();
fo...define range using col and row names; not cell name
How do you set a range using these four names? They define whole rows
and columns. The first column and row, along with the last column and
row, define a range
I can select columns with, as an example:
mySheet.Range("last_data_col")).EntireColumn.Hidden =3D False
I'm trying to do a sort, but I have to define the range to sort, as
in ws.Range("D7:L25"), but I don't have cell names, I have 4 whole
row and column names ( such as ...Recordset in excel with variables
I have successfully figured out how to retrieve data from a SQL server
from within an excel sheet. The thing I can figure out is how I can
use variables in that recordset from data in a particular cell.
Example : Select * from inventoryAudit
*that works currently in my sheet but I need to add a variable to the
Example : Select * from inventoryAudit Where transfer_dte Between
varStart And varEnd
* varStart & varEnd would be dates entered into 2 cells on the sheet,
than a button would be pushed that would run the query and return the
results into the sheet
This is what I have...Variable instances
I just want to check that i have the correct understanding of the following premise.
I have a Class , say Class A that i use as a base class for two other classes, say Class B and Class C.
I declare instance sof each class as follows.
ClassB p_BVar = new ClassB( );
ClassC p_CVar = new ClassC ( );
Each class inherits a member variable from the Base Class called bool bStatus;
Now if i change this variable using p_BVar->bStaus = .... this change should not be relected in p_CVar since p_BVar and p_CVar are two separate instances and do not point to the same address.
Is this a corr...how to convert a CString variable to unsigned short array one?
In my unicode VC6 app, how to convert a CString variable to unsigned short
unsigned short strOleChars;
strOleChars = strRst; //???
Is ConvertStringToBSTR() what you are looking for?
"David" <David_Wang_Xian@hotmail.com> wrote in message
> In my unicode VC6 app, how to convert a CString variable to unsigned short
> CString strRst;
> unsigned short strOleChars;
> strOleChars = strRst; //???
> Thank you.
...data validation not enforced with a named range source excel 2002 sp2
I have a cell with the following data validation settings
that still allows any cell value inspite of the
validation. The drop down list works, but is not enforced.
How can I enforce this validation?
Source="=Comment" (Comment is a named range)
Title and message entered.
Title and message entered.
Source should be
I don't know if that is what you have?
(No private emails please, for everyone'...word cannot save due to naming or permission error
Users trying to save office documents via AFP to a win2k3 server. I've read
some info on this from back around the first of the year but want to know if
the bug has been fixed.
Mac OSX hints says to do this:
$ cd /path/to/volume/or/sharepoint
$ sudo mkdir .TemporaryItems
$ chgrp staff .TemporaryItems
$ chmod 1770 .TemporaryItems
but the .TemporaryItems directory already exists on the server share.Is
there any other solution?Thanks,
On 2006-07-25 17:10:04 -0500, "rockymtn" <firstname.lastname@example.org> said:
> already exists on the server share.Is there any other...NDR Sender name
We have Exchange 2003. I have added my email address to receive a copy of
each NDR. It tells me who the intended recipient is but not who has sent the
message. It would be handy for important messages to contact the sender to
advise them that the address they used is not correct. I know they will get
a NDR themselves, but sometimes a direct contact works better.
Is this possible at all?
On Tue, 29 Aug 2006 11:57:27 +1000, "John"
>We have Exchange 2003. I have added my email address to receive a copy of
...Referencing Variable Name Worksheets
I'm updating a formatted worksheet every day. I have a macro that
processes, lets the user augment, and then saves that days data into a new
worksheet with that days date. I need to reference that worksheet the next
business day to error check. I cannot :
PREVIOUS DATE IS IN CELL A1
s = range("a1").value
Thank you for any help/suggestions
You might try
"camerons" <email@example.com> wrote in message
news:117nvk3b9e8mg06@c...Pop up for user name and password
This is message I keep getting I do have McAfee security and I have already
turned off email scanning what else can I do completely uninstall anti-virus?
Account: 'pop.hollandpaving.net', Server: 'pop.hollandpaving.net', Protocol:
POP3, Server Response: '-ERR Logon Failure', Port: 110, Secure(SSL): No,
Server Error: 0x800CCC90, Error Number: 0x800CCC92
did you ever get an answer to your question?
> This is message I keep getting I do have McAfee security and I have already
> turned off email scanning what else can I...Removing CEdit controls from CDialog!
I am creating texboxes at runtime and placing it on a
CDialog the CEdit objects are stored in a CObArray and
used in later point of reference. As I am creating
textboxes at runtime i want to remove the controls from
the CDialog at runtime. For e.g., When a button is clicked
10 textboxes are displayed and in another button click i
want the textboxes to be removed from the CDialog. Please
guide me how to acheive it.
Do you want to destroy the edit boxes or just hide them?
"Iyappan" <firstname.lastname@example.org> wrote in message
I just now noticed there is a big difference in coding
$i = [int] 9.99
[int] $i = 9.99
PS C:> $i = [int] 9.99
PS C:> $i
PS C:> $i = 9.99
PS C:> $i
PS C:> [int] $i = 9.99
PS C:> $i
PS C:> $i = 9.99
PS C:> $i
How would I take away the type binding from $i without deleting the variable
once I associate a type with it?
you can change the type
[double]$i = 9.99
Typing as an integer and then giving it a non-integer value could cause
issues with your logic