Recent content by psbrown

I dont know why, I am an Administrator, H is my personal drive and it works with access 2000. Are there pemission functions with access 2003? Paul

Thanks for the response PHV The error message is run-time error '2220' microsoft access cannot open the file 'H:\SafetyAuditDB\MoInciden.xls' Paul

Hi I have a button on an acess form that runs the code below, this has been happily working on access/excel 2000 for some time. We have just upgraded to access/excel 2003 and it is failing at the code marked ***** Failing Below Here. I have done the usual searches and cannot find anything, any...

Fixed it Simple error of not having the correct coloumn bound in the combo box, in the words of Homer DOH!

Hi I have found in this forum on how to use a combo box on a form to provide criteria for a query. I have tried to get this to work for more hours that I care to think about without success, the query just comes up blank. The senario is this. Form frmMASRSummary has a combo box cboWeekNo that...

Thanks PVH that did the trick, Can you please explain why my statement was not working? Paul

Hi I am doing my first excel project and found how to define a range definition from the vba help. my syntax is: Worksheets("Chart").Range(Cells(2, 2), Cells(2, NoCols)).Interior.ColorIndex = 6 Even removing the variable and using a constatnt as below...

That works great, what do they say about a liitle knowledege is dangerous. Thanks Guys

Hi I am new to VBA. I found this code on this forum and have used it to populate my combo box on a user form in Excel, the problem is when a value is selected the value is not retained in the box it just goes blank. Any pointers on what I am doing wrong would be appreciated. Thanks Paul...

Thanks Mike that works great now, below is the whole code for anyone else who might need it. Dim BusMan As Variant 'Business Manager Dim BusSec As Variant 'Business Sector Private Sub CmdCalc_Click() 'Set up Variables for Worksheet Dim wbBook As Workbook Dim wsSheet As Worksheet...

Thanks for that Mike it does seem to assign the null value correctly now. But my "if then" statments do not trap the null value can you give more guidance? If BusMan <> Null And BusSec <> Null Then MsgBox ("here 1") rnData.AutoFilter Field:=5, Criteria1:=BusMan rnData.AutoFilter Field:=6...

Hi I am a VBA newbie I have a userform with 2 combo boxes that I want the user to sellect criteria for a autofilter in Excel, when the comboboxes are populated the user hits a command button to set off the filter. I want the filter to return all values of that column if that combo box is left...

Thanks for That PVH, because I am a rookie I automatically thought it was due to bad logic not spelling. Paul

Hi I am new to VBA but have a done other languages in the past. I want to remove duplicates in column p on an Excel worksheet. I have developled the code below to loop through the column. my test data is 2 rows with the value of 2-2005(one copied from the other) my problem is that my the line...

Hi I have been asked to develop an automated method of creating forecast reports for projects that we are going to get in the office so we can assess mannning levels. There are three fields per project we are interested in: Start Date, hours and periods. Sart Date not being important at this...