Search results for query: *

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

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

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

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)

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

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

Hi, Can anyone give me any clues on this one? using VB6 to write to an access 97 database, I am using INSERT INTO to add a record. 5 minutes ago I was testing it and the code stopped with the error "The information could not be saved as it would cause duplicate values etc..."...

HI, I have an application which is a vb front end and an access 97 backend database. It sits on the network at work and works fine for 90% of the people 90% of the time. However I have had feedback that sometimes the prog is crashing but apperently with no error messages at all...