Recent content by deanwat

I am trying to to print the data from an excel document to the immediate window in access. the excel file is My Customers.xls. and this is what code I have so far. It runs but nothing appears to happen. Sub openWorksheet() Dim con1 As New ADODB.Connection Dim rec1 As ADODB.Recordset...

I am trying to build a custom toolbar with two buttons that will open two different reports. I think I have it all but the OnAction part can someone help me. Here is what I have so far. Sub AddNewCB1() Dim CBar As CommandBar, CBarCtl As CommandBarControl Dim strReport As String Dim...

I have a table and form that looks like the table below I am trying to figure out to do a monthly report, daily and who visited most like that dose anyone have any idea. I really need some help.:mad: Check in # = AutoNumber Group ID = text Indiv Id = text Date = Date

I am very new at this. So I'm sure I am far from right, so could some one help. I am trying to create a report that will ask weather you want a female or male report of customers through a input box. What I have is bellow: Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As...

I am very new at this. So I'm sure I am far from right, so could some one help. I am trying to create a report that will ask weather you want a female or male report of customers through a input box. What I have is bellow: Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As...