473,398 Members | 2,812 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,398 software developers and data experts.

Problem cycling records

Hi!

I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1, despite more records
already being entered in the table.

If I add a new record it is saved in the table and the total count of
records is indeed increased by one. I can than scroll to the two
records but it is not possible to scroll through the records that were
put in the table before I last time opened the form. Adding new
records works, and also scrolling through them works until I close the
form and reopen it. Than the stories continues from the start again...
no records until I start adding, but the previously entered records
aren't taken into account.

Can someone help me solve the problem or give a hint where to look
because I'm stuck!

Thanks!

Jonathan
Nov 13 '05 #1
5 1536
here's just a few ideas..... is there a filter set on the form? is the
source of the form the table it's self or is it on a query of the table. I
would imagine that the latter of the 2 is the case where the query it is
based on specifies that a field is = "" or is null.

Mark

"-:= Cactus" <jo**************@gmx.net> wrote in message
news:23*************************@posting.google.co m...
Hi!

I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1, despite more records
already being entered in the table.

If I add a new record it is saved in the table and the total count of
records is indeed increased by one. I can than scroll to the two
records but it is not possible to scroll through the records that were
put in the table before I last time opened the form. Adding new
records works, and also scrolling through them works until I close the
form and reopen it. Than the stories continues from the start again...
no records until I start adding, but the previously entered records
aren't taken into account.

Can someone help me solve the problem or give a hint where to look
because I'm stuck!

Thanks!

Jonathan

Nov 13 '05 #2
jo**************@gmx.net (-:= Cactus) wrote:
I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1, despite more records
already being entered in the table.


Jonathan,

Is the form's "Data Entry" property set to 'Yes'? If so set it to 'No' and
try again.

HTH - Keith.
Nov 13 '05 #3
Hi Jonathan,

Check the properties of your form. Under the 'Data' tab, I suspect your
'Data Entry' property is set to 'Yes'. Change it to 'No' and all should
be hunky-dory!

-------
LoopyNZ
-------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4
Hi Mark,

I already thought of that as well, did a check again. The record
source is the table itself and there are no filters applied in the
form, the filter entry in the form properties window is empty.

There are however, a few listboxes that look up some values in the
table used as record source. IMHO that shouldn't be a problem because
the cycling of records works during the 'session' (opening the form
entering records, scrolling through the entered records, clsoing the
form). What do you think?

Jonathan

"Mark" <ma*********@ntlworld.com> wrote in message news:<Oc**********@newsfe3-win.ntli.net>...
here's just a few ideas..... is there a filter set on the form? is the
source of the form the table it's self or is it on a query of the table. I
would imagine that the latter of the 2 is the case where the query it is
based on specifies that a field is = "" or is null.

Mark

"-:= Cactus" <jo**************@gmx.net> wrote in message
news:23*************************@posting.google.co m...
Hi!

I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1, despite more records
already being entered in the table.

If I add a new record it is saved in the table and the total count of
records is indeed increased by one. I can than scroll to the two
records but it is not possible to scroll through the records that were
put in the table before I last time opened the form. Adding new
records works, and also scrolling through them works until I close the
form and reopen it. Than the stories continues from the start again...
no records until I start adding, but the previously entered records
aren't taken into account.

Can someone help me solve the problem or give a hint where to look
because I'm stuck!

Thanks!

Jonathan

Nov 13 '05 #5
Hi!

This suggestion worked indeed... but the problem with using a
switchboard is that you can choose to open a form in either add mode
(form with DataEntry set to TRUE) and in edit mode (as a table).

Therefore I had to add the Me.DataEntrye = False line to the Form_Load
sub to keep it opened with dataentry set to false.

Thans very much for your suggestions, they pointed me to the solution!

Jonathan

LoopyNZ <Lo*****@NOguruSPPAM.net.nz> wrote in message news:<41**********************@news.newsgroups.ws> ...
Hi Jonathan,

Check the properties of your form. Under the 'Data' tab, I suspect your
'Data Entry' property is set to 'Yes'. Change it to 'No' and all should
be hunky-dory!

-------
LoopyNZ
-------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #6

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

Similar topics

3
by: robbiehenry | last post by:
1. robbiehe...@gmail.com Sep 19, 1:48 pm show options From: robbiehe...@gmail.com - Find messages by this author Date: Mon, 19 Sep 2005 10:48:50 -0700 Local: Mon, Sep 19 2005 1:48 pm...
2
by: Anshul | last post by:
I have a typical scenario to work with and seeking help for the same. The scenario is. 1) I have to write some code in Managed C++ and C# code. 2) Managed C++ will interact with Native windows...
2
by: flash1600 | last post by:
I am using Access 97, yes I know Access 97 not by choice, I am adding a new record to a table with a Primary Key set with an auto number incremented by 1. I have the following code to find the...
4
by: crescent_au | last post by:
Hi all, I'm doing some research online on creating php-based multi-level marketing (MLM) system. It seems like a complicated system to build as I need to create one from scratch. I'd like to...
23
by: buzz25 | last post by:
Hi, I have a simple table and a form associated with it for data entry. I wanted to allow users to be able to open a specific record on the form for data entry. I therefore created a separate form...
2
by: ndeeley | last post by:
Hi, I've created a database which shows the usual record button bar at the bottom of the form to cycle through records. However when editing a particular record my users are accidently touching...
81
by: =?utf-8?B?4piG4piG4piG4piG4piGIFPDvCBLZWl0aCBDaGFr | last post by:
Installed this compiler on Vista; a simple "hello world" after compiled and run would pop-up a window "source file not compiled" I've seen this question asked a few times on Internet groups and...
8
by: Rajneesh Chellapilla | last post by:
Hi I have a general question about cycling background colors. when using background color: rgb(0,0,0) is it ok to write if {i<250){
3
by: jock1up | last post by:
I am working with javascript...where I have cycling banners at the top, 3 of them and I need to make two of them clickable to a website that I assign to the two. bannerad2 for www.bigmtn.com and...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
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...
0
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...
0
agi2029
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,...
0
isladogs
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...

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.