Search results for query: *

Thanks. Good advice to a not very good question.

I am trying to install the SP4 security update 7.00.1077 package. When I click download, I then click run. The package is copied to the a temporary directory and unzips the files there, but does not install. The directions do not indicate how to install the update. There are several .exe...

I think you have to use syntax more like this to insert records into a table: Docmd.RunSql "Insert into " & rst2 & " select " & rst1 I don't think this solves your whole problem, but give this a try and let me know if it fixes the imeediate syntax error

What fields are different? If the records are really distinct, then you first need to decide which information you are losing and which record(s) you want to keep. For example if the company field was identical but the address was different, then do you want to keep one of the addresses but...

I tried the syntax you suggested "CurrentProject.Connection.Execute strSql" and it gives me the same error, i.e. "Syntax error in INSERT INTO statement" Good idea, though.

I have done an insert using rst.open format. I did a msgbox on the strSql statement to see what it is giving me literally and it comes out as follows: insert into tblOrderEntryLine(Index,CUSTNMBR,CUSTNAME) select Index,CUSTNMBR,CUSTNAME from tblOrderEntryMaster where Index = 25 See anything...

Copy a recordset based on a query using the keyword DISTINCT in a SQL statement. That assumes that you have a field that really is unique. If so, then your SQL query would be something like: SELECT DISTINCT FieldA, FieldB, FieldC FROM Table1

The following code gives me an error "Syntax error in INSERT INTO Statement. I have checked the destination table to be sure that the column headings match. I also checked the data types of the variables in the from and to tables to be sure that they match. Any other ideas of where the...

I tried that first, actually and the same error results. Any other ideas?

The following code gives me an error "Syntax error in INSERT INTO Statement. I have checked the destination table to be sure that the column headings match. I also checked the data types of the variables in the from and to tables to be sure that they match. Any other ideas of where the...

Depends on whether you mean in Access or by using VB. I have never found a way in Access by itself to query a record and apply its values to a different record. But if you go into VB, then you can open a recordset and store the value for a record into a variable, do the math you want, then...

Regarding point 1, you can also put a filter into the report itself. Enable the "Filter On" property and enter the expression you want to use to filter your data. Instead of using one of the fields in your table, use a new filed surrounded by [ ]'s. When the report runs, it will...

On the destination server: Win2K SP3, SQL 2000 SP2 On the source server: Win2K SP2, SQL 7.00.842 TCP/IP

On the destination server: Win2K SP3, SQL 2000 SP2 On the source server: Win2K SP2, SQL 7.00.842 TCP/IP

In trying to use the upgrade wizard to convert a database from SQL 7 to SQL 2000 (remote server to local server) I receive the error: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Unspecified error Step Error code: 80004005 Step Error Help...

I don't know if you would like this solution, but have you considered allowing nulls in the table but effectively prohibiting them with the forms controls you are already implementing? If this wouldn't be satisfactory, then how about making the forms not be a direct update to the to the...

We have a user running Win2K attempting to retrieve a certificate. When he hits the certificate request button, he receives an error "Error downloading ActiveX control" and cannot continue. Per Microsoft's site on this error, we have upgraded his browser from IE 5.0 to IE 5.5 SP2...