Search results for query: *

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

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

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

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

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

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

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

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

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!

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

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

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

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

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.

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

Just that form would suffice but if you can't upload it I'm affraid I can't find out why your code is not working. As missinglinq said, the most common solution is the one given on the lebans.com, try it out. All the best!

I can't tell, can you upload your database on an ftp site so I can take a look?

Try adding the following code in the Form_Open event: Me.AllowAdditions=Me.DataEntry This way when you open for editing, the form won't allow a new record. The code you have right now only works when you open the form in Data Entry mode (with the acFormAdd option). HTH

Hi irethedo, Did you define the variable globally for the entire module? Can you post the code here? Maybe there's a problem with it. Cheers!

Hi missinglinq, You're right, the solution from lebans.com is more elegant and easier to implement but it has a big disadvanage for me: it stops the scroll for the continuous subforms. That was a big deal for me so I tried to find another way. Sincere thanks for your input!