Software

Ask something
Discussion Locked

Microsoft Office suite Q&A

0 helpful
16 replies

by discussion

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Office suite users and support analysts, use this space to consult with other Office users and analysts, post your questions, offer your comments on the Microsoft Office Suite e-newsletter, or suggest future Office tips.

If you'd like to check out the previous Office suite Q&A discussions for answers, here are the links:

- https://www.techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=122381

- https://www.techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=130431

If you're not subscribed to the Microsoft Office Suite e-newsletter, you can check it out here, under Technical Tips:
http://nl.com.com/guest.jsp?brand=techrepublic&return_to=https://www.techrepublic.com.com:8001/2001-1-0.html

*When pasting these links into your browser, remember to remove any spaces.

16 replies

by passwordchanged

"before 2002 if you wanted to change the format of 10 chapter headings scattered throughout your document, you would have to find and change each one individually. "

Not correct. Back in Word 6 you could update styles across a document and in 97 and 2000 you can do search and replaces of styles.

by rick_from_bc

Word X.1.4, Mac G4, OS X.2.6, Very experienced user.
Discovered that the wildcard function in Find & Replace is
severely limited relative to Word 2001. The curly brackets {}
are not recognized, i.e. "a{2,12}" should find and highlight
strings of "a" where there are between 2 and 12 a's in a
row. But the search finds each individual "a" and highlights
one "a" at a time.
QUESTION: is it only me, or is it a bug?

by hung.pham

In old version of excel if you had a macro or any links the values would be display if the link was not there. In Excel XP the expression shows up. How do I get the values to show.

by globe_trotter_5

Go to Tools -> Options -> Calculation -> select Save External Linked Values for your worksheet. When you open your file, click "No" when asked if you want to update the workbook with changes made to the other workbook.

by junko1tui2

Check the formulas box to view formulas - as far as macros, you can see the list if you choose "run macros"

by onelap8

I have an access form where I need to insert the current date and time into two text boxes (restime & resdate)when a command button (cmdres)is clicked. I know this can be done with VB but I have no idea where to begin any ideas?

by dbwriter

Create an "On Click" event.
Then set resdate equal to Date and restime equal to Time:

Private Sub cmdres_Click()
Me!restime = Time
Me!resdate = Date
End Sub

Each time the command button is clicked, the current date and time will appear.

by eisley_rodrigues

In your form design view, right on cmdRes, then select "Build Event", a pop up box will appear. select "Code Builder"

The code for your application will look like this

Private Sub cmdRes_Click()

[resTime].text = Now()
[resDate].text = Now()

End Sub

Back in design view, you can select the spefic formatting for the date and time fields you have just created.

Hope this helps

by rleavitt1

Private Sub cmdres_Click()
Forms![test].restime = Time()
Forms![test].resdate = Date()
End Sub

I used test as the name of your form

by mschapiro

When a date is put into a field and you tab over to the next field over, the field with the date changes to pound signs.

by waresfamily

Is it possible to use a function/macro to find the maximum value in multiple sheets in a single workbook?

by nickrusso

Try syntax =MAX(sheet1![range],sheet2![range],...).

Dont't forget the bang! after the sheet name, or just click and select the sheet and range you want, comma, then repeat for next area.

This discussion is closed to new replies.