Search results

Hi I have a option group with 6 command buttons. The trouble is when you select a button, the button stays selected, so if you want to select it again you have to select another butoon then go back to it (hope this makes sence!). Is ther a way to re-set the button so it returns to un-selected...

Hi I am running a sql statement which looks at dblProdID as a value, am I missing something as sql is not working! "WHERE tblProduct.ProductIDNumber = & dblProdID & "

Hi I am using the code below to supply the record source to a form. Unfortuantly the sql is not working! Can anyone help! Dim strNewRecord As String Dim strSupplier As String If IsNull(Me.cboSupplier.Value) Then strSupplier = " Like '*' " Else...

Hi I have code which opens a query and exports the data to a file. How can I get the code to update a field in the query to a specified value, for each line of data which has been exported. This value would be used to filter future data. Thanks in advance..........

I have a list box on a form. What I want to do is get the value of one field in the first line of data in the list box. Can anyone advise! Thanks in advance..............

I us a form with combo box to filter the data for a report, when I run this the report appears behind the form. Can this be fixed so the report appears in front of the form! Thanks in advance.........

Hi Is there code which identifies if a particular form is open. Thanks in advance............

Hi Two questions! 1. Can you open a form on a specified part of the screen! I have up to four forms that can open at the same time . 2. Can you make a form stay in front of another form, I want a specified form to stay in the backgound and others to be promonent. Hope this makes sense...

Hi I have data in a table: 1234 6987 664 663 65 89 Does anyone no how I can update the numbers so they are 5 figures using a 0. ie: 01234 00664 00065 Thanks in advance!

Hi I have a report which has a sub report attached in the Report Footer section of the report, is it possible to prevent the sub report from being activated! Can the Report Footer section of the form be de-activated! Basicly I want to be able to produce a report with or with out the sub...

Code to select items in list box Have found some code, for anyone interested: Dim lngSelection As Long For lngSelection = 0 To Me!lstData.ListCount - 1 Me!lstData.Selected(lngSelection) = True Next lngSelection

Hi Is it possible to automatic select all the data shown in a list box instead of clicking on all of the data!

Instead of purchasing versions of Access for about six machines in the office I work in I have been looking at the company purchasing Visual Tools for Microsoft Office so I can us the Developer Extensions. From what I can make out this is a add on to Visual Studio.net, am I correct! Has anyone...

I am currently using a sql update statement to append data form other tables and text box's on a form to a central table. I am finding using this option a bit restrictive. Has anyone any ideas on how I could do this another way! Thanks in advance..............

I have a sql statement to update a table, the sql string is called strSQl as below: strSQL = "INSERT INTO tblQuote etc etc" Is it possibel to identify if there is a value returned, as if there isn't I would like to record the fact in the table!

I have a unbound form with a list box and text box's. I select a item from the list box and input data in the text box's then run some code to update a table using the selected items. I us a combo box on the form to filter down the items in the list box. The problem, when I run through the...

I have a field which contains data like: DRAKES GRAPEFRUIT NAT JUIC How can I remove the DRAKES from the data so I am left with: GRAPEFRUIT NAT JUIC Thanks in advance.........

Hi I have a field which contains a data string like: SO - 119 - 3532 - £67.00 Amended New (oc:Mrs Sarah Haines) or SO - 125 - - £32.00 (oc:Mrs Lynn Carter) What I need to do is identify the £67.00/£32.00 part of the strings. Can anyone help.

Thanks "raskew" this has been a great help!

I have a list box on a form, I want to us the value in the list box, but to get this to work I have to select the value, there is only ever one value showing (I have used a list box as its rowsource is referenced to a query) , how can I make it that I don't have to do this!