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!

  • Congratulations bkrike 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: Softop
  • Content: Threads
  • Order by date
  1. Softop

    Line height on report

    I am trying to get a table appearance to a report... I have the lines across but am having difficulty with the uprights. I have a row of text boxes on the detail section of a report that are set to Can Grow = Yes. I want to separate each text box with a line which is the same height as the...
  2. Softop

    Tick Box in a query

    Options for displaying boolean values in a query are True/False, Yes/No, and On/Off. Does anyone know of a way of displaying a tick box instead? Softop
  3. Softop

    Query dependant on dates

    I have two tables as shown below. They are not joined. I wish to create a Query that will select the correct rate from Table 1 at the appropriate date in Table 2. Can anyone help please (supply the SQL for the query)? Table1-Rates EffDate Rate 22/01/2004 2.5 27/02/2004 2.3...
  4. Softop

    Format a textbox in VBA

    I need to format a textbox on a report to italics depending on the result of another field. i.e. If Me.txtVerse = "C" Then Me.txtLine 'format to italics ??????? Else Me.txtLine 'format to normal ??????? End If Any idea how to do this?
  5. Softop

    How to view a Report on my Laptop

    In order to view a report I need to attach my Laptop to a printer (or network with a printer) and switch the printer on. Is this really necessary? I can't do my work on the road if this is the case. How can I overcome this problem?
  6. Softop

    Custom Ordering as with Tab Ordering

    When you right-click on a form and select Tab Order there is a box to change the order of the tabs using drag and drop. I want to do the same thing with a small set of database records. Please can anyone tell me where to find the control (as shown in the Tab Order form) that will allow me to...
  7. Softop

    Is there a way to embed a report in a form

    With the formatting available in a report you can have multiple records of varying length, coupled with the Can Grow/Can Shrink features to display perfectly. Can this be emulated in a window on a form by embedding the report into the form with scroll bars? If so how is it done?
  8. Softop

    TransferDatabase acExport produces code 2501

    Due to a change in versions of Access by Users I am converting existing code from Data Access Objects (DAO) to conform to ActiveX Data Objects (ADO). All is working well except one thing which is twisting my brain. I want to export all tables, a form, a macro and a module to a new database...

Part and Inventory Search

Back
Top