Recent content by joxo1

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

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

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

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

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

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

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

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

Hi, I have an application that has a "Notes" textbox where I want the user to be able to type anything they want. The problem is that whenj I try to do an 'INSERT INTO' command I somtimes get the error "Syntax error (missing operator) in query expresion ....." It only seems to happen...

Please ignore me, i've worked it out.

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

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

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

When you say Cell, do you mean in excel?

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