I can't seem to get the right controls to do the following;  keying in data
one character "X" or Blank to auto advance to next
element.  The value of the "X" is 1 (One).   The value of Blank being "0'
(zero).  There will be a lot of these one character fields.

Hello There, I got this code off of some website many moons ago and have used
it dozens of times in building Search Forms.  For some reason, this time I
can't seem to get it to return any results.  At one point I did have trouble
before with the SQL statement but have gone ...

I have an entry form - I would like to be able to put in the ID and
Date and have the form showing the data for that.
Currently it's on open to Edit form - and shows the first record -
I would like to be able to type in the IDNO in the IDNo Text Box and

We have a web page on an intranet site that links to an Access MDE
(XP) file.  The database is on a local file sever and cannot be placed
elsewhere.  Most users have both Access 97 and XP.
A test case of two users:  Both have their Windows file types

I am trying to send out notices of past due items.
my table holds duedates such as 12/4/2007 10:59:30 AM
when I run a query where currdate which is a date & " " time
is less than duedate, but my query comes back blank?

I have a table like this:
Client           ContactName            Email
ABC             ABC Name               ABC@yahoo.com
CDC             CDC Name               CDC@yahoo.com

I have a Table called ServiceTypes. Based on a User's input on a
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
For instance, I have a Check Box on the ProposalForm. When a Check Box is
clicked Yes, Access must search the ServiceTypes Table, select a ...

Using Office 2003 and Windows XP;
There is a built-in vertical line running down the left side of my bound
forms with a right pointing triangle at the top. I want record selection and
scrolling, but I don't want this line to show, how can I get rid of it?

I populate a combox1.rowsource = value1.  How do I display value1 in the
combo box?  I can see it in the dropdown, but how do I display it?  Thanks.
Kou

is there a way to change a msgbox so that depending in a value it has 2 or 3
or 4 lines?
change this:
MsgBox("Remisiones:" & vbNewLine _

I have a table of 14 colums, first 2 are text and the last 12 are numeric
with the field name eg. Jan-08, Feb-08, etc
I need to take this data month by month and append it to a table of 4 colums
with the first 2 colums as text then a date field and then a value field.

In Finnish bankig system is used a reference number that can be min. 4 and
max. 20 digits. It have to be displayed and printed by 5 digit groups  (#####
##### ##### #####) How can I do that? In the Property window it is not
possible.

I have this code on a form:
DoCmd.OpenForm "frm_chooser"
   Forms!frm_chooser.Caption = "Add or Edit Training"
   Forms!frm_chooser!lbl_add.Caption = "Add Training"

Hi
i am a table Mytable like this:
field1  field2  field3 .........fieldn
A         B         C              N

Hey all...
First off, thanx for the help that you all tend to give from this
forum. I have captured a lot of good stuff, and for the 1st time, am
posting asking myself for your help... Here's what I have going on...