Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Blank Form In Form View But Fields Present In Design View
After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.

After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)

I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.

Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?

(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)

Thanks, Charlotte

View Replies !   View Related
Access Forms Design View
(Forms) How do I insert a Page below the Detail Bar?

View Replies !   View Related
Field In Design View Not Showing In Table View
I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View Replies !   View Related
Design View - Where'd The Table View Go ?
You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above.

Well, I have a query where this table view has disappeared ?

I can edit the query in SQL view, the query works, just the table view is missing.

Ever happened to anyone else ? I've done the obvious and scrolled down as far as I can and nope, it's not there ??? :confused:

View Replies !   View Related
Normal View -v- Design View
I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.

However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.

Any ideas how I can fix this?

Thank you

View Replies !   View Related
Form View Screen Is Blank
Hi, i have my form open in design view and it includes quite a few fields on a tab. But when i go to open it in form view, the form is just grey and nothing appears on it. Never seen this before, can anybody help?

View Replies !   View Related
Show Blank View On Form
I have created a form from a table and only the startup screen when I hit the button I want the form to display a clear entry so that I can create a new contact each time - at the moment when i hit the button it shows the first record and im in danger of changing it (im having to hit the create record button) Help!

View Replies !   View Related
Modified Form View For UNC And Now Data Is Blank
I'm a novice Access user and I've been put in charge of changing this. The database is on a shared device. I copied a working frontend (access file) to another machine and used the link table manager tool to find the new database. Now when I open the table view mode I can see the table data, but when I open the form, it doesn't show the data at all and it only lists 1 record. I know this sounds like a really stupid question, but is there one more step or am I in insert mode?

Thanks a bunch for your help.


View Replies !   View Related
Subform Design/form View ??
I created a subform on one of my forms and in design view it looks all nice with a nice background and stuff. But in the form view it looks just like a regular datagrid. I'd like it to look like it does in design view. Any idea how?


View Replies !   View Related
One Form Closes When Another Goes Into Design View
I have a form called MainMenu which has hyperlink buttons to various other forms in the database one of which is frmMenuBTOnebill.

If I open MainMenu then link to frmMenuBTOnebill, in normal view, then go into design view on frmMenuBTOnebill, the form MainMenu closes completely. If I simply close frmMenuBTOnebill, then MainMenu stays open

frmMenuBTOnebill does not have any events other than On Open which is

Private Sub Form_Open(Cancel As Integer)
Set dbs = CurrentDb
strSQL = "Select tblRectype007.* from tblRectype007;"
Set rst = dbs.OpenRecordset(strSQL)

If rst.RecordCount = 0 Then
Me.lblClearImportAreas.BackStyle = Transparent
End If

DeleteTableName ("CompactTable") ' deletes table "CompactTable"

End Sub

Any ideas why one form should close when another goes into design view?

View Replies !   View Related
How Do I Show The Subform As Form View Instead Of Datasheet View :confused:
See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View Replies !   View Related
I Want Datasheet View... Why Does It Keep Showing Form View?
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help


View Replies !   View Related
Error Message Displays When Trying To Close The Form/switch To Design View
I have a form with a subform in it. On the main form, I have a combo box with a list of program numbers to choose from. Once one is selected, the subform displays all the unpaid invoices under that program number. This part works fine. The problem occurs when I try to close the form, switch to design view, or scroll the subform to the right. Basically, the error message says that the record can't be saved because it would create a duplicate value in the index/primary key. However, this form is used to display information only. I have disabled the edit, delete and addition abilities, so I can't figure out why it thinks I am trying to change or add a new record. Any help would be appreciated.

I figured it might make things easier if I included a copy of the database, so here it is.

The form is called SETR, and the subform is AllInfo subform.

View Replies !   View Related
Form / Sub Form Question In Design View

I have a main form and a large sub form that covers alot of the main form fields. My question is when I'm in design mode, the sub form blocks the fields I need to edit. I've tried setting the sub form "sent to rear" and the fields "sent to front", but this does not seem to solve the problem. So I end up dragging the sub form
off to no-mans land and then place it back. Is there way to say hide the sub form in design view and then unhide it.

Thank you

View Replies !   View Related
View Records In Form View
Hi, I am in the process of creating a new database - I am a bit new to this. I have a main form, which also contains two subforms. The record source of the main part of the form is 11 tables, and then each of the subforms is based on one table each (so there are 13 tables altogether).

Everything seems to be linked up ok, and when I add new information to the form (and the subforms), the information gets saved to the tables as it should be. However, I want to be able to view past records in the form view, so that users can regularly update past records using form view. I can't do this. Each time I open the form view, the thing at the botton left says 'record one of one.' THen if I put the curser in (for eg) the box called 'client name' and click on the search button, I get a message saying:

"you can't find or replace now, the fields are not searchable due to:
- the fields are controls;
- the fields have no data;
- there are no fields to search."

well I don't really know what that means. There is definately data in there somewhere, because I can view it in the table view, but I'd like to be able to view and update old records, and search, in the form view.

any tips?

thanks for helping

View Replies !   View Related
DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK
I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line

Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)


View Replies !   View Related
Design View...
I should know this but it's has me stumped at the moment - When I have a form open I can right-click and it let's me go into design view. How do I turn this right-click option off?

View Replies !   View Related
Can't Go Into Design View
I am getting the following error when I click on design view:

FSADSAFASF can't run macro or callback function 'fdesign'

I completley removed Access and re-installed the application again and I am still getting the error.

Thanks in advance for the help - John

View Replies !   View Related
I Cannot Get To The Design View
I am a new user of access and have a question concerning a database that I am working on. The database has a switchboard where you can open different objects but the problem is that the main menu on the top is missing the tools menu and the view menu. When I pressed control , I could get the views (without the actual view menu) but the tables do not have a field property control i.e. I cannot add any new fields to the table. In addition to that problem there is a reference problem with one of the tables when I add some data to it - but the table that access refers to I cannot even see. I am really puzzled over here - is it a security issue mind that I don't have the tools menu that will let me check the security settings - I am really puzzled here. I need your assistance please I am going crazy over here ! I attached a screen shot so you can see what I am talking about - also how come the database is designed this way where the forms and tables are b ound together?

View Replies !   View Related
Blocking Design View
How can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening.

Any ideas?


View Replies !   View Related
Problems With Design View
I work at a school district and we have a report card that was just created by one of our teachers in Access 03. Now, when you Shift+Click on the card on her machine (her personal laptop) it opens it up in Design View so the appropriate changes can be made. But, when we transfer it to our network so that we can copy it and give it to the teachers, the Shift+Click option doesn't work. I did some research earlier about VBA scripts being put into access documents to allow/disallow special options like this, but even when the database is open on our network, we (as administrators) can't Alt+F11 to bring up the Visual Basic Editor to check for those scripts. I thought that maybe it was a permissions thing, so that it could only be edited on the original machine, but she can move it to her home computer and Shift+click and Alt+F11 work as they are suppose to. Any ideas?

Thank you for any input.

View Replies !   View Related
Opening In Design View

I've got a DB where I need to simply change a few images on the form buttons. When I open the file I cannot access design view at all. There is no toolbar and the menu doesn't contain View, just file, edit etc. I can edit the properties of the records etc but this is all I can do. I thought maybe it had something to do with it being created in a different version of Access but still it will open in this way only. There is no messae telling me I'm locked from anything and I've tried ctrl + enter etc. I'm running Access 2003.

Does anyone know what's wrong? Its driving me nuts. :confused:

View Replies !   View Related
Mde Made But Still Able To Use Design View
I've made my mde file from a mdb which is fine apart from the fact that I can still view all the tables and queries and more to the point able to change them. Has anyone come across this before, if so how can it be fixed?

View Replies !   View Related
Design View Freezes
When I click on a command button to print a report and there is no data, after the message there is no data cancelling report the tool bar freezes and I can't get into design view. I can't figure out what's causing this. Any help appreciated.

View Replies !   View Related
Subforms In Design View
Using Access 2k in form design view, I sometimes get a blank, white section in place of a subform. Sometimes if I toggle back and forth a few times between design & form views, the subform may finally appear in detail. I've applied all updates to office 2k and can't seem to figure out why the design view would behave erratically this way.

View Replies !   View Related
Disabling Design View
This may be a very basic question, but I have to ask: how do I prevent the user from switching to design view and messing with tables and queries. Also, once I do that, how do I get to the design view to make changes if necessary?


View Replies !   View Related
Table In Design View
Hi, I have a table if I do view in design view has all validations in description.I am trying to copy this to excell or word so that I can get things started.. and I just cant seem to copy that view which I see in design. I got 174 fields so its obvious I cant copy and paste 174 times...


View Replies !   View Related
Disable Design View
is there a way to disable design view for tables, forms, etc.
thus there is no direct access to the backend code, form elements, etc.

and if so is there a way to disable it based on some caveat… basically i have a users table that has a column called access type and I want to disable the design view option of all users that do not have an access type of admin.

View Replies !   View Related
Setting Design View Password
Hello to all,

Can you tell me please is there any way to set password to form design view button in a .mdb database? I have seen it somewhere that a guy set password if you want to view his modules in a design view. Is it possible to do the same with forms, reports etc. Any help is very welcome.

Best Regards


View Replies !   View Related
Print Table Design View??
Is it possible to print the design view of a table?? If so how do you do it?? When Im the in design view and go go to file the print button is greyed out.

Thanks in advance.


View Replies !   View Related
How Do I Export A Table Design View?
I have four tables in a single .MDB file. I need to export the contents of the Design View of each table to a text file. How do I go about doing that? I've tried the help files and Access for Dummies, but neither are giving me the info I need.

View Replies !   View Related
Linked Table - Design View
I have tables that are linked to the AS400 via a file dsn. Whenever i go to the table properties, i receive a message indicating that i may not be able to save changes, but im trying to go to the properties=>description so that i can change the description of the table, which will enable me to change the filepath of the dsn from a mapped drive to the full path of the filename. Whenever i change the description, the changes do not stick? Any solutions?::D

View Replies !   View Related
Query Hangs In Design View
I maintain a mature Access 97 application, divided into front and back ends. A report is based on Query2, which is in turn based on Query1. Query 1 is the main data table with outer joins to about 2 dozen lookup tables. Query 2 applies selection criteria from a user form to generate the resultset used by the report.

Now I need to create a new report, which will basically be a specialized version of the existing one, so I have to copy Query2 and edit the copy appropriately. Whenever I try to open Query2, or a copy of it, in Design View, Access locks up with a perpetual hourglass. Yet the report runs fine, and I can open Query1 in Design View, and both queries in Datasheet View, without any problem. I've already tried creating a new database and importing all the objects from the old one into it, but this problem persists.

Any ideas?

View Replies !   View Related
Parameter Keeps Popping Up In Design View
I have a query with a simple parameter, [Enter the start date]. This is called by another query to add more data, and then by a report.
My problem is this. I go into the report in design view, and my parameter keeps popping up! It will not go away no matter how many times I try to cancel it - it just comes back. So I cannot make changes to the report. How can I stop this from happening?

View Replies !   View Related

Copyright © 2005-08, All rights reserved