Search results

Shortly after submitting this thread, I discovered that a instance of Excel is opened when the action to perform the link is taken. Then once the link to the unbound object is activated the instance of Excel remains open until the link is removed or the form is closed. If anyone has more info...

I have a new build Windows XP machine that I built to test the installation and deployment of an Access 2010 application that was created on another XP machine. This application uses an SQL database as its storage database. I have manually installed the MS Access 2010 runtime. I have also...

Does anyone have an example of an sql server connection string where the port is being specified? I have seen threads that kinda indicate that the SQL Severe Native Client driver must be used when needing to specify the port but I have not been able to get a handle on the requirements. Any...

I am experiencing a really strange problem when attempting to validate the existence of a csv file on our SharePoint server. :banghead: I am trying to use the same VBA code which I have used for many years to validate the existence of a file. This code works to validate that the file exists...

Using Access 2010 and SharePoint 2010 We have been using linked SharePoint list in an Access 2010 application for a few months now. We have been able to work through several issues and have been successful with the implementation of using Access to update records in the SharePoint list using...

I am posting this so that anyone needing to ensure that their linked SharePoint Lists have the appropriate links for editing data. Edit: I found that I needed to make a couple of modifications to the code: '***********Code Start**************** 'This code is a modified version of the code...

I am using MS Access 2010. I am creating code that will ultimately save the specified file from the SharePoint site to a local file. I have a form where the user is required to provide the filename that is to be saved to a local drive. We are forced to use the file naming convention that...

I am using Access 2010 linked to a SharePoint 2010 list. This list has less than 1600 records. I apologize in advance for posting such a long post. However, I do not know how to provide the information in a more concise way, so here goes: I am developing a VBA module that is used to open a...

Take a look at the attached zip file which contains a demonstration of a method that I use when I have multiple small lists in one database applicaiton that are used to provide selection options for user. These list are things like Prefix, Suffix, Title, etc. An Access 2002 database file and...

I am usinig the code below to create a new instance of Outlook and an email message with an attachment and send it. I have also implemented the use of "ClickYes" to fully automate the process. All of this works exacly as expected when I run it here. I have tested it with Outlook open and with it...

Try providing us with a little more information. Are you opening the "next" form or are you closing the current form with some other form already open?

It is not unusual to have multiple small lists that to be available to users from combo boxes. This, in itself, is not a real problem except that I do not like hard coding values in combo boxes and I do not like creating multiple tables to hold just a couple of values. Even if there are quite...

Has the admin folk considered having a Chat area for members? I belong to another forum group that uses this same format for the fourm and they have implemented "flash chat". It is a relly neat place were members can just chat about issues.

First I would like to thank the entire community here on the forums for welcoming me to the forums a few weeks back. I have really enjoyed being a part of this group. I hope that I have actally help some with their problems. Now, I have something that I just cannot seem to resolve. For the...