I am using Access 2003 on a Windows XP Platform. I am using DAO to open up a table and export the records to PowerPoint. I'm having an issue where deleted records are still showing up in the table's memory somehow. Even if I delete the table and start fresh, the records still show up.
Set db = CurrentDb
Set rs = db.OpenRecordset("WEEKLY_UPDATE_TABLE", dbOpenSnapshot)
rs.Requery
' Open up an instance of Powerpoint.
Set ppt = New PowerPoint.Application
ppt.Activate
This is the code I use to open the recordset. Any suggestions to get rid of these deleted records?
4  1422 
I am using Access 2003 on a Windows XP Platform. I am using DAO to open up a table and export the records to PowerPoint. I'm having an issue where deleted records are still showing up in the table's memory somehow. Even if I delete the table and start fresh, the records still show up.
Set db = CurrentDb
Set rs = db.OpenRecordset("WEEKLY_UPDATE_TABLE", dbOpenSnapshot)
rs.Requery
' Open up an instance of Powerpoint.
Set ppt = New PowerPoint.Application
ppt.Activate
This is the code I use to open the recordset. Any suggestions to get rid of these deleted records?
I must admit that this is very strange behavior, one that I have never seen before. This is a real shot in the dark, but try changing the Recordset Type to either dbOpenTable or dbOpenDynaset and see what happens.
When I used dbOpenTable, it seems to just continually print records repeatedly. And there is no change when I use dbOpenDynaset.
Any other suggestions?
When I used dbOpenTable, it seems to just continually print records repeatedly. And there is no change when I use dbOpenDynaset.
Any other suggestions?
Would it be possible to send me the Database with a sub-set of the data and a complete and detailed explanation of the problem? If so, I will send you my E-Mail Address in a Private Message and you can send it to me as an Attachment.
Would it be possible to send me the Database with a sub-set of the data and a complete and detailed explanation of the problem? If so, I will send you my E-Mail Address in a Private Message and you can send it to me as an Attachment.
If you don't mind doing that, that would be great!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andrew |
last post by:
Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to...
|
by: Max |
last post by:
Hi. I really hope someone can help me. Going slowly insane with this
problem.
I have a two Access 2000 databases. One is the backend containing
tables and some admin queries. The other is the...
|
by: memememe |
last post by:
I see weak reference on the .net api, but I do not see soft or phantom, are
they supported on .net?
|
by: Rod Billett |
last post by:
The included html contains 3 divs. One primary Div, with 2 nested divs.
the second nested DIV contains an empty table.
Problem 1: Phantom Space. When viewed within the browser, the div 'action...
|
by: Dave |
last post by:
Apologies if this has come up before, but I can't find it if it has. I
am fairly new to .Net and am having problems with ghosts in the
datagrid.
Basically I have a find screen that accepts...
|
by: TB |
last post by:
Hi all:
I realize that this is strictly speaking not an ASP.NET question, but
since most of you people out there SQL gurus as well, I hope you will
bear with me on this occasion:
I would like...
|
by: jegathees |
last post by:
Hi Friends,
I am working in SAP XI Platform. In this, we use XSLT Mapping.
I am facing one problem to print in field 'RecordID' starts from 1,2,3 in the target structure for those records...
|
by: CCHDGeek |
last post by:
I have a client-server DB, main tables in back-end, forms in front-end. The front-end is on each person's individual PC. I'm using the following code to declare a recordset and an instance of...
|
by: Bobby Edward |
last post by:
When I build my solution I get 5 errors. BUT, when I look at the Error List
the 5 errors show up but all the columns are completely blank (Description,
File, Line, Column, Project).
Any idea...
|
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...
|
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: 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...
|
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: 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...
|
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,...
|
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...
| |
