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

How do I set a form to automaticly start at new record and not overwrite first record?

?????
Nov 13 '05 #1
3 1528
It would be helpful if you asked your question in the message content and
give a topic in the subject line.

If you mean to ask how to open your form to a blank record, open your form
in design mode, view properties, set the Allow Additions and Data Entry
lines to "Yes". How will you view/edit existing records?

-Ed

"noname" <no*************@nospam.net> wrote in message
news:eC*******************@fe03.lga...
?????

Nov 13 '05 #2
Sorry about the subject line question I thought it would be easier to read
it like that..
I will view the existing records in table form.

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:5T*****************@newshog.newsread.com...
It would be helpful if you asked your question in the message content and
give a topic in the subject line.

If you mean to ask how to open your form to a blank record, open your form
in design mode, view properties, set the Allow Additions and Data Entry
lines to "Yes". How will you view/edit existing records?

-Ed

"noname" <no*************@nospam.net> wrote in message
news:eC*******************@fe03.lga...
?????


Nov 13 '05 #3
A database is NOT a spreadsheet; few, if any, users should be doing data
entry in tables. They are NOT cells that can hold values and formulas, they
are just an unordered storage collection. Create a query to
order/filter/sort your data, then create a form for data entry/editing.
Look at some of the sample databases and/or template generated ones for
examples.
-Ed

"noname" <no*************@nospam.net> wrote in message
news:dH******************@fe03.lga...
Sorry about the subject line question I thought it would be easier to read
it like that..
I will view the existing records in table form.

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:5T*****************@newshog.newsread.com...
It would be helpful if you asked your question in the message content and
give a topic in the subject line.

If you mean to ask how to open your form to a blank record, open your
form
in design mode, view properties, set the Allow Additions and Data Entry
lines to "Yes". How will you view/edit existing records?

-Ed

"noname" <no*************@nospam.net> wrote in message
news:eC*******************@fe03.lga...
> ?????
>
>



Nov 13 '05 #4

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

Similar topics

4
by: Skully Matjas | last post by:
I am using the following code (created by the wizard) to allow to bring my form to a particular entery. But when I edit the entery (ex: put new information into a blank cell), it puts that record...
0
by: Jeff Pritchard | last post by:
This is a twisted little problem. A client has an Access 2000 front-end using linked tables to a DNS to SQL Server 2000 back-end. With an Access 2000 back-end there is no problem. The problem...
15
by: Steve | last post by:
I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any...
11
by: Doug Bell | last post by:
Hi, I am trying to create form that displays data like an Access continuous dataform rather than using a data grid. I am thinking that I can achieve this by creating a row of text boxes, one...
2
by: neilphan | last post by:
Hi Guys, I need a quick reference to Windows Application Development in dotNet. I'm fairly good at the Web Development using asp.net though i'm new to the Windows Desktop Application...
4
by: Arif | last post by:
I entered 5 records and closed the database, however, when I reopen to start data entry it starts from the first record. This posses a risk that mistakenly the entry operator may overwrite data. Is...
13
by: katysei | last post by:
I have to print several large structs to print the screen. I was wondering if thers a tool to do so automaticly struct A { int i; char * s; }
2
NeoPa
by: NeoPa | last post by:
CHAPTER 1 - TABLE OF CONTENTS (Including attached database) CHAPTER 2 - INTRODUCTION CHAPTER 3 - TABLE LAYOUT CHAPTER 4 - FORM LAYOUT CHAPTER 5 - FORM MODULE CHAPTER 6 - CODE DISCUSSION (FILTER...
5
by: David Wright | last post by:
Hello Everyone I would be grateful if someone could help me with the automatic increment of a field on my subform called ‘Test_SrNo’. I am Using Microsoft Office 2000. The auto entry of the...
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...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.