Search results

Thanks Modest, its the Active Code Pane suggestion I was looking for. Its one of those ones that unless you have an incling what the function etc is called you can try all sorts of searches and be miles from the answer. The rest of it I am cool with thanks. Many thanks Dan

Either as modest says declare a constant for the original value, or on open set a public valiable to equal the original value or use and if statement to determine which value to use for the height.

Hi can someone point me in the right direction of this. I wish to, in code, create a VBA function from the contents of a text file. Essentially I want to be able to see if a text file exists. If it does then take the contents to create a function. The bit I am lost on is how do I create a new...

I have a form that lists all the backend databases for an application in a combobox. You select one and it lists the tables you expect to see. Then you can select a new location and hit replace. It then drops the old and adds the new displaying success results for each table. There are a few...

Mike there are many ways to determine this. If you have used me.control.top=me.control.top - 5 then yes each time the function is called it will move it up by 5. You could either define a variable and store the height you want the control to move to so if its called the control will be moved...

Thank you very much. That's exactly what I was looking for a pointer to the correct statement or method and you have done just that. Cheers Dan

No worries Mike glad you got it sorted.

oh god where should I buy the marvel from? and the string... What if its not strong enough or is too heavy?

It is indeed simple its the defining what phone you want. One that won't break please. Anyway since posting that I have had another look and it seems there is a siemens, the M65 that is shock proof etc so I will walk up the road later to the local phone dealer and see what he can do. Job done...

I have an unhappy relationship with my mobile. I get a contract each year so I can get a new phone as I usually manage to break them in the first three months of having them. My current one has bucked the trend and lasted, just, a whopping 18 months! Its now pay as you go as I use it a limited...

Can the read only property of a file, eg a word doc, be changed by code? Many thanks Dan.

This does work and you are not trying to do the impossible. Check that its not the code that determines what 'Presses' equals thats not truiggering the event. Stick something like. Me.myControlNameHere.Top = Me.myControlNameHere.Top - 5 on the on click event of a button and keep pressing...

Hi, I have spent the best part of the day cruising the web including the help here but failed to stumble across an answer. Essentially is it possible to expose a list of possible outlook address books for linking to a database for the user to select. Once selected from a list link the table...

Think I've got it sorted. John have sent you a PM about it. I will detail here exactly how i fudged it, er I mean sorted it, when I have finished and this looming deadline has passed successfully.

Cheers John, I will knuckle down and try and get this licked today. Or the brown smelly stuff will be flying around a wee bit.

Hi John Cheers for that, I will keep on playing. I have been doing the VBA thing on and off for years but never needed to mail merge anything and word is a mystery to me beyond the basics. Thats where I seem to be falling over. I will let you know how I get on if I get anywhere with it. All the...

When you say you have converted a mailmerge to a normal document does that mean you have to first create a mail merge document and then turn it into a normal document or can you just start with a blank document? Many Thanks Dan

John I am in the same position as you are. How far have you got? I have tried by creating a template, then by creating a word doc that has been set up for mailmerge and now a new word document. However I am stuck here: I open a document. Set the connection? (I think) then I am asked by word...

I put this in the Word forum on here but wasn't sure if that is the right place. If here is wrong let me know and accept my appology. However I could really do with some pointers as I am creek bound and paddleless. Many thanks http://www.access-programmers.co.uk/forums/showthread.php?t=84102

Thanks alot mate, will go have a play and see what happens.