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 11 of 11
Search took 0.07 seconds.
Search: Posts made by: Scafidel[_3_]
Forum: General Discussion June 3rd, 2010, 07:32 PM Posted to microsoft.public.access
Replies: 1
Views: 3,400
Posted By Scafidel[_3_]
Display subform total

I have an Access 2007 single form with subform. The subform has a hidden
textbox that sums a record in the subform and displays in a textbox on the
form. The form textbox is blank, but becomes...
Forum: General Discussion March 26th, 2010, 06:17 PM Posted to microsoft.public.access
Replies: 1
Views: 78
Posted By Scafidel[_3_]
Recordset merge

I found it. I was closing my RS twice. Remarked one out and it runs good.
Thanks for looking.
--
Lafayette, LA


"Scafidel" wrote:

I am merging from an Access 2007 Form/subforms to a...
Forum: General Discussion March 24th, 2010, 10:19 PM Posted to microsoft.public.access
Replies: 3
Views: 182
Posted By Scafidel[_3_]
Fixed field characters

Thanks, John! That did it. I had to force the table to not wrap.
--
Lafayette, LA


"John Spencer" wrote:

If it is a specific number of characters.

= Left("*" & Num2Text([TB],3) &...
Forum: General Discussion March 24th, 2010, 07:11 PM Posted to microsoft.public.access
Replies: 3
Views: 182
Posted By Scafidel[_3_]
Fixed field characters

I am filling a bank draft field with this code in Expression Builder and
would like it to always fill with "*" to the end whether it is "TEN DOLLARS"
or "FIVE THOUSAND FOUR HUNDRED AND FOURTEEN...
Forum: General Discussion March 15th, 2010, 08:10 PM Posted to microsoft.public.access
Replies: 1
Views: 78
Posted By Scafidel[_3_]
Recordset merge

I am merging from an Access 2007 Form/subforms to a bookmarked Word document.
I am able to use .MoveNext to merge the recordsets, but get an error if
there are less records.
The DAO Library is...
Forum: General Discussion May 29th, 2009, 09:14 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 87
Posted By Scafidel[_3_]
Updating cells

Thanks, Sendkeys was the ticket!
--
Scafidel
Lafayette, Louisiana


"Gary''s Student" wrote:

Why do you need to remember to change it in the code?
Why keep the formula in the code at all?
Forum: General Discussion May 29th, 2009, 04:49 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 87
Posted By Scafidel[_3_]
Updating cells

I have a workbook with merged cells with code that increases row height as
needed according to size of the string. I created a macro that essentially
goes to each such cell and hits F2 enter...
Forum: General Discussion May 24th, 2009, 03:38 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 117
Posted By Scafidel[_3_]
Concatenate and character size

Thanks, Ron. That did it. I had to massage it a bit, but it looks good.
--
Scafidel
Lafayette, Louisiana


"Ron Rosenfeld" wrote:

On Fri, 22 May 2009 16:54:03 -0700, Scafidel...
Forum: General Discussion May 23rd, 2009, 12:54 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 117
Posted By Scafidel[_3_]
Concatenate and character size

Thanks. That'll help.
--
Scafidel
Lafayette, Louisiana


"Ron Rosenfeld" wrote:

On Fri, 22 May 2009 13:21:01 -0700, Scafidel wrote:
Forum: General Discussion May 22nd, 2009, 09:21 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 117
Posted By Scafidel[_3_]
Concatenate and character size

I am using this formula to evenly space information across a cell (label).
Essentially, I would like Cell B4 to appear on the Left and Cell B3 apears on
the Right in the cell with the formula. B4...
Forum: General Discussion April 21st, 2009, 08:09 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 77
Posted By Scafidel[_3_]
Dissapearing Message

Thanks, GS, it worked, but once it was used, I had to reinstall the hyperlink
each time. Is there anyway to have it restore the hyperlink, if used and
then emptied?
--
Scafidel
Lafayette,...
Showing results 1 to 11 of 11

 
Forum Jump

All times are GMT +1. The time now is 01:41 PM.


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