Search results
-
P
sending email to Outlook 2016/365
That was just to shorten the line in the post, sorry!- ptenhet
- Post #3
- Forum: Modules & VBA
-
P
sending email to Outlook 2016/365
My work upgraded to Microsoft 365 and Outlook is now 2016. I have an Access application that worked fine with previous version. DoCmd.SendObject acSendReport, "HrEmailEvalSummary", acFormatPDF, Now after the upgrade to 365, Access freezes when it tries to run this line. Is there something I...- ptenhet
- Thread
- Replies: 2
- Forum: Modules & VBA
-
P
Setvalue with environ variables
access 2007--I'm trying to use the setvalue to grab environ("username") to populate a form. Keep getting a "Function" error. Is this possible with the setvalue? -
P
Using variable in table insert from loop
Worked perfect, thank you. Having hard time adjusting from SQL...- ptenhet
- Post #5
- Forum: Modules & VBA
-
P
Using variable in table insert from loop
Trying to write day by day for a month's period from the counter in a loop as the day. When I run it, I get a pop up asking to enter the parameter cnt. How do I use that variable in the insert string? Thanks pt Private Sub AppendRecs_Click() Dim cnt As Integer Dim sqlstrg As String Dim...- ptenhet
- Thread
- Replies: 5
- Forum: Modules & VBA
-
P
Converting Sql insert loop to Access???
So you can't really use the SQL view as SQL code, you have to do this stuff in VB code? -
P
Converting Sql insert loop to Access???
I'm trying to use a sql query to insert into an Access 2007 query. I'm assuming isn't as straight forward as it seems. I have very little experience with Access, so the example below is something I would like to get into Access. Basically I want a form to take a couple of fields and create...