John,
The controls are in Design view. The form only has 4 combo boxes and a button. I have a few forms like this. They allow the user to set the parameters for queries and reports. Some of them show the boxes and some of them do not. The ones that do not show the combo boxes had a query as their data source. The ones that did show the combo boxes had a table as their data source. When I changed the data source to the table the combo boxes showed up, also when I just deleted the datasource all together the combo boxes showed up. The tables have no data in them either so I am a bit confused there. If there are no records, just combo boxes, do I need a data source? I am not sure why I did this 6 months ago. I just copied my original form when I needed another similar form and that doubled the error.
Thanks for your help. I can at least go in and fix it now.
Bill
-----Original Message-----
From: John Viescas [mailto:JohnV@msn.com]
Sent: Sunday, August 19, 2012 01:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Blank Database
Bill-
The controls are there in Design View, right? And I bet the Recordset is not
updatable or you have turned off Allow Additions for the form. When there is no
data in either case, the form comes up blank because there is nothing to which
Access can bind the controls. This is normal.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of agent1of6
Sent: Sunday, August 19, 2012 3:31 AM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: [MS_AccessPros] Blank Database
I have a finished database and I was going to create a blank copy by importing
all the structure with no data into a new database. Works great except on two
of the forms none of the items in the detail section show up. (4 combo boxes
with lables and a button) I open the form and I can see the header but the
detail is blank. I tried to recopy the form from the original database but it
still shows up blank. I could not find anything in the properties that was
different. I tried compact and repair, no luck.
Any idea what I am doing wrong.
Bill
MN
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar