I have four unbounded textboxes on my form.Value of textbox1 validate with
table 'Master'.If found then the relevant fields of the table'Master' fill
the textbox2, textbox3and textbox4. after that user enter the values in
bounded textboxes (bounded with 'trans' table).at last the ...

I have a main Form which contains two subforms and I want to total the
amounts entered in text boxes in these two forms on the main form.
So in order to achieve the reqd. result I put a text box on my Main form and
added the two, Text49 and CA_2007 by using the following ...

This might seem like an obvious question, but I am approaching Access forms
from the view of a VB programmer.
So let me explain the issue I have, here goes.
Option Compare Database

I am trying to search my data table based on two or more search criteria that
will open a seperate form with a command button.  I have already created a
unbound form and added a command button that will allow me to search based on
a single field and have viewed the code in vba ...

I have a listbox that I'd like to sort alphabetically.  Is there a built-in
routine that will do this for me?  I wrote some code myself that works
(well, if I do say so myself!), but I wonder if something built-in would be
more efficient.

I need to populate the subject line of my email with the TrackingNo which
is the autonum on my form.  When I click the submit button, it should send
an email to the person along with the trackingno in the subject line.
Everything is working EXCEPT the subject line.  Here's my code:

Which Event is best suited for checking for blank fields on my form?

I had a table having field 'Date' with 'Medium date' property.I don'
know how user entered something that now some records show date a
'12-dec-1899' but in table when i click the field the text converte
to '00:00:09' and when leave the field it again show '12-dec-1899'

I want for time saving that when a value of a field is entered and then so
for next fileds... When press Enter for next record then this value of a
particular field displayed for new record. and user just enter at this
field rather than typing the same stuff.waitibg for a quick ...

If I make a table of inventory, and then create a form as a packing slip, how
do I design it properly so that the amount on the packing slip automatically
reduces the quantity of what is being shipped from what is in the table?

I have a nested form in Access 97 with a cancel delete option.
The problem I have is the records scroll up with the delete. If the delete
is cancelled then the records are not displayed and the user thinks the
record has been cancelled. I have tried moving the focus to the first ...

I am trying to execute a shell command with the Shell() function. Problem
is, execution continues before the command is complete.
I am trying to grab the output of the command by executing it and
redirecting to a file c:\temp.txt. I then open the file and look for the

I'm trying to identify which records are selected in a subform (datasheet
view).  I've got my code working fine, but I can't find which even to put it
behind that it will work 100% of the time.
Some examples of what I've found:

OK, I started searching this board with many questions, and I was able to
find the answers to all but one.
I wanted to made a hidden field visible based on the selection of a option
field. Shifthours visibility is set to No. Here is the code I used: