[mso] Re: Access Q - auto fill a field?
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 8 Nov 2003 19:45:10 -0600
No...I guess you ARE right and I just wasn't thinking about it correctly!
True...the DEFAULT would say text, unless...of course (which I didn't think
about before)...I overwrote the field with the properly requested type.
Duh!<g>
Thanks!
For some reason my brain was telling me that wasn't right cos' I would
overwrite what some had in there already. But that wouldn't be the case. I
was getting the update query and the default mixed up in my mind.
Dian D. Chapman
Technical Consultant,
Microsoft MVP & Instructor
Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Ray Blake
Sent: Saturday, November 08, 2003 4:39 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Q - auto fill a field?
Dian,
Maybe I'm misunderstanding, but it strikes me that a default value in the
table definition for that field of "Text" would do exactly what you want. In
one of my systems, for instance, I write new records to such a table with 6
fields, but sometimes only fill in two of them programmatically. The other 4
all auto-fill form the set default values in the table definition.
If I have misunderstood, please put me right.
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business Process
Solutions. It is confidential and intended for the addressee only. The
contents are private and may be legally privileged. If you receive this
email in error we would be grateful if you would advise the sender and
delete the email from your system.
For more information on the services that we offer please visit us at our
website: - www.grbps.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian Chapman
Sent: 08 November 2003 22:32
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Q - auto fill a field?
Thanks...but yeah, that I know about. It's not QUITE what I need.
See...most of the DB fillins I do is via VBS through an ASP page. So when
say, a su*scri*er (just remembered I can't use that keyword in here or it'll
bounced<g>) su*scri*es to TechTrax, I do enter Now() to obtain the date/time
and that goes into the DB field.
But users also get the opportunity to select Text, Doc or HTML format.
If
users su*scri*e without using the page, just by using the email
address...which is out there in many locations, they get the default Text.
The confirmation email explains this fact and how they can change that if
they now want. No problem. But if they don't change it...they default to
Text. But I would NEVER know who wants what or have any way to set in that
info just from a blank email.
So each month, before I run the query to get the names of each su*scri*er to
send out their notices, I have to sort and find all blank TYPE fields and
enter TEXT into that field so they come up with the default value for their
notice. There's really no way for me to do this automatically...cos' I'd
have to write script that goes through all emails and passes a value or
something to my DB an it's just not something I care to mess with for the
few that end up that way.
However, if I could write a simple...if any TYPE fields are blank, enter
TEXT...script...that would save me maybe 20 mins a month. Every little bit
counts! ;-)
But like I said...this one isn't a bit issue...so back to the contest code
cos' I know Linda is just WAITING to get her name in there!<lol>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
