Recent content by fordboy0

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

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

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

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

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

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

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

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

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

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

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

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

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