Search results for query: *

Hi I have a spreadsheet of 9,000 rows by 25 columns and I need to transpose some of the data as follows, can anyone suggest a solution, other than manually transposing? In all columns row 1 is column header, all data from row 2 onwards. Column A has Part Number Column B has a Count of locations...

Hi, I have an excel spreadsheet which monitors the progress of new parts through our business. I have been tasked with setting up a traffic light system to flag up the status of each of the stages, with each row of the sheet covering one part, each column covering each stage of the process...

Hi, I'm using a copy of the "Issues" database template in Access 2003 and in the view reports section, after selecting a report I want to offer the user the ability to filter the report by a StartDate and EndDate. This selection is to be applied to different query based fields, depending on...

Have an Excel 2003 workbook containing multiple sheets; “ProjectedVolumes” “ProductLines” “Supplier1” “Supplier2” “Supplier3” and so on “SummaryByLine” “ProjectedVolumes” A B C D E ProductLine Year1 Year2 Year3 Year4 Code1 X...

Have an Access 2003 database with three tables; tbMgr, tbEng and tbQuals. EngID is the primary key field in the tbEng table which is imported into the tbQuals table on a one to many relationship, with tbMgr having a one to many relationship with tbEng. Each EngID has up to 30 Quals each with...

Have an Access 2003 database with three tables; tbMgr, tbEng and tbQuals. EngID is the primary key field in the tbEng table which is imported into the tbQuals table on a one to many relationship, with tbMgr having a one to many relationship with tbEng. Each EngID has up to 30 Quals each with...

HI, Newbie to VBA so please bear with me. I have a simple database with two tables, one of which records names of people, the second lists their qualification expiry dates. I have a form where the engineering manager updates the qualification dates and I have set up the date fields to turn red...

Hi, Origianlly posted in MS Office forum; I have a created a spreadsheet [Excel 2003]for a non-technical user which lists engineers, who they report to and a listing of their qualification along with the qualification expiry dates. I have used conditional formatting to change the colours of...

Hi, Origianlly posted in MS Office forum; I have a created a spreadsheet [Excel 2003]for a non-technical user which lists engineers, who they report to and a listing of their qualification along with the qualification expiry dates. I have used conditional formatting to change the colours of...

Hi, I have a created a spreadsheet [Excel 2003]for a non-technical user which lists engineers, who they report to and a listing of their qualification along with the qualification expiry dates. I have used conditional formatting to change the colours of the dates when they are 6 months from...

Hi, I am trying to use the "route add" command in a VBS login script originally created by "Mark D. MacLachlan, The Spider's Parlor" to add entries into "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters". On XP machines where users only have Domain User rights the users get...

Hi, I am trying to use the "route add" command in a VBS login script originally created by "Mark D. MacLachlan, The Spider's Parlor" to add entries into "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters". On XP machines where users only have Domain User rights the users get...

Hi, I am using Excel 2000 and have two worksheets in the workbook, sheet1=Calc, sheet2=LookupList. The lookup list in sheet2 is 9 columns wide by 33 rows deep. Each row contains a job description, each column contains the associated cost based on a service level. I am trying to lookup a cost...

I have been tasked to co-locate 2 businesses, Adomain and Bdomain which are currently in 2 separate offices with no connection, but use the same private IP range of 10.x.x.x on a subnet mask of 255.255.255.0. The primary business [Adomain] has just been transformed from Windows 2003 Small...

Newbie to VBA, apologies if this seems too simple for words. I have a spreadsheet and I want to check a date column to ensure that the users cannot enter a date after month end. I am also being asked to lock the sheet to prevent additions but not deletions. Cell renge is E5:E100 I have tried...

Hi All, Here’s the thing. We need a way of allowing a PC to enter screen saver mode, then automatically coming back out of it after a time interval we select. The first part is obvious, but would like suggestions on the second part of the problem. Thanks