Search results for query: *

Ok, I gave up on the microsoft access. If there is a way, and someone comes here in the future, it would be interesting to know how it can be done. In the meantime we have now moved into using Visual Studio 2005 and crystal 11. Thanks again vidru.

Thanks vidru, I will take a look.

I have a MS Access 2000 form with a crviewer xi. The form allows users to select from a list of reports. When they select a report it appears in the crviewer. This works great - BUT only on my machine which has Crystal 11 Developer. The users don't have crystal at all. I have seen the list of...

Thanks fluteplr and SQLSister. I guessed as much. I think I just needed confirmation. Thanks to you both. kaiuweb UK

Hi, Does anyone know of a way I can monitor users doing a select on a table if they haven't connected via the application. I have a system with sensitive information, the users will access this info through an unbound adp. They have concerns that out IT Staff, who all have full rights as...

Hi people, I'll just briefly mention that this is my first database with SQL Server, so if the following makes no sense and you have a better suggestion then I'd like to hear it. I have created a table called TBL_ENQ_LOCK which stores the primary key of a record from a table caled TBL_ENQUIRY...

Thanks Terry, much appreciated.

Thanks for your replies. What I had in mind was , linking an Oracle table TABLE-X, from SERVER-A to a SQLSERVER-B. When new records are added to TABLE-X on SERVER-A with certain values, then I want SQLSERVER-B to perform a few tasks eg copying the record from TABLE-X to a table within...

Thanks again James and all of you who replied [Thumbsup2]

Well done JamesLean. Your suggestion works and those records are now coming back to me. Thanks. Any ideas what to do now. The end user of the search form is expecting to type in 10/02/03. Is there something that needs 'tweaking' or should I put in extra code that changes the date format to...

Hi All and thanks for the replies. I could put the whole code down but I can't even get this bit to work: Alter Procedure procGetAllEnquiriesLike @myENQDATE varchar(50) As declare @mySQLSTR1 varchar(500) set @mySQLSTR1 = 'SELECT TBL_ENQUIRY.* FROM TBL_ENQUIRY WHERE (TBL_ENQUIRY.ENQ_DATE_REC > '...

Hi John, Thanks for the reply. I have tried your code and the error converting datetime to string has gone, unfortunately it isn't returning any records either. Thanks anyway. Kai

Hi, I am trying to dynamically build sql statement for a search form in a stored procedure. All seems to be going well until dates are entered. I have tried everything I can think of but keep getting error messages about converting strings to dates. When I run the select statement below...

Hi, I am total beginner but have a question. Is it possible to create triggers on linked tables in SQL Server.