Search results

I am stumped! I use the following Access97 SENDOBJECT command to send a report to several users via email. DoCmd.SendObject acSendReport, Instructor_update1", acFormatHTML, This routine works fine on one computer but on another I get the following Microsoft Access error message: Run-Time...

I am stumped! I use the following Access97 Code to send a report to several users via email. This routine works fine on one computer but on another I get the following Microsoft Access error message: Run-Time error 2296 "The password is invalid; the message wasn't sent. I am running Windows...

I have an access97 report that has a field labeled [hours_to_date]. In the control source properties for this field I have the following: =Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" & [employeeid]),0),"0.00") This currently shows a total all attendance records for a...

I have an access 97 application that is in need of some modifications. If you are an access programmer and have an interest in doing some work for me please email me at harper@vnet.net. Please include your hourly rate and your availability. I would like to get the changes made as soon as...

I have a report designed in Access 97. There are several caculated fields on this report. I am having trouble with this one. 1. Total Hours To Date =Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" & [employeeid]),0),"0.00") How the report works: I run this report using a...

Can I do this and if so how? I am using Access97. I have a new report I need to automatically export into a runtime database at several client sites. I found where I can use the "TransferDatabase" command in a macro and actually get the report exported to the proper database. My problem is...

In addition to my earlier post on using filter by form in a runtime application; another problem I am having is that in the runtime version when I open the form and click FILTER BY FORM, the data from the record that is currently displayed on the form remains on the form making it impossible to...

I am using Access97 and have added filter by form, apply filter and remove filter to my toolbar in my application. I have a form that I allow users to filter records using the filter buttons on the toolbar. My problem is this. They all work fine in the full version of Access97. However in the...

I have a database that uses a logon form for the user name and password. The users are students. After the student logs on he/she will see a form that contains options of printing a variety of reports. When they print the report I want only their data to be printed. How can I accomplish...

Thanks for your quick response. That solution seems logical but when I try it I get the following message. "Can't have aggregate function in expression".

I have a field (text box) on a report named [Gradetotal], the source property for the field =(Avg([GradeGrade])*[weight]/100*100). The data on the report is grouped by Student and ClassID. After each CLASSID group, the total is printed for that group in the [Gradetotal] field. This all works...

Access97: I have a report (Progress_Report) that contains a subreport (Progress_Report_Grades_system) and wish to add totals from a field on the main report and a field on the subreport together for a grand total but am having problems. I am using this source code on the GRANDTOTAL text box to...

Sorry, I should give you some background information. I have an application I distribute using Developer and I have made some changes to one of the tables in the application. The application is distributed in two databases, one with all the tables and one with all the programs. I am trying to...

I know you can use CREATEFIELD to create a new field but I need to update the field type. I read where the only way to do it was to create a new field and append the old data to the new field, but the new field I create has to have the same field name as the old one otherwise I have to recode...

I have a customer who wants to be able to email certain reports from an Access97 database program. After previewing a report, they want to be able to click a button that will open their email program and then allow them to attach the report to the email for sending.

I have a school report that must display 6 check boxes, each with a different label. (New, Transfer, Graduate, etc.) What I want to happen is this: I want a check mark to appear in the whichever box applies to the status of the particular student whose record is being printed. I have included...

I haved looked at this strcritera statement until I am blue, literally. I am trying to find records based on the criteria specified below. This worked fine until I added the third criteria (strCriteria = strCriteria & "AND timeinday=" & Me!tbxTimeIn). Since adding the third criteria, I get a...