A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 35
Search took 0.62 seconds.
Search: Posts made by: Scafidel
Forum: General Discussion June 5th, 2010, 10:51 PM Posted to microsoft.public.access
Replies: 1
Views: 3,362
Posted By Scafidel
Display subform total

Never mind; I got it. I changed the field from text to double number and
added me.recalc to the form field and it stays visible.
--
Lafayette, LA


"Scafidel" wrote:

I have an Access 2007...
Forum: General Discussion October 20th, 2007, 05:41 PM Posted to microsoft.public.access
Replies: 0
Views: 63
Posted By Scafidel
Merge to Word

After an embarrassing amount of time, I have finally been successful in
creating a Bank Draft displaying currency using Access/Word merge to a table
document. One line (table cell) displays the...
Forum: General Discussion October 7th, 2007, 08:59 PM Posted to microsoft.public.access
Replies: 0
Views: 42
Posted By Scafidel
Access/Word Merge Bookmark Currency

Rick brought up the question...
Forum: General Discussion October 2nd, 2007, 03:24 PM Posted to microsoft.public.access
Replies: 4
Views: 60
Posted By Scafidel
Merge Word Bookmarks

Unfortunately I am using Bookmarks instead of the usual Fields and ALT-F9
doesn't seem to do anything.

"Maurice" wrote:

Hi Scafidel,

In your word document go the the specific field where...
Forum: General Discussion October 2nd, 2007, 06:25 AM Posted to microsoft.public.access
Replies: 4
Views: 60
Posted By Scafidel
Merge Word Bookmarks

I am merging an Access Form to a Word document using this code (in part).

.ActiveDocument.Bookmarks("Bonus").Select
.Selection.Text = (CCur(Forms!MLOG!Bonus))
I am unable to get the...
Forum: General Discussion August 20th, 2007, 09:34 PM Posted to microsoft.public.access
Replies: 2
Views: 64
Posted By Scafidel
Merge to Word

That's it! I simply plugged in "UCase" and now it's as it should. Thanks,
Arvin.

"Arvin Meyer [MVP]" wrote:

More than likely you need to validate or use Input masks to control the way
data...
Forum: General Discussion August 20th, 2007, 07:48 PM Posted to microsoft.public.access
Replies: 2
Views: 64
Posted By Scafidel
Merge to Word

I saw a similar post, but I am using the method described in "MS Office 2000
Automation" help files to Merge an Access Form with a Word document that has
bookmarks. It works ok, but none of the...
Forum: General Discussion July 23rd, 2007, 10:44 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 57
Posted By Scafidel
how do i unsave an excel document?

I must say I never thought of this site as a source humor, but I had to laugh
at your response. If the idea was, as you thought, to retrieve a document,
I have actually been able to retrieve a...
Forum: General Discussion July 23rd, 2007, 07:26 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 83
Posted By Scafidel
Cell color formula

I see what you mean. I could use different colors: red from 90-100%, yellow
80-90%, etc. I am familar with VB, but have not used it for colors.
Thanks

"JLatham" wrote:

I should also mention...
Forum: General Discussion July 22nd, 2007, 09:40 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 57
Posted By Scafidel
how do i unsave an excel document?

You could delete it.

"JLatham" wrote:

Basically you can't, unless you have a backup copy of the file. Saved is
saved.

"lofi" wrote in message
...
Forum: General Discussion July 22nd, 2007, 04:52 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 83
Posted By Scafidel
Cell color formula

Thanks for quick response. I am only getting two colors, though. 100% is
red as I wanted, but anything less is the same light pink (the color I copied
out of Paint).
Lafayette, LA


"JLatham"...
Forum: General Discussion July 22nd, 2007, 12:08 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 83
Posted By Scafidel
Cell color formula

I would like a formula to change colors in cells B1-BX based on the values of
cells A1-AX, which are percentages from 0% to 100%. So, if A5=100%, B5 would
be absolute Red. If A6=99%, B6 would be...
Forum: General Discussion May 28th, 2007, 09:15 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 85
Posted By Scafidel
Compare workbooks

The two workbooks, (old, new) have the same named sheets which near 90; but
the updated "new" could be an addition or deletion of information on the
sheets, i.e., a name, an address, a phone...
Forum: General Discussion May 28th, 2007, 07:49 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 85
Posted By Scafidel
Compare workbooks

I have several huge workbooks that I update regularly. Most of the people
simply print out the new and discard the old, however some have asked for
"changes only" since the workbooks can take a...
Forum: General Discussion May 16th, 2007, 01:22 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 97
Posted By Scafidel
Dates

Thanks for all the good avise, guys!
I really appreciate it.

"Dave Peterson" wrote:

cStr() will add those space characters.

And it's more usual to use + to add numbers and & to concatenate...
Forum: General Discussion May 15th, 2007, 10:14 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 97
Posted By Scafidel
Dates

Hey, thanks alot Joel. I guess I need to learn more about VB, I keep finding
solutions there. For some reason, I am getting a space after the slash, 5/
1, 5/ 2. Otherwise it works...
Forum: General Discussion May 15th, 2007, 01:58 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 97
Posted By Scafidel
Dates

I have an invoice with a starting date through ending date of workdays. I
use NETWORKDAYS to find the total, but I would also like to list the dates
worked in one cell, like C1, below. similar to...
Forum: General Discussion May 14th, 2007, 02:39 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 62
Posted By Scafidel
Text and Date

Thanks, Biff. This Discussion Group always comes to the rescue!
Scafidel
Louisiana

"T. Valko" wrote:

Do you have both dates in separate cells? Like this:

A1 = May 14 (formatted as DATE)
...
Forum: General Discussion May 14th, 2007, 05:46 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 62
Posted By Scafidel
Text and Date

I would like to end up with something like "Week of May 14 to May 18", but
when I combine the text with the date (from another cell), the date shows up
as a serial number. If necessary, I can...
Forum: General Discussion April 7th, 2007, 08:10 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 59
Posted By Scafidel
Sum Workbook on Worksheet

VoilĂ*! Thanks, Max. That did the trick! You're right, it will look better
with the individual returns. This will really look nice, neat and simple.
Jerry



"Max" wrote:

"Scafidel"...
Forum: General Discussion April 7th, 2007, 12:12 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 59
Posted By Scafidel
Sum Workbook on Worksheet

Max,
Thanks for your detailed response. I believe this will work, but some of
the formula are new to me and I'm having trouble applying them. On my sheet,
the first 9 rows are various parts of a...
Forum: General Discussion April 5th, 2007, 05:10 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 59
Posted By Scafidel
Sum Workbook on Worksheet

I would like to create a summary worksheet at the end of my workbook that
would add all the Acres (see below) of each Lessor on all worksheets. Each
sheet of the workbook contains information like...
Forum: Worksheet Functions February 23rd, 2007, 06:43 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 66
Posted By Scafidel
ActiveX Toggle Workbook

Thanks, again. Works well.

"Gord Dibben" wrote:

Private Sub ToggleButton1_Click()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If Not ws.Name Like "Totals-*" And _
...
Forum: Worksheet Functions February 23rd, 2007, 03:45 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 66
Posted By Scafidel
ActiveX Toggle Workbook

This probably should be a new thread, but I thought I'd go to the well once
more. I am using an ActiveX Togglebutton to hide/unhide rows of nonessential
information on various sheets in a...
Forum: Worksheet Functions February 22nd, 2007, 05:45 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 66
Posted By Scafidel
ActiveX Toggle Workbook

Thanks for the quick reply.
Scafidel

"Gord Dibben" wrote:

Private Sub ToggleButton1_Click()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name "displayall" Then
...
Showing results 1 to 25 of 35

 
Forum Jump

All times are GMT +1. The time now is 05:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright ©2004-2022 OfficeFrustration.
The comments are property of their posters.