Input Form for a Survey Database 2

[JOEYB99]

I am using Access 2007.

I am trying to design a rather simple survey type database for our company's H/R. Currently it is being done on a paper form. I have come up with the following tables - tblBasicID, tblQuestions, and tblResponses. I am using simple because the responses can only be one of three options.

I am struggling with designing the main input form. I do not know how to link the tables.

I am somewhat new, and have limited knowledge of VBA. Can someone please help me out with design and structure of the input form?

Any help would be greatly appreciated. I read something from the MS knowledge base (#292299 I think) but I'm having trouble following it.

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/q209493/

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kjv1611]

Also, if the Access database ends up being overly complex, what other options do you have? Do you have SharePoint where you work? If so, you could create a survey SUPER easy.

With Excel, you could use Data Validation to achieve what you're looking for, as far as only accepting certain answers.

And when you say link the tables... I suppose you're not sure how to pull everything in correctly to the userform?

If neeed be, you may need to take this a step at a time... start at square one, work on it, ask questions, and then move forward.

Also, in case you don't find what you need at the link provided by PHV, here's another source that has TONS of examples for various database projects:

http://allenbrowne.com/tips.html

Loads of stuff there. Near the bottom of the page, look under Applications, and you'll find all sorts of Access examples. Between the two of those guys, you probably will find more than what you need.

I do have one question... you're takling about how to link in the tables, I can't help but wonder is it really as complicated as you think it is... but try looking at those places first, then come back with some more detail, and surely we can help get you going..

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[JOEYB99]

Thanks kjv1611, that helps.

I will give this some more thought after checking out the links.

But the rogersaccesslibrary though gives me a server error. Why is that?

 

[PHV]

And this one ?

http://www.rogersaccesslibrary.com/forum/topic3.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JOEYB99]

By the way kjv1611, what exactly do you mean by "...have Sharepoint?...create a survey SUPER easy..."

We have Sharepoint and I am very intrigued by this. Can you please elaborate and/or direct me somewhere that could explain this particular "option" (i.e. feature)?

 

[kjv1611]

Sure! SharePoint is very-much the ideal way to build surveys. If your organization has SharePoint and uses it for their Intranet, for instance, then creating a survey can be done in a few clicks, along with you typing in the actual survey items.

Here's one link:

http://office.microsoft.com/en-us/windows-sharepoint-services-help/create-a-survey-HA010208578.aspx

You can search for oodles and oodles of references:

https://www.google.com/search?q=cre...rg.mozilla:en-US:official&client=firefox-beta

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[JOEYB99]

Thanks k! I'm assuming we are on a first name (initial?) basis now.....

This is quite an interesting development.

Can you, or anyone else, please take a look at my attachment? (Hopefully I did it correctly!)

This is the current paper version of what I am trying to automate. It is a 2-sided card and I am showing both sides of the card. It's nickname is BBO card - behavioural based observations.

I'm beginning to wonder if I should set it up on Sharepoint and have the results exported to a spreadsheet. Yes/no?

 

[kjv1611]

somehow, your link doesn't really work... I'm guessing you tried to point at a local file. Instead, you have to post it somewhere that is publicly accessible such as a website... file sharing site, etc.. of course, some of us (me included) cannot access file sharing sites at work anyway.

As far as what to do with the results, yes, you can export to Excel. You can do diff things. For instance:
1. Export to Excel
2. Pull into an Access database
3. Query with SQL Server
4. Display at least some sort of reports directly within SharePoint.


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57