Search results

OK Can you upload a copy of the database?

Yes but DO NOT SHOUT AT ME On the Subform you need an Unbound Control to Sum whatever you need. Then on the Main Form you need to use a Forms Reference like:- =[Forms]![MainFormName]![NameofSubform].[Form]![nameofControlthatIsdoingTheSum]

Hi Esther Here is your file in 2003 Format. It is worth noting that there are issues with the structure of your table. You are using Lookup Fields which are a NO No in Access. Google "The Evils if Lookup Fields in Access Tables" Also you are using a Value List for the Currency Field. What...

In the revised database attached I have :- 1. added VB Code to the after Update of the Currency Combobox in the Footer. 2. Now when you select a Currency the Form filters to just that Currency. 3. Click the Clear Filter button to remove the Filter. You would need to use the same process for...

You have 5 different options :- Currency Portfolio Code Accountancy Year Accountancy Month Transaction Type. When you Run your Report would the Filter to be applied only be based on 1 Option or could it be on More Than 1 Option?

The normal practice to Group anything is when you produce a Report and not a Form.

When you say "assistance in Grouping our data" What exactly are you trying to Group By?

You can generate a query to show tables booked and tables free as shown in the attached screenshot. You achieve this by having the Relationships as shown in the attached screenshot.

Hi George Ithink that is beyond my knowledge, but would appear pointless to me.

I Imported the database into a new database and then applied Descending Order

Why do you need the empty lines?

Hi I took a quick look at your Database which is in fact 1 Table which you have copied from an Excel File. Points to note are as follows:- 1. that you should not use spaces in field names 2. you should not use any of the following characters in field names !"£$%^&*()_+-=][}{#'@:;?/.>,< You...

Can you upload your database so we can see your table structures/ relationships?

The OP needs to give a more detailed description of his process. At the moment we are all just guessing what it is he needs.

Hi It would help us understand if you gave us examples of actual "Stats" rather than a list of Stat1 through to Stat30

Hi If you want to be able to choose a Supervisor , then allocate a Shift and then allocate Employees to the Shift selected, then you need tables as shown in the attached screenshots. The Data Input Form allows you to select a Supervisor, Select the Shift he is responsible for and then add...

Hi If I create a Form which allows you to select a Tag what data would you then want to be able to add? The attached screenshot allows me to select a Tag, and then add details about a specific Level Transmitter and Pressure Transducer associated with the Tag selected.

From the Relationship diagram it is difficult to determine what in fact you need to do. Do you want to be able to Select a Tag and then enter details of the Pressure Transducer as well as details of the Level Transmitter?

Are you able to upload a copy of your actual database?

Hi So all 3 rows belong to 1 peice of Machinary?