Recent content by bowldog

Compile Error - invalid outside procedure (Set is highlighted) Dim db As DAO.Database, rst As DAO.Recordset, SQL As String Set db = CurrentDb SQL = "SELECT * " & _ "FROM [program membershipSSA] " & _ "WHERE parorn='" & Text7.Text & "';" Set rst = db.OpenRecordset(SQL) If rst.BOF Then...

Thanks Aceman I moved the DAO 3.6 Library as high as it would go (3rd on the list) and still getting the error message.

Stops at Set Compile error: Invalid outside procedure I am using Access 2007 and pulling from a query

Here is the code Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) Dim db As Database, rst As Recordset Dim sql As String Set db = CurrentDb sql = "select * from [program membershipSSA] where parorn='" & Text7.Text & "'" Set rst = db.OpenRecordset(sql) If...

Upgraded from Access 2000 to Access 2003 and now my subreport is not working correctly. Any thoughts would be appreciated. The problem that is when there are no records for that group it's not showing anything when it should be showing "your SSA did not participate in any.....". The other...

Works great! a little slow but the results came out fine. Thanks again for your time.

ID Name Range 21 jones ? 22 smith ? 23 arnold ? 24 michael ? 25 johnson ? 26 davis ? 27 jones 6 28 arnold 5 29 jones 2 30 smith 8 31 ellis ?

I would like to add a new field that would indicate the range the count between all records not just 'jones'. Total records 2500+. Sorry for not making myself clearer. Thanks for any help

ID Name 21 jones 22 smith 23 arnold 24 michael 25 johnson 26 davis 27 jones I would like to count the number of records since jones last appeared.(6) Thanks in advance for your help.

I have a district participation crosstab. If the district belongs to a program the value is "1", if not then "0". I can supress the zero values. Can I change the number "1" to the letter "X"?

Having to constantly login is becoming annoying.Is there a macro or some VB code that can bypass the manual login? If so I need help developing or finding the code for it.Any ideas are welcome. Thanks in advance.

Thanks for the reply. It seems to maybe be a memory problem afterall. I have 256k of memory that goes down to 23-25k when trying to print the report then it stops with the "Cannot open any more tables" msgbox, is this normal?I'm using the task manager for the memory numbers. I'm going...

Thanks for taking time to help me with my problem.Here are the details: I'm using Access 2000/Windows 2000;Novell Groupwise for Email;I have a total of 10 subreports in the main report; I'm using SendObject command for Email to one person; when I printed the report the information stopped after...

In my report I have several subreports.When previewing report it looks fine,but when I try to email it about half way thru I get an error message "Cannot open any more tables". Has anyone encountered this before, if so is there a workaround with code maybe?

I keep getting the name of my report(mailing labels) instead of Customer Name. All of the other fields are showing fine.The field is set to: =Trim([Customer Name]), I just don't have a clue! Thanks in advance for any help.