Search results for query: *

Hello I'm looking to pull RPI data from: http://www.statistics.gov.uk/StatBase/tsdataset.asp?vlnk=229&More=N&All=Y which displays the complete table, however the link above is not a direct link and if entered in explorer it displays the starting page and you have to click the "display all...

I would like to click on different parts of a picture to perform an action, such as display another from or msg box. I have looked at using transparent rectangular labels, but the areas that need to be detected are not rectangular. So I guess I need to use the x, y coordinates and check they...

I am not familiar with the treeview control and was wondering if it is possible to display linked data from tables using a root item for the data in the first table, then a child for the data related to this root from the second table and then another child to display data from the third table...

I am displaying a recordset using the data repeater control; I have created an ActiveX Control that has various text boxes and one Check box. The Text boxes display fine, but the Check box does not display any info from the recordset, the code I am using is: Public Property Get...

I have two forms that I use to input data into a ms access databse. Both the forms put in one record e.g. some info is entered in the first form, then you click next, enter info in the second form, clcik OK and all the info is entered into one record. What I would like to do is do this a...

I have been using the sql below to select the DocNo field from table A and the maximum RevNo for this DocNo from table B. This sql was posted by Golom in a previous thread701-626707 Select A.DocNo, MAX(B.RevNo) As [Max Revision] From Docs As A INNER JOIN Revisions As B ON A.DocNo = B.DocNo...

Is it possible to use Application.FollowHyperlink to open a document in visual basic just like in access? If not is there another method with out specifying with program will open it? Thank You.

Is it possible to stop the re-sizing of certain column headers in a list view. I would like to set some headers width to 0 (not visible) so that I can store info here that I dont want the user to see? OR is there a better method that this to make columns invisible to the user? Thanks in advance.

Is it possible to update all fields in a record set in lower case (lcase). I am using a class to get the recordset and the update event is as follows: Public Sub Update() With adoPrimaryRS .UpdateBatch adAffectAll If .EditMode = adEditAdd Then MoveLast End If End With End...

Is it possible to have a Multi column list box - similar to the list box used in ms access. Is it also possible to add pictures to the list box - I am looking for something similar to the mail list in outlook e.g. where to, from, subject etc is displayed. Thank You

Is it possible to retrieve e-mail information from outlook, such as to, from, e-mail body, time date etc into a visual basic form? How would this be done? Any comment or ideas appreciated Thank you

I have been used to using the combo box in ms access but have recently started designing a front end to a access db in vb In my access form I had a combo box with the row source set to "Names" in table "Contacts", in the after update event of the combo box I used Dlookup to...

Hi, I'm trying trying to display subdata in a datagrid. e.g in access I have the tables Authors and Books (a one to many relationship which is linked by the field AuthorID) What I would like to do is display on the same form, the author details using text boxes (I have this part working) and...

Is it possible to change the text in a text box to strike through text by clicking on a command button? What sort of code would this require? Cheers

Is it possible to use vb to connect to a access 2000 database that has jet security (.mdw) by specifying where the mdw file is and a user name and password all in code? Thanks in advance.

Hi, I'm looking for some basic info on connecting to a access 2000 database through code and navigating, adding, deleting records. I have the basic idea that I need Jet 4.0 as the provider and the connection below, Dim db As Connection Set db = New Connection db.Open...

I am thinking about converting a access database into a access database and a vb front end. My original database uses a few 'sub' continuous forms, i.e. I have two tables with a one to many relationship, in access I would display this with a main form showing the primary info and a sub...

Is it possible to develop a vb front end and a access database as a backend and then distribute the application to users who do not have ms access? I do not have the developer edition of access but have vb. Any thoughts on vb project or access database are welcome cheers

I have a form where data is entered and updated - on this form I have a cmb which prints a report for the current record using the docmd.openreport method. The problem I am having is that when new data has been added to the form and the print button is clicked, the report will print off but not...

Is it possible to display records horizontal in report footer. I have a table which is used as a key to numbers on the report and I would like to display this horizontally across the bottom of the report. The table is TblKey and the fields are KeyNo and KeyName, I would like it to display...