Search results for query: *

Just a belated thankyou for steering me in the right direction! Have a star for your patience :) ---------------------------------------- I realised I was dyslexic when I went to a toga party dressed as a goat. ----------------------------------------

Output: for each w in workbooks: ? w.name: next VM0009Prices.xls Book1.xls I've been reading through the Object Browser and Ive started writing code using; Dim Source As Workbook Dim Dest As Workbook Application.ScreenUpdating = False Set Source = ActiveWorkbook Set Dest =...

Thanks for the fast reply, Using the code you provided gives me a subscript error. I have checked the book and sheet references and they are correct so Im not quite sure why it cant find the cell references. The only code I am running to get the error is...

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...

Cheers Dan, This has worked but I can't find any reference to the hash entity in the HTML spec. Could you possibly point out a site with some information on this? Thanks again Simon ---------------------------------------- I realised I was dyslexic when I went to a toga party dressed as a...

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, Thanks for your input but it really doesn't mean much to me. Could you possibly point me in the direction of some online documentation regarding FTP server set up's as I'm having difficulty locating anything useful. Many thanks again Simon ---------------------------------------- I...

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...

Erk, As is tradition with me on Tek Tips I have discovered the answer just after posting. The correct reference is: Windows Script Host Object Model. Many thanks for your help PHV, much obliged :-) ---------------------------------------- I realised I was dyslexic when I went to a toga party...

Hmm, I don't seem to have an WshNetwork object available in the Scripting library. Im running Access 2002 SP3 and I cant find anything about Windows Scripting Host in the help files :( I presume you didn't mean I had to use WScript outside of the Access environment...

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...

It is indeed, place it in a module then you can call it like a built in function. Its code that gets used over and over in a couple of my applications making it a prime function candidate. ---------------------------------------- My doctor says that I have a malformed public duty gland and a...

Hi Rachel, this function will let you check and see if a form is open already; Function fIsLoaded(ByVal strFormName As String) As Boolean If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then If Forms(strFormName).CurrentView <> 0 Then fIsLoaded = True...

Heres a little function you can use to test if a form is open. Function fIsLoaded(ByVal strFormName As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then If Forms(strFormName).CurrentView <> 0 Then...

Spot on PHV, the problem stemmed from your variable you were trying to put the split strings into. He/she (sorry PHV I just don't know) also shows you how to deal with a variable number of strings in the collection. ---------------------------------------- My doctor says that I have a malformed...

Hi, Here is an example of something you can adapt to do sort of what you need. Dim dtToday, dtMonth, dtYear dtToday = Now() dtMonth = Me.txtMonth dtYear = Me.txtYear If Month(dtToday) = 1 And dtMonth = 12 Then Me.txtNumber = 0 Me.txtMonth = 1 Exit Sub End If If...

Not sure why your putting those square brackets in, all you need is; titleParts = Split(FullTitle, Chr(124), -1, 1) Me.DrawingTitle1 = Titleparts(0) Me.DrawingTitle2 = Titleparts(1) Remember that collections (arrays) are zero based so the first value is found in 'Titleparts(0)' and that your...

Your spot on with your assumption, your code takes the first 9 characters of the line and tried to match it against everything in the Case statement. The only one that is nine characters long is 'DOCSTATUS' to fix this problem you should use: RecordId = Left(temp$, (InStr(1, temp$...

oops, missed these extra posts, sorry :D ---------------------------------------- My doctor says that I have a malformed public duty gland and a natural deficiency in moral fibre and that I'm therefore excused from saving universes. ----------------------------------------

OK, so your pulling records based on whats selected in the list box, your then changing other fields on the record then moving onto another record based on whats selected the next time the listbox is clicked? If thats what you are doing you need to add a save record in there to keep the changes...