Recent content by Mahall906

I see what you mean, I can the query down further. I like it! Thanks

Thanks Gasman. I have a query within the database which the Word letter is getting its information from. I just cannot figure out the coding i need to use (f any) to have it selct the relevant ID letter when it opens Word.

Afternoon all, I have word document letter template called 'Warning'. There are fields within the letter that are linked (mail merge way) to my database, including ID, name, etc. This creates each letter perfectly for each ID. However; Can I change my command button, that opens the letter...

Thank you. Both option tried and tested with the same results. A bit more 'Googling' and testing reveals its not just Access and is affecting all the usual, Word, Excel etc. Has to be the recent update.

I thought the same, and yes, there has been. I have checked colleagues PC's, with the same updates and they have no problems. I have 'logged' into another machine and its doing it on that. I have logged the problem with our IT service but no doubt it will take them nearly six months to...

Hi all! The last time I used my daily database was 24/12. Since 29/12 the database will crash and restart when attempting to put in a hyperlink in a form field. This is a new issue and has never happened before. Hyperlinks that are already added work perfectly fine. It is happening on all forms...

I've only gone and done it! Spent a while, worked it out and happy! Again, thank you!! (y)

Thanks, I did this and works great. Its just the new record bit now.

Thanks Pat Hartman, may seem a daft question, but where would I need to put this bit of code, in the Form_Current?

I did have a control button but now removed it to simply try the "new record" option at the foot of the form.

Me again! Now the visible options are working great; however, it will not allow me to open a new blank form to enter information. It allows be to open a form already completed. Am I missing something obvious? I get: Run-time error '94': Invalid use of Null Thanks again

Perfection! Thank you both! As simple as that. This forum it excellent! ;-)

On my form I have a checkbox called "owner" and when it is checked a button is shown. The code I use is: Private Sub Owner_AfterUpdate() If owner = True Then Command2162.Visible = True Else Command2162.Visible = False End If End Sub This works; however, when I leave the form, and that record...

What on earth have been doing then!?:rolleyes: ha ha in honesty I waiting for there to be something in between the two! Thanks pbadly(y)

Still getting used to codes and would like a command button to do two things, tick a box and run a command to insert a hyperlink. I have plenty of separate ones doing these for other things but how do I join the two in one click command? When the "Email" button is pressed I would like it to...