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

    Word Art

    I have inserted some WordArt on a web-page and it generates some HTML code which refers to the following src: src="tariffs6_files/image001.gif" everytime I save the page it generates another version of this source. However the Word Art doesnt display in Preview mode on the web. What have I...
  2. willsth

    Wide Screen problem

    I have designed a form using a normal screen size and when I try and display the form on a wider screen I lose the formats for certain fields. Not sure why this is occurring.
  3. willsth

    Cursor Control

    I have a Main-Form with 2 sub-forms and I am using the sub-forms for data entry. The problem I have is that when the user completes an entry on the sub-form the cursor moves back to the Main-Form and I want it to move to a new record on the appropriate sub-form. How do I achieve this ??
  4. willsth

    Syntax for opening form

    When I open my form it displays as another window. I want it to appear as another TAB from my previous window. How do I do it ??
  5. willsth

    Colours in View Only

    I have created a Form with a number of fields on it the majority of which are VIEW only. These fields are shown in a very light grey colour which makes them difficult to see. How do I change either the Foreground colour or Background colour of a field which is set to Enabled "No".
  6. willsth

    Errors on running Macros

    I'm not being allowed to run macros with the SET VALUE command because of the following [CurrentProject].[IsTrusted] And Not ................ I believe I have set my Database to trusted, how do I check it. All my other VB code seems to work OK. PS I'm using Access 2007
  7. willsth

    Syntax for Requery

    I am trying to requery a total field which is on my Main Form, when I update a field on my sub-form. My code is .... Me.Total Billables.Requery however [Total Billables] is not in my sub-form. How do I reference it ???
  8. willsth

    Rounding Macro

    I am using the following bit of code which I picked up from a forum and it works fine except were I present it with an amount of 13.00 or 14.00 basically anything with 00 after the decimal point. Any clues how to get rid of the error !! Public Function RoundAdv(ByVal dVal As Double, Optional...
  9. willsth

    DLookup alternative

    I have performance issues with my Access 2007 database running over a network with the FE and BE split. I have looked at various posts and I am implementing various suggestions. One of the problems highlighted is using DLookup. Does anyone have a procedure to use instead of DLookup ??
  10. willsth

    Rounding Issues

    I am trying to round-up a result field, it seems to round-down when I use the Round function
  11. willsth

    Forms - View only

    I want two versions of the same form. First one allows updates the second one is view only. Is there a quick way of doing this ??
  12. willsth

    Conditional formatting on Reports

    Is it possible to do conditional formatting on a Label within a report, I know I get the option on the Control Source but what about the label attached to it
  13. willsth

    Updating another record based on a current record

    I have a form called "Project Details" and I am trying to link two records in the same table together. The Table is "Projects". My records contain the following data:- ID Project Name (Numeric field) LinkJob (Numeric Field) etc.... Say I have 5 records in my file with Project Names -...

Part and Inventory Search

Back
Top