Recent content by annmariebette

Dear Irish1957, Thank you for submitting your code for my review. I read through the code trying to figure it out. Does it assume the record set is the table (or query) behind the form? Do I need to change the references in brackets to my textbox references? How does it pick up the report I need...

Chadrj and Robctech, I think I should email you a zipped test version of the database. I stripped out the real data and updated with some fake info. My email address is bettea@newegypt.us. Let me know your email addresses. I think both of you have ideas that I could use. I appreciate your...

Help! I have this database which contains a table of data that I need to export so our Guidance counselors can utilize an online website to track student information, college application data and SAT scores. Ideally, I would like to streamline the process so that our enduser(s) can click a...

Hi there, Once again I am calling out to the intellectuals who subcribe to Tek_Tips for help. My user has a query based on 2 tables that she uses to produce an Extracurricular APpproval Report to send out to all staff. This report (columnar style) lists each staff member at our school district...

Hap, Thanks for your reply. My problem is I am not a VBA coder. Maybe I should hang this one up??!!:) I can do some basic things in Visual Basic but I have never really written anything extensively. Actually, I guess I would be reading a recordset from a query. Her report and form are based on...

Hap, I am still confused! I created a private sub that is working great. I have a button on a form that when clicked submits a report for that persons record and transmits it as an email attachment, automatically sending it to the email address populated in a field I have. That was easy because...

Hap, THanks so much for such a fast reply. I'm a little confused. Where do I execute or attach the public function to? How do I attach it to my code? I am a VERY new Visual Basic person (trust me that's no lie!!) Thanks,:) ANn Marie

Help! If anyone out there can give me an idea of how to do this I would GREATLY appreciate it! I have a form in Access (2000) that has a button on it. When clicked I execute a Visual Basic event that basically prints a single record from the form in a report (preview mode). The VB code next runs...