[mso] Re: Access 2000
- From: "Robin Smith" <bird@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 16 Aug 2002 08:34:38 -0400
You can delete fields from your table. However, if any queries, forms, or
reports used those fields then you will have problems. You will have to
redesign each query, form, or report that contained a deleted field.
Robin
----- Original Message -----
From: "Rocky Fithian " <rockyfit@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Thursday, August 15, 2002 4:08 PM
Subject: [mso] Access 2000
>
> I'm the treasurer and computer dude (note I didn't say guru) for the
> Conway Hospital Auxiliary. I have built a database for the auxiliary
> to list each volunteer and their information. We have approx. 220
> volunteers. In the database I have approx. 36 fields. We have
> determined that we don't need about 10 or more of them. I think I
> can just delete the column for the field in the list setup, but I'm not
> sure how to handle the form that I have for the database. Some
> fields in the form are single word or number entry and some are
> setup to handle a sentence length of information.
> I have many queries and reports set up, but don't see that these
> changes would effect them at all because they use the field name
> to search on. This was built in Access 97 and converted to 2000 a
> while back. And yes it is backed up on the hospital's server if I
> screw it up, but would like to start in the right direction the first
time.
> This can be handled on or off list if need be. And TIA for any help
> you can give me.
> Rocky Fithian
> If God doesn't seem near, who moved?
> To check my sites click the link below.
> http://web.sccoast.net/users/rockyfit/WebPageLinks.htm
>
> *************************************************************
> 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?Subject=unsubscribe
>
> 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?Subject=unsubscribe
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:
