I have a form witha  text box that is not to be connected to a database
field.  Instead, it is activated by the click of a command button.  In my
code, I have the statement..
Form_form1.text0.text = MyStringValue

Hi everybody, i am having this problem:
There was a programmer that made an access aplication with VB Modules,
forms, an so on (With Spanish Office 2000), and now the organization change
all the aplications to English versions (including Office 2K).

I am trying to write the code in the Command Button that opens a new
formcalled form2, and has the say the Customer information already filled in
from form1.
Any insight would be helpful.

Is there a way to change the size of a subform that is displaying as a
datasheet?
I'm trying to get all the fields(columns) to show without scrolling left or
right.  I thought if I could change the size from say 12 pitch to 10 pitch I

Does anyone know of a way to determine which users are currently using a
database?

I am trying to enable users to find information that has already been input
into the form.  If there is a better way to do this, please let me know.  The
code will work if I use it for numbers, but it will not work for text.  I
will be looking up last names.  What I am using ...

In my app., the user can use a form to insert a record into a table.
The table holds line data for quotations.
i.e.
QuoteNo, SubQuoteNo, LineNo, etc., etc., etc.

I have a textbox with 2 events: Before Update and Keydown.  This textbox is
in a subform and once the user hits "Tab" or "Enter" the focus should be set
to a textbox outside of this subform.  However, in my Before Update event I
have a Cancel = True if a certain condition isn't ...

I'm checking a variable in the form open property of FormOne
and
opening FormTwo
and using me.visible = false

Back in April you helped me out with locking controls on forms and I'm
finally getting around to completing this database and inserted the code
(added an .Enabled = True, I needed that) and it works like a dream!  Just
what I needed!

Hi there! Using A02 on XP. Have a form that displays one contract record and
various info on that contract. There are 2 date fields [PYEBeg] and [PYEEnd].
I have a subform linked Child/Master on mainform field [PlanNum] and subform
field [GPNum]. It shows ALL records for that ...

On my form is a text box (size 60) called Organization. Rather than use the
record selector to find the appropriate record, I decided to change this
field to a combo box to allow the user to select from the drop down or to
enter a letter & it jump there. It seems to work, but I ...

Just a point about these discussion groups. It would be so much easier to
find individual messages if they were given IDs to search against. Any chance
of sorting this out?
Cheers

I want to be able to block a customer from having details altered once the
customer reaches a certain status.
I have a Combo box called Status and I want to block a record once it
reaches a status of "HO".

I have added an additional field to a table at a late stage, and this works
fine for putting a text box in a form to insert data, but if I put in a VBA
instruction Me.Newfield="Y", it does not does not recognise Newfield and
gives an error. Any suggestions?