Search results for query: *

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?

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?

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

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

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

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

Hi all, I want to make my own buttons in msgbox. I believe it is possible, the hint is msgbox has a constant "vbDefaultButton4" allows you to set the FOURTH button as default; but among the "given" button setting constants, the constant having most buttons (vbYesNoCancel) has only THREE buttons?

I want my datagrid be able to scroll freely so that any row in it can be the first row. I mean, for example, if the datagrid is 5 rows tall and have 5 records in it, then it cannot scroll at all - because the last (5th) record is forced to stick to the bottom of the grid. And if there are 8...

Hi all, There is a "FirstRow" property in datagrid. According to the documents, by setting this property in a way like " [Datagrid].FirstRow = 5] " the datagrid will roll to a certain row, in this case, 5. But what I get is a run-time error 6149 "Invalid Bookmark"? Is this is a flaw in the...

To set values for the properties of objects in a form, you can either do the property setting in the properites window (design time), or you can write codes such as textbox01.Width = 2000 (run time). I want to know if this will cause big difference to program performance. If there isn't big...

Hi, I have some questions on datagrid. Q1) In datagrid they have .columns(n) for you to refer to a certain column. For example, [some grid].columns(0) let's you refer to the 1st column. But I don't know how to get values from a certain cell. I have tried this: Dim CellThings as string...

Hi all, I have tried using DataCombo for a while and so far it seems to me that it is very similar to normal Combobox, but much weaker? 1) For example, DataCombo does not support many ComboBox's methods such as TopIndex, ListIndex, ListCount; and even worse, no DropDown. Or maybe DataCombo...

Hi all, I have a form which shows information of each product. There is also a DataCombo control - I want it to be a product finder - if the user picks a product code in the list, the program will "jump" to the corresponding record. At first I thought this can be done by setting the source of...

Is it possible to disable the paste function in a control? That is, the user is not allowed to press Ctrl + V, or Shift + Insert, or right click mouse and then choose "Paste" to insert any thing into the control. They can only input by typing.

Hi everyone, I have 2 questions about keyboard events: 1) I want a text box to accept certain input keys only (say, numbers and +- signs only). This can be done easily: in the KeyPress event, use if-then-else cases to check the key input, if it is in the unwelcomed keys list, use the code...

Hello, I have 2 forms, say formX and formY. When formX is loaded, it calls formY to open, and later it closes formY. The code is something like this: formX_Load() formY.show (code...) formY.hide end sub I know that formY is still there (in the memory) after the .hide, the proof is during...

Hi, I am trying to build an ADO command connect to a recordset. This is my code: Public CommandX as New ADODB.Command Public RecordsetX as New ADODB.Recordset Dim SQL as string Set CommandX.ActiveConnection = another_form.ConnectionX ("ConnectionX" is a connection object defined in another...

Hi all, I have a common dialog allowing the user to choose which access database (.mdb) to connect to. After a database file is selected the program will update the current connection by ADO: Set Connecting = New ADODB.Connection Connecting.Provider = "Microsoft.Jet.OLEDB.4.0"...

Hi all, I started learning VB recently. I am now creating a VB form which displays data from an Access database (2000 format). However I am quite confused with the database connection methods provided by VB. According to the books I read, there are at least the following: 1) ADODC 2) ADO...