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.
---------------------------...
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...
...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...
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/
...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...
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...
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...
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/
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/
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...
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...
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...
...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 &...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.