Recent content by RougeDev

Ok Read your post. lock_area is a variable which contains the a cell address or range eg "C6" or "C6:D6" But that's unimportant at first as it's the Worksheets("List").Unprotect line that pukes..... Unprotect method of the worksheet failed etc.

Ok I'm using Excel '97 & I've got a spreadsheet that is filled out by means of a form dialogue. Now after the user has finished with the form entries are placed in the spreadsheet. I need to lock some of the cell that have been entered & leave others free for editing manually I was trying to do...

Ok I'm using Excel '97 & I've got a spreadsheet that is filled out by means of a form dialogue. Now after the user has finished with the form entries are placed in the spreadsheet. I need to lock some of the cell that have been entered & leave others free for editing manually I was trying to do...

hmmm, kinda what I want. What I'd like to do is create a resource group & specify a number of hours that it can do in a week, with out having to create any individual resources??? Possible or not??? the situation is that the users know that their department has approx 2000hrs per week...

I'm working on project that involves a large amount of manufacturing. What I'd like to do is allocate resources to a task on a group basis. eg Add the welders to the weld girders task. Give the numbers in each resource group allocating on an individual basis would be pain Anybody got any...

Thanks For all your help. Problem Now Solved :) Gavin

Ok can't find the OnChange (or OnSelChange) you talk about so decided to use the lost focus trigger event as this will be ok Private Sub ComboBox1_LostFocus() Dim oWorkspace As DAO.Workspace Dim oDatabase As DAO.Database Dim oRecordset As DAO.Recordset Dim oQdef As...

Yep that helped heaps. What I'm doing is allowing a user to select a name from the combo-box and now I want to display the relevant phone number (stored in a database) in a cell (or label whatever is easier). Any ideas Thanks Gavin (code for combo box follows) Private Sub...

Hi I need to pull data from a MS Access database for use within a combo-box inside an Excell spreadsheet. How do I instantiate the ADO I need to query?? & Then do I just use a querydef object to query the ADO??? Am just teaching myself VBA so am a littel lost Thanks Gavin

Are you using apache & php too??? I downloaded phpTriad, It gives u php+apache+mysql in a single hit, installs fine on WIN98 and I belive it does so on WIN2K. Get it here: http://sourceforge.net/projects/phptriad It installs itself in C:\apache under here u will find a dir named mysql, go...