Search results

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

Long story, but what the excel file provides is only a small part of the Access program. The excel file is complicated and is developed, updated, modified and maintained by someone who only works with excel. It is easier for us just to ship data and retrieve results. (at least with Acesss 2007)

My goof. I will try As Object as soon as I get to my friend's Access 2016. I will also investigate what "binding" means. I much appreciate the time you are giving me on this.

I tried the link, it works, but is ridiculously slow, about 20 seconds or more. I am finding that leaving access and excel 2003 for later versions is loaded with problems. I will try to find out why code doesn't work in 2016 version. Do you know where I could find info. I have tried and tried.

With Access 2003(and 2007), I send data to an excel file. The excel file does some calcs and sends results back to Access. In order to get excel to export the results, the excel file must be opened and closed after receiving data from Access. My code works fine in A 2003 and 2007, but the...