Recent content by NebraskaUser

Merry Christmas Everyone - Can anyone give me insight as to how to write a filter of a query or report to a PDF and then send that PDF as an attachment to an email? I also want a cover letter to go to the email recipient. Nothing I've tried has worked. I have a button that executes the...

I'm afraid it isn't that simple. When I simply overlaid the default value and then tabbed out of the field, the default value immediately replaced the value I just entered. However, I have discovered a trick. If I don't tab out of the field and then just click "Save and Close", then the value...

If I need to override a default value on a data entry form, how do I do it?

Hot dog! It worked! Thanks a million!

If I need to delete every record in a table, how do I programmatically do that in VBA? Here's the code I currently have, and it isn't working. It deletes one record, then errs out. If myR.RecordCount > 0 Then For RC = 1 To myR.RecordCount myR.Delete Next RC...

Hello everyone: I have created a data entry screen in Microsoft Access. I want to retain two field values when entering one new record after another. If users have 15 records to enter, and all 15 records are for the same special collection - such as Christmas - I don't want to have to force...

Ideally, I need to display four different cross-tab queries on the same report or form. Any idea how I might do that?

Do domain aggregate functions work for everyone? Every time I try to use the DAvg or DMax functions I get a message box saying "Unknown". With DAvg I do then get the right results, but DMax keeps producing "Unknown" every time i enter the Enter key. The only way to get out of it is type...

You're right. I don't need all those Case statements nor do I need the quotes. My first problem was I was missing "DateLastSunday" in front of the expression which followed each Case statement. That resolved my "Invalid Use of Property". Then I got output but not the correct output. When I...

Can someone tell me what's wrong with my function? I'm trying to compute the date last Sunday. Every time I run it I get "Invalid Use of Property". I've tried it with and without double quotes around the numbers following each Case statement. Public Function DateLastSunday(DayOfWeek As...

Hello everyone - I'm pretty new to VBA. I'm trying to create a table definition and then add values from 3 other tables to that definition. Here's my code and I keep getting a "Data Type Conversion" error with the line reading: Set TOT_R = tdfNew.OpenRecordset("RSC_Totals", dbOpenDynaset) Sub...

Hello everyone - I'm brand new to this forum, and pretty new to Microsoft Access. Since July 1, 2018 I have completed Microsoft Access Basic Essential Training, Microsoft Access Advanced Tips and Tricks and Microsoft Access Intermediate Queries. I've also made it half-way through Curt Frye's...