Search results

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

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 function to CStr, though I am sure I am not the first to need this functionality. Thanks for 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...

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 for members to 'Contribute'. When creating the new site, make sure that it does not share the same...

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 of the file from a local folder the issue goes away. Sorry this took so long to figure out and...

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 the email before I have a chance to edit it. I believe .send and .display are meant to be...

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 = Nothing' included, Outlook also closed but the next time I opened Outlook the email was in the Outbox...

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

Thank you so much to everyone for your help! I now have a much deeper understanding of selecting an item using ListIndex, and I am now fully aware that choosing a combo box selection based on ListIndex will not work properly if the bound column is not a unique value. Thank you, Thank you, Sup

Hi Jiri, adding the code in red incorrectly changes the message box to indicate a correct selection, while in fact, the selection is not correct. The issue is that the correct ListIndex for ContactID 1 (Alan) and Region 2 (South) is ListIndex 1. The For loop correctly returns the ListIndex...

What I'm trying to do is set the combo to the correct ListIndex. The combo does have only one unique that contains those records. The code correctly identifies the ListIndex of that unique record. However, when it selects the record in the combo it selects the first record that contains the...

Hi arnelgp, Thanks for the quick reply. "me.ItemData(i)" threw a data member not found error, so I changed it to " me.cboContact.ItemData(i)" Unfortunately, this sets cboContact to the item that has the correct ContactID, but the RegionID 1 instead of RegionID 2? I'm doing this on the on...

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

arnelgp, Between you 2 pieces of code I was able to accomplish what I was trying to do! Thank you very much, Sup

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

Hi Mark, This helps a lot! Now that I can put the result into a variable, I can silently test the Powershell version and only inform the user if the version is inadequate. BTW, on my machine the KEY "SOFTWARE\Microsoft\PowerShell\1\PowerShellEngine" shows a RuntimeVersion = 2. However, there...

Hi Mark, Thanks for the response. I've been to the link you suggested: http://blogs.technet.com/b/heyscriptingguy/archive/2009/01/05/how-do-i-check-which-version-of-windows-powershell-i-m-using.aspx Unfortunately, those powershell script examples also return the Task ID instead of the...

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

Not sure if you've solved this yet? If you created the table using an Access Web App: 1) Open the Web App 2) Click File 3) In Info View, click Manage Connections. You will need to Allow connections from My location or Any location. You will need to Enable Read-Write or Read only connection...