Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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

Thanks for your help

Thanks I've sorted it now

Yes

Thanks for that seems to be sorted now !!

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

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

Thanks seems to have resolved the issue

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