Recent content by Lonemascot

Thank you so much. I remember pasting that in there now! duh. Perhaps you could help me with what i was trying to do in the first place which was have all my text boxes auto convert to Proper Case.

I've done something naughty with my DB. My 'contact details' form usually shows the [contact name] in the header of the form. However, if I enable active content then this doesn't work. Then when I go into design view and back out again it says there is an 'Invalid Outside Procedure'. it was...

Hi all. I would like to have a button (cmdPrintIntroLetter) on my Client Details form that takes the client name, address and company data of the record that I'm currently viewing and putting it into an address box in a Word document. I also want to make use of a personalised greeting. e.g...

thats great. i will have a go at all this and see what i can come up. thanks a lot.

Hi CJ. Thanks for the message. Ive got a specification that ive written, if you'd like to have a look at it and let me know how much you think it'll come to. I'm having a go at doing the easy bit; building tables and the few forms that I can do but definitely need a pro to do the hard bit. Do...

That's awesome. Gotta love freebies. I shall work through those and see if that gives me the know how to complete my project. Even if I can get 90% of the way there I guess I could always ask you helpful guys and girls on here. Thanks for that, much appreciated.

I want to learn Access so I can implement (and continuously update) a database for my company. I have a basic understanding of it already but I'm certain that what I want to do is going to require some pretty in depth knowledge. Can anyone recommend a good book or a set of videos for me to...

Ive just used >LAaC\ 0LL. The 2nd and 3rd characters can be either letter or digit with the 4th being a character or space. This can produce a few dodgy results due to input error but at least you can't write a bunch of crap in the field which is mainly what i use it to stop happening. Let...

First impressions are good, loads of customisable features. How much did you pay for your copy? I've got to wait for someone to call me back.

Hi Nigel I run a general builders but we specialise in EPDM flat roofing. As im sure you are aware, no 2 building jobs are the same and trying to price it up using a pre defined list of materials and labour charges is not always possible. which is why a lot of the online CRMs wont work for me...

Thanks guys. I knew it was a bit of a "how long is a piece if string" question but I had no idea whether what I want is just a case of tying together code from pre written program's or whether its a full rewrite which would take time. I have written up a detailed spec and i will want to use...

Hi guys. I have been attempting to create a database for myself and through my ever expanding ideas and ambition have decided that what I 'want' to do is clearly outside of my skill set. So rather than learning a load of stuff to probably only implement it half as well and take twice it as long...

That did the trick. Thank you.

Hi thanks for the reply. My knowledge of access is pretty basic but I can work it with a bit of guidance. What would I need to do with this combo box control?

Hi guys. not quite sure what this is called so didnt have much luck when searching. I have a form which im using to store records about companies that I have mailings with. The company name is my unique field as no two companies should have the same name. This form is accessed by several...