Search results for query: *

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?

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?

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

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?

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

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

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

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?

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.

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!

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

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

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

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.

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?

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

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

After several more testing I think 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...

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

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