Hi!
I'm new to this forum, but i try not to post a stupid question the first time :-). I googled for my problem, but couldn't find any answers.
When we open a select query, there is always a "new" line, where you can type in a new record. I use a "multiple items" form, where this new line shows as an empty record. Of course this is not very nice, so i would like to remove it. Anybody knows what could i do? Let me know please!
5  20335  Rabbit 12,516
Recognized Expert Moderator MVP
Set Allow Additions in the form properties to No.
Hi!
I'm new to this forum, but i try not to post a stupid question the first time :-). I googled for my problem, but couldn't find any answers.
When we open a select query, there is always a "new" line, where you can type in a new record. I use a "multiple items" form, where this new line shows as an empty record. Of course this is not very nice, so i would like to remove it. Anybody knows what could i do? Let me know please!
Try invoking the property sheet for your form and set the following properties as indicated below:
Allow Additions = False
Allow Edits = True
Allow Deletions = False
Data Entry = False
These properties can also be set and unset using vba code.
Hi!
I'm new to this forum, but i try not to post a stupid question the first time :-). I googled for my problem, but couldn't find any answers.
When we open a select query, there is always a "new" line, where you can type in a new record. I use a "multiple items" form, where this new line shows as an empty record. Of course this is not very nice, so i would like to remove it. Anybody knows what could i do? Let me know please!
in your query design grid, open the properties.
Where is says recordset type, set it to snapshot. That will remove that line.
The recordset will NOT be updateable at that time. So if you want to edit records, you have to change it back
J
Thank all of you very much! Now my forms look much better :-).
Rabbit 12,516
Recognized Expert Moderator MVP
Not a problem, good luck.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Mark P |
last post by:
I think my previous posts on this subject are too verbose and are
scaring off replies so I'll keep this one brief:
If I define my own operator new(size_t size) in a class, does that
automatically hide (global) placement new?
Would this prevent STL container classes from working (e.g., does
std::allocator require placement new for its construct() method?)?
Thanks for your help,
|
by: Dot net work |
last post by:
I need VB.NET's "shadows" functionality inside a C# project.
I tried the "new" keyword, but it didn't seem to work, because my
particular function does in fact differ in signature to the function
that is being hidden in the base class.
In VB.NET, the shadows keyword hides all the inherited functions,
regardless of signature.
I need this functionality in C#.
|
by: bokiteam |
last post by:
Hi All,
In VB6, I can show/hide form by visable.show.
It didn't work on VB.net, could you please advice,
I have a form2, I want to show it after click button 1 in form1.
Thank you very much!
|
by: scartin |
last post by:
I'm fairly new to working with ASP web controls, and am running into
what seems to be a ridiculous problem that I'm hoping will be a breeze
for an experienced ASP developer.
I have a GridView and a FormView on the same page, where the GridView
is visible at page load, and the FormView is set to Edit mode by
default, but is hidden on the page. I have the Select link enabled on
my GridView, and I use the SelectedIndexChanged event to hide...
|
by: Bill H |
last post by:
25 years ago every computer came with some form of Basic interpreter
so you could use yoru computer without having to buy more software. Is
Javascript (teamed with HTML) set to become the new Basic, where
anyone with a computer can start writing code without having to
purchase any expensive languages?
Bill H
| | |
by: Shoaibkhattak |
last post by:
Hy
when i define a new form and attach this form at a buuton on old form and debug the application.so when i open new form by clicking button new form opens and i close it by close button of control box.but when i try to open 2nd time that form it not open.and vb.net show error in show.newfor.
so i take a button in end of form and i code there me.hide.and false the control box.but i want if a person want to use close button on control box...
|
by: dougmeece |
last post by:
I have two forms with one calling the other to perform searches. When I run the search form the 2nd form a blank record is added to my table. The table is appended or updated from entries on the first form but the second form doesn’t reference the table at all. The queries ran from the form obviously query the table for data but these are not the same queries that update/append.
Any ideas what would cause this to happen?
As always,...
|
by: Robert Fuchs |
last post by:
Hello,
This example:
public class BaseC
{
public int x;
public void Invoke() {}
}
public class DerivedC : BaseC
|
by: Alfredo73 |
last post by:
Hi,
I am writing an application in VB2008 with several forms. From Form1 I open a new form with me.hide() and then form2.showdialog(). The system works but in form2 the application runs without screendisplay until the program waits for a user input. So first all databases are processed. Meanwhile no screen is visible for the user. Sometimes this takes about 5 seconds. I would like the user to see the build up screen directly. How can I...
|
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: 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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
