I am programming in Access 2007 but it has to be compatible with Access 2003. I have a master report that has a field called txtTribe. There are two...

Access 2007 - I have a report that calculates downtime based on a combination of Date&Time Up minus Date&Time Down: =(DateDiff("n", & " " & , & " " & ))\60...

I have a report set up to group information by date and a report footer set up to give me a grand total of data from the group. The problem I came across is...

I am trying to get a text box in my footer (Me.TextFooterNote) to show visible if a text box calculation in my detail section (Me.TextCalc)=1. Depending on...

Hi This is the code I have entered in the event procedure to print a single record. Unfortunately, it's not working. How do I fix this code: Private Sub...

I have done as you suggest. still it is not working. i have placed the code in the page footer section format event. -- from chanakya Baruva

I have a report that is summarized by months. I am trying to separate totals with a line. I drew a line in the report detail but when i click on report...

I know this may seem odd, but honestly, this is what I need to make the layout proper. I have GroupHeader1. It Can Grow. I have GroupHeader2. It Can...

Hi, I have a report that works off a query, including some memo fields. In the report, they are getting cut off. I already have the controls set to Can...

Hi, I am working on an invoice form in Access via Office XP Pro on Win7. Database: tblInvoice - 1 record per invoice key - InvNo - Access autonumber...

I have a report where I would like to open and print only the chosen record. How to I specify the record? Thanks

I am using a database on a LAN and I have the following in the on format event Me.ContactList.Visible = Not IsNull(Me.ContactList) However when one user...

greetings to all I have a report bound to a query called qAttendance. The report has its Filter property set to limit the records showing in the Detail...

My objective is to use VB to hide the footer in a report. I am using the following: Reports("" & ReportName & "").Section(ReportFooter).Visible = False where...

Hi, I have a table with among other things has on number field. I want two reports, one that select only records with even number in the number field and...

=DSum(""-"","Tabel1"," = " & ) Have this on my report my report fives me this CustomerNo Amount Amount2 result C00001 1000 1000 ...

I have been given a project where I have to create a chart on a form and duplicate it on a report. There are three dates that are sequential that need to be...

Hi, I have a multi page report that always prints in reverse order, last page to first page. My printer has an option to change the order but no matter what...

Karl, Thanks for the tips, The code I have for the report button now is: Private Sub EmpButton_Click() On Error GoTo Err_EmpButton_Click Dim stDocName As...

Hi all, I've been searching for an answer to my question for a while and have got more and more confused as to the best way to approach it...I am a...