Search results

Many thanks for this Humph

Can anyone give me guidance or code on how to automatically compact and repair. There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and...

Back up now working :DThanks for all your help - got it to work by importing my database into the back up utility rather than the other way around - don't understand why it works this way but the important thing is that it does. Once again a fantastic utility many thanks

Fantastic utility thanks - query it is working as a standalone database and copies everything correctly - can I add it into a database to be called up with a button - have tried to import the modules etc but am now getting a compile error. Maybe doing something silly. Thanks Humph

Timing issue Thanks for the help Moniker Firstly I am opening word and have changed the code to AppActivate "Microsoft Word" SendKeys ("%R") Am having difficulty knowing where to insert it. When I click the text box hyperlink I have tried it both in the on click code and the lost focus...

I have created a hypelink to a text box and it is working thanks to this forum for most of the code. Problem - file opens in word OK but word does not become the main focus on the screen and it is listed on the bottom of the screen to be clicked on to display the word document Any ideas please

Storing the file name Help please am I missing something really stupid everything is working great I can select the file and open word etc but the file name gets lost when I come back to it. :confused: where is the instruction o save the file attachment address to the table? Do I need to set...

Can anyone help me with this - I have an append query to a statement table for invoices with a macro set. When the query is run the data is added to the statement query. what is happening is that it is adding the data ok on a seaparate line but is also updating any previous invoices for the...

Dont think so but thanks for your help.

Contact management database I am just about to start from scratch with a contact database and would be happy to look at this one- had a quick look on microsfot site but can't see it can you give a reference where you got the download Ta humph

Wrap on knuckles duly accepted Yes - agreed but also thought that I had placed it in the wrong forum - howver point taken. Ouch!

Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want...

Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered. whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that...

Thanks I knew it was easy but the mind is getting weak at thhis time on a friday night.

Hi folks - I saw a thread last week re how to extract the year from the date field possibly using date serial but can't find it can anyone help - it is probably very simple but i can't get it to work. Ta Humph

Hi folks - I saw a thread last week re how to extract the year from the date field possibly using date serial but can't find it can anyone help - it is probably very simple but i can't get it to work. Ta Humph

Assume you have used the debug option - had the same porblem and it took some time to bottom out but there was a problem on 2 queries. If you haven't already tried it maybe worth a shot.

Hi folks - need some help with what is probably very easy but I just can't get it. I am running an access database on a 2 pc network with shared access etc. I can see all files on both computers but when I try to open the same file on both systems I get error message " could not lock file"...

I have a form and I do not want the mouse wheel to move through the records - it is a single form view and I do not want the use to use the wheel as it corrupts my calculations. Is there any way to allow input of numbers input without the wheeldoing anything I am sure that I am just missing...

You're a star!!!!! The quote marks and the [] get me the required answer Yet again many thanks.