Search results for query: *

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

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

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

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

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

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

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

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

Hi all, I'm struggling with the sortable feature applies to my listbox. I have a search form to filter unbound text boxes then populated the result into a listbox: unbound text boxes: txtName,txtCity, txtState unbound listbox: lboCustInfo The code for searching work nicely. Dim strSQL As...

Hi all, I would like to modify my code to have a pop-up message saying "No record found" if the text enter unmatch record in database. Thanks in advance. Private Sub ReportNum_AfterUpdate() DoCmd.OpenForm "frmAllReports", , , "[ReportNum] = '" & Me.ReportNum & "'" DoCmd.Close acForm...

Hi all, I've having this problem and spending days to catch the error, never figure out what wrong however. I have a form to enter data, a form to search, and a form to generate reports. Everything work just fine until I added a new combo box named cboDips (record source is from a new table)...

Hi all, I'm looking for help with how to make an Access database up and work on a web page which is developed from Front Page HTML. The access database is simply for input data, search existing and generate reports. Does it cause me any problem if I just have a link to Access file? What if...

Hi all, I'm trying to build a search function base on text fields with options of all words, any word, or exact match. I searched in this forum but I have no luck yet. Could someone please give me some help please? GelC

Urgent help please! I'm in MS Access application. When I hit F1 for help, I can't type in English characters but weird characters, look like Chinese. What can I do to change it back to default as English characters. Thank you GelC

I have a form to browse all records Record Source: qryAllRecords Order By : year I added a sorting field based on "month" (this is a text field) It never give me an order of Month (January, February, March and so on ). Hope someone can help me. GelC

Hi guys, How can I disable close button on message box? I tried this but it didn't work, Thanks for any help MsgBox "No result found. Please try again", vbInformation, "No record found" CloseButton(vbIformation) = False GelC

Hi all, I have a search form base on combo box, when click Search, it should give me all records which match "Type" in my table. I'm not sure what to do. Thanks for any help Private Sub cmdSearch_Click() If Me.cbType.Value = "(All)" Then DoCmd.OpenForm "frmAllRecord" Else DoCmd.OpenForm...

Hi all, I'm hoping to get some help on this question I would like to change a field name in my table, how can I update it in forms, reports, and VBA contain this field? Thanks for any help GelC