Recent content by JohnReaume

Details table are being conveyed in the alias name "dp" in the derived area and in the select statement All editing/deleting and adding are in the form I could have done this as a inline table function and JOIN this SP to that function...I'd get the same issue in the form Note: Your SQL...

Sure, I created this sample SP with the same idea as above ALTER PROCEDURE dbo.Room_Details (@DateID datetime) AS SELECT dbo.Rooms.Category, dbo.Rooms.ID AS RoomID, dp.[Date ID], dp.ID, dp.USRID FROM dbo.[Rooms] LEFT OUTER JOIN (SELECT dbo.[Details].* FROM dbo.[Details] WHERE...

cmmrfds, I'm only editing one table...like the detail table above the Details table is entered in the Unique Table form property to make it edit/delete...but it will not add correctly

Thanks for responding belovedcej Yes, I can add directly in the table and the primary keys and relationships are all present and setup correctly Anyone else had to do this?

I'm hope you can help me with a problem that was not an issue when using DAO-Jet/mdb's Ok I have three tables... #1 (Users) W/USRID as a primary key USRID USRName 1 John 2 Fred 3 James Ect. #2 (Rooms) W/ID as a primary key ID Category 1 Apt#1 2 Apt#2 3 Apt#3...

Part Two... Add the following stored procedure to your existing adp file. CREATE PROCEDURE dbo.ComputerName AS SELECT HOST_NAME() AS DeviceID Run it before and after you change the File/Connection/All/Workstation ID field Notice how the DeviceID changes? Now copy your adp to another...

I have an application that filters several items of SQL data by using the device ID of the source computer. The records are added via VB with a special ID for the valid records, and with the DLL call "GetComputerNameA" to keep the filter specific to the device. Then I run the Stored Procedure...

I have a groups of inventory items (Categories) and linked products under two tables I am using a subdatasheet for the user to click the categories and find the specific product and enter the qty. But I require those categories to be expanded that have been entered in before (if they exit and...

I have developed a application with mscomctl2.ocx MonthView. It is using the GetDayBold function to display 9 months of dates that are stored in a MS Access table It works fine in Acess97 but in AccessXP when you call the GetDayBold function you get the following error... The expression...