473,322 Members | 1,307 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Forms do not show

Hi,

I created some forms using the "Create form using Wizard".

However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.

I checked the forms' properties to no avail.

What did I do wrong? How do I correct and avoid this mistake in the
future?

Thanks in advance!

Zufie

Jun 27 '08 #1
8 2036
Access Version? Bound / unbound? Allow Edits? Data Entry? Updateable?

When you "cannot view" the forms, exactly what did you do and exactly what
happened?

It is difficult, at best, to debug remotely. Without detailed information,
it is impossible.

Larry Linson
Microsoft Office Access MVP

"zufie" <jo***********@illinois.govwrote in message
news:ce**********************************@r66g2000 hsg.googlegroups.com...
Hi,

I created some forms using the "Create form using Wizard".

However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.

I checked the forms' properties to no avail.

What did I do wrong? How do I correct and avoid this mistake in the
future?

Thanks in advance!

Zufie

Jun 27 '08 #2
On May 8, 1:10*pm, "Larry Linson" <boun...@localhost.notwrote:
Access Version? *Bound / unbound? *Allow Edits? *Data Entry? *Updateable?

When you "cannot view" the forms, exactly what did you do and exactly what
happened?

It is difficult, at best, to debug remotely. *Without detailed information,
it is impossible.

*Larry Linson
*Microsoft Office Access MVP

"zufie" <john.marru...@illinois.govwrote in message

news:ce**********************************@r66g2000 hsg.googlegroups.com...
Hi,
I created some forms using the "Create form using Wizard".
However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.
I checked the forms' properties to no avail.
What did I do wrong? How do I correct and avoid this mistake in the
future?
Thanks in advance!
Zufie- Hide quoted text -

- Show quoted text -
Sorry,
Access Version? Access 2000
Bound / unbound? That is has a control source
Allow Edits? Yes
Data Entry? No
Updateable? If you mean "Allow Additions" then Yes

Zufie

Jun 27 '08 #3
Text rearranged, and comments/questions interspersed. I'm not trying to
"grill" you under a hot, glaring light -- just trying to figure out what
more information might be helpful.

"zufie" <jo***********@illinois.govwrote
>>I created some forms using the "Create form using Wizard".
However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.
"Larry Linson" <bo*****@localhost.notwrote
>Access Version? Bound / unbound? Allow Edits?
Data Entry? Updateable?

"zufie" <john.marru...@illinois.govwrote
Access Version? Access 2000
Do you have all three Service Packs for Access 2000 installed, and any
"fixes" since SP3? Access 2000 had problems and, IMNSHO, only really
stabilized with SP3.

On the toolbar, click Help and About Access 2000 to see what SPs have been
applied.

Use Windows Update / Office Update to see if there are other "unapplied"
fixes.
Bound / unbound? That is has a control source
Controls do or do not have Control Source. Does the Form have a Record
Source? If so, what is the Record Source? If it is the name of a Query,
post the SQL of the Query.
Allow Edits? Yes
Data Entry? No
Updateable? If you mean "Allow Additions" then Yes
Are the Controls updateable? That is, what are the settings of their Locked
and Enabled properties (in the Data tab of the Property Sheet).

I have to ask again...
>When you "cannot view" the forms, exactly what did
you do and exactly what happened?
Did you have the Database Window open, highlight the form, and then click
Open; did you click a Command Button, and, if so, what was the code in its
click event; or did you open in Design View and click the Form View icon on
the toolbar? What _did_ you see, or was there no response at all?

Oh, yes, you said you created formS, in plural? Are there other forms in
the database, and can you view them under the same circumstances? Are you
having difficulties with viewing any other objects in the database?

Larry Linson
Microsoft Office Access MVP


Jun 27 '08 #4
>Here is the SQL for the Record Source:
SELECT [1st time callers].Date, [1st time callers].[User ID], [1st
time callers].Expr1
FROM [1st time callers];

----------

does the above work fine as a saved query? I would make the above as a
query, and then ensure you can open the query and view/browse the records in
the query builder. Also, can you edit the records using the NEW query you
just built?

I would suggest you get the query working BEFORE you attempt to create the
form.

So, it only a few forms you can't change?

Also, what happens when you open the form in design view, and then switch to
form view (ie: don't close the form, but keep it open in design view, and
then switch to form view?).

Remember, get the query working first, and then perhaps build a test form
with the wizard based on that query that we *know* is working just fine. I
suspect you deleted a table, or modfied the tables that the form needs...and
thus they don't want to open in "user edit mode" but continue to allow
opening in desing mode...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Jun 27 '08 #5
I've seen this happen before. Check the VBA code for Me.Visible = False in
the form's load and open events. Check for Cancel = True in the form's open
event. Check for the acHidden argument in code that opens the form if you're
opening the form from other than the database window.

If it's not the code hiding it, the form's window may be out of view. After
trying to open it, use the menu for Window - Cascade. If it's out of view,
that will pop it back in view again.

Chris
Microsoft MVP
zufie wrote:
>Hi,

I created some forms using the "Create form using Wizard".

However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.

I checked the forms' properties to no avail.

What did I do wrong? How do I correct and avoid this mistake in the
future?

Thanks in advance!

Zufie
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

Jun 27 '08 #6
"zufie" <jo***********@illinois.govwrote in message
news:6f**********************************@8g2000hs e.googlegroups.com...

Here is the SQL for the Record Source:

SELECT [1st time callers].Date, [1st time callers].[User ID], [1st
time callers].Expr1
FROM [1st time callers];
========================

As Albert and Larry suggested, a query may not be updateable. The Expression
(Expr1) may make a query so that it isn't updateable, so you may have to
change that slightly. The way to see if it is updateable, is to paste the
SQL into the SQL window of a new query and run it. Then take a look and see
in the navigation buttons at the bottom of the query if there is an asterisk
(*). If not, the query won't be updateable, and the resulting form will not
be either. Any form which has no records, and is not updateable, will be
blank.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jun 27 '08 #7
On May 12, 10:18*am, "Arvin Meyer" <a...@m.comwrote:
"zufie" <john.marru...@illinois.govwrote in message

news:6f**********************************@8g2000hs e.googlegroups.com...

Here is the SQL for the Record Source:

SELECT [1st time callers].Date, [1st time callers].[User ID], [1st
time callers].Expr1
FROM [1st time callers];
========================

As Albert and Larry suggested, a query may not be updateable. The Expression
(Expr1) may make a query so that it isn't updateable, so you may have to
change that slightly. The way to see if it is updateable, is to paste the
SQL into the SQL window of a new query and run it. Then take a look and see
in the navigation buttons at the bottom of the query if there is an asterisk
(*). If not, the query won't be updateable, and the resulting form will not
be either. Any form which has no records, and is not updateable, will be
blank.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
I think, Arvin, the form controls will show, but be blank. Probably
this is what you mean. In any case, the form can be viewed,
that is, it will be visible. My interpretation of the OP is that the
form or forms cannot be viewed except in design mode,

I tested this with Access 2007, The North-wind sample, a form with a
record-source of
SELECT [Last Name] & " " & [First Name] AS CalCal FROM Employees WHERE
1=2;
(no records and not up-dateable)
and one Control-TextBox Text0
with a Control Source of CalCal.
The form shows and the empty text box, Text0, shows when the form is
opened.

I assume OP went to the Window drop down in the tool bar and played
with Show, Hide, Cascade etc, after "opening" the form. If not, he or
she might try that.

I understand that Wizards can help beginners but I feel that, in the
long run they create much more trouble than they are worth, and are
the greatest cause of bad programming and programming oneself in to a
corner as in painting oneself into a corner. Whenever I see a Wizard I
try to expunge it.
Jun 27 '08 #8

"lyle fairfield" <ly************@gmail.comwrote in message
news:4c**********************************@f36g2000 hsa.googlegroups.com...

I think, Arvin, the form controls will show, but be blank. Probably
this is what you mean. In any case, the form can be viewed,
that is, it will be visible. My interpretation of the OP is that the
form or forms cannot be viewed except in design mode,

I tested this with Access 2007, The North-wind sample, a form with a
record-source of
===========================
Hi Lyle,

Actually, in Access 2003 and earlier, controls on a bound form which has no
data and is not updateable will not show, neither will their associated
labels. AAMOF, nothing on the form's detail section shows, including command
buttons, etc. I haven't tested this yet in A 2007, but will sometime today
and let you know. This is what I used from Northwind:

Select SupplierID, CompanyName
From Suppliers
Group By SupplierID, CompanyName
Having 1=2;

Using an aggregate guaranteed no records and that the query would not be
updateable. Your query was not updateable, but it did return 1 blank record.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jun 27 '08 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Daniel Hill | last post by:
OK, I have very, VERY basic background knowledge of VB6 and have now upgraded to VB.NET and now I'm struggling to bring up the forms I want. What I am looking to do is to have a click a command...
13
by: genetic.error | last post by:
I'm moving from Vb6 to VB.Net. I have a feeling this has come up before... The VS.Net MSDN file seems to state that the following should work: Form1.Show Form1.Visible = True Form1.Hide...
2
by: Ajai Kumar .R | last post by:
Hai all, I've two or more forms on my app. My requirement is, Have to show the first form asa the user press a button have to hide the first form and show the second form. If the user press the...
3
by: Joshua Russell | last post by:
Hi, Both the methods below open up a windows form called MasterForm. However, one works better than the other. Method 1 opens the form correctly but I don't have any reference to the instance of...
11
by: Nick | last post by:
Hello, Please pardon my ignorance as this is something I should know, but I'm a little unclear. I have an MDI based app. It is setup so the user opens a file and the main child form is created....
12
by: Peter Van Wilrijk | last post by:
Hi, In VB6 I have the following code ... Dim frmLink As Form Set frmLink = Forms.Add(stringformname) frmLink.Show 'wait until all data has been loaded Do Until frmLink.Loaded = 21 DoEvent
20
by: Peter Oliphant | last post by:
How does one launch multiple forms in an application? Using Photoshop as an example, this application seems to be composed of many 'disjoint' forms. Yet, they all seem somewhat 'active' in...
0
by: question | last post by:
Hi! I have a requirement where I need to display multiple forms one after the other like a slide show. These are in the same application. Basicall on selection of a menu item it should start...
8
by: Tony K | last post by:
How do you maximize a child form when you show the child form. My resolution on my screen is 1440 x 900. My parent form maximizes just fine, but when I show a child form it doesn't maximize. It...
21
by: Dan Tallent | last post by:
In my application I have a form (Customer) that I want to be able to open multiple copies at once. Within this form I have other forms that can be opened. Example: ZipCode. When the user enters...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.