Recent content by GelC

Thanks Duane! Great!!! I didn't see your solution while I made I own post.

I know the date showing wasn't real date. If I do this Control Source: =[Month] & " " & [Year] Then the real date is showed as 11 2008, 5 2005, etc... How can I make it shown as November 2008, May 2005 instead. Thanks! Gelc

Hi all, I stored month as number and wanted to display it as text. I have a text box called "MonthYear" on form and report to display month (as text) and year. Here is my format: =Format([Month],"mmmm" & " " & [Year]) My problem is the month show "January" for most records (I have over 600...

It's okay to me as long as the mods are okay with it. I just modify my code per dhookom for now. Thanks guys!

Hi all, I need help with a custom navigation buttons. When I go to the very first or very last record, there is a pop-up message "You can't go to the specific record." How can I make it not showing anymore. Below is the code. Thank you in advanced. Private Sub cmdNextRecord_Click() On Error...

Hi all, I'm using MS Office Standard Edition 2003. Am I able to create a form to be fill-in by users or not? I tried... My form is dead, can't check off on check box, can't see dropdown button, the only one make me happy is text box. Help please!!! Thanks Chelsea

I have a button to reset my form after filtering. If there is at least a record in result, then reset form...it works perfectly. However, if the result returns no record, it seems doing the job in the back but the text I enter in the form is staying there still. How come it doesn't work...

Is there anything wrong in the following code? Private Sub cmdEditLink_Click() 'Opens hyperlink dialog On Error GoTo ErrEditHyper Me.ViewDoc.SetFocus DoCmd.RunCommand acCmdEditHyperlink Exit Sub ErrEditHyper: Select Case Err Case 2046 'Edit Hyperlink not available...

I have a button to run command edit hyperlink. When I click "Cancel", I keep getting... Run-time error '2501': The RunCommand was canceled. How can I get rid of it? Thanks for any help! GelC

PHV, You are my survivor always. :-) Many thanks!!!

Hi all! I have a search form with continuous returned results. Now, I desire to add options for sorting the results. Form record source: tblAllRes Private Sub cmdSearch_Click() Dim strWhere As String Dim lngLen As Long Dim strOrderBy As String If Not IsNull(Me.txtKeywords) Then...

I got it setting back to default. Please close this thread.

It's not normal when I open a new document. Portrait Orientation: - Top: 1" - Bottom: 1" - Left: 1" - Right: 1.38" Landscape - Top: 1" - Bottom: 1.38" - Left: 1" - Right: 1" Please help me to get it back to normal 1" for each margins. Thanks! Gelc

Work likes a charm. Thank you! dhookom.

I have a command button to perform record filter attached to the following code Private Sub cmdSearch_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.txtSongNumber) Then strWhere = strWhere & "([SongNumber] = Like ""*" & Me.txtSongNumber & "*"") AND " End If...