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!

Register Log in
  • Congratulations derfloh 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: joxo1
  • Order by date
  1. joxo1

    Copy recordset to different database

    Hi, Is there any way of copying a recordset from a table in one database into a table in another database without copying each field value one by one? Cheers
  2. joxo1

    Classes

    That's a very good idea! One that will certainly work and one I hadn't thought of! .....BUT, I would really like to keep the class self contained and not rely on methods external to the class. Is there any way of doing that? Can I keep the whole solution within the class itself...
  3. joxo1

    Duplicate Elimination

    I would also find any information on this type of thing V useful. Specifically, matching a list of employee names from one spreadsheet against another spreadsheet of employee names. Where they are created by different people and therfore the names can have different spellings (i.e Bob Jones =...
  4. joxo1

    Classes

    Hi, I have created a class module which contains various useful functions. Some of the functions use recordsets. If I am using the class in a project that doesn't use databases (and therfore dosn't reference ADO), I get an error in the class at run time of "User defined type not...
  5. joxo1

    Outlook alias from address book

    Hi, At work we have a staff database that contains info such as name, managers name, grade etc... I need this database to contain the LAN ID of the person as well. I can get this info manually by searching the outlook address book and geting the "Alias" name from the properties. However we...
  6. joxo1

    Unspecified error with RS.save

    Hi, I am using the save method of the recordset object (i.e RS.Save FileName,adPersistADTG) Every so often i get an "Unspecified Error" at this line. Does anyone have any ideas? Cheers
  7. joxo1

    Missing system table

    Hi, I am tring to compact a database but get the following error message. "The microsoft jet database engine couldn't find the object 'MSysCompactError' Make sure the object exists....... This database has never had any problems before, if this object has been deleted then how can i...
  8. joxo1

    No MS Access on PC

    Hi, I have VB front end and an ms access backend. The program is to be used on various PCs throughout the company. My question is, If the PC the program is being used on does not have MS Access on it then would i need to get it installed or is there just a dll that needs putting on the pc...
  9. joxo1

    "INSERT INTO" missing operator problem

    ...the error "Syntax error (missing operator) in query expresion ....." It only seems to happen when the user types special characters such as &^*(&*"$%"£$ etc... I can't identify which one is causing the error and anyway I want the user to be allowed to type anything that the textbox...
  10. joxo1

    Fix form size but keep minimise button?

    Please ignore me, i've worked it out.
  11. joxo1

    Fix form size but keep minimise button?

    Hi, How can I fix the size of a form but still have the minimise button (not the maximize)? Cheers in advance
  12. joxo1

    Multiple values in a field

    Hi, I have a database that needs to store (and search by) invoice numbers. I was just going to use a field called 'Invoice_Numbers' however I've found out that there may be multiple invoice numbers accosiated with each record. How do i store multiple values in a field and be able to search...
  13. joxo1

    Tray Icon Disapears

    Try this link, there is code that explains it all http://www.freevbcode.com/ShowCode.Asp?ID=2055
  14. joxo1

    Excel: Change color of PART of a cell

    When you say Cell, do you mean in excel?
  15. joxo1

    Tray Icon Disapears

    Hi, It's not a form that is disapearing, it's the icon in the tray (next to the clock)
  16. joxo1

    Tray Icon Disapears

    Hi, Have any of you had any problems using tray icon? I have a program that uses it, every so often (at random) the icon will disapear. There are no error messages and the program is still running (checked by looking in task manager)
  17. joxo1

    Optional parameters in a property procedure

    Aye, good point Matt! Cheers
  18. joxo1

    Optional parameters in a property procedure

    Hi, I am tring to use an optional parameter in a property let procedure. e.g Property Let Caption(byval strValue as string, optional InBold as varient) '------- End property I keep getting the error "Argument not optional". All the documentation i can find says that this should...
  19. joxo1

    Referencing Picturebox child

    HI, If you have a label placed as the child of a picturebox, how do you then reference that label? Cheers
  20. joxo1

    INSERT INTO somtimes causes error

    Thanks for all your help on this one guys. I think i've got all the info i need now. cheers again.

Part and Inventory Search

Back
Top