Recent content by Ericnord

Thnx for the lengthy replies. god, that is exactly what I'm trying to do. keep me posted.

instead of having an if/then for each checkbox (since I will need 20 of them) what is wrong with just setting the SQL to what is checked and manually set the query with the SQL, such as: Private Sub Submit_Click() On Error GoTo Err_Submit_Click Dim stDocName As String Dim SQLstmt As...

Hey everyone, I currently have an Excel Spreadsheet w/ 20 columns and 800+ rows. The columns are such things as Product, Product Code, Description, etc. It has clearly grown to big for an Excel file so I created an Access table from the spreadsheet called All. Goal - have employees open a form...

Still crawling along here... Ok, so I'm still crawling along on this survey DB I was asked to do. I liked dgm's .jpg he sent and tried to copy his tables and relationships. The problem I am now running into is in duplicating his, or making my own, form. The top of his form uses the survey name...

Fizzio, Thank you for the reply. I'm glad I set everything up like you had intended. It does not matter if they are presented w/ 1 or more at a time. My question is how can I have the 9 buttons, that I assign values of 1-9, be the same for every question that is presented. That is, if I'm...

Nobody can help me any? It doesn't have to be Fizzio or Pat Hartman. Any help would be appreciated

Here is an image to maybe help you visualize what I have going and the way I would like the form to end up. I should have added this to the above post to help clear it up some. Thanks

Fizzio, HELP :) Hey Fizzio, I'm trying to implement your DB suggestions that you offered a while back. I'm stumped on the SurveyQuestions tbl. You have QuestionID, SurveyID (which I entered and then made a relationship with the SurveyID from Surveys tbl), and then you have QuestionText. The...

Ok, thanks to the both of you for all the help. I will mess around with Fizzio's setup and see if I can get a grasp on it. Thanks

I'm sorry Fizzio, but I cannot find what you are speaking of. Control panel for form...hover mouse over icons. I don't know where you are talking about. I have the form open in design view. I've searched all the menus, to toolbox icons, looked for tab pages icon in helper, etc.

Thanks for the help Pat I'll search the archives now. We do differents experiments and rather than a surevey, I guess they are more a questionnaire. The reason I haven't done something more elaborate is because I don't know if there is a need. I do not need to store anything about the...

Fizzio, Thanks for the reply. Can you or someone expand some on your #1. I did format the form myself and it still exceeded the page length. I do not know how to make the form go to a second page with a next button, or tabs, or anything. Thanks P.S. I'll look more at your DB setup!

Hey everyone, I've set up a DB to replace our paper survey system. Our surveys usually consist of 10 - 25 questions that are usually a scale of 1-9 type questions. I set up one table that autonumbers the participants, and then just added q1,q2,q3,q4,q5,etc with all having a number field. I then...