Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cannot edit record on an Access ADP form
Cannot edit record on an Access ADP form Access 2002 and SQL 2000 Server I had a form that uses a stored procedure to retrieve a record from a table resided in SQL Server. It did retrieve a record, but when I placed a cursor in any of the text box field to edit it, I cannot edit it...- Lin100
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
How to Convert query with IIF statement into trans-SQL for an ADP form
How to Convert SELECT query with IIF statement into transact SQL for an ADP Form. Access 2002 and SQL 2000 Server. I have an Access database named Supply.MDB I have two combo boxes (Dept, and SO) on a form. I also have a query named Q_FilteringQuery with IIF statement showed below. SELECT...- Lin100
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
What are these dt Stored Procedure in SQL 2000 Server
What are these 31 Stored Procedures that exist in the Northwind, NorthwindCS, and Pubs database in SQL 2000 Server ? 1) What is the purpose of each procedure? 2) How do you use it ? I look it up in the help file but I can 't find any information about it. 1) dt_addtosourcecontrol...- Lin100
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Optional Parameters With Date Range in SP Did Not Return Any Records
I got it solved. It is YES WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date, and not NO WHERE (@From_Date >= titleauthor.Date_Of_Title AND @To_Date <=...- Lin100
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Optional Parameters in Stored Procedure Did Not Return Any Records
Hi Pwise. I have another question that is identical to this one except that included two date fields on an ADP form, namely From_Date and To_Date. Since you have worked on it before I thought you could solve this one easily. Title: Optional Parameters With Date Range in Stored Procedure...- Lin100
- Post #4
- Forum: Microsoft: Access Project (ADP)
-
Optional Parameters With Date Range in SP Did Not Return Any Records
Optional Parameters With Date Range in Stored Procedure Did Not Return Any Records. Optional Parameters in Stored Procedure Did Not Return Any Records. Access 2002 (SP1) and SQL 2000 Server I have an ADP form that have a combo box and three text boxes. Two of the text boxes are use to hold...- Lin100
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
Optional Parameters in Stored Procedure Did Not Return Any Records
Thank you pwise for the solution.- Lin100
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Optional Parameters in Stored Procedure Did Not Return Any Records
Optional Parameters in Stored Procedure Did Not Return Any Records. Access 2002 (SP1) and SQL 2000 Server I have an ADP form that have a combo box and a text box, and I wanted it to do the following listed below: 1) Whenever a user select a value from a combo box, but leave the text box...- Lin100
- Thread
- Replies: 4
- Forum: Microsoft: Access Project (ADP)
-
Access ADP and Stored Procedure Did not Return Any Records
Access ADP and Stored Procedure Did not Return Any Records Access 2002 and SQL 2000 Server I have a form named "Selector", and it have four combo boxes and a subform named Q_FilteringQuery_subform. When any of the combo box is selected, the code will call a VBA procedure which will then...- Lin100
- Thread
- Replies: 0
- Forum: Microsoft: Access Project (ADP)
