Search results for query: *

Cheers Dan, The code I got to work was window.history.back() but you got me in the right direction. Cheers, Shaz

Simple question from a newbie PAGE1.ASP contains the window.open code for opening the web page PAGE2.ASP Because PAGE2.ASP opens in a new pop-up window it leaves PAGE1.ASP still open but its blank as there is no other code in PAGE1.ASP. What I would like to do is to use code to get PAGE1.ASP...

I'm running Microsoft SQL 2000 on my Windows XP PC. Issue I'm having is that randomly it drops my registered servers from Enterprise Manager (but keeps the Server Groups). When you go into Regedit you can still see the servers but nothing is apprearing in Enterprise Manager. I've tried adding...

Cheers for your feedback - I shall go for a pivot table options. S.

I'm looking for assistance in VBA. I'm trying to match identical entries in columns 'A - D' and if matching then add figures in column 'E' for these entries then put new information into another spreadsheet. Worksheet (before macro ran) ABLEXEC BZ 01010GPGAS 15169 2651389...

I've been passed a word document and the owner of the document wants it to contain a PO Number which will increment by one everytime the document is opened. Can this be done? Does anyone have any advise on where I can start with this one? Cheers in advance, S.

Hi, I'm currently trying to populate a combo box with the names of all the excel files that are currently opened locally on my PC I'm struggling to find the right code for obtaining the file names currently opened. Any assistance would be greatly appreciated. Cheers, S.

I've just started playing about with SharePoint Team Services but I have noticed that it doesn't like ASP code. Does Team Services allow the use of ASP code??? If it does is there any specifics that have to be configured to allow the use of ASP code???? I don't get any error messages, the...

I'm using SharePoint Team Services and trying to make Calendar the default event. I have followed the instructions given in the MS Knowledge Base:- - Open the Web in Microsoft FrontPage. - In the Folder List window, expand the Lists folder. - Right-click the event list name that you want, and...

I have one workbook which contains two worksheets. I am trying to do an identical sort on the first column but the output is different - one does it numeric alpha and another which does it only numeric. I have tried changing the format on both to be either general or text but I still can't get...

Hi, This is probably a really simple question but it driving me mad at the moment (I have done searches but I could just be putting in the wrong keywords). Anyway, I have a loop which finds the cell that contains the text 'Gross Total:' then does some processing before looping to find the next...

I currently have a web page which contains a table which is populated by reading a recordset which is constantly changing. Currently when you print this page the table populates multiple pages and some of the data in rows starts at the foot of one page and then ends at the beginning of the next...

How typical, after I submitted this post I managed to get a piece of code to work:- DoCmd.RunSQL "SELECT MAX(tblLogins.Login), tblLogins.Username " _ & "INTO [tblLogins2] FROM tblLogins " _ & "GROUP BY tblLogins.Username" Shaz

I have a table in Access2000 (tblLogins) that has 2 columns, one with Login Details (Login) and the other with User ID's (Username) e.g. Login Username 20020729082158 Admin 20020729082258 Admin 20020729082420 Admin 20020729083500 Tester 20020729083539 Tester 20020729110013...

Cheers for that Ken - if you change the rename to just name then it works beautifully name filename As Left(filename, Len(filename) - 3) & "txt" Thanks, S.

I'm currently writing a VBA Macro from within MS Access 2000 where I wish to rename all the files in a directory from having the file extension .log into .txt files prior to importing into an Access Database I'm unsure as to whether or not this can be done - any assistance would be greatly...

I've just started using JavaScript and I am trying to validate that when someone is changing their password in the system that it is a certain length and also that it has been input in LowerCase. I've got the length part to work by using the following:- if(elmNewPwd1.value.length >...

I'm trying to extract the name of a sub directory from a directory path. Path - c:\thomsons\stuff\exciting.xls Using the following code (picked up from Tek Tips by Supra - cheers) I'm able to extract the full directory path and also the filename but what I am wanting to do is extract the sub...

Hi, I'm trying to select the cells that have been setup in PrintArea to allow me to copy that range of cells only. I'm able to get the PrintArea address but only as a string using the following code:- Dim strPrintArea As String strPrintArea =...