A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

from table to form



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2005, 02:06 AM
alex1
external usenet poster
 
Posts: n/a
Default from table to form

I'm adding rows in my form: just adding up different characteristics for
listing them up in the merge report. But when i rearrange the rows in my
table it's not reflected in the form: it's still the same old table
arrangement. The form doesn't see my new table. What can be done? I'd
appreciate some help.
  #2  
Old August 19th, 2005, 08:57 AM
tina
external usenet poster
 
Posts: n/a
Default

if you're talking about *sorting* records, don't do it at the table level.
sort the records directly in the form, or sort them in a query and bind the
query to the form.

hth


"alex1" wrote in message
...
I'm adding rows in my form: just adding up different characteristics for
listing them up in the merge report. But when i rearrange the rows in my
table it's not reflected in the form: it's still the same old table
arrangement. The form doesn't see my new table. What can be done? I'd
appreciate some help.



  #3  
Old August 19th, 2005, 11:07 AM
alex1
external usenet poster
 
Posts: n/a
Default

Thnks, Tina. I can't sort records anywhere except in the table. In the form
window I can highlight rows whatever is appropriate for each client and then
press 'add' button (that's how I'm adding them up for each client). In the
form, under the window, there are names of clients. I press on the client i'm
interested in, then highlight some rows in the window, then on 'add' button,
then i see all highlighted information appear in the field corresponding to
this client under the window. As i said before my new table arrangement is
not seen in the form.

"tina" wrote:

if you're talking about *sorting* records, don't do it at the table level.
sort the records directly in the form, or sort them in a query and bind the
query to the form.

hth


"alex1" wrote in message
...
I'm adding rows in my form: just adding up different characteristics for
listing them up in the merge report. But when i rearrange the rows in my
table it's not reflected in the form: it's still the same old table
arrangement. The form doesn't see my new table. What can be done? I'd
appreciate some help.




  #4  
Old August 19th, 2005, 11:35 AM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

alex1 wrote:
Thnks, Tina. I can't sort records anywhere except in the table. In
the form window I can highlight rows whatever is appropriate for each
client and then press 'add' button (that's how I'm adding them up for
each client). In the form, under the window, there are names of
clients. I press on the client i'm interested in, then highlight some
rows in the window, then on 'add' button, then i see all highlighted
information appear in the field corresponding to this client under
the window. As i said before my new table arrangement is not seen in
the form.


Sorry, but none of that makes any sense to me at all. What is "under the
window"? What do you mean "I press on the client I'm interested it"? What is
this "add button"? What do you mean by "table arrangement"?

If by "table arrangement" you mean that you have altered the design by adding
new fields then those new fields "might" automatically show up in your form's
list of available fields. If the form is bound to a query that explicitly picks
certain fields from the table though (typical if built with the wizard) then you
will need to modify that query to add the new fields to it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Options Group Patty Stoddard Using Forms 19 August 4th, 2005 02:30 PM
Combo Box NotInList - How To Add Data To Underlying Table 10SNUT Using Forms 19 July 8th, 2005 09:12 PM
Access combo box-show name, not ID, in table? write on New Users 30 April 30th, 2005 09:11 PM
Get data from combo box to popluate the next box Lin Light Using Forms 4 December 30th, 2004 05:01 PM
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM


All times are GMT +1. The time now is 10:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.