Recent content by Hawkster

Thanks alot Theologian, with a little modification to display the list below the selected cell it works a treat. List1.Top = DataGrid1.RowTop(DataGrid1.Row) + 500 List1.Left = DataGrid1.Columns(ColIndex).Left + 140

I have a datagrid and have a button set in one of the columns. I assume I have to add a listbox to my form and populate it with the data I want. No problem there. My problem is this. How do I determine the location at which to show the listbox ?? as this will change depending on which row...

I’m trying to use a DataGrid that has 6 columns, all 6 columns are populated from a recordset, the first 3 contain non editable data and the last 3 are blanks for the user to fill in with data. My problem is that I don’t wont this DataGrid to be still connected to the backend database, I mearly...

Thanks alot RobS23 that’s exactly what I was looking for.

Nice idea but I want the user to be able to type into the combo box and the Text result to be built up as the user goes along. Much like the combo boxes work in Access.

As you can tell I'm not sure as to the correct phrase for this but what I'm trying to accomplish is that when a user types into a combo box the text is filled in with the most likely result in the list and have the curser remain in the same position in the string i.e. List ---- ABC123 ACD321...

Rick, I've fixed this problem by running sp_defaultdb and setting the default database for the login name. Found this browsing through microsoft help files. Not sure what this stored procedure does tho, but it worked.

I've written a little application using a VB front end connecting to a SQL Server 7 Backend. Obviously I can connect to it and I've managed to installed the application on a different users computer but when I've tried running the application of various other users computers I get an error...

After a lil playin i've managed to cume up with a solution. '*** This line controls the data for any given object '*** .section(?) refers to the section on the report '*** .Item(?) refers to the item within that section Me.Sections(1).Controls.Item(1).Caption = "1234&quot...

How do I access the properties of say a textbox on a data report from within a form before I show it ? For a form its very easy... i.e. frmTest.Label3.Caption = "1234" But the above doesn't work on report objects ??? What am I doing wrong.