Can anyone tell me a simple method of creating an application in Access
2003 that uses "Double data entry"? For me double data entry is defined
as the ability to have data entered twice. The first entry is entered
into the database, the second entry is checked against the previously
entered data, discrepancies noted during second entry are communicated
and during the second data entry there is an option to correct or
accept either value. The end result is one database that is a higher
quality based upon two independent entries of source data into the
database.
I have created a sample database that has a Switchboard form (Main
Switchboard) which opens the same form (Form1) in "Add" and
"Verify". I request for somebody's help with VBA code to enable
the verify mode of form, according to the requirement as mentioned
above. I have been struggling to do this for long time, but in vain.
Any help in this regard will be highly appreciated.
Thanks in advance for all your help.
0  2131  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: M Wells |
last post by:
Hi All,
I'm trying to implement encryption on certain data fields in my MySQL
database and I'm experiencing ongoing problems.
I seem to be able to encrypt the data without issues, but can't figure
out how to decrypt the data.
My field in my test table, in which I'm storing the encrypted data, is
a TEXT type field.
|
by: Sandros |
last post by:
Background: I'm collecting usability statistics for a group of
applications. Each count has the following attributes: date,
application, major heading, minor heading, count. My intent is
to pull this back as XML and render it in to an HTML table.
I have all this working and all the files are below. I would
value any feedback.
A simple example of the data looks like this:
|
by: sara |
last post by:
I am learning with a simple application/form. I am ok - enter customer
name, list box of customers, select a customer, see the items for that
customer.
The items form has customer ID and Name in the header; details on
continuous form in detail.
I want to press a button "Add Garment" and open the customer item form
with the customer ID and Name from the view of the form, but open it as
Data Entry so the user can add garments.
|
by: Sethos |
last post by:
I am sure that this has been covered, hashed, and rehashed, but a
search on the group did not produce the answer, so forgive me if this
seems like a "newbie" type question...
Besically, I have a form on which the users can click on a button to
add text boxes dynamically. That all works without a hitch. The problem
comes in trying to verify the information in the boxes.
Below is a very abbreviated example of the code I have in the form:
|
by: SBC News Groups |
last post by:
I have a field on a form that when a user enters a number, I want to verify
that the number is already in another table.
For example:
If a user enters 100 in the control Bidder, I want to check a table to see
if that number has been entered. If it has not, then I want to warn the user
and clear the data. If the number does exist in the table then nothing need
to happen.
The form is NOT based on the table that I want to verify agaisnt.
| | |
by: hippomedon |
last post by:
Hello everyone,
I'm looking for some advice on whether I should break the
normalization rule. Normally, I would not consider it, but this seems
to be a special case.
I have created an "Outcomes Database" used to store response data
from measures/ questionnaires for a longitudinal health study. It is
essentially derived from Duane Hookom's Survey Database (thanks
Duane!!!), with many modifications added to fit the needs of my lab.
|
by: rustyc |
last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-)
As I said over there:
... for a little side project at home, I'm writing a ham radio web site in uby/Rails. I started it in Perl and gave up on Perl as I went from the 'display the database information on the web page' to the 're-display the information from the database and allow the user to update the database using the web page' stage and realized...
|
by: admin.offshoredataentry |
last post by:
Data Entry Outsourcing provides time bound, cost effective and
qualitative Data Entry also provides numeric data entry, textual
data entry, image data entry, data format, data conversion and also
online data entry, offline data entry with 99.98% accuracy and time
bound.
Data Entry Services also provides form data entry, data capture, HTML/
SGML coding, image scanning, file conversion with low cost,high
quality, 99.98% accuracy and...
|
by: Mike Copeland |
last post by:
How do I work with a std::list that might have multiple objects
having the same "key", but which have other data that is different?
Here's code that compiles, but doesn't do quite what I expect:
(Please note that there's some specialized I/o code here, but the
logic flow should be clear...)
struct GenCheck // Gender Check data
{
char genCode;
int useCount;
|
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: 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...
| | |
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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
