Search results for query: *

I've got an HFlexGrid bound to an ADO recordset, one of whose columns is a Memo field. I've noticed that the text in the Memo field gets truncated at about 963 characters once it gets to the grid. Anyone else notice this? I don't suppose there's a work-around? Dave

That's what I was looking for...don't know how I missed it. Dave

This seems like a simple question, but... I want to trap the Click event in a heirarchical flexgrid, and show the full text of one cell in that row -- if it is a row. How can I tell the difference between a Click somewhere on the grid and a click on a row? Also, two clicks in sequence on the...

>>What do you mean by "where a 3rd Row Would Be". Is there >>a row there?. No, just a blank grid. >>Do you have any Click events on the grid that are taking over. No, only event I'm trapping is SelChange -- and the Row property is off by 1 even before the event code runs. Dave.

I've found the problem, but no idea what the solution is. In this case, I only have two rows, plus a fixed row. Turns out if I click below row 2 (where a 3rd row 'would' be), it moves to Row 2. If I click on Row 2, it moves to Row 1. Bug or feature? Dave

I'm using an MSHFlexGrid, binding it to an ADO recordset, then closing the recordset (so now it's unbound). I have all the code to load the grid in a subroutine called 'RefreshData' I call RefreshData inside Form_load, and also when a user clicks a button. The problem is, after a Form_load...

I found out why, but not sure how to fix it. If the form is bound to a recordset, and happens to load with zero records, the calendar is still visible, but it doesn't like to be clicked. It works fine with 1 or more records. Dave

I have a form in Access 2000 with 2 calendar controls, version 7, which works fine. Each calendar works in conjunction with a combo box, as suggested in another thread. I created a new form, added another calendar, copied the same code into the form, and now when I click on a new date I get an...

Found it. There's a menu item Debug, Compile <YourApp> that does what I want. Too bad I didn't find it two weeks ago. :) Dave.

I don't get that far. When I load the form, the error message is &quot;The expression On Load you entered as the event property setting produced the following error: Expected Function or variable.&quot; None of the code runs, but form loads anyway. Must be some way to spot which code it's...

I checked the FAQs, but didn't find anything. How do you tell Access to compile the code associated with a form, and tell me where the problem lies? In a module, I just hit F5, and there it is. If I try the same in a form, it wants to know what Macro I want to run. Dave.

FYI - I made a permanent table, and added queries to delete then insert the appropriate records based on the user id. Since everyone is sharing the same database file, at the same time, this seemed like a good solution, and it appears to work. Dave.

WildHare, this sound promising, but what about a multi-user environment? Does everyone share the same table generated by the Make-table? It seems that Access wants me to delete the table first. Perhaps I could make a permanent temp table, use an Append query, and delete the appropriate...

I have a situation where I need to: - compare Table A with Table B - present records where there is an A, but no matching B - allow user to check off which records to copy to B - allow user to change certain fields of record A - copy the selected records from A to B when user clicks Note that...

I'm a VB programmer, so I'm used to doing everything in code. I'm trying to create an unbound modal form that when user fills out and hits Save, I create one parent record and multiple child records. The problem I'm having is that when I make the form unbound, my combo boxes quit working --...

Correct me if I'm wrong, but Leban's calendar seems to be a dressed-up version of the one included with Access. I don't see a way to display an entire month with various names against each day of the month. Dave.

I've been assigned the task of tracking vacation/sick days/personal days for my dept, and they want it done in Access 2000. Everything looks easy, except -- how to display a monthly &quot;group&quot; calendar with everyones &quot;out-of-office&quot; days marked? I'm open-minded -- an ActiveX...