Search results

I developed an Access app 10 years ago using an ODBC connection to a hosted SQL Server database. My host has just updated their servers and has changed the url of the server. I need to update the ODBC connection to attach the approx 30 tables. Here's my problem: I have a much older copy of my...

Galaxiom, your solution did the trick, thank you very much! I may be optimistic, but by my estimation the form now loads much faster. And, Thank you to all of you for your assistance! Sup

I have an Access application that is the front end to a SQL Server DB. The app includes a search form that has 5 combo boxes that filter the records. The combos are currently populated by Access union "ALL" queries that take a while to load. I'm trying to speed up the loading of the form by...

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 module that contains my send email via outlook vba function. From there I will use a windows scheduled...

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: https://vpolizzi.wordpress.com/2010/09/11/database-mail-on-sql-azure/...

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 database that is administered by an outside Sharepoint consultant. I am given limited SQL Server...

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 day. I began designing the function in Access, but if no user is logged in at the designated...

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 the query that worked. I greatly appreciate your assistance! Sup

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 function was exactly what I was looking for. Unfortunately, none of my searches for the Access...

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 that all the fields that I need are in a single table. Then I used the ROW_NUMBER() OVER (PARTITION...

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

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 records, not necessarily the record with the Max(tblH.HeadID). Thanks, Sup

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 convert: SELECT Max(tblH.HeadID) AS MaxHeadID, tblH.DeliverTo, tblH.Region, tblL.ProdNo...

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. My searches have returned vba methods to send Gmail outside of Outlook, but no vba methods to...

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 number) Random OK = 1, 3, 5, 6 ,7 ,8 ,9 Random NOT OK = 2 or 4 I can generate the random number...

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 sendandreceive is concerned, I have at times manually hit the Send/Receive button in outlook only to...

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 last type and prevent 2 of the same type in a row. Public iLastBulk as Integer Function...

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 Outlook.SyncObjects Dim syc As Outlook.SyncObject Dim i As Integer On Error GoTo RefreshInbox_Error Set...

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 in the thread. I probably could have extracted the original date by searching for the earliest...

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 sent on date of the original email which belongs to the incoming response. Here is the code of a...