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 5 1554
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.goog le.com... 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 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.
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!
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*********@nt lworld.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.goog le.com... 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
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*****@NOguru SPPAM.net.nz> wrote in message news:<41******* *************** @news.newsgroup s.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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
Subject: javascript cycling graphic does not work on MAC IE
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
I built this page for my company's corporate website
|
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 service.
Detailed Information
C++ Dll
When the native windows service start, it calls its own callback Init (
) method in our C++ dll (coz these methods are exported from this dll).
|
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 highest
number. It works great 99.9% of the time then, it will just stop
working it doesn't find the highest numbered record. I can't replicate
the problem, but I can fix it by compacting and repairing the DB. I
would like to know why?
prime =...
|
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 know if there are
open-source CMS tools or MLM tools available that helps me to customize
or even upgrade to the kind of system I'd like to have.
I'd like to know how should I start building one from scratch- just the
logics or algorithms that I...
|
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 with a control for choosing record ID's. After choosing a record ID users are taken directly to that record on the main form.
This is the problem: Once users are at their chosen record on the main form, I want them to be able to cycle through...
| |
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 the pinwheel on their mouse, causing it to cycle to the next record (or even further). They don't notice of course and edit the wrong record.
Is there anyway I can lock the form so that they can only edit the current record and not cycle to any...
|
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
noone seems to have figure it out.
What is going on?
|
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){
|
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 bannerad3 for www.bridgerbowl.com Not sure how to get this to work right, have tried some things and it usually ends up making duplicate banners above the original, which I don't want. Here is some of the code for now:
<html>
<head>
<title>Ski...
|
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: 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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |