Recent content by linda sciallo

I have an amount that is a string field that contains the value 0.01 that I want to convert to numeric in the recordset. The convert statement I am using is as follows: CDbl(Val(Replace(OldValue, ",", ""))) OldValue contains 0.01 The application abends with "key column error is...

This is a numeric field that is being converted to text field on the database.

Below is the code: strfield is the name of the field NewValue contains "0.01" intIndex contains the field index in the recordset mrsTable is the recordset I get the error when I hit the update statement. '************************************ 'Public property that returns the value 'of the...

Has anyone ever gotten this error when you try to update a recordset??: "Key column information is insufficient or incorrect. Too many rows affected by the update". Error -2147467259 If so, how did you resolve the problem?? Thanks.

Can "0.01" be converted using the CDbl function?? If not, any suggestions on how to convert to text?? Thanks.

I have a form where I can enter New Request information. There is a button on the form that allows you to save the data by clicking on it. A message box comes up and asks if you want to create a new request. If you click the Yes button, the New Request form is displayed, but the form is not...

I have an application that is open on a server. Another user opens the same application on the same server, and tries to run an Access report. An out of memory - run time error 7 occurs. In the code that executes the SQL to produce the report, there is a DoCMD that opens the report in design...

I had to do something similiar recently. This worked like a charm!! Thanks Pat.

Does anyone know how to unload a multi dimensional array to individual text boxes on a report. The array contains 38 rows and 15 columns or fields. The report has 15 text boxes (one for each field) in the detail section of the report (in Access) for each row in the array. There seems to be...

It starts out as a recordset. It is a contractor activity report that contains open, closed and total activities. There can be 2 rows for the same contractor that are returned by the query (sums for all the opens and sums for all the closed). On the report, I need to collapse the two rows...

Does anyone know how to unload a multi-dimensional array that contains 38 rows, and 15 columns (fields) to a report that has 15 text boxes (one for each field in each row)?? A sample of the code would be helpful.

Does anyone know how to unload a multi-dimensional array on to a report?? There are 38 rows in the array, and 17 columns (or fields) for each print line. A sample of what the code should look would be helpful since I am only a VBA beginner. Thanks.

Not sure that I totally understand the solution. The row on the table contains one column for the status field. The value in that field can be a 'O' for Open, 'M' for Missing or 'C' for closed. In the crosstab query, how do differentiate between each status?? Do I use IIF in the Count...

I WANT TO CREATE A REPORT THAT LOOKS LIKE THE FOLLOWING: CONTRACTOR TYPE OPEN, MISSING CLOSED NAME CONTR #APPS KWH KW #APPS KWH KW ABC CO HVAC 23 234 2 22 456 5 THE TABLE CONTAINS ONE STATUS FIELD THAT HAS A VALUE OF O FOR OPEN, M FOR MISSING, AND C FOR CLOSED. ONE...

Has anyone used the Replace Function in VB to replace quotes and apostrophes? Can it be used in VBA code behind a form in Access 97? If so how can you supply me with a example of how it would be coded? Thanks.