Search results

  1. V

    help!!!!!! ..form

    Hi everyone, Some of you may have seen the problem already. To make the questions more clearly, I have attached the db file. Basically, in this database, I have three tables. Maintable includes several fields, such as ID (primary key), Name, Date, [Sent To 1], [Other Sent To], [Purpose]...
  2. V

    create a form

    Hi, Does anyone know how to create a form which let the user input some search criteria and the results will be listed in the same form by using the Docmd.RunSQl() instead of requery()? How is it done to have multiple records display? The form is similar to the following: Input Name: Date From...
  3. V

    vba for form

    Hi, Does anyone know how to create a form which let the user input some search criteria and the results will be listed in the same form by using the Docmd.RunSQl() instead of requery()? How is it done to have multiple records display? The form is similar to the following: Input Name: Date From...
  4. V

    VBA in Forms and Combo box

    Hi everyone, Some of you may have seen the problem already. To make the questions more clearly, I have attached the db file. Basically, in this database, I have three tables. Maintable includes several fields, such as ID (primary key), Name, Date, [Sent To 1], [Other Sent To], [Purpose]...
  5. V

    question about the form

    Thanks for your help, Brian. I appreciate it. The acNewRecord exists in form_open() and open_form_click(). I have the same problem when I deleted the acNewRecord in the open_form_click(). Actually I have got an empty record as well as the record which has the ID. I put the sample database as...
  6. V

    question about the form

    Thanks, Brian. The Searchform is a seperated form from entryform. I have move the flag = statement before the openForm in the searchform (I assume this is what you mean), however, I still get the same problem. It is an empty record when I click the ID of one of the results.
  7. V

    compare differnt data types

    Thanks for your help, Wayne. However, I still didn't get how this works with my search query. The search query that I have is select Maintable.ID, Maintable.Name, Maintable.Date, Maintable.Topic1, Maintable.OtherTopic from Maintable where MainTable.OtherTopic like "'" & forms!search_form![Input...
  8. V

    compare differnt data types

    Can you give me an example? I have tried that, it didn't work out.
  9. V

    compare differnt data types

    NO. There are only Id and topic name in TopicTable. The topic id is hidden to the users. In addition, the input for search criteria is a textfield. I think that the users have to search on the topic name in the topictable. Also, Docmd.requery() is used in the VB code. All comparison are in...
  10. V

    compare differnt data types

    Yes. I didn't find a way which uses only one textbox to solve the problem yet.
  11. V

    question about the form

    That is one of the requirements. Each record contains many detailed information and it is impossible to show all of the information in the searchForm. Hence, in the searchForm, only ID, Name, etc. main fields are showned.
  12. V

    compare differnt data types

    Hi, I have trouble in comparing the two different data types. Suppose I created a database for student essay topics. I have one form called SearchForm to retrieve the data from a table called MainTable. This table includes Id(index), Date, Student_Name, Topic1, OtherTopic, etc. I also have...
  13. V

    question about the form

    Hi, I have a question when I set flag for the form. I have two forms: one is called Entryform and the other is called SearchForm. The Entryform shows all the records in the table Maintable; this form is set to an empty record when the form is open. The SearchForm retrieves the records which...
View older results
Back
Top Bottom