Search results for query: *

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...

Thanks for the guidance I have used the dcount function to determine how many licenses there are in table b and assign it to a variable (Call it varA). I now want to assign the value of a field in table A (Call it FldB) to a variable Call it VarB where a field in table a (Call it FldC) is equal...

Hi Background I have a inventory database for our computers, I am trying to tie in the software licenses to make sure we do not exceed our qouta. I have created a table (call it A) with a softwareID and the quantity of licenses we have. I have Created a table (call it B) that ties a...

Lots of good stuff here http://www.bluewillowgroup.com/DesktopModules/forum/?tabid=40 I am looking at this too and sysprep provided with win2k3 and xp lets you build a single image for multiple machines so long as include the mass storage devices and include any drivers (oempnpdriverspath) that...

Hi I have created a custom message form that users can enter the follwing custom fields: project number email unique identifier deprtment. This works fine. However I want to create a centralised store for all messages sent from multiple users so that I can archive them when a project is...

Thanks Tsjui Seems that is the case I put the script in the ou logon scripts and it worked. Can anyone reccomend a way of modifying the script so it can be ran at startup? Thanks Paul