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

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

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

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

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

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

Hi, I have created a custom commandbar (popup type) that shows up when I right-click on a listbox on my form. I want to add a textbox or a combobox to the popup, to allow the user to enter some search criteria and filter the list of items in the listbox (similar to the popup that comes up when...

Hi, I was wondering if there is a function that will return the kth percentile of a dataset, for instance the 95th percentile of salaries, etc. Or if not, is there another way to do it that may not be as easy? I know there is a percentile function in Excel but not sure about Access. Thanks, Bill

Hi, I have an option group / frame which has several option buttons in it as well as several labels (to identify the options). The problem is, I can't see the labels, only the option buttons when I have a backstyle for the option group that is "Normal" (i.e. the background is a solid color...

Hi, I am developing an Access application on a computer that has a screen size / resolution of 1024 x 768 pixels. I have noticed that on other computers that have a lower resolution (800 x 600 pixels), the form looks really huge and many of the controls are actually cut off, and the user has...

Hi, I have a form that has a Form Header section, Detail section, and Form Footer section. I can re-size the height of the Form Header and Footer sections, but can't figure out how to re-size the Detail section. To be more clear, I can set the height of the detail section but it will be...

Hi, I am using Access 2000 and have a number of events for various controls that are not being triggered when they should be. For example, I have a command button cmdPrint_Report. The event procedure looks like this: Sub cmdPrint_Report_Click() 'print the report to the default...

Hi, I'm looking to do some formatting to a query through code, specifically, widening some of the columns (or doing an Autofit).. you can do this through the Format menu once the query is open, but I want to do it with VB. I investigated the properties for the querydef object, but couldn't...