MS Access Zone

    MS Access ZONE

 
Article Author:
Page headers and footers are naturally very useful. It would have been unthinkable to create a reporting engine without them. However, they are not printed on sub-reports, the rationale being that the main report provides them. If one needs sub-report page headers or needs to customise them in any other way not allowed for the built-in section, there is a trick to create one's own.

Group headers (but not footers) have the option “Repeat Section: yes”. This means that the header will become an additional page header over all pages of that group. Now if ...
Article Author:
Sometimes, when developing a report in Access, one might wish for more than one single Detail Section. Perhaps 22 inches is just not enough, perhaps conflicting settings should be applied to different areas of the section, perhaps a section break could serve as a conditional page break...

There is a simple trick to obtain as many Detail Sections as needed. Well, there is a limit — isn't there always? — of ten user-defined sections on any report (and 200" total height). There is also a prerequisite: the rows must have a unique identifier.

...
Article Author:
Introduction

One feature painfully missing in Access is the ability to edit calculated fields. To do so anyway requires unbound control techniques, i.e. using the form events to write the calculated field into an editable control, and to propagate updates to the underlying field... with one exception!

Changing the state a check box can happen in only two ways: the user clicks on the control (or its label), or presses the space bar while it has the focus. By trapping both events, the form can perform the underlying edit. The same can be ...
Article Author:
by Patrick G. Matthews


Introduction


Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables. While Microsoft Access does not have any native functions that specifically address regression analysis, it is possible to perform regression analysis in Access via queries.

...
Solution by:
Hi,

Is there a VB code to import/eport SAS to and from Access. I am well-versed in having SAS as the originating source, but not access.

That is, can we write a code, place in a macro, that will import a SAS dataset?

Does anyone know of a good resource for bridging SAS and Access?

Thanks.
Solution by:
I have several forms which the user can go back and forth between them. The first form has Company info and its record source is CompanyInfo. The user fills in this info, and then can advance to the next form, which has a different record source, but uses the CompanyID as its Foreign Key.

When the user clicks the command button to advance to the next form, I would like the company information record to be added to CompanyInfo and I want to retrieve the autonum assigned to the record so that it can be used in subsequent forms. Then, I want the user to be able to return to the first form, if necessary, so the company info for this same record...
Overall Rank:
Genius
DatabaseMX has been a member of Experts Exchange since 09/11/2006. Since then he has earned 14 certifications, including a Genius in Access Coding/Macros.

To date, he has answered 5847 questions, and posted 32848 comments on Experts Exchange.
 
 
 
 
Zone Advisors

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
 
Second Quarter Hot Shots

Time for your 2nd quarter update! Are you in the running for the 7th Annual Expert Awards? Click on the link to find out.

2nd Quarter Update
 
 
[x]
Neglected Question
Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).
Filter: Date
one8solutions asked a question! Issues with Value List in Table ver 07 or 10 07/31/10 05:41 AM
dory550 accepted a solution! MsAccess Query 07/31/10 05:10 AM
puppydogbuddy posted an expert comment! MsAccess Query 07/31/10 04:56 AM
cactus_data posted an expert comment! MsAccess Query 07/31/10 04:43 AM
cactus_data posted an expert comment! MsAccess Query 07/31/10 04:41 AM
dory550 asked a question! MsAccess Query 07/31/10 04:30 AM
LPurvis posted an expert comment! Search list box with greater than with this code...not working 07/31/10 04:01 AM
LSMConsulting posted an expert comment! Microsoft Access security (2007 and 2010) with lin… 07/31/10 03:57 AM
LSMConsulting posted an expert comment! Microsoft Access security (2007 and 2010) with lin… 07/31/10 03:55 AM
als315 posted an expert comment! Dashboards with MS Access guidance 07/31/10 03:40 AM
 
 
Loading Advertisement...
ADVERTISEMENT