Search results

Access 2007

How can I open a form as a tab rather than a new window ?? I just cant find the appropriate parameter !! I dont wish the form to be a tab of the form already open Thanks

The problem is with my form/sub-form. I attach the relevant form/sub-form. Basically i want to replicate 3 fields from my Main Form(Header) to each record on my sub-form together with 2/3 other fields. At the moment it only replicates the data on the first record of my sub-form

I wish to create a simple data entry form as follows :- Main Form(Header) will contain a JobNo, Date, Supplier then a sub-form(Detail) will contain x number of detail records containing unique ID no, description, amount etc. It should output to ONE record to a file containing both the Header...

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.

I've sorted it thanks. I had a 'REQUERY' command which was refreshing totals. I've removed it and it works fine !!

Tried that but still reverts back to my Main Form, I just want it to drop down to a new record within my sub-form !!

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

Thanks a bunch

I have created a query which shows 2 fields "Project Name" and "Date Worked". I want to show/select only the latest record (shown in red below) :- Project Name Date Worked 753 17/10/2008 753 16/10/2008 753 15/10/2008 753...

Thanks thats just the job

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 set the form to VIEW only and I was unable to use any other drop-down menus from the form thereafter. I have had to alter my form design to suit

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

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.

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

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

I've sorted the problem thanks with help from the following :- Google "better round function vb" and you will find lots of code. Here is one: http://www.developerfusion.com/code/4252/a-better-rounding-function/