Search results for query: *

Hello, I have a chart control on a form (the standard/included chart control MSGraph.Chart.8) which allows the user to build line charts and interact with it in a variety of ways. One of the features is a 'zoom' which allows the user to click on a section of the chart where they want to see...

I am just trying this in the immediate / debug window to test: ?Forms("frmMain").WindowTop while the form is open, and I get the error. one other thing to note, when I type the "." the property does not show up in the list, just WindowWidth and WindowHeight. Thanks, Bill

Hi, I am trying to use the WindowTop and WindowLeft property but I am getting an error message "Application defined or object defined error". This is what I got from MSDN (below) - seems pretty straightforward so I'm not sure what is going on. I doesn't say I need a special library or...

I think this is a simple one - I'm wondering if there is a way to prevent the users from re-sizing a column in a form (datasheet view). Thanks, Bill

Hi, I have a small popup / modal type form that will pop up when the user clicks certain buttons and I would like to position it right next to the control that the user clicked on. I couldn't find properties for the form (left, top) that would allow me to do that. Is this possible? Thanks, Bill

The acReadOnly is exactly what I needed. Seems so obvious now! Thanks, Bill

Hi, I have an application where users can query my database through linked tables. The SQL for the queries are dynamically built in the interface when the user selects the report and various criteria, and then the query is created and opened. I didn't build a bunch of forms because there are...

Hello, I am using two ActiveX controls for my application - the Microsoft Common Dialog control 6.0 and the Microsoft ProgressBar control 6.0 (which is included in the Microsoft Windows Common Controls 6.0 mscomctl.ocx file). I am never quite sure when I use an ActiveX control whether my end...

This is perfect - thanks! Bill

Hi, I'm trying to figure out if there is a way to run some code when the database is opened, even if the user holds down the shift key when opening the file. I know I can run some code with an AutoExec macro, or by tying it to a form that is set to open when the database opens, but neither or...

What object does the Columns property apply to? For a querydef it didn't seem to work (it has Fields property). Are you sure this is for an Access query, and not Excel? Thanks, Bill

Hi, I'm wondering if there is a way to do a Best Fit on a column in a query through code, similar to what would happen if you went through the toolbar (Format -> Column Width -> Best Fit). I know how to set it to a specific size through VB: Set Prp = fld1.CreateProperty("ColumnWidth"...

Hi, I'm wondering if there is any way to trigger an event when the mouse moves over any portion of the Access screen / application, not just a form or control. The problem is, when the mouse is moved too quickly over a control and then off the form, the mousemove event for the form is not...

Hi, I am using linked tables between my interface and back end (both Access). The back end deletes it's data and then downloads new data every day from our main Oracle ERP database. Because of this, the file size keeps growing unless I compact the database every day after deleting the old...

That works perfectly - thank you very much, Bill

Hi - hopefully this is an easy one. I am trying to set the caption of a label through code, and I want the caption to be split into multiple lines. I tried to use the chr(13) to split the text but it didn't work, it displayed a square instead of performing the carriage return. My code looked...

Thanks Seaport.. in general I would agree, and yes most of the code is in the interface. I do have a small amount of code in the database to do refresh tasks though (it downloads data from our Oracle ERP database every morning). I'm not expecting to have to edit this code that much either so...

Hi, I have an Access database on a server an Access interface linked to the tables in this central database. The problem I'm having is that when one or more users open a form in the interface (that has as it's recordsource one of the linked tables), the .ldb file appears and I get locked out...

I've noticed that a lot of common applications like MS outlook, Access, etc. have some type of commandbutton or other control that will be highlighted or the picture inside it will change when you mouse over the control. I would like to do something like this for my app but it does not seem...

Hi, I am trying to do some formatting for a query through code - specifically, formatting the column widths so they are not too wide or narrow. Here is the code I have so far: Dim qdf1 As DAO.QueryDef Dim fld1 As DAO.Field Set qdf1 = CurrentDb.QueryDefs("Delivery Performance") For i...