473,323 Members | 1,560 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,323 software developers and data experts.

Hide "new" row in query or on form

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!
Sep 6 '07 #1
5 20145
Rabbit
12,516 Expert Mod 8TB
Set Allow Additions in the form properties to No.
Sep 6 '07 #2
puppydogbuddy
1,923 Expert 1GB
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.
Sep 6 '07 #3
JConsulting
603 Expert 512MB
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
Sep 7 '07 #4
Thank all of you very much! Now my forms look much better :-).
Sep 7 '07 #5
Rabbit
12,516 Expert Mod 8TB
Not a problem, good luck.
Sep 7 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

5
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...
8
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...
2
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...
1
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...
43
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...
2
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...
5
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...
12
by: Robert Fuchs | last post by:
Hello, This example: public class BaseC { public int x; public void Invoke() {} } public class DerivedC : BaseC
9
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...
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
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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
isladogs
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...

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.