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 100
Search took 14.73 seconds.
Search: Posts made by: fredg
Forum: Setting Up & Running Reports May 20th, 2010, 01:11 AM Posted to microsoft.public.access.reports
Replies: 9
Views: 314
Posted By fredg
Report - Don't print the page footer on the last page

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page...
Forum: Setting Up & Running Reports May 18th, 2010, 09:43 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 326
Posted By fredg
Concatenate Expression with text string in Report?

On Tue, 18 May 2010 13:04:01 -0700, Steve Stad wrote:

I would like to concatenate the text string..."Birthdays in " with the
expression =MonthName(Month(Now())). Can someone provide the...
Forum: Running & Setting Up Queries May 17th, 2010, 05:52 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 853
Posted By fredg
Multiple criteria IIF function help

On Mon, 17 May 2010 09:18:01 -0700, Cam wrote:

Hello,

I am trying to create an IIF query field where if RtgGrp not equal NA or
Non, the return Yes, otherwise return No. But it is not...
Forum: Setting Up & Running Reports May 14th, 2010, 09:41 PM Posted to microsoft.public.access.reports
Replies: 11
Views: 577
Posted By fredg
Conditionally Format A Line?

On Fri, 14 May 2010 17:41:06 GMT, 1stAyd via AccessMonster.com wrote:

Now I'm really confused. As an attempt to simplify, I put this line into "On
Format" of the "Detail" section:

...
Forum: Setting Up & Running Reports May 14th, 2010, 06:49 AM Posted to microsoft.public.access.reports
Replies: 11
Views: 577
Posted By fredg
Conditionally Format A Line?

On Thu, 13 May 2010 20:28:14 GMT, 1stAyd wrote:

Greetings, Access Novice here.

I have Line18 formatted as Visible = "NO" in Properties, and I want to make
it visible depending on the value...
Forum: Running & Setting Up Queries May 13th, 2010, 07:28 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 397
Posted By fredg
IIF function help in query

On Thu, 13 May 2010 07:00:01 -0700, Cam wrote:

Hello,

I have the following field in the query to look at a field PartDesc, if any
of the text have a *BUSH* word, return yes, otherwise...
Forum: Using Forms May 13th, 2010, 06:16 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 306
Posted By fredg
New Problem - Buttons

On 13 May 2010 16:00:59 GMT, Vito wrote:

In 2007:

In a form I created a button, used the wizard to set it to go to next
record when clicked. When I click it, I get this:

The...
Forum: Setting Up & Running Reports May 12th, 2010, 11:27 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 323
Posted By fredg
Showing field after page 1

On Wed, 12 May 2010 14:41:00 -0700, Don wrote:

Hello, I have an Access 2003 report that show several fields on the top of
the first page (one of thses fields is the WorkOrderID), these fields...
Forum: Using Forms May 12th, 2010, 05:37 PM Posted to microsoft.public.access.forms
Replies: 17
Views: 661
Posted By fredg
How do I sort a listbox by field

On Wed, 12 May 2010 11:07:15 -0500, Bruce Rodtnick wrote:

But with this code...HOW do I get rid of the semi-Colon?

"Douglas J. Steele" wrote in message
...
Forum: Using Forms May 11th, 2010, 11:53 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 142
Posted By fredg
Conditional formatting not quite working

On Tue, 11 May 2010 15:26:27 -0700, Repent34 wrote:

I have a form that is generated by a query. The query is populated via
table.

I want all values in the report that are over 1.99% to show...
Forum: Using Forms May 11th, 2010, 11:29 PM Posted to microsoft.public.access.forms
Replies: 17
Views: 661
Posted By fredg
How do I sort a listbox by field

On Tue, 11 May 2010 14:47:05 -0500, Bruce Rodtnick wrote:

And that's what I'm TRYING to do...This is what I have now:

Dim strSQL As String

strSQL = Me.lstMailTo.RowSource

strSQL =...
Forum: Using Forms May 11th, 2010, 02:49 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 169
Posted By fredg
Internet Explorer 8 Update problem

On Mon, 10 May 2010 20:51:21 -0400, Red Racer wrote:

Hi,

I have recently updated my Windows XP Pro system to service pack 3 and
Internet Explorer 8. Previously I had service pack 2 and...
Forum: Setting Up & Running Reports May 8th, 2010, 12:25 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 283
Posted By fredg
color text in report

On Fri, 7 May 2010 14:42:01 -0700, shwan wrote:

I have a 3 text (High , Normal , Low ) in filed bound to txt.remark filed , I
want in print out [txt.remark] appear in a diffrent color depending...
Forum: Running & Setting Up Queries May 7th, 2010, 01:09 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 147
Posted By fredg
Finding a function call in queries

On Thu, 6 May 2010 15:57:01 -0700, cherman wrote:

Does anyone know of a way to find if a function is being called from a query?
Another words, I have a function that might be called from 1 or...
Forum: Setting Up & Running Reports May 5th, 2010, 12:14 AM Posted to microsoft.public.access.reports
Replies: 6
Views: 344
Posted By fredg
How do I parse a phone number?

On Tue, 4 May 2010 14:47:01 -0700, gagecres wrote:

I keep getting a syntax error.

"Petr Danes" wrote:

If you always have all ten digits, something like this might work:

="discuss...
Forum: Using Forms May 4th, 2010, 09:21 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 197
Posted By fredg
Filter

On Tue, 4 May 2010 11:36:10 -0700, PJ wrote:

I have a filter on a form based off of multiple criteria. Once you put the
criteria I have a command button to search for this criteria based on...
Forum: Using Forms May 4th, 2010, 09:14 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 161
Posted By fredg
Allowing Temporary Sorting

On Tue, 4 May 2010 12:24:01 -0700, Williams wrote:

I have a form that I always want to appear with the records displayed in sort
order. The end users may sort the data by any column desired,...
Forum: Using Forms May 4th, 2010, 05:44 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 183
Posted By fredg
allow user to highlight field on form

On Mon, 3 May 2010 23:06:01 -0700, aussiebob wrote:

"fredg" wrote:

On Mon, 3 May 2010 16:52:01 -0700, aussiebob wrote:

I have a database which records info about disabled people. One...
Forum: General Discussion May 4th, 2010, 05:36 PM Posted to microsoft.public.access
Replies: 2
Views: 96
Posted By fredg
DLookup Problem

On Tue, 4 May 2010 09:15:01 -0700, tgavin wrote:

Here is my code. It is returning a type mismatch error and I can't figure out
why.

dblPriceToPurchase =...
Forum: Using Forms May 4th, 2010, 01:41 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 183
Posted By fredg
allow user to highlight field on form

On Mon, 3 May 2010 16:52:01 -0700, aussiebob wrote:

I have a database which records info about disabled people. One form is used
to input comments about the the person and has several memo...
Forum: Running & Setting Up Queries April 30th, 2010, 10:01 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 160
Posted By fredg
Using Between...And with General Date

On Fri, 30 Apr 2010 13:08:04 -0700, mewins wrote:

I am trying to query all records created between given dates. The field,
DtRecCrt, is a general date field that is set to =Now() whenever the...
Forum: Using Forms April 29th, 2010, 11:40 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 112
Posted By fredg
Conditional format of a control

On Thu, 29 Apr 2010 14:26:01 -0700, Toller wrote:

I have a form that among other things has on it a field called 'EndDate". I
need to add a field that will be conditionally formatted. If the...
Forum: Running & Setting Up Queries April 29th, 2010, 10:19 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 264
Posted By fredg
Convert to Proper or Title Case in Access 2003

On Thu, 29 Apr 2010 13:00:02 -0700, Jeff wrote:

I am trying to convert a field that is in all CAPS to Proper Case. Ex: Field
Name is First Name, contents "ROGER". Desired way for First Name...
Forum: New Users April 29th, 2010, 06:07 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 263
Posted By fredg
Help Me!!!!!!!!!

On Thu, 29 Apr 2010 07:50:21 GMT, Achit via AccessMonster.com wrote:

I Have 2 question
1.I want maximize view of form, when I move to another computer, the view of
form not flexible, it means...
Forum: General Discussion April 28th, 2010, 09:15 PM Posted to microsoft.public.access
Replies: 2
Views: 95
Posted By fredg
opens a report

On Wed, 28 Apr 2010 07:44:01 -0700, jwebster1979 wrote:

I have a form that is basically an invoice, I want a command button that
opens a report that will print only the invoice I am viewing. I...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:02 PM.


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