OK, lets see if I understand this. I can add a field in any place in list view and rename it. I can then go to form view in design and drag and drop the new field in where I want it and readjust the lay- out and then do the tab stop settings and that way it will show the information in the database in their right fields? Rocky On 30 Aug 2002 at 16:10, James LaBorde wrote: From: James LaBorde <jlaborde@xxxxxxxxx> To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx> Subject: [mso] Re: Access 2000 :VSMail MX1 Date sent: Fri, 30 Aug 2002 16:10:32 -0700 Send reply to: mso@xxxxxxxxxxxxx > > Rocky, > > If you open up the properties form there is a listing for tab stop > under the Other tab. It tells Access what field to go to next when > you hit tab in a field. It starts at 0 where the tab will be when you > open the form and then goes from there. You will need to check these > and reset them to keep the flow of your form going. > > James La Borde > South Western Federal Credit Union > > -----Original Message----- > From: Rocky Fithian [mailto:rockyfit@xxxxxxxxxxx] > Sent: Friday, August 30, 2002 4:04 PM > To: mso@xxxxxxxxxxxxx > Subject: [mso] Re: Access 2000 :VSMail MX1 > > > > OK, I'm sure I can find the field list to drag and drop the new field, > but I'm not sure I know or will find the tab stop stuff. How does > that work? Rocky > > On 30 Aug 2002 at 14:38, James LaBorde wrote: > > From: James LaBorde <jlaborde@xxxxxxxxx> > To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx> > Subject: [mso] Re: Access 2000 > Date sent: Fri, 30 Aug 2002 14:38:03 -0700 > Send reply to: mso@xxxxxxxxxxxxx > > > > > Rocky, > > > > There are a couple options for you. The first is simply open your > > form in design view and drag and drop your new field from the field > > list. If you want it in a particular position this will force you > > to place it where you want it and then adjust the tab stops so that > > they still run in order. There is another easy option, simply create > > a new form, using a wizard or autoform. Depending on the complexity > > of your form and if you have any code behind it, this may be your > > easiest option. The best way to go is definitely to add it manually > > and reposition everything, but as I said, if you have a basic form, > > recreating it may be your best option. > > > > James La Borde > > South Western Federal Credit Union > > > > -----Original Message----- > > From: Rocky Fithian [mailto:rockyfit@xxxxxxxxxxx] > > Sent: Friday, August 30, 2002 2:21 PM > > To: mso@xxxxxxxxxxxxx > > Subject: [mso] Access 2000 :VSMail MX1 > > > > > > > > I have a database setup in Access 2000 with 35 fields and I have a > > form setup for it. I know you can add a column in the middle of list > > for a new field, but how do you add a field in the middle of the > > form and have it pick up the right data for the right fields from > > there to the end? Rocky Fithian K2LN 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 K2LN > 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 K2LN 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 *************************************************************