Search results

If I do this Brian, then the user can still type into the box as long as the text is available in the dropdown itself. I was hoping not to allow any typing at all but I guess it doesn't matter as the control will still return the same value.

Thank you very much Brian. I will try that. Would you also happen to know how I can make the ComboBox dropdown so that the user CANNOT type values into it?

Hi again... ...the problem is "All" will not return all values in the query for that particular field. The field only has 3 possible values (the ComboBox only shows 3 items). The query behind the report has the following for that particular field as a criteria...

Hi and thanks, Some other questions come from this... The Record Source for the report (query behind the report) uses the value selected in the ComboBox as a criteria. How can I ensure that if "All" is selected, it has no effect on the query? i.e. doesn't filter at all on the criteria...

Hi, I have a ComboBox on a form with a CommandButton next to it. The ComboBox is populated with the contents of a field in a table. When the CommandButton is clicked, a report is opened in preview mode. The Record Source for the report (query behind the report) uses the ComboBox value as a...

It's OK I have done it :) I added the country to the select clause which populates the control (bound column 1 so it only shows the company in the dropdown). I then referred to the control in my VBA as ComboBox.Column(1) That enabled me to pick up the country for the selected company :)

Hi ctechnumber1 and thak you for your reply. I have the following tables and relationships (see attached image). On a form I have a ComboBox showing a dropdown list of companies. There is a button next to the ComboBox. There is a different report for each country. When the user selects a...

Hi, I need some VBA to perform a simple task. I am novice and would like to ask if some kind soul would write the code for me in order that I can learn by looking at it. I have 3 tables: 1) Companies 2) Countries 3) Combinations The Combinations table is a joining table and its soul purpose...

It does indeed work now thank you both :)

Here is the code which is generated by the wizard for "Open Report"... Option Compare Database Private Sub ButtonOne_Click() On Error GoTo Err_ButtonOne_Click stDocName = "Report1" Exit_ButtonOne_Click: Exit Sub Err_ButtonOne_Click: MsgBox Err.Description Resume...

Hi Bob. I wanted the report to open and look like it does in "Report View" rather than "Print Preview" view. How do I do this please?

Hi I am using MS Access 2007. I have 1 simple report. I have 1 simple Form. I wish to place a button on the form which opens the report. When the button wizard runs, I choose "Open report" and select the report I wish to open. When I run the form and click the button nothing happens. If I...

I have created a CrossTab Query which displays correctly in Datasheet View. When I create a Report based on this query it displays correctly (see attached SubReportDesignView.gif and SubReportReportView.gif). However I wish to add this Report to my Main Report (i.e. make it one of several...

Hi Uncle Gizmo and thanks for your time. I have read that article but don't quite understand what you are suggesting. Should I hold all of my Data (and YearID) in the Entities table together with BankID, CompanyID, RelationshipID and CountryID? Thanks again.

Hi, I have been asked to build a fairly simple Access project by my boss and am desperate to have it finished by the end of the week. Although I have some knowledge of databases, queries and programming etc I am new to Access. I have been reading like mad but don't know if I shall be up to speed...