Hi I have added a field called txtInFoPlus which if there is no data the
field is not visible but the fields remain visible.
The following code worked with only the txtInFo field
Private Sub Form_Current()

Hi;
I want to get the nearest greater number from a fractional number.For
example,getting 4 from 3.2
It is to find the pages number of a report while its not open,based on the

How do I apply a value list to a combo box in a Data Access Page, I'm not
looking up data, I just want to pick from the list.
John

I have a combo box called "cboPromoStartDate" with a calendar control that
displays a pop-up calendar.  When the entry person clicks their date
(7/14/2005), that date format of numbers and slashes displays in the combox
box and is stored in the underlying table.  

I have a master form and two subforms linked by a related field. I have a
command button which when pressed invokes a report wherein I filter for the
record being shown on the screen currently. Now I want to specify that I want
to print only those records from the subform where ...

I'm using a .adp front-end and SQL 2000 server database. I have a form based
on table Companies and its subform based on contacts. I need to keep track
who is the Main contact for the Company. What I've been trying to do is to
update a view based on the two tables and to copy ...

how to calculate the total in subform in msccess ?

I have frmMain and 2 subfoms (control names on frmMain - frmTransSub and
frmLOBSub).  Both subs are linked to frmMain.  I am having problem going to a
new record on the frmLOBSub FROM frmTransSub.
On the frmTransSub_AfterUpdate I have:

How do I go about changing the value of a field on a form based on a
selection in a combo box and some sql stuff.  
The following query will produce the correct value, I did that as a stand
alone query, but I don't know how to make the text box that value.  The

I have some code that loops through a ListBox named "lstAdmin" to find all
selected items. What I want to do is de-select each selected item in the
ListBox after it's no longer needed.
I have used a Control reference "ctl" for de-selecting the selected items,

MS Access 2K, Windows XP
====================
Hi,
I've been trying to get the file create date stamp using code on a form.

I have a form with a tab sheet on it, when the user opens the form, I need
the form to go to the second tab (page), how can I do this?
Thanks
Kevin

I have reservation program (built with MSAccess 2003).  I would like to
process customer credit card while taking reservation over the phone and
store the "authorization code" that it receives back from Authorize.net
I can't figure out how to send the customer CC info to the ...

I wish to compare two tables and based on the existance of data I want to
insert data into table 2.. I am using the following code for this. but It
says type mismatch near set rs1 = "select ..."
Pls help

I have three fields that make up a primary key in most of my tables.  The
data is entered in a text box.   I want to display in a label at the top of a
form which shows all three text boxes.  For example:
Data 1   textbox1