Search results for 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...

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.

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.

I have several subreports inside a main report but none of the labels from the subreports seem to be showing up.

I want to send a report each week automatically to two recipients. If I am away from the office it still sends report. Thx in advance.

I have a database that I would like to incorporate the ability to automatically send me the current record via email once a particular field has been changed. For example, I have a field named DateFinished. I would like to have it automatically email me the record when a date has been entered in...

Is there a way to get access to send an email based on the fact that a record has been changed. Example: Names,Addressess,Phone Numbers,Fax Numbers don't get changed that often, but I would like to know right after the record has been updated, by email,logfile,something! I also have a date/time...

I have a query that has the following fields:1-name, (timestamp for) 2-address change,3-telephone change, 4-name change,5-job postion change. I want to create a report that will list the record(s) that have been changed in the last 14 days for each change that may have been made. Thanks in...

About a week ago my computer was upgraded from Windows 98 to Windows 2000 Pro. It seems that in one of my Access databases the Date function and the Trim function does not work in any of my queries. When I copied a few of them to another DB they work fine. Bowldog