Search results

Just seen the 'Limit to list' option. Which is what I'm looking for. But going on from there is there any code that Icould input that will enable me to tailor make the error message?

I have various Combo Boxes linked to Lookup Tables, but I want to stop the user from being able to input their own answer. In other words if the drop down only has four options then the user can only use of the four options. Thanks Gareth

Hi People Can we tell Access that if a certain report has no data, do not print the report. I have 4 reports that print off at the same time, but sometimes some of the reports will have no data, so I am trying to not print it. Any ideas? Gareth

On the example I am using the report should print off 2 columns, it is only showing one. I can get the report to run separatley ie Not as a sub report. It displays the two columns OK

Can anyone tell me if the following scenario if plausible? In a report that prints fine, insert a sub report, but the sub report needs to print in columns and there can be upto 7 columns going across the page. All linked via a Contract Number. I have looked into 'snaking' but I can only...

But that prints all the contracts, I need the current one printing only

I need to print off 3 reports, rptMechanical, rptElectrical and rptCommercial, from a Form all linked via a Contract Number. Could someone kindly help with the vba? Thanks Gareth

Hi Bob, Thanks for replying. Me.Description = Me.frm_Contracts.PARTDESCR Did the trick Thanks again

Hi all, One is having one of those days. 1 Main Form (frm_Contracts) with a field called 'PARTDESCR' (tblContract) 1 Sub Form (frmRecords) with a field called 'DESCRIPTION' (tblRecords) I need the input from the PARTDESCR to be copied to DESCRIPTION. Using...

Hi all I have a main form which contains customers details. Within that Main Form I have 6 Tabbed Forms. A user may look at a Contract number and make a change in only a couple of the Tabbed Forms, but I cannot code it to Prompt the User to Save changes or Not to save changes. I have...

Hi All My main form has clients contact details etc in, in the main Form Header In the detail pane I have 4 Tabbed forms. However whenever I open the form I have to scroll up about 2cm so that all the tabs are showing. I've tried re sizing even placing an invisible command box at the top...

I am after layout 2

I don't mean vertical text as such If the labels are on the left hand side of the screen going down and the relevant text boxes are next to them., but if there are more than one entry for this particular Contract number it will show another column with the info in.

Hi Everyone I know access can show Continuous forms in a horizontel form, listing them down the page, but is there a way of listing them across the page?

Did this ever get resolved. I have a similar need for the query results to be numbered, as they will go onto a mail merge. My query lists about 2000 or so i just wont to limit it to say 50 or 60 each time or >1 and <50 Gareth

Attached is a snapshot. When run the Query will list anything from 20 -2000. I want the ability to say 'I only want x showing?'

I have a table with hundreds of Sport Clubs entered and their corresponding Leagues they are in. I have to do a mailshot but only 50 at a time. I have the query setup so it lists all clubs in x League, but cannot limit the query to show only the first 50 or 60 etc etc it only shows all 2000...

RuralGuy, I did try your suggestion in 8, but still to no avail. I will try the form way. Thanks

It is purely to select a client from a combo box, then if you select for example Smith, John then all his address, phone etc etc will be displayed.

This is the code thus far Private Sub Combo103_GotFocus() DataEntry = False End Sub Private Sub Form_Load() DataEntry = True Me.Requery End Sub I have never used a 'ReQuery' before. The above code still not working. The combo box does no longer list either?