Recent content by dmgg

I have a program designed with Access 2007 and also used with Access 2004. I just installed the latest version of Access and get a puzzling problem. I have a form with sub forms. Two of the sub forms have a colored rectangle hiding fields and buttons until after select criteria. (After...

We have 3 computers using Access 2003 linked to tables in a base computer. When a version is modified somewhere else and we install the replacement in our computers, we always have to click a little circle to allow the program to function. We only have to do it the first time we use the...

Thanks for reply. As you can see on my reply to Paul, I just cover the form when double click.

I gave up and actuated a hide, as you suggest. I don't remember the code that I got on the web, but didn't get an error message when tried it. Just no action. Thanks much for reply,. Covering the sub sub works fine. I

I have a sub form that is a sub form of another sub form. After I double click a value on the sub of the sub, I want the sub-sub to close. (The value gets transmitted to the master sub form). I followed some instructions on the web, but it didn't work. Any help much appreciated.

Thanks for reply. I got Gasman's reply installed and it is working. I will give this one a try tomorrow. Thanks again.

THANKS SO MUCH This was driving me nuts. Can't thank you enough! I looked all over the web.

When enter a last name in a form, it generates a count of the last name in the source table. The count is used to display a list of same names if count >1. It works fine except if a name has an apostrophe (like O'Briant) Here is the code that works fine with no apostrophe included. LN is...

I thought that I had posted this already, but don't see it. I found some code that opens/closes excel in Access 2016 (also works with 2003 and 2007). Not sure why other code didn't work with Access 2016. Sometimes I hate Microsoft. Dim xlapp As Object 'had to add this-thanks you Set xlapp =...

I found some open/close excel code that works in Access 2016 (also with 2003 and 2007) on StackOverflow. Not that different, but works. Here it is. Dim xlapp As Object 'had to add this-my thanks to you. Set xlapp = CreateObject("Excel.Application") xlapp.Visible = False...

Thanks. I don't get an error message In Access 2016, it just imports data derived from the previous export unless manually open/close the excel file. Looking at your code, I don't see anything that defines the excel file that I want to open and close. or a command to open close. I'm sure my...

The code preceding this is export to excel and the code following is import from excel It all works except for the opening and closing procedure that I show.. The exported data gets to the excel file perfectly. The import from excel doesn't work because excel has to be opened and closed...

Reply: I finally got to try "Object" in Access 2016. Didn't work, excel receives and provides new results, but won't export because excel doesn't open close. this is how I modified my code: Dim xl As Object, WB As Object ' Set xl = CreateObject("Excel.Application") Set WB =...

I export a single row of 51 items and import a single row with 16 columns.

Thanks for reply. See my reply to sxcheck