I need to hide/not display a blank row on a subform.
The Main form is based on a table, contains Site Header information
The Subform is based on another table containing Sample Details records
Site Header table to Sample Details table relation ship is one-to-many,
with two key fields SiteID and SiteVisitDate
The Form/SubForm is linked by SiteID, SiteVisitDate
The form adds one record to the Site Header Table.
Then adds mutliple records to the Sample Details table for that SiteID.
Some fields are populated with a script, while others are populated by user input
An empty/blank/new row always appears on the subform before & after the Sample Details are added. Before records are added is not a problem,it's when
records are added that the row of empty fields is a pain. It actually looks like a "New Record Row"
Any ideas appreciated, cheers
Michael
I've tried CanShrink etc,
1 3816 PEB 1,418
Recognized Expert Top Contributor
If I understand well you want that the row with thenew record doesn't appear, do-I? If Yes, you have to go to the Form properties and change the property allow additions to No
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: S P Arif Sahari Wibowo |
last post by:
Hi!
Do you know how to put a form's Access-Visual-Basic-code that will force
the form to be inserted, while the user has not type anything in the form,
without changing focus, selection, etc.?
Here is the story.
I have this structure:
|
by: JM |
last post by:
Hello,
I've created a Querydef in a Form_Load() sub. The form is a subform
that no longer has linked child fields. The form is bound to this
querydef. When I open the form, the fields are populated just fine.
However, when I add a new record using the new record control at the
bottom of the subform, it gets added with NULL for the two values that
were in the original WHERE clause.
For example, if my query was "SELECT batch, style,...
|
by: John |
last post by:
I have two tables in a 1:M relationship- the parent has 5 fields in the
primary key and the child 6 (these are actually pretty far downstream in
a complicated ER model, but the problem is between these two). I set up
the relationship with no problem- referential integrity and left outer
join. I have created two forms- one for the parent and one for the
child table. I want to import the child table's form as a subform on
the parent...
|
by: fstenoughsnoopy |
last post by:
I have a customer order database and I need to pull a customers
information, ie first name, last name, address, city, state, zip,
phone, etc, into the oder table. i don't know how to go about making
this work...
|
by: erick-flores |
last post by:
Hello all,
Form A & Form B
Form B opens when I click on a button from Form A. How do I setup Form
B so it will always let me insert new records. Because right know, when
I click on the button from Form A to Form B (onClickEvent), Form B will
open and show all the records that the table has. So I need to click on
the navigation button (buttom of the form) and insert a new record.
| |
by: olivier.wambacq |
last post by:
hello,
This sounds simple but I can't seem to manage...
So I'm in a form, and have got a button to "open" (make visible) a
subform.
the subform actually contains fields from the same table as the big
form.
but I want the open button to be disabled if a field in the subform is
empty.
|
by: imrosie |
last post by:
Hello Experts
This is a hard one (I still speak newbie). An expert may think it's not a big deal, but, I am trying to replace my Main Order form with a subform because of the following:
Original form was based on a query of 2 tables (Order and Customers), the subform was based on table OrderDetail(productname, quantity, discount, unitprice). I was experiencing autonumber problems when attempting to start a new order, because of the inner...
|
by: Beany |
last post by:
Hi,
i have a subform within a form.
i have a combobox in the form that populates the subform after a selection.
i have two textboxes that show some info from the subform, ie Number of items and User...
How do i make sure that the textboxes are empty before i select a user from the combobox???
|
by: Yvonne |
last post by:
Hi,
I have this Access 2003 DB that handles Clients and their respective
items of correspondence in a one to many relationship. Clients details
are entered in frmPerson. When it comes to recording an item of
correspondence this is done via another form/subform ( main form is
called frmLetterDetail ). This main form summarises the Client's
details and the subform gives details of each individual item of
correspondence displayed as...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |