I have a report containing a graph that looks fine in preview but when printing to pdf or printer, I may only get an empty frame. I tried changing the page size, graph object size, printer set...
Sorry for this newbie question, I have done a lot of data manipulation in Access but never written an access report.
I have a report written by someone else that uses a temp table to draw t...
When opening a cross tab report, if any of the fields on the cross tab are null, the report will not print. Can these fields containing nulls be forced to 0s so that the report will print and ...
I have the following grouping/sort in my report:
Group on Job Code
Group on PO Number
Sort by Check Request Date
I want to keep these like that. The user however needs to be able to so...
I have the following code, that I retrieved from microsoft's Scripting Guy,
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\chris\115.mdb"
objA...
Hello Experts,
I have a query (actually many different ones) but for now, just this one that must be ran every month. It finds activity codes from users which are then exported to Excel and...
I have this criterion in a Query in the date field of the underlying Table:
<["Before which date"] And >["After which date?"]
The query then only selects records between those dates.
H...
I have set up a form in Access 2000 using Microsoft Rich Textbox Control. It shows the text in the format that I want (bolded, underline, etc.) just fine. Now, I want to show the same inform...
I need to print out a report in Access 2003, where some of the records do not have pictures. When the report is run, records with associated jpgs print fine, but a record with no picture print...
Here is a puzzlement.
I have an MS Access database and am using on a report in the Control Source the default to populate a textbox field with the current date in long format and am using ...
Hi,
How can I sort data in access form.
I have few fields in my form.
Customer, facility, address.
I'd like sort data in my form by Customer field in alphabetical order.
If I put dat...
I don't even know if this is possible... I'd like to create an Access Report that provides different data metrics. Say a 10 page report, that breaks down the data in a lot of different ways, ...
Is there any way in Access to highlight certain words in a form or a report? The words in question are key words in a search funtion and are stored ina text field or a string as necessary
Hi,
I have an Access report with a large number of fields.
I need it to print on one page, so I have squeezed the fields together and turned on Can Grow.
My problem is that I need some sor...
Hello, I have a order table with different statuses like 4.0 and 4.1,
The status column is std_code. I want to count all the statuses from a particuler period (like status 4.1 = 154 and 4.2 =...
I am creating a label in access 2000 as a report. I can't change the left margin of my page to 0. I went to 'Page set up' changed the left margin to 0, pressed OK and saved, but the margin go...
Hi
I am working in Excel and i have 50 different sheets sheet1, sheet2, ..., sheet50
i inserted a new sheet in which i waht to copy a cell from each sheet(1 - 50)
so i create a link ina ce...
Hello,
I am building a report of daily total quantities delivered to customers by week
I want to format the report such that it reads across the page rather than down
IE
Week Numbe...
I have a report that is based on a query which is in turn pulling data from about 15 other queries. Yes - this query structure may be inefficient, but it was the best way that I knew to gener...
I have attached a sample database.
In my database I have several One-to-Many relationships between tables. When viewing this linking information via a query or report, the data is listed in ...
Grreting all,
I attached a sample of the database I'm creating for reference and help. I created the tables and forms I needed to collect the data I needed. Here's where i need help. I wa...
I have a DATACARD SP75+ (Card Printer) and i created my own Access 2003 Database to print my cards. Now i need to encode the magnetic stripe of the card through my database.
Please help.
T...
Hello,
I have a report based on a query. However the query does not aggregate data.
In the report I have created a text box which counts the number of records satisfying a criteria in a ...
Hi,
I found a website a while ago which explained how you can make reports in access by looking at two dates and then taking the values in between into a report. This all works fine with a ...
I am working in an employee database someone else build and I have a request to create a report that displays the employees name and picture. The table storing this information has the picture...
