I've taken a user input on a form, and assigned it to a variable in the
code, say MyVar.   Its a string.  I want to redefine, pass to, somehow make
it an array, so I can parse characters out of it when I make the name of the
text file I'm ecentually exporting to.  

I have the following program for a Find Command Button:
Private Sub CmdFind_Click()
On Error GoTo errhandler:
   Comments.SetFocus

Just wanted to know if somebody created user defined grid control
(Like MSFlexGrid) in vb6.  I require help if anyone provide the code
or path to download the file.
Thanks in advance,

I have two fields in a subform one called "Category" and the other called
"HrCost".
I need the "HrCost" field to turn yellow if the "Category"  field has
anything starting with either a P. or SP.

I am trying to use the code from this link:
http://www.mvps.org/access/forms/frm0007.htm
I am trying to have a query run off a multi-select list box...
here is the code I am using:

I've a backend database file in A2000 format and a corresponding frontend
application developed in A2000. They are now running in Office XP environment
and it runs fine when they are both in MDB format. When I tried to compile
the application to MDE format, it failed. The system ...

I have two fields in a subform, "User" and "IT Announcement"
I would like to do conditional formatting to this effect:
On ther "User" field:
If "IT Announcement" = Yes then make the "User" field turn blue (I would

previously, I was able to do this by having seperate field names; for example:
stAppName = "C:\Program Files\Internet Explorer\iexplore.exe
http://maps.google.co.uk/maps?f=q&hl=en&q= " & "from: " & Link_Waypoint_1 +
", London" & (" to: " + Link_Waypoint_2 + ", London") & (" to: " ...

with the following code i am trying to uncheck a box on my continous form as
it's closing and this does not work. my recordsource is ProdHistory and in
that table the record that i need to disselect everytime the form closes is
Select. can anyone help?

Thank you Thank you Thank you for your help...
Concept:  I have a report and underlying query object.  I would like to be
able to click a button on a form that would set the criteria for a field in
the query and then run the report.  Of course several buttons to set

I have a sub form (subfrmOrderStatus) that has a data source of a query
(qryOrderStatus) that shows all a list of all open orders.  I want to be
able to double click on any row in this dataview and have the Order
Form(frmOrders) open up to show the specific order number that I just

I have a combobox [me.cmbx_example] who's recordsource is a valid sql
statement which returns a list of usernames on form open.
I have an additional field [me.curr_user] that holds the current
network user name on form open.

I need my new records, once entered, to slot into their alphabetical
position in the form, not at the END of the form/table. If I enter a record
and then "Me.Requery", the record pointer goes to the first record, not the
record I just entered. I've been struggling with me ...

I'm envisioning an application with 2 forms filling up the screen, one
on top of the other. The user could drag in the middle to resize both
simultaneously just as you would a website with 2 frames. How can I do
this?

This code behind a command button should check to see if a record exists and
open a form with that data if it does. If record does not exist it will open
the form in data entry mode.
I don't understand this error???