Search results for query: *

I have an Access 2016 application that opens Notepad++ with the Shell function when the user clicks on a text box with a path in it. The Shell function then opens Notepadd++ and opens the document found in the path. That works fine. However, Notepad++ with the opened document is in a window...

I have an Access application developed in Access 2007. I want to convert it to Access 2016. I know I can open it in Access 2016, but when I run SysCmd(acSysCmdAccessVer) or CurrentProject.FileFormat, it still shows as Access 2007. I want to convert it to Access 2016. When I do a "Save As"...

I have a worksheet that appears to have something wrong with it that I can't figure out. It originally had approximately 40 columns and about 1500 rows and it would move exceedingly slow when I would click the scroll button, scrollling either to the next row or the next column. This...

I want to prevent users from leaving a record on a form based on the values in the controls on the form. I can use the form's AfterUpdate event to check the values in the controls, but I can't find a way to stop moving to another record or closing the record if the values in the controls are...

I want to do something I have not done before and need some expert advice/direction. I want to connect an Access 2016 database front end to a SQL Server 2016 back end--the tables will reside in the SQL Server database. The front end application will reside on multiple users' computers (about...

My search did not produce a thread with the scenario I'm facing. I want to develop a new application that will enable the user to open and view (read only) text files that already are laid out with data in columns on some lines and data in sentences on other lines. There will be thousands of...

Access 2013. I have a form (frmMaintenance) with a tab control (TabCt10) and each page on the tab control has a form (subform) on it. The data on each subform is independent of the frmMaintenance (no Master-child relationship) and has its own query with its own table behind it. For two days...

This is probably easy for some who have done it, but I have an installed Instance of SQL Server 2008 Express or SQL Server 2008 R2 Express I'll call Instance CCC and need to remove it. I have two other Express instances I'll call Instance AAA and Instance BBB. I want to uninstall Instance CCC...

I have some code I found and modified as shown below that opens a Word document. However the window is behind the Access application window that has the button with the code to open the Word application and document. I've searched and so far can't find the code to bring the Word application to...

I have an Access 2007 form (Form A) with a button that executes a macro that opens another form (Form B). In the OnActivate property of Form B, I have an event procedure that executes a function I created in a new object module. The function includes code that sets the active form's recordset...

I mistakenly ran the 2007 AccessRuntime.exe runtime installation program on my Windows XP SP3 machine on which I had already installed Office Professional 2007 (which, of course, has full Access 2007 included). Now I am concerned that there will be changes in or problems with the full version...

I am trying to randomly display an image file on a web page. The web page is HTML but the random number generator is Javascript. The files are named 1.png, 2.png, 3.png, etc. I found some code that is supposed to generate a random number and I know know to display an image by enclosing the...

I want to be able to open a Data Access Page using a browser, select a record, and then open a file (in this case a PDF file) using a hyperlink. I'm using Access 2003 and I have a table with a field defined as a hyperlink field. When I click the hyperlink field, it opens the file in the...

thread705-1525332 I had to put the project referenced in the thread705-1525332 on hold, but now I'm back at it. Let me try to simply what I need to do. I need to be able to send an electronic fax via Access 2003. Does anyone have VBA code for sending faxes? Besides what was stated in the...

After two weeks of searching, I'm resorting to getting help. I want to be able to find a lost folder, whether or not it has any files in it. I want to be able to specify the drive or path in which to search and have the procedure return to me all the (parent) paths in which the particular...

I have not found the answer to my problem in other threads and wonder if it is even possible to do what I want to do. I have a Main Form, with a Tab Control with several tabs on it. On one of those tabs, I have a subform. On that subform, I have another Tab Control. On one of the tabs on...

Has anyone found a solution to the following thread: thread705-1346398. Like DatabaseDude, I searched the site referenced by kjv1611 and did not find quite what I am looking for. Yet there were 1000s of results from my search so maybe I just could not find the right combination to come up...

I want a generic procedure to test bound fields on a subform for updating or changing of the value and then sending a message to the user when the value changes. I do not want to send the message the first time the user enters data, but only if he/she changes it. Also, I want this procedure to...

I have at least two reports I developed in Access 2007 using narrow margins. The margin settings were .25 inches for all four margins. After a few months, the right margin setting has changed. When I reset the right margin to .25 by going to Page Setup under the Page Setup menu option, Access...

colezpapa (or anyone else) - Did you get sample code as you requested in your last post in the referenced thread? If so, would you be willing to post it? I need to do the same thing, essentially. Thanks!