By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,519 Members | 2,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,519 IT Pros & Developers. It's quick & easy.

Subform mods not saving

P: n/a
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except
I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back to
the old way. Yes, I do Save - and Save... I've looked at it from several
angles and can't see what I'm doing wrong. I'm using Access 2000 and these
are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open it
in design view. Make a change, and save. Close and reopen. Did the design
changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back to the old way. Yes, I do Save - and Save... I've looked at it from several
angles and can't see what I'm doing wrong. I'm using Access 2000 and these are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

Nov 12 '05 #2

P: n/a
Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but
then I tried a few changes and they still do not stick. I've developed in
about everything except Access so I'm new to it. Here are some screen shots
to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design
view; decimals are automatic on the last column, different headings, widths,
etc.. It looks like a plain old grid, as if the form is approximating the
design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have
used (and am used to) in, say, VFP. For this Access project, I definitely
selected 'subform' from the tools menu and dropped it on the form. But I
seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open it in design view. Make a change, and save. Close and reopen. Did the design
changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a

subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully,

except
I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back

to
the old way. Yes, I do Save - and Save... I've looked at it from several angles and can't see what I'm doing wrong. I'm using Access 2000 and

these
are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne


Nov 12 '05 #3

P: n/a
access2.jpg indicates the subform is in Datasheet view.

1. Open the subform in design view.
2. Open the Properties box (View menu).
3. Set the Default View property (Format tab of Properties box) to
Continuous Form.
4. Click the SubsAmt textbox.
5. Set its Format property to Fixed Number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:_HCIb.705253$Tr4.1775366@attbi_s03...
Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but then I tried a few changes and they still do not stick. I've developed in
about everything except Access so I'm new to it. Here are some screen shots to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design
view; decimals are automatic on the last column, different headings, widths, etc.. It looks like a plain old grid, as if the form is approximating the
design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have
used (and am used to) in, say, VFP. For this Access project, I definitely selected 'subform' from the tools menu and dropped it on the form. But I
seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open

it
in design view. Make a change, and save. Close and reopen. Did the design
changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?
"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to many relationship. I created a form to show fields from CUST and a

subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data source for each is the table (not a query). It behaves wonderfully,

except
I can't seem to change the layout of the subform in design view. I make changes and can see them in design view but in form view it reverts
back to
the old way. Yes, I do Save - and Save... I've looked at it from

several angles and can't see what I'm doing wrong. I'm using Access 2000 and

these
are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

Nov 12 '05 #4

P: n/a
Allen, that worked beautifully - thank you
wayne

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
access2.jpg indicates the subform is in Datasheet view.

1. Open the subform in design view.
2. Open the Properties box (View menu).
3. Set the Default View property (Format tab of Properties box) to
Continuous Form.
4. Click the SubsAmt textbox.
5. Set its Format property to Fixed Number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:_HCIb.705253$Tr4.1775366@attbi_s03...
Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but
then I tried a few changes and they still do not stick. I've developed in
about everything except Access so I'm new to it. Here are some screen

shots
to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design view; decimals are automatic on the last column, different headings,

widths,
etc.. It looks like a plain old grid, as if the form is approximating the design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have used (and am used to) in, say, VFP. For this Access project, I

definitely
selected 'subform' from the tools menu and dropped it on the form. But I seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open
it
in design view. Make a change, and save. Close and reopen. Did the

design changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?
"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...
> This should be easy. I have 2 tables - CUST and SUBS, which have a
1 to > many relationship. I created a form to show fields from CUST and a
subform
> to show those in SUBS. The 2 tables are related on SUBSNO, and the data > source for each is the table (not a query). It behaves wonderfully,
except
> I can't seem to change the layout of the subform in design view. I make > changes and can see them in design view but in form view it reverts back to
> the old way. Yes, I do Save - and Save... I've looked at it from

several
> angles and can't see what I'm doing wrong. I'm using Access 2000

and these
> are native Access tables that were imported from Foxpro 2. 6 DBFs.
>
> Help?
> thanks
> wayne


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.