473,728 Members | 1,619 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Alert or Preventing data entry?

I am using Approach 9.8 and have set up a appointment database with
the following fields.

DATE, TYPEACTION, TIME, WORKER LASTNAME FIRSTNAME

I do not want my clerical staff to be able to key in a date if

DATE is the same, TYPEACTION=LEAV E, AND WORKER is the same.

I can use the Combine function and prevent data entry by using a
modification formula and unique code to prevent a duplicate entry for
DATE, TIME, AND WORKER.

I have been unable to get it to give me an alert though for
Combine(DATE, TYPEACTION ='LEAVE', WORKER).

Any help with this problem would be very much appreciated.

The reason I am using this newsgroup is that I am not getting any
answers from the Approach group.

Thanks for any help.
Nov 12 '05 #1
1 1458
I've no idea how to do this with Approach but you should be able to use
an INSERT trigger to prevent a duplicate row for the specific 'LEAVE'
action. The trigger can raise an error that would be passed back to the
application as any other SQL error is.

Phil Sherman
Randy wrote:
I am using Approach 9.8 and have set up a appointment database with
the following fields.

DATE, TYPEACTION, TIME, WORKER LASTNAME FIRSTNAME

I do not want my clerical staff to be able to key in a date if

DATE is the same, TYPEACTION=LEAV E, AND WORKER is the same.

I can use the Combine function and prevent data entry by using a
modification formula and unique code to prevent a duplicate entry for
DATE, TIME, AND WORKER.

I have been unable to get it to give me an alert though for
Combine(DATE, TYPEACTION ='LEAVE', WORKER).

Any help with this problem would be very much appreciated.

The reason I am using this newsgroup is that I am not getting any
answers from the Approach group.

Thanks for any help.


Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
1869
by: F. Da Costa | last post by:
Hi, This is a strange issue I'v been staring at for half a day now. It concerns catching keys via the onkeydown handler. In IE5+ it works fine but in Moz 1.6 (& Firebird 0.7+) it behaves most peculiar. The 'offensive' code is included below. The weird thing lies in the alert box preceded by // **. * function textboxReplaceSelect *
4
3627
by: Drew | last post by:
I have a permission tracking app that I am working on, and I have made the insert page for it. I am having issues on how to prevent duplicates from getting entered. Currently the interface for the app has a mixture of select boxes, list boxes and checkboxes. The form submits the page to processAIMR.asp and then does the inserting. I am using a loop to insert a new record for each checkbox checked or listbox entry selected. My...
1
1830
by: Wayne Aprato | last post by:
Is there an effective method of preventing users from accidentally or maliciously deleting the database file/files from a shared network drive? At the moment, I'm using a batch file to copy the data.mdb to another secure location every time a particular user who performs most of the data entry exits the database. Setting the windows permissions for the database folder to "read only" seems to create problems and data entry users obviously...
3
2176
by: ColinWard | last post by:
I am using the following code to validate that the person that is being entered into the database does not already exist. However wnem I test it by entering myself as a contact(I first checked that I was indeed NOT in the database), the message still comes up saying that I am in the database. what am I doing wrong? Private Sub txtEmailName_AfterUpdate() On Error GoTo Err_txtEmailName_AfterUpdate >> If DLookup("EmailName", "Contacts",...
2
3154
by: Seth | last post by:
I have a query with field names and . When I access any given record in form "test", I want the user to be alerted if there is more than one record with the same first name and last name. This is different from most posts I've read in that this doesn't happen upon data entry since my data is imported and already verified. Duplicate first and last names do legitmately exist in this application and therefore I simply want to be notified...
5
2950
by: Darrel | last post by:
I have a web form that inserts a record into a DB. This function is called from the button_click subroutine. After the record is inserted, I show/hide some different panels and let the page postback. The problem is that if a person reloads this page after submitting, a new record is inserted into the DB. Short of doing an actual compare query prior to entering the new record, or
1
2003
by: pcnorb | last post by:
I have a form, pulling data from a Products table that has many fields that do lookups to other tables. These are in a one-to-many relationship to a pk in each of said tables. I'd like to be able to compare the data on a BeforeUpdate event to be sure that this data is not duplicated. Here is the structure: Products 8-1 Frames
19
5743
by: ivan.leben | last post by:
Let's say I have a piece of allocated memory which I want to expand and reuse if possible or allocate in a different part of RAM if resizing is not possible, however, in the latter case I don't care about the old data and I don't need to copy it to the new location. Is there a standard function that could do that? As far as I understand the description of the realloc() function, it _always_ copies the data to the new location, even if that...
2
8410
by: mikemiller.innova | last post by:
I developed a C# Windows App that requires a user to input their real name and what they did to the server while they were online. I am going to launch the app att shutdown via a logoff script. I want to prevent the computer from logging off or shutting down until the app is closed. The best example I have is when you have an unsaved notepad.exe document open and logoff or shutdown, an End Program dialog pops up
0
9418
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9272
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9196
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,...
0
9129
tracyyun
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...
1
6712
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4790
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3235
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
2
2651
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2160
bsmnconsultancy
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...

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.