 |
28-Jul-2006, 08:24 AM
|  | Guest | | | | | | | | | | RE: Adding a Field to a Form
Add a new textbox on your form and set his RecordSource to the employee ID
table field (Since you added Employee ID to your table, it should be listed
in the RecourdSource dropdown if your form is bound to your table.) If your Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
form is bound to a query, you have to add the Employee ID to your query to be
able to add it to your form.
Yanick
"ktie2332" wrote:
> I created a table, then a form. Then I added an employee ID field to my
> table, but now it isn't in my form. How do I update the form without
> recreating it with a wizard? I am using ACCESS 2003.
> --
> Katie |
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | RE: Adding a Field to a Form
1st you really look at creating a query from the table and then creating form
from the query. (It's not a good idea to work straight from the table and
with a query you can run many other functions that are not possible in a
table).
Either way open your form in design view and click the view menu. From the
dropdown list select View Fields". Drag the new field into the form.
Hope this helps
--
Wayne
Manchester, England.
"ktie2332" wrote:
> I created a table, then a form. Then I added an employee ID field to my
> table, but now it isn't in my form. How do I update the form without
> recreating it with a wizard? I am using ACCESS 2003.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
> --
> Katie |
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
Is the form based on the table, or on a query? If it's based on a query,
make sure that the query includes the new field.
Once the new field is included in the form's recordsource, simply add a new
textbox to your form, with the new field as its control source. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"ktie2332" wrote in message
news:ACF7DDB2-5834-4EE2-82AF-39F9F3A14752@microsoft.com...
> I created a table, then a form. Then I added an employee ID field to my
> table, but now it isn't in my form. How do I update the form without
> recreating it with a wizard? I am using ACCESS 2003.
> --
> Katie
|
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
Wayne,
Why do you say to create a query - that you shouldn't have the form based on
a table? Queries are accessible to users, who sometimes like to play with
things they shouldn't - even in an MDE. With a split app, the linked tables
can't be modified as to design,. but queries can be. Therefore, myself, if
I'm basing a form on a single table, I always use the table. And unless it's
a fairly complex query, I code that into the form, rather than create a
stored query. (I have a few "problem child" users who can't leave things
alone )
Not bustin' ya, just curious why you feel this way.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
SusanV
"Wayne-I-M" wrote in message
news:1462F13B-13B2-4E6D-9836-D58544786294@microsoft.com...
> 1st you really look at creating a query from the table and then creating
> form
> from the query. (It's not a good idea to work straight from the table and
> with a query you can run many other functions that are not possible in a
> table).
>
> Either way open your form in design view and click the view menu. From
> the
> dropdown list select View Fields". Drag the new field into the form.
>
> Hope this helps
>
> --
> Wayne
> Manchester, England.
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
>
> "ktie2332" wrote:
>
>> I created a table, then a form. Then I added an employee ID field to my
>> table, but now it isn't in my form. How do I update the form without
>> recreating it with a wizard? I am using ACCESS 2003.
>> --
>> Katie
 |
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
I always use queries so that I can control the order of the records on the
form, so that I can include calculated fields and so that I can pull in
information from other tables.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"SusanV" wrote in message
news:%23YaE9NTlGHA.3816@TK2MSFTNGP02.phx.gbl...
> Wayne,
>
> Why do you say to create a query - that you shouldn't have the form based
on
> a table? Queries are accessible to users, who sometimes like to play with
> things they shouldn't - even in an MDE. With a split app, the linked
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
tables
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
> can't be modified as to design,. but queries can be. Therefore, myself, if
> I'm basing a form on a single table, I always use the table. And unless
it's
> a fairly complex query, I code that into the form, rather than create a
> stored query. (I have a few "problem child" users who can't leave things
> alone )
>
> Not bustin' ya, just curious why you feel this way.
>
> SusanV
>
>
> "Wayne-I-M" wrote in message
> news:1462F13B-13B2-4E6D-9836-D58544786294@microsoft.com...
> > 1st you really look at creating a query from the table and then creating
> > form
> > from the query. (It's not a good idea to work straight from the table
and
> > with a query you can run many other functions that are not possible in a
> > table).
> >
> > Either way open your form in design view and click the view menu. From
> > the
> > dropdown list select View Fields". Drag the new field into the form.
> >
> > Hope this helps
> >
> > --
> > Wayne
> > Manchester, England.
> >
> >
> >
> > "ktie2332" wrote:
> >
> >> I created a table, then a form. Then I added an employee ID field to
my
> >> table, but now it isn't in my form. How do I update the form without
> >> recreating it with a wizard? I am using ACCESS 2003.
> >> --
> >> Katie
>
>
|
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
How do you keep using from futzing with them?
"Douglas J Steele" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
news:eZY8vSTlGHA.1344@TK2MSFTNGP03.phx.gbl...
>I always use queries so that I can control the order of the records on the
> form, so that I can include calculated fields and so that I can pull in
> information from other tables.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "SusanV" wrote in message
> news:%23YaE9NTlGHA.3816@TK2MSFTNGP02.phx.gbl...
>> Wayne,
>>
>> Why do you say to create a query - that you shouldn't have the form based
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
> on
>> a table? Queries are accessible to users, who sometimes like to play with
>> things they shouldn't - even in an MDE. With a split app, the linked
> tables
>> can't be modified as to design,. but queries can be. Therefore, myself,
>> if
>> I'm basing a form on a single table, I always use the table. And unless
> it's
>> a fairly complex query, I code that into the form, rather than create a
>> stored query. (I have a few "problem child" users who can't leave things
>> alone )
>>
>> Not bustin' ya, just curious why you feel this way.
>>
>> SusanV
>>
>>
>> "Wayne-I-M" wrote in message
>> news:1462F13B-13B2-4E6D-9836-D58544786294@microsoft.com...
>> > 1st you really look at creating a query from the table and then
>> > creating
>> > form
>> > from the query. (It's not a good idea to work straight from the table
> and
>> > with a query you can run many other functions that are not possible in
>> > a
>> > table).
>> >
>> > Either way open your form in design view and click the view menu. From
>> > the
>> > dropdown list select View Fields". Drag the new field into the form.
>> >
>> > Hope this helps
>> >
>> > --
>> > Wayne
>> > Manchester, England.
>> >
>> >
>> >
>> > "ktie2332" wrote:
>> >
>> >> I created a table, then a form. Then I added an employee ID field to
> my
>> >> table, but now it isn't in my form. How do I update the form without
>> >> recreating it with a wizard? I am using ACCESS 2003.
>> >> --
>> >> Katie
>>
>>
>
>
|
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
Keep *users* from...
Darn speel-chucker!
"SusanV" wrote in message
news:euavtZTlGHA.1208@TK2MSFTNGP02.phx.gbl...
> How do you keep using from futzing with them?
>
> "Douglas J Steele" wrote in message
> news:eZY8vSTlGHA.1344@TK2MSFTNGP03.phx.gbl...
>>I always use queries so that I can control the order of the records on the
>> form, so that I can include calculated fields and so that I can pull in
>> information from other tables.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "SusanV" wrote in message
>> news:%23YaE9NTlGHA.3816@TK2MSFTNGP02.phx.gbl...
>>> Wayne,
>>>
>>> Why do you say to create a query - that you shouldn't have the form
>>> based
>> on
>>> a table? Queries are accessible to users, who sometimes like to play
>>> with
>>> things they shouldn't - even in an MDE. With a split app, the linked
>> tables
>>> can't be modified as to design,. but queries can be. Therefore, myself,
>>> if
>>> I'm basing a form on a single table, I always use the table. And unless
>> it's
>>> a fairly complex query, I code that into the form, rather than create a
>>> stored query. (I have a few "problem child" users who can't leave things
>>> alone )
>>>
>>> Not bustin' ya, just curious why you feel this way.
>>>
>>> SusanV
>>>
>>>
>>> "Wayne-I-M" wrote in message
>>> news:1462F13B-13B2-4E6D-9836-D58544786294@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
>>> > 1st you really look at creating a query from the table and then
>>> > creating
>>> > form
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
>>> > from the query. (It's not a good idea to work straight from the table
>> and
>>> > with a query you can run many other functions that are not possible in
>>> > a
>>> > table).
>>> >
>>> > Either way open your form in design view and click the view menu.
>>> > From
>>> > the
>>> > dropdown list select View Fields". Drag the new field into the form.
>>> >
>>> > Hope this helps
>>> >
>>> > --
>>> > Wayne
>>> > Manchester, England.
>>> >
>>> >
>>> >
>>> > "ktie2332" wrote:
>>> >
>>> >> I created a table, then a form. Then I added an employee ID field to
>> my
>>> >> table, but now it isn't in my form. How do I update the form without
>>> >> recreating it with a wizard? I am using ACCESS 2003.
>>> >> --
>>> >> Katie
>>>
>>>
>>
>>
>
>
|
28-Jul-2006, 08:24 AM
| | Guest | | | | | | | | | | Re: Adding a Field to a Form
Hi Susan
In my opinion only (I may be wrong – like I was with England and Sweden last
night) but I was always told that tables are for storing data, queries are Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
use to combine and manipulate stored data and forms are used to view, correct
and function.
Using a form based on a query – taking that most queries are based on more
than 1 table will (sort of) ensure that the query will take care of any
Referential integrity problems that inexperienced users may come across if
working directly with a form based on multiple tables
One of the d bases I work with takes over 38,000 inputs per month (payments
and receipting) the use of too many functions on a form (which could be
better done in a base query) will slow the form down and with such a large
number of inputs per day the speed could be too slow to actually function.
As I said I may be wrong (I am about most things) but there are many reason
NOT to base a form on a table and hardy any TO.
The need to “see” the results of functions and “work” with them is what the
vast majority of d bases are used for
How many apples have I left on the shelf?
Who is working in the office next Wednesday?
Ect
These are all functions which are best undertaken in a query if possible
(sometimes it’s not) and then either display on screen, e mailed, printed. Of
course virtually any of these “could” be done on the form but that is not the
reason for using a form.
Don’t worry I fully expect many people to tell me I’m wrong. If I am, Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11828
please tell me as really do appreciate any help and advice.
--
Wayne
Manchester, England.
"SusanV" wrote:
> Wayne,
>
> Why do you say to create a query - that you shouldn't have the form based on
> a table? Queries are accessible to users, who sometimes like to play with
> things they shouldn't - even in an MDE. With a split app, the linked tables
> can't be modified as to design,. but queries can be. Therefore, myself, if
> I'm basing a form on a single table, I always use the table. And unless it's
> a fairly complex query, I code that into the form, rather than create a
> stored query. (I have a few "problem child" users who can't leave things
> alone )
>
> Not bustin' ya, just curious why you feel this way.
>
> SusanV
>
>
> "Wayne-I-M" wrote in message
> news:1462F13B-13B2-4E6D-9836-D58544786294@microsoft.com...
> > 1st you really look at creating a query from the table and then creating
> > form
> > from the query. (It's not a good idea to work straight from the table and
> > with a query you can run many other functions that are not possible in a
> > table).
> >
> > Either way open your form in design view and click the view menu. From
> > the
> > dropdown list select View Fields". Drag the new field into the form.
> >
> > Hope this helps
> >
> > --
> > Wayne
> > Manchester, England.
> >
> >
> >
> > "ktie2332" wrote:
> >
> >> I created a table, then a form. Then I added an employee ID field to my
> >> table, but now it isn't in my form. How do I update the form without
> >> recreating it with a wizard? I am using ACCESS 2003.
> >> --
> >> Katie
>
>
> | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | Amrit Yesterday 23:38 PM 4 Replies, 345 Views | | | | | | | | | | | | » Books You Should Read... | | | |
