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!

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

Recent content by SuryaF

  1. SuryaF

    background grid for scheduler

    In case somebody else is looking for a similar solution, I found a more elegant way. I'm using the FlexGrid control to draw the back grid and on top of it I draw my appointments. Since Access puts any ActiveX control in front of the other ones, I need to disable the flexgrid. Nonetheless, it's...
  2. SuryaF

    control's position and size after anchoring

    Hi everybody, I'm using the anchoring in Access 2007 and although I find it very useful to get rid of some old code of mine, I have some problems with it. The thing is the resizing/repositioning doesn't really change the left/top/width/height values of the controls so I have no idea where are...
  3. SuryaF

    background grid for scheduler

    Hehehe, yes, I have around 1000 forms and probably some of them can be taken out and replaced by dynamic versions but most of them are unique and necessary. It's a lot but it works without issues. The application is an ERP system for small clinics, fron-end in Access 2003 and back-end in SQL...
  4. SuryaF

    cloning form using VBA

    Hi everybody, I have learned the hard way that old forms with a lot of controls can have enough garbage hidden to make it run very slow. Once I have recreated the form from scratch (with the same controls and code), everything worked beautifully. Now hoping to improve the performance of the...
  5. SuryaF

    background grid for scheduler

    Yes, that's one way of doing it but it limits the actions you can do and the formatting options. Which is quite necessary for me since I'm building a commercial application that needs to look as non-accessy as possible. I solved the problem though, I basically recreated the form from scratch...
  6. SuryaF

    background grid for scheduler

    Thanks MajP. The problem with a continuous form is that I can't put a control that is on two rows. Imagine each row is a 15 minute interval but I want to show a 30 minute appointment as a distinct block, there's no way I can do that with a continuous form. Makes sense? I'll look into the...
  7. SuryaF

    background grid for scheduler

    Hi everyone, I'm working on a scheduler and I've been using labels to draw the background grid but I'm using way too many controls and the form is getting very slow. Any idea what kind of control or method I can use to put that table-like grid in the background? I'd like to be able to format...
  8. SuryaF

    Synchronised Subform Scrollbars - Is It Possible?

    Hi MajP, I saw your example. The problem is when you don't actually have rows. Imagine two tall subforms, with a bunch of controls in them of various heights. The subforms are neither continuous forms nor datasheet, so no record is changed. To be more clear, I'm working on a scheduler grid. In...
  9. SuryaF

    Synchronised Subform Scrollbars - Is It Possible?

    The problem with your solution DAmoss is that it doesn't work with the mouse wheel, does it? If it does, how did you do it? I ran into the same issue but the two long subforms in a tall form is not nice because of this silent-wheel problem. Thanks!
  10. SuryaF

    rich text formatting in runtime

    Hi, I'm moving towards Access 2007, I like the Rich text control they have added. I have a problem though, the mini toolbar doesn't come up when using the Access runtime. Any suggestions here? I can apply bolds, italics and underlines with Ctrl-B, I, and U but I can't find the shortcuts for...
  11. SuryaF

    task pane

    Greetings! I'm trying to add a docking form to my Access application. It should look something like the Navigation Pane in Access 2007. I found references on the internet about custom task panes, did anyone here develop one for Access? Do you know of a sample I can use for model? Do you have...
  12. SuryaF

    activex button

    Heya, I have a big dillema and I'm hoping one of you can give me a hand. I've implemented an ActiveX button in my Access 2003 front-end but since I started using it the front-end crashes regularly. The most visible symptom is an "insufficient memory" error coming at some point, after which the...
  13. SuryaF

    stopping the scroll

    I don't think this is optimized but it's not important. Please check the Data Entry property of your form. I think you have it set to yes. If this is true please do the following: Add: Me.DataEntry=False Me.AllowAdditions=False at the end of your Form_Load event. You can ignore all of the code...
  14. SuryaF

    stopping the scroll

    Yes, this is quite strange. You said: Can't you just have the form linked on that table in the first place? Can you paste your Form_Load event in here? I think that's what's creating the problem.
  15. SuryaF

    stopping the scroll

    a few more questions: A. How many records do you have in your table? I see you don't apply any WHERE condition to your OpenForm command. B. Do you ever add records with your form? If not then you simply set the Allow Additions to no and it's all good. C. Do you navigate between records with...

Part and Inventory Search

Back
Top