Search results for query: *

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

I should have said that I want a print button to print the returned results. How do I implement this function? Could anybody help? Thanks.

Hi all, I have this code to perform my search. I have a print button to print the results after searching. Could someone please help? Thanks in advanced. Private Sub cmdSearch_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.txtSongNumber) Then strWhere =...

It sounds complicate to me. So the add button function must be build with coding behind it, correct. It doesn't seem to be easy to me at all. Could you give me more hints?

Hi all, I'm thinking of doing this but not sure if it's doable in MS Access. I want to have a box where I can pick up name multiple times from a author table and store the value in author field in tblsongs. For example, I want to enter a song that was composed by two authors, so I want to pick...

Thanks guys for helping out. So sorry cuz I was so busy over the weekend with my holidays list (smile :) I tried both of your suggestions/solutions, work perfectly. I must give each of you five stars. I can't imaging life is that simple with help and sharing. Thank you very much