Rocky, All you'll need to do is open the form in design view, delete the control that corresponds to the field you've deleted and then save it again. Otherwise the form will display "#Name?" in the control cuz it can't find the field" Peter Young ----------- Computer, Web, Database & Network Design, Implementation & Support -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Rocky Fithian Sent: Friday, 16 August 2002 10:57 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Access 2000 My queries and reports don't use anything I'm going to delete. What your saying is there is no way to save the form without redesigning the whole form? Rocky On 16 Aug 2002 at 8:34, Robin Smith wrote: From: "Robin Smith" <bird@xxxxxxxxx> To: <mso@xxxxxxxxxxxxx> Subject: [mso] Re: Access 2000 Date sent: Fri, 16 Aug 2002 08:34:38 -0400 Send reply to: mso@xxxxxxxxxxxxx > > 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 > ************************************************************* > 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 *************************************************************