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 Chriss Miller 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: xinyin
  • Order by date
  1. xinyin

    Database problems

    I'm trying to use the data form wizard to create a form to connect to a simple Access 2000 database using VB6 Service Pack 6." Is there really a "data form wizard" in VB6? Could you please tell me how to open it?
  2. xinyin

    Can I use Powerpoint to make screen saver?

    I am a Powerpoint beginner. I want to know if Powerpoint can be used to create screen savers? Or is there any shareware that can change a Powerpoint file into a screen saver?
  3. xinyin

    Excel charts

    Thanks it works. But then I just realize that I can edit the chart directly by clicking it. So I can first enable the line name marker option - this put the name of that line on each turning point of the line, next I can click and press delete on any unwanted marker, finally I will get a line...
  4. xinyin

    Excel charts

    If you use Chart wizard to make line charts, Excel will put a legend at the bottom of the chart to let you identify each line. Can I disable this legend at the bottom and tell Excel to put the name right beside each line instead?
  5. xinyin

    NotInList event does not fire

    Oh, I overlooked this one. Now I set it to Yes and it works. Thanks.
  6. xinyin

    NotInList event does not fire

    I have a combo box which it got its source data from a table. I want it to automatically detact the user input: if the user input something which is not in the list, a msgbox appears telling the user about this. I put the msgbox code in the NotInList event. However, this msgbox does not appear...
  7. xinyin

    Controls Contained in a Picture Box

    Thank you very much to all of you. I learn a lot from your posts.
  8. xinyin

    Controls Contained in a Picture Box

    Do you understand why it doesn't work with the = sign?" Not quite understand... I am still in the primary learning stage of Visual Basic. Would you please tell me the answer?
  9. xinyin

    Controls Contained in a Picture Box

    Yes it works, thanks both of you! I also realize that the tricky part is the "is" in "varCtrl.Container Is Picbox2". If I put it in "varCtrl.Container = Picbox2" it won't work.
  10. xinyin

    how can i change my .exe icon?

    I met the same problem before, here is my thread # (222-1030144). In it there are some links to sites that you can download useful .ico conventions tools. Hope this helps!
  11. xinyin

    Controls Contained in a Picture Box

    I have several picture boxes in a form. Each picture box contains some controls (mostly labels and textboxes). How can I do some operation to those controls in a CERTAIN PICTURE BOX? For example, if I want to change the backcolor of all textboxes in picutebox#2 ONLY. I know the method: Dim...
  12. xinyin

    Why is MSHFlex Grid so popular

    show data hierarchically" - Do you mean it can open a sub-list of each item like Tree View?
  13. xinyin

    Why is MSHFlex Grid so popular

    Hi all, I wonder why it seems like most of you prefer using MSHFlex grid than datagrid? I learn that MSHFlex Grid uses more memory than datagrid - when it starts it copies ALL data from the target recordset; while datagrid only copies some records that are currently required (thus datagrid also...
  14. xinyin

    Create Recordset from another Recordset...

    Thanks I think this method is a possible solution, I will try it. Can you please tell me where I can find "elementary chapters" about it? I search in Google but they only have very "high level" articles, I also tried www.jetsql40.chm as johnwm suggested but this site does not exist now.
  15. xinyin

    Create Recordset from another Recordset...

    If possible I don't want to create a local temp table in Access because my Access database is only used as a container of data. All the operations are done on the VB side. Or is there a way to let ADO to command Access to do this?
  16. xinyin

    Create Recordset from another Recordset...

    Thanks Jerry, "But why dont you use an SQL statement using the WHERE clause to query the table from which the first recordset retrieves records?" This is because I want my program to allow "advanced searching" / "Pyramid shaped searching". For example, if the user is not satisfied with the...
  17. xinyin

    Create Recordset from another Recordset...

    Sorry I post the last reply by accident before I finished. Continues here: ... and if I change arround the syntax to be RsetNew.Open "SELECT [some fields] from '" & RsetMain & "'" then the error becomes "Type mismatch" I wonder if ADO only allows you to create recordset from database tables as...
  18. xinyin

    Create Recordset from another Recordset...

    ...I have figured out what is going wrong: If I creat a recordset from an Access TABLE (tblMain), the ADO syntax is simple - RsetMain.Open "SELECT * FROM tblMain" This works. But next when I try to create a new recordset (RsetNew)from another RECORDSET (RsetMain), the following syntax...
  19. xinyin

    Create Recordset from another Recordset...

    I want to know if this is the right way to create a recordset base on the data from another recordset: I have a recordset (RsetMain), its source is from a table of an Access database (.mdb) - I have no problem in creating this. Now I want to make another recordset (RsetNew) which picks data...
  20. xinyin

    Add blank to BOUND datagrid

    Hi all, Can I add blank rows to a BOUND datagrid by coding? The difficult part is the datagrid is BOUND to an Access table, which one of its field is the PRIMARY KEY (does not allow null values), thus the Access table does not allow datagrid to add blank rows because this will also add records...

Part and Inventory Search

Back
Top