Search results for query: *

Hi, I have been working on the piece of code below in a DTS package. The two lines highlighted are causing problems. The 1st one I am getting an error with is saying that their is a type mismatch. In the table currentpractice is a varchar - am I declaring it incorrectly? The second line says...

Hi, I would like to export the files created by activeX script to be automatically saved to a predetermined location on the execution of a DTS package. I have checked the code using Visual Basic compiler and seems to work. When I put it into DTS package - the code executes however the file is...

Sorry if this is not directly related to this forum - was not sure which one to use. I am trying to get the code below to run, I am planning to hopefully get this running through a DTS package. However I keep reciveing an error 429 cannot create ActiveX component. I have tried installing...

Hi, I have not used crystal reports before and dont really know where to start. I have a SQL Server database with a Stored Procedure which pulls out all the information needed for the reports which i would like to generate. I plan to run this each night based on a SQL Server scheduled job so...

I have created the stored procedure below to create reports based on a number of months. This works fine when there is only one record inserted into the temp table. If there is more I get the following error:- Subquery returned more than 1 value. This is not permitted when the subquery follows...

I have a CDO stored procedure which works and send out emails. However I would now like the body of my email to be HTML so that I can apply formatting to the text. However I am unsure how to set up the HTML tags and where to put them. I have change the main SP to this:- EXEC @hr =...

I would like to run a store procedure for every record in a table. Go to the first record send an email Go to the second record and so on until every record has has an email sent. I was just wondering how you do this in a SP, currently the SP only does it for the one record Thanks in advance.

I have created an macros in an adp project that does exactly what I would like it to do. Replaces a current Excel file with the new information. The problem is that this needs to be run each week and I would like some way of automating it.I have tried doing this all in SQL Server however you...

Hi, I have set up a DTS package which links to an Excel document. This document is going to be updated on a weekly basis. However the problem is that when I run the query, the rows just append to what is already there and I would like to replace them. I then tried to use an SQL Task in the...

Hi, I am trying to catch errors for null primary key or duplicate keys. I have put the following code into the forms OnError event. I am using an adp project with a SQL Server database. I think I am catching two error the SQL Server one and Access one and only displaying one message. If...

Hi all, I have an unbound control on a form which is based on the following fields from an Employee table(Empolyee_Id and Surname. When the users selects one the ID is stored. i have another form which is based on all the details from the Employee table. If I was in this form and selected to...

Hi all, When I put a Combo box on my form, I do not have the option to:- Find a record based on the value of the combo box. This use to be available, have I set a property on the form which I should have not. Thanks

Hi all, I have created the following stored procedure however I keep getting an error saying that there is an error near the SET. Am i right in assuming that I could use the output of the query in an adp project with VB. I could say if output greater than 2 then ...... CREATE PROCEDURE...

Hi all, i was just wondering if it was possible to prevent a user from editing a database field on a form. So they would be able to enter a value once and then they would be prevented from entering it again. i.e. locking the fields for edits Thanks in advance

I have a problem preventing the same error message appearing twice. If you try to enter a null primary key and then close the form, you get error 515. Which I have successfully trapped in the below code. If dataerr = 515 Then If MsgBox("Are you sure you want to exit and not save the current...

Hi all, I have 6 tables which are to be shared between two databases. The input to these will occur through two seperate adp Access projects. i believe that you can do this with triggers - when anything changes in one table -update the other tables across d/b on the same server. When a...

I have tried this question on another forum and it was suggested I try this forum so sorry for anyone reading this twice. I have a form when I try to enter a null primary key I get runtime error 515. I have trapped this error in the OnError() event of the form. Which works fine. However this...

Hi all, I have created a front end in an Access adp project. I have forms for the input of information based on tables in SQL Server. I have a problem if i select to enter a new record or move to another form and dont complete all fields including the primary key. So when I go to save I have...

Hi, I would like to be able to load my forms up in full view, i have tried using DoCmd.Maximise. Which opens the form in a maximised window. However I would like the user to be unaware that there are in Access and therefore would like to know how to make the menus and pulldown menus etc not...

Hi, I am pretty new to SP's and I have created the SP below:- CREATE PROCEDURE [update_Practices_1] ( @No_Old [varchar](6), @No_New [varchar](6) ) AS UPDATE [Temp].[dbo].[Practices] SET [No] = @No_New WHERE ( [No] = @No_Old ) GO With @No_Old and @No_New being the values of...