Search results

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...

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...

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.

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.

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...

I have a subreport that is based that is on 5 queries which are linked together to obtain the data needed for my subreport. The final query that links two of the 5 queries together is the record source for the report (the query names are used in this query). How do I hide the title of the...