Search results

Cheers Datagopher. Worked a treat! :)

Hi I have been searching around the forum but havent stumbled across the answer. I have a form which has a field called ContractNumber. I would like a hyperlink which would open a document with the same name as the contract number. Example: If the field has 123, I would like to open...

Thanks Simon. From having discussions will some developers - one thing they all agreed on was that .NET is the future.

Great advice as always Namliam. :cool:

Mike Your post makes complete sense. If you ever come up here - look me up for a Pint (or two)! I'm defintely going to give it more thought. I must admit - the thought of managing others appeals more than running procedures all day. As always....the plot thickens!! Have a great day and...

Yes - I agree on the differences between small and big companies. Unfortuntely - I work for the latter - which employs 30000+ employees. I am still weighing up moving to a more project manager role vs development role. I think the Project manager has more of an extended life span than a...

My soft skills could always be done with developing. But surely I will need the skills and tools which would go hand in hand with this. If someone asked me to develop a web application - I would certainly need dreamweaver/frontpage/notepad etc. But I see your point - I would only need to use...

I completely agree. I can't see any job out there that will pay you £30k+ for being an access developer, and if i have to be sensible about my choice of career - learning new skills is a must - however nerve racking it must initially be! :confused:

Hey Mike Thanks for your comments. My aim is to get some personal experience in my home - learn to a certain level and then go for some qualifications. So far I have a degree in Business IT, Access Intermediate and Advanced courses and Prince2 Qualified. I have enough qualifications to...

I'm going to hang on to my access skills - it is too useful a tool. It's fast, quick and efficient - and frankly - i love it. But it is also time to expand my knowledge portfolio as I have no idea what the future brings - and I better be prepared!! Thanks again Daz

Namilam - Many thanks for your detailed reply. You understand exactly what is going through my mind. I know access will be needed in my job for a considerable time yet - but I feel it is time to upgrade/move on with my self development. I would do this to gain new skills, develop myself and...

Thank you for the advice. I think I will go down this route and see how i get on. Many Thanks for the advice. I really appreciate it. Daz

Thanks Dream. I think I will begin with using Access as a temporary backend whilst I get upto scratch with communicating with the database from the front end. So I think i will be using ASP (VB) to communicate with the backend in the interim, then once I feel confident I will upgrade the...

Thanks for replying Dream. What I would ideally like to do is create database driven websites. I have good knowledge of databases and some little html knowledge. I guess my choice would be what platforms to use as a backend and front end. In regards to the backend - it would be SQL server...

Hi Thanks for replying. Well from what I have heard on the grapevine is that Corporate IT want to do away with access. I work as a development officer (amongst other things) for local government. For years I have been playing with the idea of upgrading my database skills. I feel that if...

Hi Guys I was wondering if someone could point me in the right direction. My job has taken some interesting turns in the past few weeks and to cut a long story short - I need to learn some new skills fast. I was wondering if anyone has taken the jump from Access to ASP. Is it any easy...

I sorted it - the problem was that in the subform's underlying query - I had the Group By option set - i disabled it and rejigged my query and it all works now! Yey!! Thanks for your help guys. :cool:

Hi thanks for replying. I have tried both variations of namliam's advice but they both resulted in the #Error. I'm not sure what I can do really. If there is no records displayed in the subform - i think it isnt even a null value - its like there is no recordset at all so Null doesnt even...

Hi Thanks for your response. I have edited my expression as follows: =IIf(IsNull(Forms!frmInvoices!subTaxiChangesForInvoices!TCCalc),0,Forms!frmInvoices!subTaxiChangesForInvoices!TCCalc) But I am still getting the #Error. I am entering this on the Control source of my calculated field.

Hi everyone Please can someone help me with this problem I am having. I have a form with a subform on it. On the main form are two date fields - when the user enters the two dates - the subform shows any records which fall between the two dates. One of the fields on the subform is a...