Recent content by jeisch

Thanks! Changing the registry setting fixed it. Does this registry setting have an impact on anything else I need to be aware of?

I'm new to VB, and heve been asked to support an existing application. Two of our users has been using the application, then they started getting a compile error. They are using VBA 6.3. The error occurred when trying to refer to a RichTextBox that was supposed to be on a form, but the box is no...

I'm new to VB, and heve been asked to support an existing application. Two of our users has been using the application, then they started getting a compile error. They are using VB 6.3. The error occurred when trying to refer to a RichTextBox that was supposed to be on a form, but the box is no...

I have an Access application we have been using for years, originally in Access97, converted to 2003 a couple of years ago. I recently made changes, adding a new report, along with other minor changes. When exiting the application by doing: Application.Quit acExit The application closes, but...

Thanks, That worked.

I have a column in a table that contains values with spaces include. Ex "12 F7 35". I need to remove all spaces from this column. It needs to be "12F735". I tried using translate, but that seems to only translarte from one character to another, it won't actually remove the space. Thanks

Try creating another query using the pass through query as input to that query. That query will now be an Access query, and you should be able to do a make table or append into an Access table using that query.

There is a different version of Word and Outlook on the XP machines. When the apllication is opened, it goes out and gets the newer references for those products automatically, and those functions work fine. Keeping multiple versions of the application is what we are trying to avoid. And if we...

It only happens when going from the windows 95 workstation to the XP set. I think it may have something to do with the references to Word and Outlook. When running on the XP machine, it automatically changes the references from Word and Outlook 8.0 to Word and Outlook 11.0. The XP sets only have...

I have an Access97 application that is running in several different environments, 95, NT, XP. Everything works fine except when we distribute it to the XP machine. On the XP set, we get an error in a couple of queries where it can’t find certain functions. If we go into references and change any...

I am trying to open a recordset that uses SQL selecting data from an attached table in an Access97 database on a Novell server. I am running this in access97 on XP with SP2, and I get the error 3045 - file already in use. We have users on all different platforms running the front end...

Thanks Ties, I ended up loading the data into a temporary table, and then doing my update from there. I don't think I was going to be able to get around the group by clause, which I think I do need. Jim

I tried to do that and it tells me I'm trying to update with a NULL value, I don't think it will work because it is not grouping the minumum date based on the values of col1 and col2. I tried the following and got an error message: UPDATE TableA A SET upd_dt =...

I have been trying to update the value of a column in table A, using the Min value of a column from table B, and have been unable to figure it out. This is the query I need to use to update the value in Table A Select COL1, COL2, MIN(UPD_DT) From Table B Group By COL1, COL2; The...

Thanks, That works great, and its so simple.