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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by willsth

  1. willsth

    Word Art

    I was using FP2003, I think I've resolved the issue. I've created the WordArt in Publisher and saved it as a GIF then inserted it onto my web-page. Seems to have done the trick. Thanks
  2. 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...
  3. 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.
  4. willsth

    Cursor Control

    You're right I put in a re-query command to refresh totals - I've just removed it and it seems OK Thanks
  5. willsth

    Cursor Control

    Sorry what I meant to say was that I want the cursor to remain within the sub-form that I'm entering data into, just to jump to a new record !!
  6. 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 ??
  7. willsth

    Syntax for opening form

    Its Access 2007 and I've set Options to 'Tabbed Documents'. Some of my forms actually appear as 'tabs' but the one I am opening just displays as a whole screen. For example if I make a selection from my Main Menu it opens up a Form as another Tab, it still retains the Main Menu. I have a...
  8. 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 ??
  9. 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".
  10. willsth

    Errors on running Macros

    Problem solved I had set my Form to Read-only therefore I couldnt access any drop-down options from my form. I have had to rethink my Form Design
  11. willsth

    Errors on running Macros

    Further info:- I've copied some code from a Sample Database which allows you to run various reports from a drop-down combo-box. Although I get the drop-down list I cant get the macro to run. I've also added some code from this Sample Database to allow users to Filter their data. I cant get this...
  12. 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
  13. willsth

    DLookup alternative

    Thanks for your help
  14. willsth

    Syntax for Requery

    Thanks I've sorted it now
  15. willsth

    DLookup alternative

    Yes

Part and Inventory Search

Back
Top