Search results

I have some other forms that are using unbound textboxes already. Updates are done by VBA code, just like you. However, the users prefer the multiple fields/multiple rows look (e.g. as if in Excel...) That's why I'm trying to provide them with datasheet editing mode. (trying to, anyway).

I know what I need. I'm having problem with making what I need to happen. (You just basically listed the things I already know I need to do.) A disconnect recordset used with datasheet, when edit by hand, it doesn't mark the record (rst.Status) as adRecModified (for some unknown reason)...and...

Anyone else got any suggestion?

RunCommand acCmdAppMaximize

Hum...no. Let's try a mini example: [Flight Rates Table]: ID RevisionID Origin Destination Price DateUpdated 1 4 Tokyo New York 1100 1/10/2004 2 2 Tokyo Vancouver 1050 15/10/2004 3 5 New York Chicago...

I really don't see what info is missing. So, I'll say the same thing again, but differently: Users need to have the ability to edit data of a table. Everytime a record is changed/updated, its revision number is incremented by one. One way is to edit data directly in a datasheet form, but will...

Disconnected Recordset is one that has ActiveConnection set to Nothing after the data is cached locally. Batch mode is when you open a recordset, the LockType is set to adLockBatchOptimistic. Recordset is using ADO.... The fact that you're asking what "Disconnected Recordset in batch mode" is...

Since no one can help me with my previous two issues...here's a third one, which will help me decide how I should do what it is that I want. Question: Can I have a single recordset that is both "User editable" (from datasheet) AND batch updateable (via VBA code)?

yes...did all those.

This one is urgent as well...

Please? It's rather urgent...

Please? I need a solution...

Anyone? Where are my usually group of Gurus?

I have a disconnected Recordset in batch mode. When I update the fields (via VBA code), the recordset status returns adRecModified....as expected. Now, this recordset is also hooked up to a datasheet. When user edit the datasheet (by hand, via keyboard), change data in multiple records/row, the...

Reason why I want to be able to preview batch changes to the recordset in a datasheet view is because the datasheet consists of some data where the user will apply a batch changes (via vba code) AND also edit the changes on the datasheet directly. So, I need the ability to batch change the...

I have a recordset (Disconnected) that's opened for UpdateBatch usage. certain values of the recordset are change via VBA code (say, Field1 increment by 1 for all rows/records). The recordset is also the .recordset property of a subform (in datasheet view). After changing the values of Field1...

Take out the first rst.open statement. Also, why don't you use boolean as the return data type for the function? Also, you don't need to set the strSQL to nothing, you only need to close the rst and set rst to nothing.

ChrisO, Thank you! Thank you! Thank you!!!! The second demo is EXACTLY what I needed! You're the man!

yes, that I'm aware of...but so is VB. (In VB you can get a scrollbar's value, as you know) I was hoping that upon Form_Close or Unload, I can read certain properties of the controls within the form.

The thing is, the form isn't bound. I have setup user preferences, so the user can choose go to last position or not (using registry for VBA). Again, I need to know the scrollbars x or y position, or window viewing position.