Search results for query: *

LastModified" is here my (badly)named variable. "sfrm"=subform. Is there any further explanation available about "run-time error '7878'" anywhere? I coud not found any info on that.

line 5 (1st one)

What is going on when I get (Access 2002) error message: run-time error '7878': the data has been changed (The error message sounds to me quite confusing.) then the VBA debugger shows a line " !LastModified.Value = Date " If I then continue running the coe, it seems to work...

Here is a part of the questionary, so you can see why there are so many check boxes (poorly translated from finnish): several options may be selected for each question. 1. services that customer has previously used: 1.2 hospital 1.3 police 1.4 social worker 1.5 wellfare 1.6 AA 1.7 drug rehab...

thanks "dhookom", additional detail sections solved the problem. Trick was to put data to new 'header'-sections of the report. (in "sorting and grouping" add as many as necessary : Field/expression=myCustomerID, Group Header=yes. )

No normalization issue here. I'm trying to print only one record! It contains all customer data concerning one customer-visit, hundreds of check boxes and text-boxes. (Database contains hundreds of customer visits.).

I need to make a report which contains aprx. 300 "text box":es. (Access 2002) Currently I have them all in one report, in same 'detail'-section. How can I make a report, where they all fit? Tried so far: -make detail section longer: can't do, Access doesn't allow over 55.8cm...

asnwer(old,bad version commented out): Dim CurConn As New ADODB.Connection Dim p_rst As New ADODB.Recordset Dim CurDB As Database Set CurDB = CurrentDb ' Set CurConn = CurrentProject.Connection ' With CurConn ' .Provider = "Microsoft.Jet.OLEDB.4.0" '...

I'v get excatly same problem as nickjar2. Did anybody found out the solution? (how to get 'current connection', for which user has already supplied username and password?)

I don't know what has caused the problem. This is my 1st access application, and the same problem with Recordset has been present every time I'v used it. Here are the properties: (resulted from adding the code) property value = True property name = Jet OLEDB:Lock Retry property value = 0...

1) Is it a normal procedure to use ADODB.Recordset to modify database in Access. Is there some way know when updating is 'ready'(?) ? There is some strange problem with my system with it. The code below works erratically: the table "tbl_kansallisuus" is always updated when the code is...