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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fordboy0

  1. fordboy0

    Open Modal / Dialog form as object with VBA code.

    The trick here is to open the form in acDialog mode (as opposed to making visible). e.g. docmd.openform "frmOkYesNo",,,,,,acDialog select case frmOkYesNo.Reply ... ... end select Yes, but unfortunately, this restricts the level of customization once again... If I open the form like...
  2. fordboy0

    Open Modal / Dialog form as object with VBA code.

    Hey all, I have an interesting problem. I had posted earlier about making "Message Boxes" non-centered. It's for an app that's on dual monitors, and well, a message box split between two monitors sucks. I got some great responses about creating a modal form with borderstyle set to...
  3. fordboy0

    Make msgbox display non-centered.

    Sorry for the delay... Other problems you know :) Thanks for the info, I guess I should have searched first. It's what I thought I would have to do, but it's implemented better, so... Yoink! Thanks again! -Jeff
  4. fordboy0

    Make msgbox display non-centered.

    Hey all! Hope all is going well... I have a strange problem that probably hasn't occurred for most of you. I am building an application that uses two monitors. They are configured as one on top of the other. Ie. My total screen resolution (as far as access is concerned) is 768H x 2048V...
  5. fordboy0

    Dlookup question

    Hey all, I'm coming over from the VB side, and I have little experience with databases so be gentle. :) I've got a NASCAR pool of which I'm the "commissioner". I figured the best way for me to figure out how this database stuff works is to have a hands on project to get my feet wet...
  6. fordboy0

    Return all objects available on a form.

    Aha! Thanks for the info... Still kinda getting my feet wet on some of the intricacies of VBA. "theform.controls" is considered a Collection object right? In order to get this straight in my head... PLEASE correct me if I'm WAY off base :) I would call it as such...
  7. fordboy0

    Return all objects available on a form.

    Hey all, I have an interesting problem that I can't seem to find information on. I have the need to create a Sub (or function or class) that will, given the form.object, return all of the objects (or controls) on that page. The reason for this is that one of my fellow programmers has a need...
  8. fordboy0

    Opening a form at a specific location

    I did a search through the forums and found an answer, but it doesn't work. :( I am using two monitors with the desktop spread across both. I have a preview form that needs to open and be sized on one of the monitors. I haven't found any form methods or properties that seem to support this...
  9. fordboy0

    Pass form or control object to subroutine.

    Thank you all! I ended up using a combination of both of your suggestions. Peace! -Jeff
  10. fordboy0

    Pass form or control object to subroutine.

    Oky... Much MUCH closer than before. The passing of the LEAD control works fine, but I'm still having issues with the form. First off, Thank you to pwise! Assuming my control name is "LEAD1" and my form name is "orderform" AND I'm using the snippet of code from pwise...
  11. fordboy0

    Newbie Question: Need path and filename for file import??

    Sorry, but I guess I should have said... 'code... CD.Flags = cdlOFNLongNames 'code... That's probably what you are looking for. -Jeff
  12. fordboy0

    Newbie Question: Need path and filename for file import??

    Give this a try... Make sure that you have the Microsoft Common Dialog control loaded (Click More Controls... from the toolbox). Hope I understood what you were looking for. Good luck! -Jeff Private Sub cmd1_Click() Dim CD As New MSComDlg.CommonDialog CD.Filter = "All Files...
  13. fordboy0

    Pass form or control object to subroutine.

    I have searched both high AND low and haven't found the solution for this... Maybe I'm just looking too hard. I have an application which uses a specific ActiveX control (LEADtools) on many of the forms. With each form, the user will have the opportunity to do the same sorts of things with...
See more

Part and Inventory Search

Back
Top