Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: briancoats
  • Order by date
  1. briancoats

    Add field to table programatically at runtime

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

    DesktopToDevice

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

    Excel ActiveX Install not working

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

    Excel ActiveX Install not working

    the client pc does our test pc in the office does not. Brian
  5. briancoats

    Excel ActiveX Install not working

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

    Install Problem

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

    Install Problem

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

    Install Problem

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

    Horizontal Scrolling a List Box

    actually after further testing, It just gets the same width either way. Maybe i ma doing something wrong... Brian
  10. briancoats

    Horizontal Scrolling a List Box

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

    Package with Dynamic Dependent file

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

    Package with Dynamic Dependent file

    good Idea, but I forgot to tell you that this is the file I use for my Copyright protection. Thanks for the input anyway.
  13. briancoats

    Package with Dynamic Dependent file

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

    Slip Printer Question

    Thanks, that is sort of what I figured, she already had been talking about dips so I guess she has this. Thanks again. Brian
  15. briancoats

    Slip Printer Question

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

    Access 2002 Connection

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

    Access 2002 Connection

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

    Access 2002 Connection

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

    Access 2002 Connection

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

    Access 2002 Connection

    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

Part and Inventory Search

Back
Top