Search results for query: *

I've never seen this happen before... I have a textbox on an unbound form for entering a Date of Birth. It has an input mask and the format is short date. mm/dd/yyyy But when I type in 13/10/1978, I'm trying to purposely enter a bad date, the month reverses automatically with the day to give...

Good morning, I have a question.... I'm sure some may recognize to following code, I altered it a bit and it works great but when I click a button called "Search Students", which is a dialog, popup and modal search form to select another record, that form opens with the validation message. Is...

Morning, I've been experimenting with unbound ADP forms using stored procedures for inserting records. And one of the things I've noticed is data validation in a bound form may not work as it did in a bound form. For example.. I have 5 unbound text boxes for collecting and storing data...

Good Morning, I've been using a trigger on my tables that some of you may recognize. It works beautifully if it's on a table where an update is performed on a single record which is the case for most of my tables. Now I need it to work for multirow updates because I have stored procedures that...

Good morning, I've been working on this for a couple of days and I concede that I need some help. This is being developed using SQL Server 2000, Ms Access 2002 ADP. I created a stored procedure (usp_InsertClass) to insert class information. I tested it in Query Analyzer and it inserts the...

Good morning, I've been working on this for a couple of days and I concede that I need some help. This is being developed using SQL Server 2000, Ms Access 2002 ADP. I created a stored procedure (usp_InsertClass) to insert class information. I tested it in Query Analyzer and it inserts the...

Hi everyone, I haven't found anything on this topic so I'm just going to ask it. I have a view that counts the number of classes (TtlClasses) an Instructor has taught. It is comprised of two tables, Instructors and Classes. And they are linked with a Left Outer Join on the Instructor table to...

Hi all, I'm working with an ADP Access 2002 FE and a SQL Server 2000 BE. Just wondering... I'm using a Dlookup function to return a messagebox if a Social Security Number is already in use. In SQL Server it's stored with no template characters, 555555555. On the ADP, I have an input mask...

Good morning, I have a query with a derived table that is not returning all the results. I'm trying to get the Max record of an Instructors certification and it returns them if the Instructor has more than one certification but not if they have only one certification. SELECT IC.certificationID...

Hi everyone, I'm using an ADP Access 2002 fronted with SQL Server backend. I have a Main form that displays Instructor records and a subform where employees add certifications There are 3 types of certifications.. 1 TSP 2 BSP 3 HSP Instructors can be certified for any of these...

Good morning Gurus! I wrote my first stored procedured and I'd like your expert opinion on it. Just in case I need to do any fine tuning. It is a combination of insert and update. At 24 months, if an Instructor has participated in teaching a class either as a primary Instructor or an Assistant...

Hello, I have a view that returns records based on whether an Instructor has not taught a class within a 22, 24 or 25 month period and what classes an Instructor has taught are outside the date range specified in the WHERE clause. My problem is there might be Instructors who have never taught...

Merry Christmas Everyone! Have a question for you. I have a Combo Box on a subform in datasheet view that allows the user to select a SSN of an Assistant who participated in a class. There are no limits to the amount of Assistants a user can enter for a class but I do not want them to be...

Hi all, I'm using MS Access 2002. I have a main form and subform. The main form has an unbound combobox used to select a class number and some unbound textboxes to display the Instructor of the class. After selecting the appropriate Class, the user tabs into the subform and the cursor moves to...

I've been messing with this on and off for days. I have a DLookUp expression in the Default Value of a textbox control on a subform. For the life of me I can figure out what is wrong. I believe I have the Forms referenced properly because another variation of this expression works in a...

Hi Gurus, I'm trying to learn more about Stored Procedures. I don't have alot of time to practice with them but I created a Stored Procedure with two insert statements. It's supposed to perform inserts on two tables in a parent/child one-to-many relationship but I'm not sure if I have it right...

I need to be pointed in the right direction.... I have a Windows Form to insert a record into an "INSTRUCTORS" table. It works great but I need a MessageBox to appear when a Social Security Number is already in use. I also need it to display the name of the Instructor the Social Security...

Hi everyone, I came across this trigger a few days ago and modified it to track updated fields only (No inserts or deletes)from my Instructors table to the Audit table. Works great!! But I have one more problem that I can't seem to fix. I need to include the InstID (InstructorID) which is the...

Hi everyone, I'm not sure if this is the proper forum for this question. I apologize if it's not. We've recently installed Visual Studio 2005 and we are just learning the environment. One of our staff was creating a ASP.Net Web site and has suddenly lost the ability to drag and drop any and all...

Hi Everyone, I done a lot of reading and I find I'm more confused than ever. I have an ADP frontend with a SQL Server 2k Backend. I created a form to enter new records into a table. What would be the best way for users to enter new records without directly compromising the table? My...