Search results for query: *

Hi wayner1980 I started with a similiar aproach myself. When you say you added a flag, did you do this manually or did you find a way of isolating that last row for each city (that's where I got stuck with this approach)? Cheers.

Got it sorted using a Macro, as follows: this macro should work. It assumes: •your cities list (City A, City B etc) is in a column with the range name "city_range" •this column is sorted so all instances of eg "new York" appear in sequence one below the other •your names are in the adjacent...

Have exactly the same thing to do and for me yes the City column is in order. Tried using a concatenate combined with an if statement and it gets what i want in the last row for each city but then I can't isolate all those last rows. No good if I have a 1000 rows! Cheers.

Hi there Using outline view in MS work to build a tree structure and I am getting the words underlined by a green line. This is not grammer or spelling mistakes and the line does not appear in any other view. Also the line does not appear when the tree is fully expanded. Anyone know how I can...

Don't really care what values go into facilityGoalID as long as they are unique. So guess that'll mean the values need to be sequential from the last facilityGoadID on. Is this possible? Thanks PHV...appreciate your help! Regards, John

Hi there, I have a table with a primary key and 200 records with the same 'facilityID' I want to copy these 200 records, change the 'facilityID' for these 200 and append them to my table. The table also has a primaryKey called 'facilityGoalID' so my 200 copied records will have to have this...

Hi there, discovered very annoying problem today when using MS Outlook! When sending an email in rich text format and then attaching a document my recipients do not receive the attachment. However if I send the email as plain text and attach a document in exactly the same way my recipients do...

Hi there, have a presentation that when first slide is displayed I can decide whether to go straight to 3rd or 5th or 7th slide. I don't want to bring anything up on the screen e.g doing a right click. Therefore is it possible to associate a slide with a specific keystroke. For example if during...

ok......i downloaded and installed Zonealarm on the Windows 98 machine but should I also install this on the 2 XP laptops. I know I can activate the XP firewall on the laptops but I read somewhere in the XP firewall help that it should not be used in conjunction with another firewall? OR Is it...

Hi, have a small network that uses an ISDN line to connect to the internet. The main PC is running Windows 98 and have 2 other laptops on the network that are running XP Home Edition. All PCs have Norton Anti-Virus installed but I need to get a firewall. I know XP has a built in firewall but is...

Hi, running XP on Dell Inspirion 5100 laptop. It's a P4 2.4GhZ 512MB RAM, 30Gig harddisk with 14.5gig still free. About 2 weeks ago the machine started to take a long time to boot (maybe 10minutes) where as it used to boot in about 30 sec. This was annoying but once the machine booted it...

Hi, wonder can anyone suggest a good text book for developing an application using Microsoft Access 2000. I have a decent knowledge of Access already and have some programming experience but have not done any development using Access. Need to build a small user friendly app for dealing with...

Hi, wonder can anyone suggest a good text book for developing an application using Microsoft Access 2000. I have a decent knowledge of Access already and have some programming experience but have not done any development using Access. Need to build a small user friendly app for dealing with...

Hi, need to get a new good quality printer. Was thinking about a colour laser but was also interested in some multi-function features (photocopy, fax, scanner). Is there a printer that combines all? Does anyone know of an article that compares/reviews new laser colour printers? [Have very small...

Hi, have Win98 running on a PC that has 2 other PCs connected to it over a network. About twice a day the PC monitor will jump and a blue screen appears. It says: ----------------------------------------------------------- Windows An Exception OE has occured at...

Hi Mike, thanx for replying no apostraphy, f2 thing doesn't work for dates that are already there so i guess Excel isn't recognizing these dates as dates. Is there not somewhere i can say convert everything that looks like 05/24/1999 to 24-05-1999 i.e mm/dd/yyyy to dd-mm-yyyy

Hi, I've pasted in a large block of data into Excel and have a column that contains date information in the format mm/dd/yyyy. I want to convert the existing dates in this column into the format dd-mm-yyyy. I have tried Format/Cells and have made a custom date to suit the format I need but it...

The Machine has 192MB of Ram Under System Properties, Performance Tab it says 67% of System Resources free.....not sure does this mean 67% of RAM free. If not how do i check RAM usage? There's only about a 3rd of the HD used and it has a second HD shared over a small network but don't think this...

Hi, Running Office 2000 on Windows 98. When attempting to insert a bullet point in MS Word the following annoying message box pops up (does not happen every time but quite often): 'This program has performed and illegal operation and will be shut down' I did a reinstall of Office but the...

Hi, can anyone tell me the name of a good Halloween style font, something spooky or along them lines??? Thanks, Lavaghman