Search results for query: *

Hi, I am having problems getting a command button to work. I have inserted a 'print current record' button using the wizard. However, the button prints ALL records. I have used this button before and it worked fine. This time I am trying to put this button on a sub-form. Could this be what...

Hi, I have a form (frmSearch) based on a table (tblBooks) that displays the Title and Author (in text boxes) of books in a library. I have added a command button 'Search Title' with the following code attached to the Click event: Private Sub cmdSearchTitle -Click() Dim frm As Form...

Hi, I have aproblem with a field in one of my tables. The field is called LibraryNumber. The problem is that when I put and A-Z sort on the field the numbers are not in the order I'd like them to be, for example: 1 12 13 134 20 22 255 3 35 As you can see they are not 'really' in numerical...

Thanks :) Knew it would be simple and easy!

Hi, I have a couple of filled in rectangles and a filled in text box on my form. They overlap each other. The text box is currently partly covered by one of the rectangles. Is there a way to send a rectangle to the back or send a text box to the front???? I'm sure the answer to this question...

Ummm...afraid that doesn't seem to work. Don't suppose you have any opther ideas????

Hi, I'm having a bit of a problem with displaying only two decimal places in a text box on one of my forms. This should be quite simple, but it just doesn't seem to want to work! The text box takes its value from a field in a query. I would like the text box to display its numeric value to 2...

Thanks........that works fine :)

Hi All, I am having a problem with a query. I have a query that selects the following fields: 'WASTE_PROD' 'WASTE_CODE' from a table 'tblWasteData'. This query also creates a new field called 'WASTE_PROD2'. The values for 'WASTE_PROD2' are equal to the values in field 'WWASTE_PROD' WHERE...

Nope that doesn't appear to work. Any other ideas??????

Hi There, I hope someone can help with the following problem.... I have the following code attached to the open event of a form: Private Sub Form_Open (Cancel As Integer) If Me!txtWasteProd = 0 Then MsgBox "The answer is 0." Cancel = True Else End If End Sub This works...

Horay it works! Thanks :)

Ummm...I'm afraid that doesn't seem to work. I get a message saying "The expression is typed incorrectly or is too complex to be evaluated. For example, a numeric expresssion may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to...

Hi Everyone, I'm relatively new to Access 2000 and have been struggling with this one for a while. I have a table tblWasteData with the following fields: INDUSTRY_CODE WASTE_CODE WASTE_PROD I have a query that currently picks out records from tblWasteData where INDUSTRY_CODE matches data in...