Search results for query: *

Is it possible to hide columns in a datagrid ?

How do I set the addNewMode property for a datagrid ?

Hello. I'm new to VB and have just used the Data Form Wizard to create a Master/Detail view of my Access DB. Using the wizard I choose to include a button to add new records, however this only seems to allow records to be add to the master datagrid and not the detail/child datagrid. I could...

Hello. On a form I have 2 combo boxes (the first controls the values of the second) and a subform with a combo box on that form. When selecting values using these combo boxes, all seems to work fine, however when I return to the first record and then move through each record in turn, the...

Hello. I'm new to VB and have just used the Data Form Wizard to create a Master/Detail view of my Access DB. Using the wizard I choose to include a button to add new records, however this only seems to allow records to be add to the master datagrid and not the detail/child datagrid. I could...

is it possible to add a new records to two related tables using a datagrid (or some other) control ? if so, how ? thanks. j.

I have a SQL "music collection" DB. I have two tables Artist and Album. I want to add records to this using VB. How do I do this ? I can display the records using the Datagrid control. I've added a new record using this control, to the two tables which works fine but the records...

Hello. I'm using an Evaluation Edition of Visual Basic 6, which I got with a book. The book talks about using the Data Form Wizard but I don't appear to have it (along with Class Builder Utility, Data Object Wizard, Proporty Page Wizard, API Viewer etc). Is it possible to download these from...

Hello. I have a SQL Server 2000 DB. A field in a table allows "Nulls" but has no default value. Using VB 6.0, I've written a procedure to add records to the table. Question. How do I pass a Null 'value' to SQL Server ? Do I have to set a default value for the field of 'Null' ? If...

How can I get a list of all the links to external data sources in my Excel workbook ? Menus or VBA, it doesn't matter) Thanks. J.

I am currently working on a system of displaying visually,the progress of various projects. I'm doing this by displaying a picture of a traffic light; the red light illuminated to show the project is behind schedule, amber to show the project is running according to plan and the green light to...

Hello. VBA in Excel 2000. How do I determine the first/last row/column of a selection ? Thanks. J.

Hello All. I have a "shape" on an Excel worksheet. I need to select this object and copy it within the same workbook but to a different sheet. If I copy this object into cell A3 for example, I need the top left corner of the image to align exactly within the top left corner of the...