'Record Deleted' - Microsoft Access / VBA

John

Hi

I have a janusys (www.janusys.com) grid2000 ex on an access form. From time
to time the clients report a 'Record Deleted' error after which everything
goes blank. No user seems to have deleted any record deliberately. Any idea
what this error could be?

Thanks

Regards

Yahya

Nov 13 '05 #1

Subscribe Reply

2062

Sherwood Wang

"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:41******** *************** @news-text.dial.pipex .com...

Hi

I have a janusys (www.janusys.com) grid2000 ex on an access form. From
time
to time the clients report a 'Record Deleted' error after which everything
goes blank. No user seems to have deleted any record deliberately. Any
idea
what this error could be?

Thanks

Regards

Yahya

Wrong newsgroup, Yahya Moron.

Nov 13 '05 #2

John

Turns out it, it is the right ng; http://support.microsoft.com/?kbid=308630.

Right back at you . :)

"Sherwood Wang" <sh****@waynesw orld.net> wrote in message
news:1098383407 .1RJ1U1T4MGFMkv c+rtFcgw@terane ws...

"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:41******** *************** @news-text.dial.pipex .com...
Hi

I have a janusys (www.janusys.com) grid2000 ex on an access form. From
time
to time the clients report a 'Record Deleted' error after which everything goes blank. No user seems to have deleted any record deliberately. Any
idea
what this error could be?

Thanks

Regards

Yahya

Wrong newsgroup, Yahya Moron.

Nov 13 '05 #3

Sherwood Wang

"Sherwood Wang" <sh****@waynesw orld.net> wrote in message
news:1098383407 .1RJ1U1T4MGFMkv c+rtFcgw@terane ws...

"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:41******** *************** @news-text.dial.pipex .com...
Hi

I have a janusys (www.janusys.com) grid2000 ex on an access form. From
time
to time the clients report a 'Record Deleted' error after which
everything
goes blank. No user seems to have deleted any record deliberately. Any
idea
what this error could be?

Thanks

Regards

Yahya

Wrong newsgroup, Yahya Moron.

is forgery by larry or tony ok?

***Shrewood Wang MVP***

Nov 13 '05 #4

Tony Toews

"Sherwood Wang" <sh****@waynesw orld.net> wrote:

Message-ID: <1098383407.1RJ 1U1T4MGFMkvc+rt Fcgw@teranews>
X-Abuse-Report: http://www.usenetabuse.com

Please ignore the above posting and others which are somewhat bizarre.

Note to persons new to this newsgroup. One person, with many identities, is being
rather disruptive. If you see a bizarre posting it's probably the work of this
disruptive person..

Check the headers of the posting. If you see the following the posting likely can be
ignored. Of course, there will likely be other headers to be added to this list.

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.
or
X-Abuse-Report: ab***@teranews. com
or
Organization: Posted via Supernews, http://www.supernews.com
or
Organization: 100ProofNews.co m - Unlimited Downloads - $8.95/Month
or
X-Complaints-To: ab***@vnet-inc.com
or
X-Abuse-Report: http://www.usenetabuse.com

You can also change your NewsReader program settings to ignore off-topic posts. See
http://www.hyphenologist.co.uk/killfile/ for more information.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #5

Similar topics

1647

I'd like to get rid of new record so that user doesn't notice it.

by: Galina | last post by:

Hello A have an application in MS Access 2000. It has a form (courses), which has a subform (course occurrences), which has a subform (occurrence learning aims). The Learning aims subform is based on a table with a composite primary key of course code ID, occurrence ID, learning aim code and year code. The table also has got a column Deleted (Yes/No): learning aims deleted by users are not deleted from the table, but marked Deleted=Yes....

Microsoft Access / VBA

7830

Delete Current Record In Subform

by: Maria | last post by:

Is there another way to delete the current record in a subform from the main form, another subform or a sub-subform other than setting focus on a field in the subform and using run command acCmdDelete Record? Thanks! Maria

Microsoft Access / VBA

3348

Variables in standard modules, single record entry wiht foreign keys

by: Ross A. Finlayson | last post by:

Hi, I'm scratching together an Access database. The development box is Office 95, the deployment box Office 2003. So anyways I am griping about forms and global variables. Say for example I'm adding a customer. The Customer fields are mostly foreign keys that refer to primary keys in other tables, left join instead of junction tables at this point. So, when I want to add a customer record, I also need to add records to the other...

Microsoft Access / VBA

1808

Putting the Record number in a field?

by: Scott269 | last post by:

So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the database so I could sort the records by the date at which they were entered. Well now I've deleted some of those records so its of course causing gaps in the records. The record number in Access no longer matches my record number that I...

Microsoft Access / VBA

5421

Entering the Record Number in a field?

by: Scott269 | last post by:

Microsoft Access / VBA

2151

adding record to sql db

by: Bryan | last post by:

hello all... im trying to add a record to an sql db on ms sql server 2000, using vb.net. seems to be working.. except for one thing, one of the columns in the database is a bit datatype, and though i get no syntax errors when compiling, i get an error indicated that the data would be truncated. the field is login_status. ive tried in quotes and not, giving it an integer variable with the number 1

Visual Basic .NET

2151

Safely deleting a db record with php

by: MaXX | last post by:

Hi, I hope I'm not OT. I have the following issue: I want to delete a record from my db with a php script. Let's say I'm auth'd and I want to delete the record id 440. With a simple form (get or post), I send the id to my script and delete the record (DELETE FROM table WHERE id=some_validated_input). The problem is if I'm a nasty guy I just write my own form and delete any

PHP

3535

Delete record doesn't work

by: Phil Stanton | last post by:

I have a form based on a complex query (Lots of tables) If I delete a record, everything appears to be OK. Get the message "Youa are about to delete 1 record ....". I say yes. The record count goes down correctly. Then if I do Records-->Remove Filter/Sort there are the deleted records back as if they had never been deleted. Same thin exactly if I do the operation on the form's recordsource query, so that eliminates anything to do with...

Microsoft Access / VBA

17791

Error 3167 Record is Deleted **

by: david720 | last post by:

Error 3167 Record is deleted And Sometimes the main entry form displays a record in the form where all fields are "#Delete" Why do we get this error sometimes (about 2 times a week)? It happens from different users and on different workstations. Also in this application no records are ever deleted and would be difficult for a user to delete a record

Microsoft Access / VBA

9572

Changing the language in Windows 10

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,...

Windows Server

10562

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10319

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10070

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

9132

AI Job Threat for Devs

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7608

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5508

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5639

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4282

transfer the data from one system to another through ip address

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

C# / C Sharp