Search results for query: *

Hi Want to be able to put a line into an ASP page that stops the browser from cache'ing it. As it stands sometimes it doesnt update after underlying data changes. I want it to fully re-run everytime. how do i do this? Thanks Joe

Hi I have a stored proc that returns two recordsets. Is it possible to use both of them in VBA as i can only seem to pick up the 1st one that is returned. Thanks Joe

Hi I have a table with 10000 applications in it each application is made by a person with an ID. I need to be able to find out how many of the people who made applications in the last 12 month period had never applied before. Ive done this in MS access by making a qry for the old data and a...

Hi Outlook 2000 and exchange. If i receive and email from external to the business and click reply to all i am always on the recipients list, meaning if i forget to take my name out i end up emailing myself with my reply. It doesnt do this on a reply to all from a mail from within the...

Hi, im trying the following in a stored proc Select * from tablex order by coalesce(@sortfield, referencenumber) I want it to sort by a field that i pass into it, if it is not provided i want to use the reference number but it doesnt work. I cant build up the SQL text and execute it as i have...

Hi Im trying to make a proc return a list of data depending on what parameters are sent too it. There are 8 parameters all of which are optional. If non are sent it returns all the records if 2 are sent it uses them etc etc How can i build a wher clause to reflect this as it can be different...

Hi Im trying to create a proc to update a single field in a table, but that field can be different each time. ie i pass in the field name and the value i want it to be set to. What i have tried to do build and SQL statement into a string and execute it. This works but only from SQL server not...

Hi im building an update statement from some parameters and storing that SQL statement in a variable. How do i execute it?

Hi in VB a select case is select x case a do this case b do this end select but how do i do this in a proc? I can only find how to do it in a select statement and this is not what i want to do. Thanks Joe

I have a table with fields AA BB and CC My select statement multiplies AA by CC to give my results. However if there is a value in BB i want to use that instead of AA in the sum. Cant work out how to do it, anyone help? Thanks

Hi I have a simple proc that deletes a row from a table. CREATE PROCEDURE [dbo].[SPdeleteRework] @reworkID int AS delete from tblreworkscompleted where reworkID = @reworkID GO But i get the following error: [COLOR=red]DELETE failed because the following SET options have incorrect settings...

Hi I have a stored procedure that i send some params to and it does a whole load of processesing. Within that it has some Return commands to stop the process dead and return a number. If i used the SQL query analyser i can see this on the screen but how can i pick it up when calling it from...

Hi I issue several copies of an MDE file to my users that connect to a SQL server for their data. Whenever i make a change to the database and have a new mde file to pass out i have to chase people to do it which is a pain. If i go into database properties on the file menu i can add a version...

I want to add text boxes to a form depending on the data that is sent to it. I can create a text box in code but how do i get it to display any help would be great thanks

Hi I have IIS 4 running on NT4 and i need to count hits to various parts of my site. Im told i can do this via the log files. If i can how do i get it to log hits and does it just put the in the evenyt log or somewhere else. Thanks Joe

Hi I am passing an update statement into command. How can i get back the number of rows that were affected by the update statement? Thanks Joe PS code.... dim com as command com.CommandText = "UPDATE tblDANs SET DANStatus = xx WHERE DANnumber=yy" com.Execute

Hi Im have me lumbered with a rather extensive Access 2 database fresh from the stone age. I need to convert it to access 2000. There is reams and reams of VBA code in it and when i convert the database over to 2000 much of it does not work, as i expected. Are there any references i can make...

HI 2 dynamic disks in windows XP. Small boot sector to start things off which then choses which OS to load. I have created a striped volume on which i have restored a working OS (XP) into. When i try to boot it says cant find HAL.dll in the system32 directory. It is there. In the boot.ini file...

HI Is there a way of telling where a form is on the screen. If i use docmd.movesize i can move it to a set position but i need to know where the position of other forms are. I need this to open 1 form directly next to another regardless of its position. any help would be great thanks joe

Hi I have now installed VS.net about 5 times but im keep getting an error why i load it up for the first time. This happens on both windows XP and 2000pro If i do a default or full install, when i open VS.net for the first time i little box pops up and says "help is updating to reflect...