The date format mmddyyyy is common but I realize it's not a standard
format in Access.  There must be a simple way to provide this format
to Access so it treats it as a date?  In past, I play with it and do a
(Left MM, Mid, and Right Function) and add "/" so it's recognized.

I have a form to add new employees to tblEmployee with the following
fields:
Department (text - linked to tblDept - 3 values in a single field)
Shift (numeric - linked to tblShift - 3 values in a single field)

I tried to seperate my query update im order to define what is the
limitation for the field
becaouse i know that it is limiting for 1024 characters but i see that
can update more characters(for now checked 2000 and it works too)

Hi, could anybody help me with this please
I want to add a date stamp in a table, it should automaticlly updated when
another field in the same table is selected as "Yes".  I am not very good at
VB code, so please if at all that can be avoided otherwise please be a bit

I have a form where on current, it evaluates some fields to determine
which page on a tab control should be displayed and which should be
hidden.  If I cycle through the records using the navigation buttons,
the focus will remain on the "ID" field if the tab control remains on

Using AccessXP front-end on PC linked to AccessXP database on server.
System works well for about 25 concurrent users.   Have been forced to
upgrade back-end to SQL Server.   Have linked tables to SQL Server - similar
process as Access.   With minor front-end changes, application ...

I would love to check out Stephen Leban's ReportToPDF database, but
only have Access 97.  Is there a way to get a 97 version?
Thanks,
Jana

Is is possible to track or stop someone from importing your tables
from a unprotected db?
Is it possible to track of stop someone from linking to your tables in
a unprotected db?

On a form listbox Access version 2003 has a limited number or
characters that can be stored in a listbox when the Row source Type is
set to "Value List".
Is there anybody that knows the limitation and is it possible to

"lyle" <lyle.fairfield@gmail.com> wrote in message
news:48c3dde7-07bd-48b8-91c3-e157b703f92b@f3g2000hsg.googlegroups.com...

How do I get a Calender Control popup to appear near the button which
activated it, rather than on the other side of the screen?
(MS Access 2000)

I'm new to Access. I am a programmer, but my only database experience
was when I made a medium sized FoxBase application for a small
business years ago.
The project I've started working on is way to simple to justify

Anyone use the AHRESIZE utility to resize a form dynamically who is also
using background images?
I have an app that creates electronic versions of manual forms.  I
digitize the manual form and load it (at run time) as the form

Is this guy for real?
I cam on this forum expecting to find database related topics.....What has
this guys' rants got to do with Microsoft Access? Or have I missed
something?

I need to audit the freight bills charged by freight company which has
over 20,000 consignment per week. The basic charge is base on distance
and weight, something like this:
SYD-MEL <1kg $6