Search results

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.

to dhoffman: In the Report Footer area (in Design view), I created two subreports that are side by side. The first subreport contains the first query and report which retrieves the first half of the data from the table. The second subreport contains the second query and report which retrieves...

I tried that, but it not display the data down the first column and then start in the second column when the first column is full. It displayed alternate rows in the first and second columns (like below): 100 Pending Events 1100 1105 200 Pre Inspections...

Yes, you can. You need to join the tables together. Depending on what data you want to see on the report, you can do a RIGHT, LEFT or INNER join (you can lookup joins in HELP to determine what type of join you want to do). Good luck!

I tried that prior to posting my question and it did not work. It works if I run the subreport independent of the main report. Once I put the subreport in the main report, it lists all the data in one column. Has anyone been able to do this successfully??

I have a subreport that has data in one column as follows: 100 Pending Events 1100 1105 200 Pre Inspection Events 1200 1205 1210 1215 I want to fill the page going down the first column. When the first column on the page fills up, I want to continue...