Recent content by pcgenie

Ok, I got the filter to work. Now I need to get the syntax right for the "sort order". Any suggestions?Private Sub btnSetFilter_Click() On Error GoTo Whoops Dim strSelect As String, strFrom As String Dim strSQL As String, strWhere As String Dim strOrderBy As String Dim intCounter As...

Good question. I should post the entire code for the filter. Code: -------------------------------------------------------------------------------- Private Sub btnSetFilter_Click() On Error Resume Next Dim strSelect As String, strFrom As String Dim strSQL As String, strWhere As String Dim...

Can someone help me to get the syntax correct? The global variable gstrDate is a string which can be either "[DueDate]" or "[Actual Completion Date]". Code: -------------------------------------------------------------------------------- strSQL = gstrDate & " Between #" & Me.BeginningDate &...

I have code on a subform that is referencing another form that is still open (not the parent form, but the main form that has the opening button on it). I'm trying to get the value from a combobox on the main form that contains the data that will filter the subform in question. The error that I...

I have a form "frmMAINEntry" with a tabcontrol with several pages. The form's Record Source is a query "qryMainData"; however, on two of the pages there's a difference. On the page "Program List" I have a listbox that has a Row Source to table "tsubProgramList" and on the page "Program Details"...

Thank you PHV, TheAceMan1, and RoyVidar. I appreciate you effort in suggesting some solutions. I think all of them have merits that I can use in this and future applications. Gratefully, PC Genie

I have a database audit form module that takes a few seconds to search through a linked table and then insert the information into the main db table. I've seen a lot of newsgroup discussions on progress bars and I have a few examples, but they either use a timer or counting records. I'll...

I tried making the changes you recommended and I can't seem to get the module to work right. Please verify that I'm doing it correctly. I changed "Private Const CF_TEXT = 1" to "Private Const CF_RTFTEXT=&HFFFFBF01&" and changed "hClipMemory = GetClipboardData(CF_TEXT)" to "hClipMemory =...

I found a rich text spellcheck module that uses MS Word's spellcheck. It goes in and out of Word and deposits the results back in the richtext field; however, the results are deposited in plain unformatted text. If you look at the code, could you tell me how I can get this to leave the...

>ZmrAbdulla (TechnicalUser) said: "I have no problem on editing and formating the RTF." I'm not likely to change to another richtext control soon, but could you share some of your information about richtext editing? I would like a "Find" function to highlight all occurances of the word that...

My employer's IT Unit won't approve its use and I can't install it because IT Security blocks all unauthorized installations.

I have a prototype that involves rich text, if you would like to take a look. It contains 4 tabs on a tabcontrol and each tab has a rich text field. Enter data in any of the rich text fields and click the save icon. Then with the cursor in one of the rich text fields, do a right click and what...

I have an alternate solution that involves rich text, if you would like to take a look. It contains 4 tabs on a tabcontrol and each tab has a rich text field. Enter data in any of the rich text fields and click the save icon. Then with the cursor in one of the rich text fields, do a right click...

Thank you, CajunCenturion I'm not a proficient programmer. If you are able to download my test db, you'll see that I've transferred the value from the popup menu to a unbound field on the main form. Is there a way that I can use the value from that field or do I have to use some other...

I'm creating a shortcut menu to popup over my richtext box. Its a form with a listbox of menu items with associated richtext activex (rtf) editing commands. I found a way to transfer a value from the popup menu to the form, but now I have one more step to take. The value being transferred is a...