[AccessD] 2 quick questions

Asger Blond ab-mi at post3.tele.dk
Thu May 26 18:30:13 CDT 2011


John,
For once a question, I'm fit to answer - the dumb one ;-)
Office Button -> Access Options -> Current Database -> Select "Overlapping Windows" instead of "Tabbed Documents"
Asger


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af John Clark
Sendt: 26. maj 2011 20:26
Til: Access Developers discussion and problem solving
Emne: [AccessD] 2 quick questions

1) 
The data for the program I am working on, comes w/no real good unique identifier, so I'm trying to create my own.  The only personal data I am getting is name (last, first, MI) and DoB. The rest is survey data. This is a dental survey form, and they want to track clients if/as they go from infant to adult, so I told them we need some sort of identifier. 
 
The method I've come up with, to create an identifier is using the 1st 3 letters of the last name, the 1st 2 of the first name, the middle initial...if there isn't one, I place an "X" into the ID...then 6 digits of DoB.
 
For example: a client named Joe T Murphy, born on Dec 7th, 1994 would be assigned an ID of MURJOT120794
 
It is not air-tight, so to speak, but I don't see another way...I'm just looking for opinions on this...
 
2)
This one is a dumb one...
 
I don't like whole screen forms, if they're not needed. In all the earlier versions of access, if you didn't have your form maximized in design view, it would default to run in a smaller window. But, w/A07 it doesn't seem to work this way. My form keeps running full screen and I don't want that...how do I do this?
 
Thanks...J Clark
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list