Search results for query: *

Found an answer using a cursor... is there a better way? BTW the Stored Proc sp_Do_Ad_Archive performs the Archive action on a per Ad basis ALTER Procedure sp_Do_Archive_Run_Ads As declare @AdID int declare loop_Archive cursor for Select Ad_ID From dbo.tbl_Ad,dbo.tbl_Edition Where Ed_ID...

Hi, I am trying to write a Procedure that will return a set of ID's and then Execute another procedure based on the results Basically I have a working procedure that archives files associated with a single Item_ID, so users can archive on a per Item basis, but I also require someway of...

Hi, We are running Quark Xpress 4.1 on PC. Is is Possible to get Quark to open a document of size X by Y? eg 15cm x 12cm - so that a new Blank Page of the correct size for the job appears in Quark? Not looking for a Pay plugin, but something that Quark can handle?

Simple question, When creating a Rollover button, Do you have to export the button in its two states and change to Gif/Jpg? I would prefer to be able to save the button in native PNG format and then have the page call the correct frame of that PNG So basically instead of having: Button.gif...

Hello, Recently we started having a few problems with some of our windows 98 boxes. Normaly the Directories sort by name but these machines INSIST on sorting by last modified. I have changed these machines to sort by name and saved the settings using the folder options. This works until the...

The Files do exist on the clients E:\ which is a networked drive on another server. - the problem is that the submit does not open the file on the client end.

Hello, I want to be able to have the user click on a Submit button and download a file with one click. The form contains the Current Time and UserID and the file is based upon a passed variable AN. There are 2 buttons basically an Accept <input type=&quot;submit&quot...

Thanks, I used your top example as there is only one item inserted at a time, and it worked a treat.

Hi, I have a SP that accepts a Value (item_id) and then creates a folder under its name. Is there anyway with an Insert Trigger to call the SP and pass the value? something like? sp_itemFolder item_id From Inserted

Hi, Simple problem but cant get my head around it. I have a couple of forms and tables. One table contains the orders including an Order ID (OID) and a Customer ID (CID). When the user Doubleclicks on the CID field in the Forms!Orders it opens Forms!ChangeName containing just the OID and a CID...

Thanks, the Unload event was the one I needed I ended up using the following to get it to work Private Sub Form_Unload(Cancel As Integer) Forms!NewOrders!CID.Requery Forms!NewOrders!CID = Forms!Customers!CID Forms!NewOrders!CID.SetFocus End Sub It would not show the new value until I Set the...

Hi, I have a Order form which has a combo box listing Clients. This is based on a query. The table has 'CID' and 'CName' fields. If the Client is not listed I have a button that calls up another form and prompts the user for the clients details (Name etc). When this second form is closed I have...

Fixed the problem - changed from a report based query to a stored procedure.

Hello, I have an Access 2000 ADP connecting to a SQL backend. I want to print a report of a single record based on the value of a field called OID of type INT. I have tried putting into the reports record source the criteria of OID = Forms!Orders!OID to get its Value but Access 2000 changes it...

Hi, I have a SQL database that contains various date fields and a record number. I want to compare two dates from a record and get the time difference i.e. when the Item was supposed to arrive and when it did actually arrived. Im looking for an output which looks like &quot;Item&quot...

Try this from microsoft itself.... http://www.microsoft.com/windows/ie/downloads/recommended/ie55sp2/download.asp It worked for me with IE6 installed....

Hi, I have a form with variables which I need to submit to a SQL 7 server. When the user Clicks a button I want to send different information to different Stored Procedures on the SQL server based on the button pressed. I've looked at using the onClick call function to call a subroutine as...

Hi, I have a form with variables which I need to submit to a SQL 7 server. When the user Clicks a button I want to send different information to different Stored Procedures on the SQL server based on the button pressed. I've looked at using the onClick call function to call a subroutine as...