Recent content by 82412

No need to use code. As you have no doubt discovered, if you maximise your Word doc after it's opened, it doesn't remember this the next time. But......... If you "maximise" it by dragging the edges of the Word doc window to the edges of your screen, it should open in that size every time!

Over the past few months I've switched three more of our computers to cable connections - one because yet more wireless networks appeared nearby, two because their wireless adapters became increasingly unreliable. Not really surprising when you feel how warm they get when in use. Now I'm going...

Oh yes, backing up online twice a day, and keeping 3 days worth of backup copies in case the latest backup copy(ies) were made after the corruption occurred. I don't know if this ever happens in Access, but in Outlook, for example, the corruption in its data file can occur one day but Outlook...

It has been pointed out many times in this forum that Access doesn't do well when networked wirelessly. I was experiencing fairly good reliability with a wireless network but the reliability decreased (a) because we had some additional partition walls erected in our office and (b) too many...

The "data" is e-mail addresses (one in each field). A specific e-mail address has to be entered into a letter, depending on which user is sending the letter. I'm using Albert D.Kallal's Word Merge which allows me to store any number of letter templates and send a single letter based on a...

Yes, or I could just go to the table and do Find/Replace. Brain was a bit slow this morning, looking for a complicated solution instead of an easy one!

Due to a change in working practices I needed to create new text box fields in a table, with their default values already entered. These values are to be used as merge fields in Word documents, and they will never change. I have created the required fields in the table and set the default...

Thanks guys, sorry for the late reply, been off with flu. Problem Sorted.

In one of my forms I have used this code in the properties of a check box (with the names changed) to apply conditional formatting to a text box when the checkbox is ticked: Private Sub Check14_AfterUpdate() If Me!Check14 = True Then Me!txtDesc.BackColor = vbRed...

Solved it, no need to reply.

Total from query, percentage from table This is probably simple but it's something I haven't had to do before. I have a main table. I have a filter query based on this table. I have a report, based on the query, which displays the total number of records in the query. In the same report, I...

I've got round the problem by creating a text box bound to a new date field with =Date() as its default value and placing code in the After Update event of the List box so that the current date is entered in the new text box when one of the phrases in the list box is clicked. It would still be...

I merely used the Control Wizard. The resultant code, as you can see, is unremarkable - Private Sub List122_AfterUpdate() End Sub Private Sub List122_BeforeUpdate(Cancel As Integer) End Sub Private Sub List122_Click() End Sub Private Sub List122_DblClick(Cancel As Integer) End Sub...

At the moment I have achieved what I wanted by simply putting the short phrases into the list box - they are very short so they don't take up too much space on the form. And now the inevitable follow-up question! Using this simple list box to text box method, is it possible to populate the text...

I have a list box on a form. It shows Code01 on the first line, Code02 on the second, Code03 on the third and so on, and is set to populate a text box on the same form. What I want to happen is that when Code01 is clicked a specific short phrase or sentence appears in the text box, a different...