Recent content by Uli

This should be easy.... I think. I am having trouble with the following: I have a user input form where the user puts in the start date for a monthly report. The report will then print the data for that month. In my report header I would like to use the month value of that date and have it...

Good morning, I'm trying to figure out whether I can automatically create an e-mail using Outlook with the onclick event of a button on a form. Actually, I have figured out how to send the e-mail to the e-mail address of the contact on the current record using the above already. I can specify...

I actually figured out one way to do it: Private Sub UpdateExcel_Click() Dim exObj As New Excel.Application Dim exSheet As Excel.Workbook Set exObj = CreateObject _("Excel.Application") Set exSheet = GetObject _("filepath and name") Set exSheet = GetObject _("filepath...

I'm just wondering if it is possible to update an Excel Workbook that contains links to other workbooks from within Access. What I have done is this: I have created a link to a spreadsheet (rather than importing the spreadsheet) because I know the data will change frequently. What I would...

Thank you Jack. That worked. Now I can trash the code that added a record with a zero value every time I created a new main record. I was going the real complicated route. Muchly appreciated. Uli

Hi, I'm new here on the recommendation of a good friend and one post in this forum already related to a problem I was trying to solve for a few days now. It's great. Right now, I'm struggling with the following question. I have a main form with 3 subforms all linked on a field called...