Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davem1958

    MSHFlexGrid cell size max

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

    MSHFlexGrid click event

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

    MSHFlexGrid click event

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

    MSHFlexGrid ignoring mouse click

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

    MSHFlexGrid ignoring mouse click

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

    MSHFlexGrid ignoring mouse click

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

    Error 2771 with Calendar control

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

    Error 2771 with Calendar control

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

    Compile errors in forms

    If you try to open a form with compile errors in the code, you'll get a non-helpful message such as "The expression On Load you entered as the event property setting produced the following error: Expected Function or variable." To track it down, click on Debug, Compile <YourApp> menu...
  10. davem1958

    Compile errors in forms

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

    Compile errors in forms

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

    Compile errors in forms

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

    Can form be bound yet unbound?

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

    Can form be bound yet unbound?

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

    Can form be bound yet unbound?

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

    Unbound forms

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

    Generate calendar on Access form

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

    Generate calendar on Access form

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

Part and Inventory Search

Back
Top