Recent content by vikin9

I want to find a record on a bound SUBform using a combo box located on an unbound main form. I want to use a datasheet subform to display the records, so I need to put the combo box in the header of the main form. I've tried modifying the combo box code from the wizard to refer to the subform...

Exactly. Usually, this situation occurs when I want to make a change in the BE and a table is in use (locked) by a user. Previously, we implemented an eMail request, but if someone's away from their desk, you've got to pay them a visit. I just got this feature working with a timer on a hidden...

I would like to somehow remotely close a user's local front end. We have a typical FE/BE set-up, with the FE's loaded from a .bat file. Occasionally, I want to remotely close all the FE's without running all over the building. I'd like to build something into the FE to automatically close the...

I tried this post in the Forms Forum, but no response. Is it possible to change the commands in the right-click shortcut menu? I'd like to add the "Find" command to the right mouse button shortcut menu (along with the Filter and Sort commands that normally show there). I don't see a...

I'd like to add the "Find" command to the right mouse button shortcut menu (along with the Filter and Sort commands that show there). I don't see a way to do this in the Customize menu. Is it possible to modify the properties of the right-click menu? Thanks, Vikin9

Thanks, I've got it. Put the Function in a Module and then refer to it. WorkDays: DeltaDays([StartDate],[EndDate])

Thanks for the fast responses! Rolliee: OnCurrent worked great, thanks! SBendBuckeye: That makes sense. How do you refer to a function in a calculated query? I've done some pretty involved calculated query fields, but I don't see how to pull the Function into it.

I have an unbound text box in a Form footer that calculates work days based on two dates in a form. The work day value is calculated with code (per faq 181-261, which works great I might add). I have it working properly using a command button. However, I want the value to calculate...

Thanks, again!

Terrific! I referenced the object library as you said, hit my test button and it worked first try! Thanks, Kyle! (Now I want to know how do the Star Wars thing below your signature.)

Thanks, Kyle! This is a little advanced for me, but conceptually I see what you're doing. Should Access (97) recognize the Outlook objects, or do I need to define them somehow? Pardon my ignorance, but let's say I wanted to use your code example to send myself a test message from a button on a...

I tried this question in one of the Access forums without success. Perhaps this is more appropriate here. I want to launch an Outlook eMail message automatically from Access, but the process stops at the Choose Profile box if Outlook is closed. You must press "Enter" to proceed. I...

The approach I use is two unbound combo boxes in the form header. In Combo1 AfterUpdate, requery Combo2 and the form itself. The row source of Combo2 uses a parameter that refers to the value in Combo1 (e.g. [Forms]![FormName]![Combo1]). In Combo2 AfterUpdate, requery Combo1 and the form itself...

I want to send an automatic eMail notice based on a value entered in a form. I'm using the SendObject method to send the message and everything works fine as long as Outlook is open. If Outlook is closed, the event opens Outlook (good), but stops at the Outlook Choose Profile box which requires...

Did you use the wizard to create the Crosstab? The wizard automatically places months ("Jan", "Feb", "Mar"...) in the Query Properties-Column Headings box. This presets what columns are shown and determines their order in the query output. And, it sums values of...