I have a form, one of about 20 editing forms I created last
week. All were created pretty much the same way, used
the column wizard just to throw everything from the source
table/query up there. Then I modified from there, adding
buttons 'n whatnot.
I cannot see any controls on one of the 20 forms in form
view. They're all there in design. None have visible property
set to False. The controls are just not showing up. No matter
how many times I open it. I don't know what to do short of
rebuilding the form from scratch.
That's not the issue and I could do it in a short while. But
I really would like to know what's causing this. I don't like
being caught completely off-guard and don't want it to
happen again.
10  1646 
I did check to see if the controls became visible if
the form's RecordSource property was removed
completely. And they did. When I put it back in,
they disappeared again. This should provide some
clue, but I can't figure it out.
MLH <CR**@NorthState.net> wrote: I have a form, one of about 20 editing forms I created last
week. All were created pretty much the same way, used
the column wizard just to throw everything from the source
table/query up there. Then I modified from there, adding
buttons 'n whatnot.
I cannot see any controls on one of the 20 forms in form
view. They're all there in design. None have visible property
set to False. The controls are just not showing up. No matter
how many times I open it. I don't know what to do short of
rebuilding the form from scratch.
That's not the issue and I could do it in a short while. But
I really would like to know what's causing this. I don't like
being caught completely off-guard and don't want it to
happen again.
Have you got any data in the data source? ie. if there is no data in the
table behind the form then you might not see any bound controls
(depending on how you set your forms up). Is the form setup to allow
additions/edits?
--
regards,
Bradley
A Christian Response http://www.pastornet.net.au/response
Or the form's DataEntry property is set to Yes, and the form's recordsource
query is not updatable.
--
Ken Snell
<MS ACCESS MVP>
"Br@dley" <n0****@4u.com> wrote in message
news:jf*****************@news-server.bigpond.net.au... MLH <CR**@NorthState.net> wrote: I have a form, one of about 20 editing forms I created last
week. All were created pretty much the same way, used
the column wizard just to throw everything from the source
table/query up there. Then I modified from there, adding
buttons 'n whatnot.
I cannot see any controls on one of the 20 forms in form
view. They're all there in design. None have visible property
set to False. The controls are just not showing up. No matter
how many times I open it. I don't know what to do short of
rebuilding the form from scratch.
That's not the issue and I could do it in a short while. But
I really would like to know what's causing this. I don't like
being caught completely off-guard and don't want it to
happen again.
Have you got any data in the data source? ie. if there is no data in the
table behind the form then you might not see any bound controls (depending
on how you set your forms up). Is the form setup to allow additions/edits?
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response
Allow Edits, yes.
Allow Deletions, yes
Allow Additions, no
And, no, there is no data in the datasource (query). I have similar
editing forms bound to tables having no records. These do not
exhibit similar symptoms. I did test and the controls are all visible
if the source query returns data. It will, therefore, not present a
lasting problem since my data is permanent. But the behaviour
deserves some explanation since other forms based on record
sources returning no records display their empty source fields,
command buttons and other controls anyway. I thought it odd. Have you got any data in the data source? ie. if there is no data in the
table behind the form then you might not see any bound controls
(depending on how you set your forms up). Is the form setup to allow
additions/edits?
MLH wrote: Allow Edits, yes.
Allow Deletions, yes
Allow Additions, no
And, no, there is no data in the datasource (query). I have similar
editing forms bound to tables having no records. These do not
exhibit similar symptoms. I did test and the controls are all visible
if the source query returns data. It will, therefore, not present a
lasting problem since my data is permanent. But the behaviour
deserves some explanation since other forms based on record
sources returning no records display their empty source fields,
command buttons and other controls anyway. I thought it odd.
Is the underlying query editable? The "usual" blank form you are used to seeing
is actually the new record position. That is not available if the query does
not allow new records to be inserted.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
The form's DataEntry property setting is No.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Or the form's DataEntry property is set to Yes, and the form's recordsource
query is not updatable.
I checked the query, opening it in datasheet view. I manually added a
couple of records to it to make sure it was editable. The impact this
issue has on my app is negligible, as I have employed a workaround
to count the records returned by the query. I simply do not open the
form unless records are returned now. But you know how these things
are - sometimes you just wanna get to the bottom of it.
Thx for your contribution.
Is the underlying query editable? The "usual" blank form you are used to seeing
is actually the new record position. That is not available if the query does
not allow new records to be inserted.
MLH <CR**@NorthState.net> wrote: Allow Edits, yes.
Allow Deletions, yes
Allow Additions, no
And, no, there is no data in the datasource (query). I have similar
editing forms bound to tables having no records. These do not
exhibit similar symptoms. I did test and the controls are all visible
if the source query returns data. It will, therefore, not present a
lasting problem since my data is permanent. But the behaviour
deserves some explanation since other forms based on record
sources returning no records display their empty source fields,
command buttons and other controls anyway. I thought it odd.
Have you got any data in the data source? ie. if there is no data in
the table behind the form then you might not see any bound controls
(depending on how you set your forms up). Is the form setup to allow
additions/edits?
Ok, you either need data or to allow additions.....
--
regards,
Bradley
A Christian Response http://www.pastornet.net.au/response
MLH <CR**@NorthState.net> wrote in
news:qr********************************@4ax.com: The form's DataEntry property setting is No.
That combined with what you said in another post:
Allow Edits, yes.
Allow Deletions, yes
Allow Additions, no
Shows why it's blank if there are no records in the returned
recordsource. To not be blank, the form would have to move to a new
record, but your settings prohibit that.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
BTW, I tend to open forms with a non-editable blank record and than
load the records the user requests. I also tend *not* to allow
addition of records in the same form as the data is edited, but
create it from an unbound form, then load the record into the form,
replacing the blank, non-editable recordsource with a recordsource
that returns the just-added record.
My reason for this is that I've seen too many users start typing
into the first record of a form. Thus, I make sure that there are no
editable records loaded, and that they have to do something else to
load a record for editing.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Lance |
last post by:
I need help with having a Login Form on a website that goes to a
member only section, to beable to check my forum database so that when
people register, they register on my forum, and at the same...
|
by: TomB |
last post by:
Ok, I'm new to dotnet. Not only do I need help I need to know which of
the dotnet groups would be best for this question. I have over 30
applications in Access with nearly 300 forms that have to...
|
by: rodchar |
last post by:
Hey all,
You notice how when you mouse over each thread in this forum how the
highlights, well how can I do this same thing in my win form with my datagrid?
thanks,
rodchar
|
by: al jones |
last post by:
I see many different questions here. Some of us are obviously *very* new
to vb and others are 'old pros'. As you've seen from my 'frustrated'
posts, I'm obviously stuck on a problem that...
|
by: Simon Harvey |
last post by:
Hi everyone,
I have a windows form application that looks a little bit like outlook
in that it has a menu system on the left and then the main area to the
right has a horizontal splitter thing...
| | |
by: joeschnell |
last post by:
I'd be embarrassed to tell anyone how long it took me to get this far, since about 8pm last night! I have been assigned some homework to code a program that produces output in a diamond shape on...
|
by: oh4real |
last post by:
I recently developed a compact function to efficiently allow users to change info in a form (like account info, contact info, etc.) and then the function automatically identifies what's changed and...
|
by: DirtySnipe |
last post by:
I have created a php form with dynamic drop down boxes in it which pull the options from a database. The boxes work fine and the data gets submitted fine but im having a problem getting the box to...
|
by: Robertsonjay |
last post by:
In mvc you separate view from controller. How do you do that in C#?
Many people define an interface for a controller but isn't controller is specific to a form(gui) which all controller contains...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
