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...

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...

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...

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...

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...

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...

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 the PDF and save it to the Sharepoint drive is causing an issue with my next routine which attaches the...

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 code looks like this: For Each Record in tbl1 Where Condition = [tbl1].[fldNew] Is Null...

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 Outlook is not already open, Outlook opens and the message form gets filled as expected. However...

I have a combo box (cboContact) with multiple columns on a form: ContactID | Name | RegionID 15 | Alan | 1 15 | Alan | 2 16 | Bob | 1 16 | Bob | 2 ContactID is the bound...

I have been developing access desktop apps for more than 15 years, but his is my first encounter with sharepoint web apps. I have spent months developing a hybrid app that uses the web app's sql azure db as the BE to a desktop app, with a couple of fairly complex web forms so remote users can...

I'm trying to replace a password in a text file that changes from time to time. I need to find the current password so I can use the replace function to change it. The text file looks something like this: $Site = 'https://mysite.com' $User = 'someuser@mysite.com' $Password = 'currentpassword1'...

I'm using Powershell.exe to access data on a Sharepoint server. The Powershell script fails if the installed version of Powershell is less than 3. I'm trying to run the following vba code to determine which version of Powershell.exe is installed, so I can advise the user to update their...

I'm trying to extract invoice and payment transaction data from a very old version of quickbooks. This very old version allows for the export of customer and item lists to .iif format which I can view in Excel. However, there is no method of exporting transactions. All of my searches for how to...

I have 2 separate Access 2013 Web Apps on a Sharepoint 365 server. Web App 1 was created by uploading related tables to the Sharepoint Azure SQL. I am hoping to use that app strictly for housing the tables which are currently linked to a desktop application which is working very well. I'm...

I have uploaded my back end database to an Access App on Sharepoint 365. I have set the permissions to allow access from any location and to allow read-write. When I create a ODBC data source in the ODBC Data Source Administrator, the connection works fine. My front end includes code to make a...

I am trying to run an Access front end with a Sql Server backend from an Office 365 Sharepoint site. I published the (A2010) accdb to Access Services using my Sharepoint url. It uploaded a the local tables, but ignored the linked SQL server tables. It also uploaded a few of the forms, but most...

This for an app being used in Access 2003. I'm trying to (sort of) automate naming a PDF report. After the user selects a printer from the print dialog, if the printer name is like "*PDF*" then I want to put the PDF file name in the clipboard so it can be quickly pasted in the file name of the...