Microsoft Access

Verb

Does anyone know the best sites for advice on building a database. I used to be rather good at this (in my university days) but 5 years on I am so rusty. I have sort of built what I need, its just not quite what I want. What is the best way to get help in this area. I am now looking at a refresher course but that is a long term plan.

PROLIANT

Verb wrote: »

Does anyone know the best sites for advice on building a database. I used to be rather good at this (in my university days) but 5 years on I am so rusty. I have sort of built what I need, its just not quite what I want. What is the best way to get help in this area. I am now looking at a refresher course but that is a long term plan.

I am a database developer amongst other things in my line of work as an IT Support Engineer, I would be more than willing to help you get it off the ground, If you need VBA code samples have millions of them and have some E-Books you can have, just let me know what it is you need help with.

Verb

I dug the hole in work for myself, not realising the amount of work I was making for myself. I am an Industrial Print Maintenance Planner. With in excess of 1500 machines all based on one site. My predecessor/s used Excel based systems for reporting jobs, breakdowns etc…But this gives me a zero chance of tracking fault histories unless I go thought all old reports to hopefully find what it is I’m looking for.

I have in part built a data base that records such information as day, date, team, fault area down times etc… But what I wanted to do was get this to be done using drop down options to allow me to get some sort of standards that could be followed. This is where my knowledge seems to have left me. I have built the database all in one table (numerous columns) and have made a front page that says that all information fields must all be completed. I don’t know where to put the information that would be contained within the drop down areas. If I manage to get a drop down table on it, it seems to mask over the cell I have on the front page and when I go to save it, it tells me that the cell under it is still empty.

With all of this functioning properly, it would then be down to the type of reports I make that would show the information I would be after when the time comes.

If part of this is too vague please let me know.

Thanks
Carl

PROLIANT

Hi Carl, I see what you are trying to do, you can create a separate table for the combo box list values and set the combo box row source type to a Table/Query and set the row source to the new table which has the values that you require and remember to set the column count to the amount of columns that you want to be displayed, i.e. say you have an auto number field that you use as the primary key of the table and you have in the second column a text description that you want to be displayed then you would set the column count to 2 and set the column widths to say 0cm;5cm which would hide the first auto number column and leave you with the text only.
The other way is to hard code the values into the combo box properties page and set the row source type to value list and then in the row source directly type the values that you want the combo box to display i.e. "1";"2";"3" and use this format. If you want to restrict users to use the values that are in the combo box then set the limit to list property of the box to yes.

Regards

Rob

Verb

Do you have any e-books available that show this. At the moment I am trying to do this off memory as I am not in work till Tuesday. As easy as it sounds, I think I'm going to have to walk myself slowly throught this until my brain gets back up to speed.

PROLIANT

Verb wrote: »

Do you have any e-books available that show this. At the moment I am trying to do this off memory as I am not in work till Tuesday. As easy as it sounds, I think I'm going to have to walk myself slowly throught this until my brain gets back up to speed.

Yes do you want me to email them to you?