Search results for query: *

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

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

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, 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'm trying to make a macro run every time I open or close a form in my database. Any form. Can that be done or do I need to run the code on each Form_Open event? Thanks!

Hi, I have a problem with an SQL Server 2000 MSDE installed on a Windows Server 2000. When I'm loged in as an administrator my Access front-end works lightning-fast with the MSDE but when I'm logged in as a non-administrator it's very slow! I assume it's from the back-end (MSDE), it behaves like...

There are tons of information on the internet on how to stop the scrolling through records. Most of them require an external dll or ActiveX so I had to find something else (due to the way my application is distributed). I found a way to do this with a few lines of code in VBA, it’s not the most...

Heya, I'm trying to see if a certain form was opened as vbDialog. I tried testing the Modal and the PopUp properties of the form but they are both false (the original settings). Any ideas? Thanks!

I have an Access db with linked tables and views from an SQL Server 2000 database. When I'm opening a linked view with the DAO.OpenRecordset SQL Server locks the tables involved in the view. I can see that in SQL Server Enterprise Manager. 1. How can I open the view without locking the tables...

Heya! How do I add a custom drop-down button on my toolbar? I suppose it's basically a menu but I can't seem to make it image-only. Any suggestions?

I have a tiny program that at some point displays a MsgBox. It works beautifully except on one computer all the text is gone. I mean all the text including the text of the buttons. It displays only a greyish empty clean (almost naked) box with three empty buttons. I tried changing the Windows...

Hi, In one of my tables I have a string field to record a calculation formula. For example "([Cost]+[Markup])*(1+[Tax])+10". I need to get the value for this formula. For example, when I have Cost=10 and Markup=5 and Tax=0.1 I need it to calculate somehow to whatever it is (I think it's 26.5)...

Hi, Any ideas how to right-align a column in a listbox? I have some amounts to show and they don't look well when left-aligned. Thnx.

I'm trying to set a transparent image for a command button. Of course, I have a GIF file but when I try selecting it for the button it gives me the following error: "Access doesn't support the format of the file ..., or the file is too large. Try converting the file to BMP or GIF format." Now...

Hi guys, I'm kinda challenged with a little thing. I've created a little procedure to refresh a combo box. I've put that procedure in a module. Sub RefrCombo(ComboCtrl As Control) 'refreshes the control and makes it null if the old value is not in the new list anymore ComboCtrl.Requery If...

I need to link my database to another one that uses different permissions. I need to do this from the code as both the database file and the workgroup file need to be changed at some point. Any idea on how to specify the mdw file? Thanks!

Well, I have a mind-twisting problem. My application runs as an MDE. I need to use some libraries that are only installed on some of the computers (quickbooks dll's, FYI). If I create the reference from the get-go, the application doesn't work on the computers that do not have the libraries...