Search results

I have a database with several complex reports (each running at least 40 queries (while some run up to 90 querries) to prepare the data for the reports requirements). Basically I have a combo box where sales order numbers are entered, upon a click event for this control a series or queries are...

I have a listbox which has a field bound to a table. The values in the table are recorded with 4 digit precision, the values in the listbox are displayed with only 2 digit precision. How do I get the listbox to display 4 digit precision numbers?

I want to find a method name for changing records. When I use navigation buttons to flip between records this creates an event. I want the VBA form module to "detect" this event and autocomplete the value of the unbound text box "txtDescription" based upon the value within the bound combo box...

Is there a way to programatically schedule a compact/repair operation? I would like to use the windows scheduler to open a database whith a compact/repair operation. Alternately I would like to add this utility function to the autoexec macro. ========================= I have a couple of...

I have a database where selection of a sales order number autocompletes several fields on a form, then sets those text boxes ENABLE value to FALSE. My question is HOW CAN I SET THE ENABLE PROPERTY TO TRUE ON RECORD CHANGE? What is the event name associated with record change?

For Runtime distributions of Access 2000 I have been adding command line switches to the desktop shortcut to manually point the client machine to the relevant MDW file. Can I programatically set this in the actual database so that each secured database will have its own MDW file? If not...

How do I attach a calender control to a combo box, so that the selected date will fill the combo box field? I have seen this done a lot but don't know how to do it. I am using MS Access 2000 and Calender Control 9.0 does not appear to serve my needs. Thanks in advance.

With VB there is a calender control you can place on forms showing a month-view calender, then when you click on a day it enters that value MM-DD-YY into a field. Can I do this with MS Access 2000?

I have an MS Access 2000 database which runs several underlying queries and then pulls rusults via a date parameter. All calculations are done in the query and the query takes about 4 seconds to run. I then have a report with no special formatting which merely posts the results of the query...

I want to force a UNIT PRICE value 0 to appear for all ORDNUM_28 which begin with the digit 5. My attempt to run the following within a query is not working and I'm hard pressed to figure out why. I have never used the LIKE method before...... Please help. UnitPrice: IIf([SO...