I have in one unbound form some fields that gather data that I use to create
an sql statement that I want to open another form with.  I'm trying to call
the form with the sql statement as the openargs value.  On the load event of
the form I'm opening I'm assigning openargs to ...

I am working on designing a form .I want  to be able to have a text box field
called “total”  calculate the weight times qty.   One field  remains static
and this has the weight of product in it “wt”. Another is the “Qty” field and
that changes.   I created another field”Total” ...

The below code works, so why am I here???  Well, the Select Case
cboFieldName cause a repainting which I would prefer to avoid.  I would like
it sort by whichever field you choose without the repaint, if that is at all
possible.

I have a situation where I am giving the user the option of using a List Box
or a Command Button.  The list box is one choice, and the Command Button is
All.  If the user first selects the list box, then the choice remains in
black.  However, if the user then chooses the Command ...

I'm using the following code to deselect a selection in a single select
listbox.  It works but it always leaves a small line.  Any to get rid of
that line?
Thanks

I have an unbound form that is used as a type of worksheet for our users.  
They will click on various buttons to enable certain controls to enter
values.  Here is a scenario:   There are 6 text boxes that enable with one
button.  I want to set the focus to the first text box that ...

I have a function apiGetUserName that uses - Lib "advapi32.dll"
to get me the username.
But this gets me the windows username with which I am logged on to the
computer.

Hi y'all
Newbie question!!
How do I check for design mode in code in an Access form?
I need to do some cleaning up on the Close event of a form and avoid firing

Is it possible to use a form to select what information is shown in a
querie?
For instance, one of the sections of the database I am developing is
collating issues and concerns addressed by people under certain topics.

I'm working on a form that will open in Read Only mode by default.
A user can change it to Edit mode by clicking a button.
On Close, I want the user to be prompted to save their changes, but only if
it was open in Edit mode.

I created and Incoice form and a print command that prints the invoice to a
report.  Is there anyway I can hit the print button once but print 3 copies?
Please Help Thanks

I have a custom "previous" and "next" buttons.
How can I disable them when I reach the first or last record?
The form does now allow for additions.
Thank you!

Doug,
Your suggestion to use the sql
select user, ...
to get the sql login name doesn't work in Access, please look at the

How do I get form results in private folder inside frontpage 2003

I have a continuous form in which I would like to conditionally set the
properties on a row by row basis.  For example, if the status of the record
is "closed", I would like to disable all controls for the record, some of
which are combo boxes. Is there a way to do this when the ...