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...
I bought a new printer, and now when I try and print a report in Access by clicking the Print Button on a form - i receive the folowing error.
"There was a problem retrieving printer inform...
My report contains fields along with 9 subreports in the main detail section. The subreports repeat throughout. For example, for Record 1, the GENERAL info in the detail appears once, SUBREP...
For some reason when I try to drag an individual detail field into a header section like I've always been able to in 2003 I cannot, the detail cells are grouped to their headers and I can't se...
Is there a way to export an access report into excel and specify the formatting of some of the cells. In this case I would like a particular cell to be formatted as "wrap text" when the repor...
I have a MS Access file that runs reports from a .CSV file. I keep getting an error when I put the Date Range from 1/1/08 to anthing past 9/30/08. When the date is 10/1/08 or beyond, I get t...
Hi to all,
I would like to create PDF file in Access 2000 by VBA code.
Is there a way to save or export forms or reports in PDF format? I prefer not to use third party software. I need to d...
Could someone tell me how to convert Time() to 24 hour time?
Our MS Access Application's mdb has a table with the following fields:
1- Invoive number [InvNum] (i.e. list of all invoices)
2- Date of Invoice [DateOfInv]
3- Date Paid [DatePaid]
Quest...
it is very simple and easy, but for some reason i can not find the answer
I have about 25 different reports in ms access and would like to output all of them at once to one word file so it ca...
How do I multiply a numeric field by 100 on an Access report?
I have a button on a modal form to print a report. The button triggers the following code.
DoCmd.OpenReport stDocName, acNormal
The report is setup to print to the default printer and th...
I am using the following code within a Button on a report
'DoCmd.OutputTo acOutputReport, , "PDF Format (*.pdf)", Me.Report.Name & " " & Format(Now(), "ddmmyyyy-hhnnss")
OR
DoCmd.Ou...
I have built an Access 2007 report that shows 2 rows of sales data from each of a bunch of store locations. My table has the date, the location and the sales_amount. I grouped my query on loca...
I cannot figure out why the four subreports on my master report are coming up blank. They worked fine when I closed the db last night. The subreports themselves open fine and have data. The...
Using Access 2003, I have a report with alternate row back color using the code below. I have a field called CaseWeight. I would like to apply conditional formating with a black background w...
Hi,
I have a form which sends data to a report. For some reason its throwing up a Runtime error 3075 "Syntax error, missing operator".
Google says its missing a comma somewhere so ive ...
I have a report with a field called "TEXT42". I created another text box to do some calculations for me. In this field I want to put in a calc to figure out the quantity of records where the v...
I have 4 fields, lastname, firstname, grade, schoolname
I created sql base on these fields. A report is based on this sql.
Now I would like to have user can selectable sort section , for exa...
Hi Experts,
I am having problems adding up totals in my report colums. What I have is a query that does some basic selects, then a crosstab query groups the data I need for me and counts t...
I have a SQL view with a line to mask SSN field for specified records written like this:
SSNshow = CASE WHEN C.ID in ('SBAO','MCLT','SBAIPT') THEN " ELSE E.SSN_taxid END,
(C.ID and E.SSN...
I would like to format a number in a report. The number is set up as currency in both the table and in the query but comes out as 2000000 when what I want to see is $2,000,000
Is there a w...
I use the following code to set an Age_Group field when Date of Birth is updated:
Private Sub DOB_AfterUpdate()
Me.Age = DateDiff("yyyy", [DOB], Date)
If Month(Date) < Month([DOB]) Then
...
Hello! I have a report in access with a field (actually several fields) that are bound to memo fields that vary in length... I don't know if this is at all possible, but I'm just curious - is ...
I have some Access reports that print just fine but at the end of the report, when no more records exist, I get an extra page. This would not be a big deal except that the vendor which receiv...
