I would like to check to see if a field already exists in a table and the add it to the table programatically if it does not. I am connecting to an access database through the data objecy (I know, don't kill me) but I can change that if I have to. I would appreciate any help with this as I...
Hello,
I have developed a program that runs partly on a handheld computer. In the past customers I have installed the program on have been able to use the automatic database update options in the program but the last customer I installed cannot. I manually registered the AdoFiltr.dll so it...
Thanks, we figured that out. that only other thing I would add is that it has to be a version at least as late as the developing computer. Thanks for the help.
Brian
I have a program that opens an excel file in order to extract the data therein into a userdefined type. This all works well and good on my machine, as well as my bosses. My boss confidently sent this program to the user and after installing the program on his machine the inport from excel...
Would using CreateObject fix the problem and if so, what do I create? are these right?
CreateObjext("Excel.Application")
CreateObject("Excel.WorkBook")
CreateObject("Excel.Sheet")
Boy I would really like to get this to work.
Brian
OK, we got that fixed, now I am getting the error that says "ActiveX Component cannot create object." when I run the program. Any ideas what to do about that. It there an alternative way to declare the excel objects other than
Dim xlApp As Excel.Application
Dim xlBook As...
Well,
I have an application that is accessing an excell file to omport data into my userdefined data type. When I am trying to install on the users computer it gives me an err. It says "Error regestering msado25.tlb" Any suggestions of how I can get this file or what to do...
I have inserted this code, which I found in this forum and changed to accept a passed form. It is in a module so it can be called from anywhere. None of that really matters. When I had the fontsize = 7 on my list box, it worked beautifully. I set the size back to 8, nad the hscroll doesnt go...
I do use the app path thing and all that. The thing is that I would have to repackage for each different file. I think I am just going to have to do it the hard way. Any Other Suggestions would be appreciated.
Brian
Here is the thing. I have a program that Uses a file I create to store customer information for the program. This file will be different for each customer and I would like to build the package in such a was as to not have to rebuild it for each instance of that file. Basically, I need a way...
This is interesting,
A coleague of mine here got a slip printer in today that she is trying to get working for one of her customers. It is printing the information but all the information is upside down and backward. She has tried every conceivable way to hold the slip but to no avail. She...
THANK YOU CCLINT.
I got it working without using the datacontrol object just used my Dim-ed variables and it kept the format. Though in all my shuffling I am not sure what made it like to stay using 2002 format but it works now. Thanks Again. You are a great help to all people on this site...
Well, I just got it going again with the dao code you just posted. Though it still converted my databast to access 2000 format.
Am I missing a step?
BRian
Well, when I used the actual DataControl, I was building a file from a random access file that i had made to convert the program over to database. Anyway, I got that data out of the file and into the database but it converted my database to access 2000 format, which is not what my customer...
I am now. I changed it from DAO 3.51 Object Library to 3.6 Object Library. Do I need to change my components because this had no effect on the list in my datacontrol even after I put a new DataControl on the form.
Brian
Well, I have SP5 and I dropped down the connect on my datacontrol, and access 2000 was the highest that was on the list. Do I need to change my referenced controls maybe?
Thanks.
Brian
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.