Search results for query: *

My primary data source is an SQL Server database to which I have very limited view-only rights. As a result, I have created some separate tables in an MS Access database to help me work with the data in the SQL Server. I am able to use the Database Expert to link the two data sources together...

I am trying to retrieve the information from a saved Access query and display the results in Microsoft Excel. I managed to find some helpful code, but it is only working for some queries and not others. If I run it on certain queries, it gives me the full results. If I try it on others, it...

I have an Excel file with macros in it that is being run on a server where the user will log out after 15 minutes of inactivity, and if the user does not save the file before the log out they will lose all changes made. I have set up some ways of detecting how long it has been since the user...

Is there any way to control the language that the buttons on the message boxes are being displayed in? I am making a program that will be used in either English or French, and I want to be able to control which language is being displayed on the prompts regardless of which language the version...

I have an Excel file with a number of macros, including some code in the Workbook_BeforeClose subroutine of ThisWorkbook. When the file is first opened, Workbook_Open runs some code and sets ThisWorkbook.Saved = True. If I immediately close down the file without doing anything...

I used a recorded macro to try and learn how to use the Find command in VBA. Everything works fine if I want to activate the cell containing the information, like this: Dim fullName as String Selection.Find(What:=fullName, After:=ActiveCell, LookIn:= _ xlValues, LookAt:=xlWhole...

I have a database to which I wish to import information from emails in my outlook. I keep the emails in a specific directory to make it easy. I am using Office 2003. I can easily do this manually by going File > Get External Data > Import - then I select "Exchange()" from "Type of File"...

I am using Office 2003. I am trying to run two filesearches in the same sub. The first run runs no problem and I get the multiple files that I require. When the second one runs, it always finds 0 files no matter how many files are actually in the directory in which it is searching. Any...

I have set up a small program to search a folder, open up each .pdf file and send it to the printer. Everything is working fine, except that the printer produces one extra blank page after each document - this does not happen when I manually print an individual document. The same thing happens...

I am trying to create a new Outlook Email from code in Access. In the email, I wish to be adding one or more attachments, based on the situation. By searching, I have found some great code examples showing how to add an attachment, but I wish to be able to use Outlook's ability to specifically...

Hey everyone, Short version: VBA code in Access to fill two Word forms then save them as PDF. Getting an error that "normal.dot" is in use when second Word file is opened. Long version: I have a small program set up in Microsoft Access to take a selected record, copy the information into...