Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GelC
  • Order by date
  1. GelC

    Format month number as text

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

    Format month number as text

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

    Format month number as text

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

    Navigation Buttons

    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!
  5. GelC

    Navigation Buttons

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

    Create form with MS Office 2003 - Standard

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

    Reset button won't work if no returned records

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

    Run time error: '2501'

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

    Run time error: '2501'

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

    Sorting continuous form

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

    Sorting continuous form

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

    MS Word 2003 - Page Setup - Margins

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

    MS Word 2003 - Page Setup - Margins

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

    Wildcard Search in multiple fields

    Work likes a charm. Thank you! dhookom.
  15. GelC

    Wildcard Search in multiple fields

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

    Print results after search

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

    Print results after search

    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 =...
  18. GelC

    Select value multiple times

    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?
  19. GelC

    Select value multiple times

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

    Add sortable column headings to listbox

    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

Part and Inventory Search

Back
Top