Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 357
Search took 0.21 seconds.
Search: Posts Made By: supmktg
Forum: SQL Server 06-14-2019, 11:42 AM
Replies: 12
Views: 265
Posted By supmktg
Re: automated email

For clarity's sake, I meant logged in to the db.

With all of your guidance and some additional research I have decided to build a separate app that includes the required linked sql tables and...
Forum: SQL Server 06-13-2019, 01:03 PM
Replies: 12
Views: 265
Posted By supmktg
Re: automated email

I've discovered that Azure SQL no longer includes SQL Agent. For others that happen upon this post, my research found 2 alternative methods to send a scheduled email from Azure:...
Forum: SQL Server 06-12-2019, 04:54 AM
Replies: 12
Views: 265
Posted By supmktg
Re: automated email

My knowledge of SQL Server is pretty much limited to the database tables, views and stored procedures. In this case, I am connecting an Access front end and some asp.net web forms to a client's Azure...
Forum: SQL Server 06-11-2019, 07:02 PM
Replies: 12
Views: 265
Posted By supmktg
automated email

I have a Access app that uses an Azure SQL Server database on Sharepoint. I need to send an email at the end of each workday that informs mgmt of orders rec'd but not yet processed by the end of the...
Forum: SQL Server 02-14-2019, 06:33 PM
Replies: 10
Views: 340
Posted By supmktg
Re: Convert Access query with 'Last' to SQl Server

Hi DBGuy,

Top 1 was the first thing I tried, but I couldn't get it to work for my data set. I did finally solve it with ROW_NUMBER() OVER (PARTITION. If interested, see above post that includes...
Forum: SQL Server 02-14-2019, 06:26 PM
Replies: 10
Views: 340
Posted By supmktg
Re: Convert Access query with 'Last' to SQl Server

Hi CJ,

I've been working all day on the above solution and just saw your post. I greatly appreciate your assistance! After reviewing your 2 suggested posts, it seems as thought the Last_Value...
Forum: SQL Server 02-14-2019, 06:00 PM
Replies: 10
Views: 340
Posted By supmktg
Re: Convert Access query with 'Last' to SQl Server

I'm fairly versed in Access sql but not so much in SQL Server, especially where it differs from or includes advanced functions that I don't use.

I've solved my problem by 1st creating a View so...
Forum: SQL Server 02-14-2019, 01:22 PM
Replies: 10
Views: 340
Posted By supmktg
Re: Convert Access query with 'Last' to SQl Server

CL,

I neglected to include the Order By tblH.HeadID portion of my query, so you are correct that without that Order By last is worthless.

Thanks,
Sup
Forum: SQL Server 02-14-2019, 01:22 PM
Replies: 10
Views: 340
Posted By supmktg
Re: Convert Access query with 'Last' to SQl Server

DBGuy,

Max does work for Last(tblH.PODate) because in this table the max PODate is also the record with the Max(tblH.HeadID). However, the Max(tblL.Qty) will return the largest qty in all...
Forum: SQL Server 02-13-2019, 03:22 PM
Replies: 10
Views: 340
Posted By supmktg
Convert Access query with 'Last' to SQl Server

I'm trying to create a View in SQL Server equivalent to an Access query that uses 'Last' in 2 columns in order to return only one (the last) of each record. Here is the query that I am trying to...
Forum: Modules & VBA 07-10-2017, 02:22 PM
Replies: 5
Views: 391
Posted By supmktg
download gmail messages to table

I am trying to import Gmail messages to a table from a non-Outlook account. The purpose is to filter and report on correspondence regarding specific subjects and specific senders or recipients.
...
Forum: Modules & VBA 05-17-2017, 02:52 PM
Replies: 2
Views: 531
Posted By supmktg
random number with exclusion

I'm trying to generate a random number between 1 and 9 based on a fixed master number. I need to exclude numbers that are + or - 1 of the master.

Master = 3 (it changes after each correct random...
Forum: Modules & VBA 02-08-2017, 10:56 AM
Replies: 3
Views: 2,326
Posted By supmktg
Re: refresh Outlook Inbox via vba

Thank you Darbid! I seldom use Outlook automation, but needed to automate an approval process based on returned emails. I am not that familiar with all of the Outlook methods.

As far as sync vs...
Forum: Modules & VBA 01-10-2017, 08:19 AM
Replies: 9
Views: 537
Posted By supmktg
Re: Random Sequencing

This function should help you generate a random bulk type between 1 and 3. Put it into a module and call it each time you need to generate the next type. The public variable iLastBulk will hold the...
Forum: Modules & VBA 01-10-2017, 02:15 AM
Replies: 3
Views: 2,326
Posted By supmktg
refresh Outlook Inbox via vba

I am using the following code to refresh my Outlook Inbox before searching it for responses to certain emails:


Public Sub RefreshInbox()

Dim nsp As Outlook.NameSpace
Dim sycs As...
Forum: Modules & VBA 09-11-2016, 06:00 AM
Replies: 3
Views: 924
Posted By supmktg
Re: date of first email in Outlook conversation

Hi sneuberg, I appreciate your reply.

After much research I discovered that although there is no conversation start date property, there is a ConversdationID property that is shared by all emails...
Forum: Modules & VBA 09-01-2016, 06:19 AM
Replies: 3
Views: 924
Posted By supmktg
date of first email in Outlook conversation

I'm trying to open an Outlook email from a form that contains the date, recipient and subject of a previously emailed request for approval.

I am having trouble finding a method to determine the...
Forum: Modules & VBA 06-29-2016, 10:06 AM
Replies: 1
Views: 240
Posted By supmktg
OutputTo 2 locations at once

I'm using the following code to save a PDF file to mapped Sharepoint drive.

DoCmd.OutputTo acOutputReport, "", acFormatPDF, strPDFPath & strPONum & ".PDF", False

The time it takes to format...
Forum: Access Web 06-24-2016, 03:14 PM
Replies: 4
Views: 1,334
Posted By supmktg
Re: data macro set field

Hi Paul,

Unfortunately, Access Web Apps do not use vba, they are limited to macros that do not recognize vba functions. I have been unable to find documentation that gives me the equivalent macro...
Forum: Access Web 06-24-2016, 12:30 PM
Replies: 4
Views: 1,334
Posted By supmktg
data macro set field

I have a web app form in which I'm using a data macro to update a field in a table. I'm trying to update the field with a short text string that I am building out of other fields in the table. My...
Forum: Access Web 04-14-2016, 07:09 AM
Replies: 3
Views: 1,659
Posted By supmktg
Re: lock sharepoint web app and keep data

This took quite some time to ferret out, as the documentation from MS really doesn't exist.

The solution was to create a separate site that has its own permissions and then set the permissions...
Forum: Modules & VBA 03-22-2016, 06:27 AM
Replies: 8
Views: 2,191
Posted By supmktg
Re: mail via Outlook does not send

In the end I discovered the problem was caused by the fact that the file I am attaching is on a mapped drive on an online Sharepoint server, which takes forever to attach. When I attach a temp copy...
Forum: Modules & VBA 03-18-2016, 10:44 AM
Replies: 8
Views: 2,191
Posted By supmktg
Re: mail via Outlook does not send

Yes, I commented out ".send" because I want to display the email in order to edit the message and then manually click the Outlook send button. With the ".send" included, Outlook automatically sends...
Forum: Modules & VBA 03-18-2016, 09:21 AM
Replies: 8
Views: 2,191
Posted By supmktg
Re: mail via Outlook does not send

Outlook still closes. The next time I open Outlook the email is in the Outbox. With 'set olApp = Nothing' commented out, I have to click 'Send all' to send the email. Before, with 'set olApp =...
Forum: Modules & VBA 03-17-2016, 05:16 PM
Replies: 8
Views: 2,191
Posted By supmktg
mail via Outlook does not send

I'm using the following code to email a PDF report.

If Outlook is already open, the email gets sent immediately upon clicking the 'Send' button in the Outlook message form. It works great!

If...
Showing results 1 to 25 of 357

 
Forum Jump



All times are GMT -8. The time now is 01:06 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World