Search Result

Hello, I am currently writing a work term report on the efficiency / organizational abilities of PHP. Can anyone suggest a book that I can look at for useful information? I am asking for a book because I need to include non-internet citations.

Thanks,

Pawel

I have set up for users to output various forms and reports to either Excel or to PDF format. In both cases, I would like the footer to not be included in the output. The footer area includes the button to output the form or report. Any suggestions?

I have an agreement template in a MS access report. The report's fields are populated by the form's records. my goal is to automate the report to filter to the agreement # to what ever the current agreement # on the form is. i do not want to have to enter the agreement # every time i click on the cmd function to preview the report. below is the code i have, can someone please edit my code to what it should be?

...

I found a post on here earlier regarding this problem and there was no solution. I don't necessarily have a solution, but I came across a workaround in my instance. I found that Access would crash when I opened certain reports (not all - the only pattern I could find was that these reports contained subreports).

I had recently changed the options from tabbed windows to overlapping windows. I changed it back and "Voila" all...

Hey all,

I'm a little new to Access 2007 and need help coding filters in VBA.

Right now my report has 3 fields:
FirstName LastName Grade

In the header of my report are 1 checkbox for each grade (9 - 12).

I want to be able to display, for example, only students in Grade 12 when I click the "Grade 12" checkbox.

The ApplyFilter method won't work because, according...

Hi Everyone,

I've read the Insight article regarding this topic (Courtesy of MMcCarthy); however I suspect there might be an easier way than the mentioned extensive VBA coding.

My situation has spanned several posts now (first post), and I am still as of yet to post my promised summary code / database structure (sorry! Undergoing a revamp currently), and I now find myself in the situation of writing multiple, repetitive...

Hi,

I have a form A that contains a subform B listing the names of potentially multiple people all associated with the 1 record displayed on form A. That part works just fine.

Now, I want to be able to create ONE line (NOT just a subreport listing all the names from the subform) in my associated report that basically loops through all the records, pulls out all the names associated with that one record, and lists...

I have a database of people who call into our office for assistance. They are designated by their location (A drop down menu with City/County/Out of County) and then the Nature of Problem is checked off (Eviction, Request for Housing, Implied Warranty) (Sometimes someone needs all three options).

I would like to show in a monthly report how many times a check box was clicked for the Nature of Problem and the location the call was...

I have a client that has all their reports, data, and code in Access 2000...They also have a copy of Access 2007 that they want to copy or somehow trigger a report in access 2000 and email it to 150 employees since emailing in access 2007 is much easier and more robust than it was in access 2000.

Just in case this gets confusing, they are wanting to press a button in access 2007, which emails ReportA from access 2000. Let me know...

Hello all,

I am trying to print values in a report with the following code:
...

Hello,
I have a text file(tab delim) with data and I want to create report. Here is the content of text file:

HD John Smith j.smith@testmai l.com
CT service 1 5$
CT service2 1 6$
CT service3 4 7$
FT total 6 18$
HD Cindy Surname c.surname@testm ail.com
CT ... ... and etc.

HD- is report header, CT-report content(invoice items), FT-footer.

Now I'm splitting...

Hi,

Currently on each report I put in pagefooter: number of pages,pages in group,id number and etc. I need to write that info vertically in the middle of page. Something like that:
-------------
|.............|
|.............|
|.............|
|i............|
|n............|
|f............|
|o............|
|.............|
|.............|
-------------

I know...

Hi, I a several subforms in a report and for some records the subforms do not return any data. When this happens, I would like to display a message as at present the area normally occupied by the subform is simply blank. Can anyone help me? Thanks in advance.

I have a form "PartsAndInvoic es that has all the parts in the database listed in split form view. I want the user to use Access 2007's filter section on the ribbon to choose mutiple filters. Me.Filter may equal ([Lookup_cboDNRCI D].[DNRCNUM]="dnr1940"). I tried pass ing me.filter to the report but get all the records in the report not the custom filtered set.
Private Sub cmdPartsNInvoic eReport_Click()
Dim strFilter...

Hi all,

I have a report based on a table and i want something that could flag it when it is printed so i can not print it again ?

thanks in advave