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 Rhinorhino 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: *

  1. chuanwang

    Cross-reference or Field with Microsoft Word!

    Hi all, I am now writing one paper. I want to use reference in this paper. In the contents of this paper, I only want to add the author's information, not all information about this reference. I can describe this following. Here is one paragraph of this paper. ---------------------------...
  2. chuanwang

    Run *.exe in one computer which has not installed Visual Basic with it

    I have one database created by VB and Access. I save this database as *.exe. I am going to use execution file in one computer which has no Visual Basic in it. Then I got some problems. I can not display some forms which contains some tables created by FSFlexGrid. There is one prompt saying...
  3. chuanwang

    Select more items from ListBox to show the table with SQL

    Could someone read this and give me some idea? Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  4. chuanwang

    Select more items from ListBox to show the table with SQL

    I tried, but it does not work. Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  5. chuanwang

    Select more items from ListBox to show the table with SQL

    Does anyone know this? Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  6. chuanwang

    Select more items from ListBox to show the table with SQL

    ...If Right(WhereClause, 3) = "OR " Then WhereClause = Left(WhereClause, (Len(WhereClause) - 3)) End If mySQL = "SELECT * FROM tblResults WHERE (Field1 = WhereClause)" Data1.RecordSource = mySQL Data1.Refresh End Sub ----- Could someone help me to check...
  7. chuanwang

    Select two more items in one Combobox and use SQL to display the table

    Sorry I do not understand exactly what your code mean! What does it mean 'DLL01' and 'BRS01', can you give me detail explain. thanks Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  8. chuanwang

    Select two more items in one Combobox and use SQL to display the table

    ...more item or criteria in one text-box, then use SQL to display the table metioned above, it is also OK. use some codes like: mySQL = "SELECT * FROM tblResults WHERE ((tblResults.field1) like '" & Text1.Text " But it only cover one item. How about two, three more item. I hope...
  9. chuanwang

    Select more options in one field then display the table and SOL

    I looked through the website above, but I did not find UNION operator. I do think that the key solution to this quesion is question is how to set two more criteria or option to one same field, and how to express it in textbox or combo-box, or how to link the different table together. By the...
  10. chuanwang

    Link Access database to one form in VB

    Thanks for your suggestions. I know how to use the Common dialog box to open one file, but I do not know what you mean for Command of DAO. Also I post this questin because that I think there is aonther way like what I mentioned can directly open some table in Access. Thanks a lot! Chuan Wang...
  11. chuanwang

    Select more options in one field then display the table and SOL

    Sunaj, can you explain it in detail. This question is quite difficult for me, I have spent a lot of time on it. But still I do not know how to solve it. Thanks Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  12. chuanwang

    Select more options in one field then display the table and SOL

    And also if you can make two tables(with same fields) added together, it can realize this goal. But how? Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  13. chuanwang

    Inactivate OptionButton and CheckBox

    Hi CajunCenturion, Very happy to hear you again. Could you look at thread222-331995 and thread222-332708 again. I do believe that you can solve this problem because that you are familiar with my case. Thanks again! Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage...
  14. chuanwang

    Select more options in one field then display the table and SOL

    mattKnight, No, it did not get answered in Thread222-331995. Because what I want is not only two options, it is more than two options, you can select whatever how many options in Field1 you like, then you can display the talbe. Maybe I can make it clear like this: when you select A1 in Field1...
  15. chuanwang

    Setting column width of a database grid.

    Thanks Scstand. It works this time. Chuan Wang Royal Institute of Technology Stockholm, Sweden Homepage: http://chuanwang.tripod.com/
  16. chuanwang

    Inactivate OptionButton and CheckBox

    Does anyone know how to inactivate OptionButton? The problem is when I select one option it can work, for example it can go to another form, but when I come back to the orginal form, this optionbutton is still selected, when you click it, nothing happened, you can not inactivate it. It bother me...
  17. chuanwang

    Select more options in one field then display the table and SOL

    ...selcet B2 in Field2, then press the commond button to get the table results. ------------------------------------------------- mySQL = "SELECT * FROM tblResults WHERE ((tblResults.field1) like '" & Combo1.Text & "*' And (tblResults .field2) like '" & Combo2.Text &...
  18. chuanwang

    Link Access database to one form in VB

    I am going to link one database in Microsoft Access to one form in VB. What I want is when click one button (like,Show Access Database)on one form, this database or file can be opened, then I can read some tables and other things created in Access. Does anyone knoe how to realize this goal...
  19. chuanwang

    Setting column width of a database grid.

    Thanks for your reply. I tried, but when run it, it does not work. There is one prompt like this ------ Complie error: Method or data member not found ------ and in my code I used the following ---- MSFlexGrid1.Columns(1).Width = 1000 ---- Because I used MSFlexGrid not DBGrid. Another...
  20. chuanwang

    Setting column width of a database grid.

    I have the same problem as Djmc's. I tried the code given by CCLINT, but it does not work. Could someone tell me how to set the column width individually so that all the values are viewable. Where I must put these code? I put the above code into one command button named Show Table, is it...

Part and Inventory Search

Back
Top