Recent content by fynder

The form becomes the input box. A regular input box will not allow you to put a combo-box on it. You can call the form you've created from a macro just like you did the input box however. "Databases That Work The Way You Do!"

Create your own form with the combo box on it. Use VBA to open the form when you need input and use docmd.runsql to run your query with the combo box as the criteria. If you don't want to see system messages, use docmd to turn of warnings until after the query runs, but don't forget to turn...

I'm afraid that the solution will not work with an MDE file. You cannot import certain objects from an MDE. "Databases That Work The Way You Do!"

The Format Function is more or less "Basic" to Access. When you get an error like this (sometimes you'll get the same error with a function like "Trim()") the database has somehow incorrectly registered within Access itself. To fix it, create a new BLANK database and IMPORT...

You can have 24 of those hidden textboxes if you want to write the code to manage them. You are not limited to one textbox to pass info back and forth with. "Databases That Work The Way You Do!"

A lot of times, the kind of problem you describe is not an ongoing one. Sometimes, the problem is with windows and not with the code you've been successfully using. Do a compact and repair on the MDB first. Then close and restart windows on your machine. If you STILL have the problem, create...

Suggestion: Place the value you want to appear in your label in a textbox (with visablem property set to "no") on the form you are using to call up the new form. In the "On Open" event of the new form, have the new form look back at the other...

Can anyone point me in a good direction to find info on creating a "dynamic" access report that will allow displaying different pictures with related text in the detail section of an Access2K report. The graphics will reside on a CD or in a directory. The text would be...

Easier than that, try putting your code in a new module instead of relegating it only to the form your control appears on. You can then call that same code from any form in the database. "Databases That Work The Way You Do!"

You need to properly reference the form/subform. When it has been inserted into another form, THAT form becomes the "Main" form. The former main form is now a subform of the new one and needs to be referenced as such. "Databases That Work The Way You Do!"

Have the code you are running call up the splash screen with the message you want displayed. At the end of the process, close the form and reopen it with the next message explaining the next process. To make this look less "clunky" and more planned for the user, change the form...

DAO is used specifically for the JET Engine behind Access. The DAO library for Access 97 and 2000 differs because each version has a different version of JET. ADO code is not limited to the Jet Engine. If you anticipate upsizing your application to SQL Server or some other server backend, it...

Use the Timer for your form (see Timer in Access Help). Let the timer increment itself and use that as the source to update your progress bar. You'll need to experiment with the timer interval value to determine what makes your Bar look the way you want it to. You will also need to tell the...

If you are using a query to provide the source, any blank line in the source will show as a blank in the listbox. To avoid this, use VBA code. Take your original query and use DAO(if you are using JET) (or ADO if otherwise) to get a result set of the items you want. Using code, cycle through...

The NZ function goes on the field line of your query grid. The function "Nz(variant[, valueifnull])" returns a VARIANT type variable. If you are interested in a Long Integer value instead of a variant you can use an "Immediate IF" function. Assume the Field Name is...