Search results for query: *

strongm, Thank you for your testing and the "Are you sure..." question. I looked further and found that the text box "Is Hyperlink" property had been set to Yes. I changed it to No and--what do you know!--the Notepad++ app window stayed on top. I think that was the culprit all along. Thank...

Andy, that worked! I put the code in a command button's click event and Notepad++ stayed on top. I'll have to modify my design a bit, but I can make that work. Thank you much!!!

Thanks Andrzejek and strongm, but it does not work for me. I see you dimmed lngMaVal as long and you changed the Shell windowstyle argument from maximized to normal. I tried that and it still opens the Notepad++ application window behind my Access application window. I wonder if it has to do...

In the example code the Private Sub should have been named TextBoxPath_Click(). My apologies.

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

Okay, I understand there is no AcFileFormat created by Microsoft beyond acFileFormatAccess2007; nevertheless, the version of Access itself, like Access 2016, can have features that do not exist in Access 2007. These new features can cause Access 2007 to be unable to open an application...

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

Thank your for your responses. I am open to the VBA solution if it will not be a maintenance problem. I am not eliminating any options. Regarding walking around to each machine, I could to that, too, and I'll stay away from open windows! :-) If I do that on the other workstations that do not...

Sorry for the delay, but here is what I ended up doing: The ID Info and the text file paths are in a SQL Server table linked/attached to the Access front end. The path points to where the text files are located including the text file name. The path field can be searched for and found by the...

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

Thank you all for your input. I gleaned helpful info from each post, so I give you each credit for a great post. I am waiting till I can get some more test data and files and then I will try a couple of different options to see which works. The options that seem most feasible are options 3...

Thank you, Simi! What is still confusing me is the text files. I have attached a sample text file with a sample statement to help you evaluate what I am trying to do. You said I would need to determine if the data lend themselves to being tables. Do you mean that each text file would become...

Thank you for your reply. As you can tell, this is new territory for me. I like your suggestion of importing the text files into SQL Server tables. If I understand you correctly, there would be one table for Folder A that currently has the 800,000 text files and one for Folder B with the...

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

PWise, Guess we were entering our last two posts at about the same time. Your code was a bit cleaner but essentially the same. In my post I included info for any who were wondering where to put the code. Thanks, again! You pointed me in the right direction!

Okay. I figured out how to do this. The code below is put in the On Click event of the tab control itself (not the pages of the tab control). I had to test for which page was visible and then set the focus and go to the record as shown below:Private Sub TabCtl0_Click() Select Case...

Thanks, PWise. Now I need to know where to put this code. What Event on what control is the place to put this code so that whichever tab of the tab control I click on, the subform (frmCars, frmTrucks, frmMotorcycles) on that tab goes to the new record on the appropriate form. I put the code...

Hmmm. That's the very first thing I indicated: Access 2013. Thanks!