Search results for query: *

Im reasonably familiar with VBA but havent really done anything with Excel before so my question is how much information does Excel need to do my above request. Do I need to set a workbook object up or can I just reference the book somehow? Im looking to do this off the push of a button rather...

Hi all, I am trying to create a link that will use a browser to log into an FTP site, the problem I have is the password starts with a hash (#) character. For some reason when I place a colon and hash together in the link itself my browser is converting it to a forward slash (/) Heres the code...

Hi, I'm rather new at this as I haven't much experience with Novell but I seem to be having an odd problem. When I set up an FTP user if I give Write but not Read the user cannot upload or download. If i give Read but not Write the user can upload and download. Shouldnt these rights options...

Hi all, I have a need for one of my systems to programatically log into a secure PC to retrieve files and then to log out again. I have looked through the FAQ's and searched for it but I can't find anything pertaining to this problem. I'm comfortable with having the windows username and...

Hi, I need to search a directory for 2 different file types (extensions) and do stuff according to the files found. I figured using the Application.FileSearch would be the best bet but I could be doing this search (across a network) up to four hundred times in one procedure call. With...

Hi, I'm not sure this is the right forum for this but here goes; I have some legacy code for displaying dates based on the records in a query. For vWeekday = 2 To 6 '########### label all dates #################### vDespatch = Null strCriteria = "WeekDay(IdealDespatchDate) = '" &...

Hi, I have written a script to deal with the end of payment process at WorldPay. Amongst other things this script takes a html template and replaces blocks with the order info then prints the template to screen. My problem lies in the fact that the worldpay server seems to output one line...

Hi, I have been working on some locking code but now I'm stuck on the last hurdle! I need a 'catch all' piece of code that will check the time stamp of the lock file and if its old delete it and start the locking proccess anew. After looking at the Stat function I presume I can use the ctime...

I have a form upon which a user can select from a list of account numbers. When the user selects the account number I have 2 form fields which I need to change reflecting the account name and an email address associated with the account. How exactly would be the best way to go about this? My...

Hi all, I am building a letter based on a load if parameters, the best way I have found so far is to create a master string variable and add to it the bits of text I need based on my criteria. The problem I have is I need some lines to be bold and others to be underlined, I seem to recall...

I am trying to create print buttons in a PDF document that will print just the current chapter.I dont have a problem with making the button but what should the script look like? I really don't have a clue here so even a push in the right direction would be appreciated. Sim :)...

I am a little stumped as to what I need to set in the connection string so I can open an ADO recordset and read directly out of a text file. Can anyone please point me in the right direction. Simon ---------------------------------------- Of all the things I have lost in my life, the thing I...

I have a Stored Procedure sat in my Server which I call from and Access2000 frontend, see code below; CREATE PROCEDURE dbo.procMailDates @StartDate datetime, @EndDate datetime, @Account int AS SELECT OrderNo,[Purchase Order Number],KPShipmentID,[Required Delivery...

I have written a stored procedure to extract rows from an SQL table and I call the proc from VBA below id a snippet of the code I use. ::Stored Proc:: CREATE PROCEDURE dbo.procMail @Date datetime, @Account int AS SELECT [LOADS OF FIELDS] INTO MailTemp FROM Orders WHERE Orders.AccountNo =...

I have recently moved from access client/server to access client / sql 2000 server and I am looking into ways i can speed up my code. Scenario: I have one table of Orders, each row contains an OrderNo field and a MainOrderNo field. When shipped the orders can be combined, at this time the...

I have an updated ADO recordset that i would like to push into a new excel book. Is this possible or do i need to store my recordset in a temp table and pull data from there? Reason: I am creating an excel file to mail to a customer and I change the data so it is more readable for said...

I have an image as a background for a <td> tag, the cell is just for a link. The text in the tag is quite small so I would like to use an image map to make the entire <td> tag a link but because the image is not actually referenced by an <img> tag is it possible to do it in the css class...

Is there any way of removing the 'sunken' effect from the <SELECT> tag, I have used the border-style css property on all my input boxes but it fails to change dropdowns! any ideas?

Hi peeps, I am running a web application which I can track orders from a unique order number, I am trying to stop my application from adding one to the order no when it has already done it once. (ie I dont want the orderno to go up if a user hits the refresh button). The code generates a .dat...

Hi, I am looking for some code that will open groupwise with a new mail dialog and a TO: specified programatically :) I am file with opening groupwise but I dont know the command for new mail I have only dealt with programaticallly sending the mail :( Any help would be great Tanx Mute