Recent content by JJ

I'd like to create a form that automatically opens Outlook Express and inserts the email address when I double-click on that particular email address. Any suggestions on how to accomplish this? Thanks.

I'd like to use a toggle button to enter start and stop times. The first value is "Start Clock" and when clicked enters the current date and time and toggles to "Stop Clock", which also enters the current date and time when clicked. Can anybody help with the code for this?

I have a subform that I want to sort in descending order by the date. I can accomplish this just fine in the subform. However, when I open the main form, for some reason the subform loses its sort order and defaults to ascending. How do I make the subform maintain the sort order when it's...

I have a subform that I want to sort in descending order by the date. I can accomplish this just fine in the subform. However, when I open the main form, for some reason the subform loses its sort order and defaults to ascending. How do I make the subform maintain the sort order when it's...

Would I accomplish this through a applyfilter macro? Something like: Subform!ClientID = Sub-subform!ClientID

This is kinda confusing, so forgive me. I've got a form (1st level) with a subform (2nd level) with a combo box. The combo box determines which record appears in the subform (2nd level). This subform (2nd level) also has a subform (3rd level), which shows the sub-subform (3rd level) records...

I've got a form that opens a subform showing related information based on [ClientID]. What I would like to have happen is the subform have a combo box that displays all the values of [CaseID] for matching [ClientID] records. I would then use the combo box to go to the specific [CaseID] record...

Can anyone point out my problem here? I'm using this procedure to open a new form and go to the record with the same value as the one I've clicked. It opens the new form, but doesn't go to the record, just opens blank. Thanks. Dim stDocName As String Dim stLinkCriteria As String...

I know I can create a hyperlink to a specific form in my database, but can I hyperlink to the value of the specific record that is the hyperlink? For example, in Form 1, I click on the hyperlink "1234". How do I have the hyperlink open Form 2 and automatically show record "1234"?

I know the general rule is to not save calculated fields, but in this case I am trying to calculate a unique identifier built from the first letter of [First Name], the first letter of [Last Name], and an autonumber [Client Number]. Thus, the form automatically creates a unique client number...