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 2.82 seconds.
Search: Posts made by: Allen Browne
Forum: Setting Up & Running Reports June 7th, 2010, 03:22 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 1,998
Posted By Allen Browne
PageSetup properties keep changing

Make sure Name AutoCorrect is turned off.
Then compact the database.
Explanation:
http://allenbrowne.com/bug-03.html

If this is Access 2007, make sure you have applied the service packs. SP2 is...
Forum: Setting Up & Running Reports June 7th, 2010, 07:39 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 2,925
Posted By Allen Browne
easiest way to create gridlines in an Access 2003 report

You can use the Line method of the report in its Page event.
Use a loop to repeat at whatever grid size you want.
Measurements are in twips, where 1440 twips = 1 inch

This is how the Line method...
Forum: Setting Up & Running Reports June 6th, 2010, 04:58 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 2,053
Posted By Allen Browne
Prevent skip to new page after last page prints

Remove the page break control.

Instead set the Force New Page property of the section to before (if you do
this in the group header) or After (if you do this in the group footer.)

--
Allen Browne...
Forum: General Discussion June 5th, 2010, 04:15 PM Posted to microsoft.public.access
Replies: 2
Views: 1,709
Posted By Allen Browne
Where is the startup manager in 2007

To specify the form you want loaded at start up, go to:
Office Button | Access Options | Current Database | Display Form

If you are trying to design a splash form that displays version info, this...
Forum: Using Forms June 5th, 2010, 03:03 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 1,722
Posted By Allen Browne
Criteria for check numbers only

The problem seems to be that you have two pieces of information in the one
field -- the type and the number.

The solution is to follow the rule to make your fields atomic (i.e. only one
thing in...
Forum: Setting Up & Running Reports June 5th, 2010, 02:45 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 2,053
Posted By Allen Browne
Prevent skip to new page after last page prints

If you have *no* report footer (or a zero-height one), it should not print a
blank page at the end.

If you need the report footer, drop the Report Header section instead, and
change the report so...
Forum: General Discussion June 4th, 2010, 10:48 AM Posted to microsoft.public.access
Replies: 2
Views: 867
Posted By Allen Browne
VBA conditional formatting

If you use VBA code to set the properties of the controls (ForColor etc), it
will affect all rows of the datasheet, so no: that's not possible.

You can use that approach in a report: that's...
Forum: Setting Up & Running Reports June 4th, 2010, 02:09 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 370
Posted By Allen Browne
Opening Report Closes Database

Sounds like something has corrupted with the subreport.

Follow the steps suggested here (in order):
http://allenbrowne.com/recover.html

I imagine you will need to use the SaveAsText at the end...
Forum: Setting Up & Running Reports June 4th, 2010, 02:06 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 735
Posted By Allen Browne
filrter several reports

Yes: you can use one form to filter several reports.

You need a control where the user selects which report they want. That could
be a option group, or a combo or list box. Use the AfterUpdate...
Forum: General Discussion June 3rd, 2010, 04:29 AM Posted to microsoft.public.access
Replies: 3
Views: 379
Posted By Allen Browne
Table of Contents in an Access Report - Possible?

Not a simple task, but here's Microsoft's suggestion on how it can be done:
http://support.microsoft.com/kb/210269

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access...
Forum: Setting Up & Running Reports June 3rd, 2010, 04:17 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 381
Posted By Allen Browne
Report formatting hangs

This is probably to so with the properties of the sections and groupings. It
may be attempting to find a solution that's not possible.

To test if this is the problem, open the report in design...
Forum: Setting Up & Running Reports June 3rd, 2010, 04:13 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 326
Posted By Allen Browne
Highlighting a word when it shows up on a report

Access 2007 and 2010 have a text box that supports rich text, so it is
possible in these versions.

Details:
Highlight matches
at:
http://allenbrowne.com/AppSearchHighlight.html

Includes a...
Forum: Using Forms June 2nd, 2010, 02:10 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 887
Posted By Allen Browne
How to use dynamic query in Access 2007 Form?

Best to ask a new question as a separate thread.

If you don't want the parameter dialog popping up, then I presume you want
it to pick up the parameter values from an open form. You can do that by...
Forum: General Discussion June 1st, 2010, 04:07 AM Posted to microsoft.public.access
Replies: 3
Views: 319
Posted By Allen Browne
Running Access 2007 In Office 2003

If you already have Access 2003 on your computer, you can do a custom
install of Access 2007, and instruct it not to remove Access 2003. (The
default install will remove it.)

You can then use each...
Forum: Using Forms June 1st, 2010, 04:02 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 887
Posted By Allen Browne
How to use dynamic query in Access 2007 Form?

The table you have is structured like a spreadsheet rather than a database.
If you build it that way, you lose most of the power and reliability that a
relational database can give you, and you...
Forum: Using Forms May 29th, 2010, 10:50 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 348
Posted By Allen Browne
Using the SUM function in a main form -referring to a sub form

Presumably you have two subforms (say Sub1 and Sub2), and you have the total
in the Form Footer section of each subform working correctly.

To subtract one from the other, place a text box on the...
Forum: Database Design May 29th, 2010, 06:46 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 8
Views: 437
Posted By Allen Browne
[OT] Allen Browne's 'Library Resource'

"Fred Boer" wrote in message
...
chuckle Been so long since I've posted, I can't remember how to do it
correctly!...
Forum: Database Design May 29th, 2010, 02:21 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 8
Views: 437
Posted By Allen Browne
Allen Browne's 'Library Resource'

There's not a sample database for this page:
http://allenbrowne.com/AppLibrary.html

You can make one quite quickly from the screenshots.

--
Allen Browne - Microsoft MVP. Perth, Western...
Forum: Running & Setting Up Queries May 28th, 2010, 02:33 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 398
Posted By Allen Browne
Next to Last Date

Time to learn about subqueries. Here's an intro:
http://allenbrowne.com/subquery-01.html

You will end up typing an expression like this into a fresh column in the
Field row in query...
Forum: Running & Setting Up Queries May 28th, 2010, 03:42 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 407
Posted By Allen Browne
Currency Format Lost in Union Query

What data types are these fields?

The field in a UNION query will normally take on the data type of the field
in the first SELECT. So, if the field in the first SELECT statement of the
UNION is of...
Forum: Running & Setting Up Queries May 27th, 2010, 10:15 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 873
Posted By Allen Browne
Criteria to return all records if selection from form is null

It is possible to craft the WHERE clause of the query to it evaluates to
TRUE if the control on the form is null.

Switch the query to SQL View.
Locate the WHERE clause. It will be something like...
Forum: General Discussion May 25th, 2010, 03:24 AM Posted to microsoft.public.access
Replies: 10
Views: 372
Posted By Allen Browne
Duplicate Field Names

So you have a Student table and a Guardian table.
One student can have multiple guardians?
One guardian can have multiple students.

The simplest solution would therefore be to create a...
Forum: Running & Setting Up Queries May 25th, 2010, 03:12 AM Posted to microsoft.public.access.queries
Replies: 3
Views: 393
Posted By Allen Browne
adding a Carriage Return or Line Feed character to an update query

Chr(13) & Chr(10)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot...
Forum: Using Forms May 24th, 2010, 03:00 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 346
Posted By Allen Browne
On No Data Event

Cancel the form's Open event, e.g.:

Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
Cancel = True
MsgBox "Nuffin 2 c here."
End if
End...
Forum: Setting Up & Running Reports May 24th, 2010, 02:55 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 320
Posted By Allen Browne
Write Name of Report Query in Report Footer

"Steve Stad" wrote in message
...
Is it possible to programmatically write the name of the query the...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:23 AM.


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