|
How do I put pictures in Access then print them out?
I'm not a programmer. I'm building a database in Access 2003 of my poster
collection. I would like to include a photo of each poster in its associated
record. I've achieved that in the form with some kind of add-on program
(don't remember exact name), but the pictures don't printout on the reports.
As non-technically as possible, can you explain how I can do this.
All my pictures are in ....
|
4 |
17.08.2006 20:20:02 |
|
|
Maximize a report with Pop Up set to Yes?
I have a mainform with a command button that opens another form,
frmFinishFormulaEntry. That form has a subfom called frmFinishFormulaReports
that contains an option group allowing users to view or print various reports.
I have to set the Pop Up property to Yes for those reports so that they open
up "on top of the stack".
Can something be done that would make the forms maximize when they o...
|
3 |
17.08.2006 19:37:16 |
|
|
Print Certain Number of Pages
Depending on a value criteria from a form, I do not want the first page of a
report to print. I want to put the coding in the report. The report does
not have a set number of pages. So sometimes the report will 2 pages or 10
pages. So it varies. Sometimes I will just need to have the first page
print.
I have tried. Any help is appreciated. Thanks
Private Sub Detail_Print(Canc...
|
1 |
17.08.2006 18:26:46 |
|
|
String data from numerous records
Hi all,
I have an issue printing a report.
I have a report that groups on field1. I print fields 2 and 3 and count of
field1. No problem so far. However, I also need to print a string of field4
for the group. For example, given the following data
field1 field2 field3 field4
1 f12 f13 f14
1 f22 f23 f24
2 f32 f33 f34
3 ...
|
9 |
17.08.2006 18:25:54 |
|
|
Can font size be changed automatically?
I have a report with a field that varies in text length. Some records only
have a small amount of text in the field, while other records have a lot of
text. If I design a report to accomodate the records with largest amount of
text in the field, then when I have to decrease the font to a very small
size in order for it to print (report is actually a 5" round label and the
size and loca...
|
1 |
17.08.2006 18:18:43 |
|
|
How to eliminate duplicate information in report
I have tables and queries that track child immunizations at given locations.
The children are in one table with a unique ID. The Visit information
(location and date) are in another table with a unique ID. The immunization
visit consists of looking at a child’s information regarding 17 different
immunizations and recording the status of them, such as current or needs.
The immunizat...
|
6 |
17.08.2006 16:06:02 |
|
|
Report not showing blank records
I have noticed that on my report where the organisation field has no entry it
doesnt show that record how do i fix this>?
...
|
4 |
17.08.2006 15:19:39 |
|
|
How do I create all columns in a macro.
Hello
I am trying to create a report like the one below but I am having difficulty.
Balances EUR GBP USD
Broker 1 10.00 10.00 15.00
Broker 2 15.00 10.00 10.00
Broker 3 10.00 5.00 ...
|
3 |
17.08.2006 15:13:50 |
|
|
on close event of a report
hi all,
i am trying to update a chk box on a form on a close event of a report. the
idea is that the adviser can confrim that he has issued a confimratin letter
to a client, when the report closes, this will then update a hidden chk box,
which will then inturn identify that the letter has been issued.
here is the code
Private Sub Report_Close()
If vbYes = MsgBox("Have you issue...
|
5 |
17.08.2006 15:08:03 |
|
|
I'm gonna feel real silly, but......
I have overlooked something really obvious, but I am in one of those "can't
see the wood for the trees" type of situations.
I output a report to a barcode printer to make a label - I have an identical
printer on another PC with all the printer driver settings the same, but the
resultant print is half the size from the second machine.
What have I overlooked?
As long as you give me th...
|
1 |
17.08.2006 11:28:02 |
|
|
Report not showing record with a blank field
I have noticed that when i print my report if the organisation field is blank
the particular record does not show for a person even though it appears the
table source??? how do i fix this?? ...
|
4 |
17.08.2006 10:25:56 |
|
|
Print Lines - Lebans Printlines Help
Hi Guys,
I am trying to use this print line function, but cannot work out how I turn
it off for the page header and footer sections. Can anyone help please ?
...
|
4 |
17.08.2006 08:00:02 |
|
|
Lines and Shading
How do I preserve the lines and shading in my report when it is exported to
Word or as an .rtf file?...
|
4 |
17.08.2006 03:13:01 |
|
|
Section Size limited on Report
Hi,
I have created a report and now it is telling me that I cannot have its
height more than 55cm. Is there a way around this as I have more data I need
to put on the report?...
|
2 |
17.08.2006 03:11:45 |
|
|
Display reports in preview mode with the Access Window hidden
I have an Access 2K2 application running at the office that uses Dev's
fSetAccessWindow() function to hide the Access window. It works great, but
recently, some of my users wanted a way to preview a report, rather than
direct it to the printer. When I try to do this, Access locks up, even when
I set the popup and modal properties of the report to Yes.
I have worked around this by outp...
|
1 |
16.08.2006 23:47:16 |
|
|
Don't want to count duplicates in Report
I need the duplicates my report, but I don't want to count them. I was
to have a =count([]) and then a =count where is does not count the
duplicates.
Not sure how to do the second one.
David
...
|
5 |
16.08.2006 20:53:28 |
|
|
add picture to report
I'm trying to add a picture to my report where the path of the picture is in
the [Pic] field.
The help section has the following blurb...
>>Click the Build button next to the OnCurrent property box, and then click
>>Code Builder in the Choose Builder dialog box. <<
I don't have an "OnCurrent" property to my report.
What did I miss?
thanks!
...
|
4 |
16.08.2006 20:47:08 |
|
|
Emailing reports with using filters
i have 200 stores that i have to email a store specific report to which is
contained in a query. i have used the filter function and created filters
and then used a macro to send the store specific report out to my stores. My
question is, is there a more simple way to get a these store specific reports
without creating 200 filters. Also looking to see if there is an easier way
to send...
|
1 |
16.08.2006 20:42:01 |
|
|
Using the '&' for text.
I have a report that needs to be titled 'Employees enrolled in AD&D'.
However, when I type in the & sign, access drops the & and underlines the
last D.
Is there anyway to get around this....
|
3 |
16.08.2006 20:38:02 |
|
|
I have a report i want to email as an attachment
I process a form by autoupdating it. I then display it for any
corrections. I then want to somehow send a report for the current
record contained on form. I could use a button to generate it.
Currently I build a separate recordsource while building the
recordsource for the form which works but any edits won't be reflected
in the report.
my questions are:
1. what should i use for the records...
|
1 |
16.08.2006 20:08:02 |
|
|
Total Pages Limitation?
Hello,
Is there a limit to the number of [PAGES] a report will count in Access
2003? I have a report with the text box: ="Page " & [Page] & " of " &
[Pages].
The PAGES field only goes to 21388, while the PAGE field goes to the total
for the report, which is 77,000+ pages.
--
David...
|
3 |
16.08.2006 19:49:02 |
|
|
Sum not to include given records
How can I show a total in my report footer that does not include given
records in the sum? My report has several regions and their leads recieved
in the detail section. In the detail section (and group sections) I want to
show the leads recieved for all regions including the "out of area" region;
however, I do not want the "out of area" leads included in the total at the
end of the rep...
|
4 |
16.08.2006 18:46:02 |
|
|
Access Report Question
I have a problem with a report I have created in access. I have many
fileds whioch contain no data and I would like to hide the labels for
those empty fields in the report. Does anyone have any idea how to do
this?
...
|
2 |
16.08.2006 18:37:41 |
|
|
Don't want to count duplicates in Report
I need the duplicates my report, but I don't want to count them. I want
to have a =count([]) and then a =count where is does not count the
duplicates.
Not sure how to do the second one.
David
...
|
1 |
16.08.2006 18:29:45 |
|
|
draw lines in report
hi
i have a report with name "RPTsellfactor" with source "TBLorders"
ihave three txt box in it with name "TXTtotalprice","TXTcheque","TXTcash"
with currency format
i want to create a textbox with name "TXTremainder" that shows
"TXTtotalprice"-("TXTcheque"+"TXTcash") value
this report has been grouped by field "orderID" which is 'uniqe key' of
"TBLorders" on the
other word each pa...
|
2 |
16.08.2006 18:28:11 |