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 derfloh 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: *

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

    Syntax for Requery

    Thanks for that seems to be sorted now !!
  17. 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 ???
  18. willsth

    DLookup alternative

    I have created a persistent connection and that has improved things, and I'm looking if its really necessary to use DLookUp. I'm using the following bit of code :- =DLookUp("[Total Billables]","Projects Extended","[ProjectID]=" & Nz([ID],0)) How would your code look instead ??
  19. willsth

    Rounding Macro

    Thanks seems to have resolved the issue
  20. willsth

    Rounding Macro

    ...= Mid$(DecimalPart, 1, iPrecision + 1) Case "5", "6", "7", "8", "9" RoundUpValue = 0.1 For i = 1 To iPrecision - 1 RoundUpValue = RoundUpValue * 0.1 Next DecimalPart = CStr(Val(Mid$(DecimalPart, 1, iPrecision + 1)) + RoundUpValue) If Mid$(DecimalPart, 1, 1) <> "1" Then DecimalPart =...

Part and Inventory Search

Back
Top