Recent content by hillsee

Hi Noboffinme, Thanks for the help / code, unfortunately I dont understand VB enough to make the code work. Thanks for all your help... I think I am just trying to do too much in excel.. Hillsee

Hi everyone, I have attached an excel spreadsheet of a drawing register we use within our architectural practice. I have managed to colour a coloumn cell fill yellow, dependent on the latest drawing issue using conditional formating. However I would also like the DWG Number, Description and...

Thanks for quick reply, The folder name suites the way my company works and our type of work. Which I havent explained in my post.... I thought that this would bore people and is irrelevant to my post... :-) I have thought about creating a another field, but wont this mean I have to enter...

Hiya guys, Im sorry if this is already been asked / answered, I have tried searching through the forum to find help, tried some solutions but im still getting errors (mainly because I dont understand Code very much) Basically.. I have a form called projectsheet, on that form I have a field...

Sorry Im new to Access, I dont know how to use the Dir command, what do I do? Thanks

thank you for that, your rite it doesnt work.. Do you know of anyway to open a folder with the same name as a form field but with the folder having extra characters on the end?? Thanks

Hello there, What was the final code you used??? I have the same problem. I can open folder but soon as i use the wild card function as described in messages in errors and just opens default explorer window. The code I am using Dim ProjPath As String Dim stProject As String stProject =...

hiya, thank you very much i will give it a try. thanx again

Hiya, noob question here. Access 2003 Within company database there is a form that contain the details of each project each listed with its own unique 'projectID'. On this form I have buttons which opens up windows explorer to a specified folder on our server with the same name as the...

Cant get sample to round up, it jsut rounds to nearest 1000 Hiya, sorry for delay in getting back to you. the sample doesnt round up to nearest 1000. the sample code you have given me ------------ Private Sub Command3_Click() Me.f3 = Me.f1 - Me.f2 Me.f3 = Round(Me.f3 / 1000) Me.f3 = Me.f3 *...

You Star !!!! cheers mate, thanx for that, it looks so simple. Ive been trying for half a day to do that. thankx for the help and quick response

Hiya, I have searched the forum as u do, but i cant find a solution to my problem. I have a form which has a 3 fields called OvercostingCost Estimatedcostinggreaterthan Overcostingroundup basically I want the field me.Overcostingroundup = me.OvercostingCost -...

heheh thanx guys thanx guys, i know this could get really complicated, specially with hols and stuff. but to be honest its not for whipping the employees into submission. its just a form of reminder for peeps to fill it in. The office is run quite efficiently and most peeps do fill time in...

hiya, just posted a message today. Problem, ive got a work database which employees logon to and enter time against certain projects they have been working on. What i need is to somehow create some code that will look at each of the employees names and sum up there total time for the previous...

code help thanx for your help, from your comments i re read through all the code and related forms and queries and realised i set the form to pop up in add mod, hence the reason no values. Fixed my error and everythink now works apart from....... when there is no entries in the timesheet...