473,569 Members | 2,768 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

form does not show records in dynaset mode, only snapshot

9 New Member
hi!

i'm at a loss here.

after creating my form, I added data to it and the next time I started access, it did not show any of the records- they are still in the table but are not shown!!

I played with some settings and found out when i change the form type from dynaset to snapshot, I can see the data, but cannot create new entries.

I've enabled the option Cascade Update Related Fields within the relationship manager but to no avail

thanks :)
Jan 25 '08 #1
3 8080
missinglinq
3,532 Recognized Expert Specialist
You have the Data Entry Property of your form set to Yes. This means that you can only add new records; you cannot view existing records.

When you change Recordset Type to Snapshot, in essence you reverse this because, as you found out, a Snapshot recordset is not updatable, you can only view existing records.

Set Data Entry to No and change Recordset Type back to Dynaset.You can now add new records and view existing records, which means when you open the form, the records you previously entered will be there.

Linq ;0)>
Jan 25 '08 #2
gismar
9 New Member
You have the Data Entry Property of your form set to Yes. This means that you can only add new records; you cannot view existing records.

When you change Recordset Type to Snapshot, in essence you reverse this because, as you found out, a Snapshot recordset is not updatable, you can only view existing records.

Set Data Entry to No and change Recordset Type back to Dynaset.You can now add new records and view existing records, which means when you open the form, the records you previously entered will be there.

Linq ;0)>
again this is exactly what was the case so all thanks to you :D
Jan 25 '08 #3
missinglinq
3,532 Recognized Expert Specialist
Glad you got it working!

Linq ;0)>
Jan 25 '08 #4

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

Similar topics

4
3854
by: Tim Marshall | last post by:
This is an embarrassing question to which I should know the answer, but I am not 100% sure of myself. My applications, whether they are Jet or Oracle usually deal with reporting on existing apps that others have done and except for the odd single user app, I don't do many transaction type applications.... Anyways, I have an unbound form...
7
14349
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to display the graph but it is not possible to send query parameters to an OLE graph on a report (or programatically change any properties of an OLE...
4
2895
by: Pierre | last post by:
Hi all, To ease load on a network i close automatically form open with a timer reset by user actions. If the time is expired i go through the collections of form and table and close all those that are open. I choose this way to avoid putting code in each form, plus i can close all open table if any
2
2017
by: tdmailbox | last post by:
I have an access form that has VB code to enable and disable individual fields depending on the state of other fields. That works great. However, now I am looking to create a read only version of these forms so that managers can review data entered without messing it up. Is it possible to call these forms as read only? My concern is I am...
2
1482
by: MLH | last post by:
I feel pretty lucky on my last SQL question. I think I'll try one more... If there is a table (tblCorrespondence) with a field in it named and I am extracting a dynaset of records having an value of "06"... - Lets say the query displays , , and . And lets say that for every record in the table having an value of "06", I would also...
9
2808
by: Rajat Tandon | last post by:
Hello there, I am relatively new to the newsgroups and C#. I have never been disappointed with the groups and always got the prompt replies to my queries.This is yet another strange issue, I am facing. Please please help me to solve this as soon as possible. So here we go ... I am not able to take the screen shot of the windows form...
6
3787
by: MLH | last post by:
When the vehicle entry form (frmVehicleEntryForm) first opens, the additional owner SubForm control (frmAddnlOwnrListSubForm) is enabled. You can click on it and it will accept the focus. But after you enter data to the first field on the main form (a VIN#), that is not the case. The SubForm control becomes disabled and will not accept the...
7
1899
by: MLH | last post by:
But now here's the catch - I want to see information from an earlier record in the table. Suppose the correspondence table had these five records ID VehicleJobID OutDate OutType 1 150 11/24/06 14 2 151 10/12/06 14 3 152 11/24/06 11 4 ...
4
2747
by: Roger | last post by:
on sql 2005, I've got a view with select permission granted, the view just "select * from table" using odbc in access97, I linked this view and I create a query to retrieve certain fields the query properties are 'no locks' and dynaset record type but just executing the query as a datasheet, locks some records in the original sql server...
0
7695
marktang
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...
0
7922
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8119
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6281
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5509
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5218
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...
0
3653
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...
1
2111
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
1
1209
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.