Blank Form View

I am very new to Ms Access 2007 and I have been trying to create a simple database for my office. My tables are all related but if I try creating a form by dragging fields to the design view, when I click "form view" its blank...
Can someone tell me what is happening and how to correct it?

Aug 12 '08 #1

Subscribe Post Reply

3017

hjozinovic

167

100+

Hi Bram,

I'll assume you have record source of the form set to the table/query you want, so you're dragging the fields from field list.
Is the visible property of the fields set to Yes?
Are you dragging the fields on to a Detail section?

Aug 12 '08 #2

Brahm

Hi Bram,

I'll assume you have record source of the form set to the table/query you want, so you're dragging the fields from field list.
Is the visible property of the fields set to Yes?
Are you dragging the fields on to a Detail section?

Hi
Yes, the record source is set right and the visible property is set to Yes. And I am also dragging it to the Detail section.
The field was created with a look-up wizard (if that helps)
Thnx

Aug 12 '08 #3

hjozinovic

167

100+

[HTML]I would try to set record source of the form to nothing and save.
Close the entire database.
Open again, and set the recordsource to the original table.
Save, and exit.
Open and try dragging fields.[/HTML]

It worked for me when I had no fields in the field list after setting new recordsource.

Aug 12 '08 #4

missinglinq

3,532

Expert 2GB

This is the classic description of what happens when a form has no records in it's Record Source and for whatever reason (such as AllowAdditions being set to No or the underlying query being read-only) the form doesn't allow new records to be added. Are these conditions true?

Welcome to Bytes!

Linq ;0)>

Aug 13 '08 #5

Brahm

Thnx for the welcome, Linq

Unfortunately those conditions are not true in this case. are there any other possibilities?

And i've tried what hjozinovic suggested (thnx btw) but my form hasnt changed. it still doesnt display my fields

Aug 14 '08 #6

hjozinovic

167

100+

Maybe you could create compeletely new form based on the same table/query and than try to dragg fields on it.
Or use wizzard for creating forms. That way fields will automaticaly be on the form.

Aug 14 '08 #7

Brahm

Thanks again...it worked. Although I might have liked to know what exactly it was...

Sep 2 '08 #8

by: Batezz | last post by:

I have created a form (below) How do I stop it redirecting to another page (productsearchresults.php) when form is submitted if both the fields are blank? Any help appreciated. Batezz

PHP

Empty/Blank form appearing!?

by: Andrew | last post by:

I recently copied an old form and modified it with new fields and such, and now when I try to simply open the form (view it to enter data) there is nothing but the header showing! The header is...

Microsoft Access / VBA

Parameter query returning information in form view

by: Simon Pleasants | last post by:

Am something of a newbie at this, so please bear with any stupid questions. I have created a database to track shipments that we import. The information is stored in a table and I have created...

Microsoft Access / VBA

Blank Form

by: jervin via AccessMonster.com | last post by:

Good Day, I want to get rid of the blank form everytime i open. I had a form link with a query and i wanted to prompt me sayin "data not found" instead of showing a blank form. i just dont know...

Microsoft Access / VBA

Difficulty displaying graph in Form View that I see fine in graph control on form opened in design view

by: MLH | last post by:

A97 Am having difficulty displaying graph in Form View that I see fine in graph control on form opened in design view. I know I'm doing something wrong. If I open the form in design view - I...

Microsoft Access / VBA

Importing data from form to a new blank form

by: hexagram | last post by:

hi guys can anybody can teach me how to do this scenario Transfering Data of a form to a new form The Scenario is: I have a Delivery Receipt Form (Hardware) with a fields of the following ...

Microsoft Access / VBA

any way to jump the cursor to a specific field (variable) while inform view?

by: mckbill | last post by:

Is there a way I can direct the cursor to a specific field (variable) in a form by typing the field name while in form view? I have a form with many fields, and it would be nice if there were...

Microsoft Access / VBA

blank form submits

by: 0utlawza | last post by:

Hi Guys It seems i posted this in the incorrect topic, so i am reposting here. Please excuse the Newbie question. I am not really a programmer so excuse me if i dont clarify my point...

Javascript

Form fields will not display in Form View

by: davisjr6 | last post by:

I recently converted an Access database built in Access 2000 to the Access 2007 format. Upon doing so, I created a new form that used a table from the old database plus two new tables created in...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

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...

General

Wordpress or something else?

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...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

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...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics