Hi - please direct me!

[PleaseHelpMe]

Hi all,

I am new to the forum and have been thrown in the deep end with an Access-orientated task.

My Access knowledge and experience is limited to I.T. classes over 10 years ago at school and are basic at best. I am pretty good with computers in general and have strong Excel skills.

Could someone point me in the right direction where I should post my questions?

In case you are wondering I need to know:

1) How to create an online form which adds records to a database

2) Understand how to auto-populate a field on a form (or decide which drop-down list to display) given a selection on another field.

3) I am tracking work between offices and need to report on attributes associated with an office (for example region, sub-region, type, size). How can I set it up such that it allows for the type/size to be changed eached year (if applicable) so that the reporting by type/size changes.
As an example we might have office A with type 1 and size 1, Office B with type 2 and size 1 and Office C with time 2 and size 2. Reporting in period 1 we would combine/average/whatever the results by type (combining B and C for type 2 and A on its own in group 1). Another analysis would be by size and we would group accordingly. Say in Period 2 office A becomes type 1 and size 3. We would like to be able to report in Period 2 with A in size 3, but if we revisited Period 1 we would like A in size 1.

I hope I make sense. Apologies for posting the questions here - I will repost in the appropriate thread once I understand the structure of this site more.

Appreciate you assistance & congrats on what looks a great site!

David

 

[JamesMcS]

Hi, welcome to the forum! Yeah that's a few threads there, start with:

1. A data access page should do the trick here.

2. You can populate fields in forms using VBA, but there are a ton of methods to do it, depending on how you're making the selection and where the data is.

3. You'd just use a form so that users can change the data if need be, and rerun your reports. If the queries are based on size, and one record's size changes, it will or won't come up in the query result - depending on criteria of course.

Post a thread for each of these topics and describe in more detail what you're unsure of and we'll sort it out!