access db online

[Danny]

Greetings,

I have created a database to track applicants’ eligibility process. Mainly, a Head of Household will call or apply in person for a medical assistance for self or for child #1, child #2 etc. I created two tables tblHeadHouseHold and tblApplicants with a (one-to-many relationships) and, a main form (frmHeadHouseHold) and a subfrom (sfrmApplicants). So far, the database works fine and just recently, I was approached first, to make this database available online, so that applicants can go to a given center (clinic) to fill in the application, and we then pull the application from the office. Second, to add a new field (source of Application) where applicants learn about our program (Friend, School, Doctor, Advertisement, other) to create a ‘Source Report’, how many from friend, how many from school, from Advertisement etc.

I’m using access 2003 and would like to know:

1. What I need to make the existing db available online

2. Given the type of report I need to generate for ‘Source of Application’
shall I use check box, drop downs, or a lookup table?


Thank you in advance,

OCM

 

[aleb]

Are those centers connected via network ?
If yes then you need to put the db to the shared drive and make sure that every PC will have at least a runtime version of access installed.
If not ... then you can make replicas from db. and once in while update main db with information. Or you can create a form in ( excell, text documents ) in this case you would need to worry about the correct keys to be in the file, for the records to be correctly loaded to the db.

I would go for a dropdown list.

 

[Danny]

Alexei,
The centers are connected via a network, but not to our network. (their own network).
I have created a dropdown as you also suggested as follows:
In my tblHeadHousehold, I added a new field 'AppSource' as a dropdown with dropdown lists: Friend, School, Family, Other etc. I have tried to design the query, but didn't get what I was looking for.
How do you create the query so when I ran it, will give me how many AppSource were from Friend, how many from School, and how many from Other sources etc.?

Thanks,
DD

 

[aleb]

this is the sql for your query:

SELECT tblHeadHousehold.AppSource AS Source, Count(([AppSource])) AS [How many]
FROM tblHeadHousehold
GROUP BY tblHeadHousehold.AppSource;

Populate your field Appsource with appropriate values and then run the query.

As I said above since they are connected via the net work you can just place a db on the shared network drive where every clinic will have access to it,
if you are interested only in the reports from then create your own reports and ask them to send the output reporst ( lets say in snapshot format ) to you.

 

[Danny]

Thanks Aleb for your reply,
When you get a chance can you take a look at my attachments (screenshot of the structure of my table) I'm not sure if I have created the table and the relationships right, but on my form, for the newly created field Application Source (AppSource)
I do not see the dropdowns. And in regard to the query, can you explain why you have [How Many]? And when you 'Populate your field Appsource with appropriate values and then run the query' do you mean list all the possible dropdown options (School, Family, Friend, Doctor, Other etc.) in the query grid?

Thanks,
DKD

 

[aleb]

Ok ... I am back at work.
1. I do not see any screenshots of your db. if you can post db here then post it please.
2. No I didn't mean populate a grid of the query. I meant to populate the table, I assume you already have some records and the field appsource is empty at the moment
3. When you created a new field appsource have you defined that this is a combo box type field ?
4. [How many] thing is just a name of the column in the query.

Anyway ... post your db and we will see what we can do

 

[Danny]

lookup table

Well come back Aleb,
I was trying to attach the structure of the table to help you see what I did so far, but got a message saying too large. My file is only 152kb zipped. When I created the AppSource field in tblHousehold, I defined it as number (since AppSourceId is AutoNumber).

Thanks,
DD

 

[aleb]

Zip your db and send it aleb@tengizchevroil.com