Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SequenceIT

    how to handle subform references in code

    I'd urge you to have a squizz at MSDN and the Access Help file to check on the order of event firing. As I recollect, the subform load before the main form, but don't quote me. The syntax for referring to a subform's controls from a main form is...
  2. SequenceIT

    how to update "null" value with zero ??

    Firstly, make sure that the default values for all the fields in all the tables are set to some approriate value to avoid this happening again in the future. Now, if the problem is just in dealing with the Nulls in data processing, you can alway use Nz to fix it up. e.g. intMyInteger =...
  3. SequenceIT

    Form don't have to be maximized !!

    I second the last post! I always use DoCmd.Restore on form load for consistency, and set the Form's AutoResize and AutoCentre so they always turn up in a predictable location. All the stuff you read about user interface design aside, I've had users thank me for designing forms this way - they...
  4. SequenceIT

    Accessing Multiple Word docs in a form

    That's the great motivation for looking into storing the paths. I've meant to look into seeing if they can be stored as hyperlinks, as hyperlinks take up no more space that OLE bound frames, and since they're 'active' make it very easy to gain access to the docs. Just display them in a...
  5. SequenceIT

    Accessing Multiple Word docs in a form

    Hmmm. I can't reproduce the problem. Can you describe in a bit more detail what's going on. There should be a table with an OLE Object field that is displayed on the form using a Bound Object Frame. When you right click on the frame, you should get an Insert Object option, that will allow you...
  6. SequenceIT

    'Check all that apply' list box

    scra is absolutely right, not only from a functionality point of view. It's standard user interface design to use option buttons (radio buttons) for OR type choices (only one is selectable at any one time) and to use check boxes for AND type choices (pick as many as you like). Such standards...
  7. SequenceIT

    NEED ADVICE ABOUT ACTIVEX LISTBOX

    Easy on the CAPS! It look like your shouting!
  8. SequenceIT

    Active X Problem

    Just a guess, but open the VBA editor (ALT+F11), and check 'Tools, References' to see if there are any broken references. If not, refresh references anyhow. Make a note of all the checked references, then uncheck one, close the dialog, try and compile (it may fail), then go back and recheck the...
  9. SequenceIT

    Writing Subform data to a second table

    There's a lot more to this than meets the eye! It rather depends upon the relationship between the bound table, and the secondary table. Explain a bit more, and I'm sure that a solution will be pretty straightforward. Think about the data that your representing in the tables, and decide what...

Part and Inventory Search

Back
Top