Currently I have inserted blank records with record IDs of 99999 and just linked the "open form" button to the last record, but I would like to be able to open it to just a blank record if I was just opening the form. Is this possible? My boss is asking and I don't know.
Seth:
Does that make sense?
You cannot go to a blank record Seth. As Mihail says, you can do various things to hide it, but essentially the concept of a blank record in these circumstances doesn't make sense, no.
8 2200 NeoPa 32,556
Expert Mod 16PB
When you say blank record, I assume you mean a new, unsaved, record. As if you clicked on the New button of the Record Navigation buttons. It is possible to navigate to any record when you open a form.
It is also possible to set the form so that only new records can be processed (You wouldn't be able to edit an existing record at all) by setting the .DataEntry property to True.
I was more meaning just a blank record. My problem is that my primary key is an auto-number, so the new record has a "(new)" inserted automatically. I was hoping to get around this is possible.
NeoPa 32,556
Expert Mod 16PB
I'm not sure what you think you're saying Seth, but I can't make it make sense. If a table has an AutoNumber field then it's not even conceivable (what sense would it make anyway?) to have a blank record with no value for this field.
I don't need the table to contain a blank record, but I just need the form to be blank. It would probably have to be done by opening the form to no record. Does that make sense? Again, I'm not sure if it is possible. I'm just asking so that I can tell my boss.
You can hide the text box where your AutoNumber is displayed. Anyway you can't make any change in that field. Or play around formats: If current record is a NEW record, set paper color and ink color to the same value, else set colors as you need (i.e paper=white, ink=black).
NeoPa 32,556
Expert Mod 16PB Seth:
Does that make sense?
You cannot go to a blank record Seth. As Mihail says, you can do various things to hide it, but essentially the concept of a blank record in these circumstances doesn't make sense, no.
Okay. I'll see if going to a new record will satisfy my boss. At least I can now tell him for sure that it isn't possible to do anything else.
Thanks everyone.
As Mihail said, why not just hide the autonumber field?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: David |
last post by:
Hi,
I have the following code which adds a record to a table:
vUser = request.form("user") '(UserID = PK in table)
vPass = request.form("pass")
vEmail = request.form("email")
uSQL =...
|
by: Joe Scully |
last post by:
Hi all,
I am having trouble with access adding a blank record to a subform
everytime I finish entering data and closing the form. (The form and
subform are based on the one table)
When...
|
by: Johm |
last post by:
How can i go to the next blank record in the table , such a blank
record exists ?
In my form Customers, i have a command button with the following
command :
DoCmd.GoToRecord , "", acNewRec...
|
by: Bill Hand |
last post by:
Is it possible to open a form from table and have it access a given
record?
I want to be able to query all baseball cards with the last name Jones
and have it open a table. In each record of...
|
by: MMcCarthy |
last post by:
Has anyone experienced this problem and found a solution.
I have a multipage form used to edit specified record. This form opens up filtered to a specified record and its relevant subforms etc.
...
|
by: cmp80 |
last post by:
I have a database that I am using to store student data. There are two tables and two forms to display the data:
Tables
tbStudent
tbRE
Forms
fmStudent
fmRE
|
by: kev |
last post by:
Hi folks,
I have a form for registration (frmRegistration) whereby i have two
buttons. One is Save which saves record using the OnClick property. I
used wizard to create the save button. The...
|
by: lrw0831 |
last post by:
I have the main form where employees enter "issues". Some issues have fields that are the same. My fields are
Issue ID (auto)
Product
Entered BY
Issue Type
Priority
Request from
Status...
|
by: munkee |
last post by:
Is there a way to automatically have a web based data access page to start on a new record when you open the page? (Without going to data entry mode in page properties) If I go to data entry mode,...
|
by: hannoudw |
last post by:
Hi i searched here but i didn't find out how to add a button and when i click on this button to open a new blank record?
I could really need some help. many thanks :)
|
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
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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,...
|
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...
| |