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...
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...
...want without a problem. It's only when I try to access it through the code that I get this error.
Set db_Access = ws.Databases(0)
SQL = "Select * From Res_Security Where EMPLID = '999999'"
Set ds_Privileges = db_Access.OpenRecordset(SQL, DB_OPEN_DYNASET, DB_READONLY)
Any help would be...
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...
I am using Access 97 and was wondering if there is a way to pass an input parameter to Access when opening up the database. I have two different sets of users that use the same application, but have certain things I would like to make available on one workstation, but not on the other. If I...
I am setting up an automated process using Access 97 on a NT 4.0 PC to create PDF files from reports using the Adobe Distiller. I am then attaching the PDF files to Winfax or Outlook , and sending them to customers. When Winfax uses the PDF files, it opens Adobe Acrobat to convert the files to...
We have various reports used by an Access application that change frequently. The person who will be maintaining these reports does not know Access. So, I would like to set up a procedure to open Word from Access (already done), create and/or allow modifications to the report in Word (already...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.