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  

Missing controls on forms



 
 
Thread Tools Display Modes
  #1  
Old December 14th, 2004, 12:12 PM
Aaron Howe
external usenet poster
 
Posts: n/a
Default Missing controls on forms

I have created a form based on a query, which gets data
from two tables (see my post yesterday for further details
on that). I use the wizard to do this for simplicity and
bind the form to the query I need, then use combo boxes to
look up the various pieces of data and store them in the
field I need.

I know that can't be right, I should be chucking it all in
a table. My question: do I use a make-table query or
create a whole new table to replicate all of the fields I
need? If I use a make-table query can I base a form on it?

And why don't my controls show up, even if they have
nothing to display within them?
  #2  
Old December 16th, 2004, 04:58 PM
Brian
external usenet poster
 
Posts: n/a
Default

"Aaron Howe" wrote in message
...
I have created a form based on a query, which gets data
from two tables (see my post yesterday for further details
on that). I use the wizard to do this for simplicity and
bind the form to the query I need, then use combo boxes to
look up the various pieces of data and store them in the
field I need.

I know that can't be right, I should be chucking it all in
a table. My question: do I use a make-table query or
create a whole new table to replicate all of the fields I
need? If I use a make-table query can I base a form on it?

And why don't my controls show up, even if they have
nothing to display within them?


I don't understand most of your question, but I can tell you that the usual
reason for no controls being visible is that (1) there is no data in the
form's record source, and (2) the form does not allow records to be added.
This would normally be because the form's AllowAdditions property is set to
No, but in your case, with a form based on a multi-table query, I would
hazard a guess that you have created a non-updatable query.

As I say, I really don't understand the rest of your description. Why have
you created a form based on more than one table? This almost invariably
causes a lot of problems, and almost invariably is not necessary.


 




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
My Access front-end bloats! Rauken General Discussion 10 September 28th, 2004 05:06 AM
AllowAdditions=False makes unbound controls blank out when recordcount=0. Jon Using Forms 2 August 21st, 2004 03:08 AM
Help with report...need to list if any info was missing from application. Jacqueline Setting Up & Running Reports 2 June 3rd, 2004 01:38 PM
How to repeat code that is used in all forms Christine New Users 1 May 20th, 2004 02:18 PM
Microsoft Forms: Cannot load as some objects are missing from this machine Graham Setting up and Configuration 0 January 8th, 2004 03:26 PM


All times are GMT +1. The time now is 03:47 PM.


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