473,324 Members | 2,417 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,324 software developers and data experts.

Subform - Display Problem

Hello,

I'm using a form that has a subform. The subform is linked to a hidden
datasheet form, and the subform displays records from the form.

The problem is, the subform will only show X number of records, and one
additional record for data entry. My boss wants me to show an entire sheet,
with many rows available for data entry (Because it looks better).

Is there a property that can be changed to show the subform in this way?
This may be an easy one but I'm not familiar enough with subforms to know.

Thanks in advance,

Nick

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
1 1617
Nick via AccessMonster.com wrote:
Hello,

I'm using a form that has a subform. The subform is linked to a hidden
datasheet form, and the subform displays records from the form.

The problem is, the subform will only show X number of records, and one
additional record for data entry. My boss wants me to show an entire sheet,
with many rows available for data entry (Because it looks better).

Is there a property that can be changed to show the subform in this way?
This may be an easy one but I'm not familiar enough with subforms to know.


No, you will always only ever get one blank line for the new record. You
could bodge a workaround whereby you enter some blank records into the
underlying table but...

Pros:
Your boss will think it looks better (questionable)

Cons:
You need to maintain the number of blank records.
You need to maintain some sort order so that the blank ones always
appear last in your subform.
This may impact on a required field.
It's a waste of space.
It's a waste of resources to create just to please your boss in that way
(completing the project on time might be a better way to please him).

You have my express permission to dope slap your boss.

--
[OO=00=OO]
Nov 13 '05 #2

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

Similar topics

4
by: Trevor Drake-Brockman | last post by:
Hoping some can help. Have a subform that is working fine except if you swap to another application and then back to the access form when you do that the area over the subform is not updated...
2
by: Scott | last post by:
In my database, I have a form with a subform. I had everything working correctly - the correct records would display on the subform for each record on the form. I could edit, add, and delete on the...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
1
by: kevin | last post by:
I have created a main form with a combo box (cbo_student_events) that has a drop down list for various student events. I have a subform that displays all the corresponding data for the...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
6
by: Sally | last post by:
I need to be able to click in a subform and run code but at the same time I need to be able to scroll the records without running the code. I tried coding the Enter event of the subform control but...
2
by: Smartin | last post by:
Using Access 97 I am trying to create a form that allows for user entry of search terms and displays a table of results. I thought I could accomplish this using a subform but it isn't quite...
6
by: ryan | last post by:
I created in design view a subform within a subform. However the subform within the subform in only visible in design view. In form view the subform within the subform is not visible. I have...
10
by: sara | last post by:
Hi - I am developing a simple app, and just found a problem that I can't fix after 4 hours of trying. I display a list of customers, and the user chooses one and displays "orders". The...
4
by: aqua404 | last post by:
I know this has been discussed, but I can't find a resolution. I have a subform on a form. The table with the data for the main form has 15,000 records. I am opening and then setting...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...

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.