Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Boccle
  • Content: Threads
  • Order by date
  1. Boccle

    Command buttons on sub-form

    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...
  2. Boccle

    Filtering problem

    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...
  3. Boccle

    Adding zeros at start of numbers

    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...
  4. Boccle

    Send to back??

    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...
  5. Boccle

    decimal places in text box

    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...
  6. Boccle

    Help with IIF

    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...
  7. Boccle

    Form_Open Event

    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...
  8. Boccle

    adding a column to query

    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...

Part and Inventory Search

Back
Top