Search results

First, to theprez, This works and it's even easy enough for me to understand! :D Thanks, now what about extra letters? And to Doug, This also works, but on display it repeats the first digit or group of digits, (not that is needs to be shown) but I don't know if it will cause issues in...

This is what I did: Expr1: Val([tblQuestion]![Sheets]) Expr2: Right([server],1) First of all I don't know what [server] means...? Also when I tried to run the query I got an "enter parameter value tblQuestion Sheets message. There could possibly be more than one letter at the end of the...

I'm faced with another interesting sort issue. I have been studying about functions Left, Mid, and Right. I can't seem to get anything to work. I need to sort from beginning to end and not from left to right. I have numbers and letters both. I have read old posts and can't find any help. I...

I think I've figured out the problem. I think it's the way that I set up the tblQuestions. When all options relate to one question I duplicated the question for all options. I am currently removing those duplications and will write another query to include the questions that are now coded 1...

I think I've figured out the problem. I think it's the way that I set up the tblQuestions. When all options relate to one question I duplicated the question for all options. I am currently removing those duplications and will write another query to include the questions that are now coded 1...

One more thing... Here is the code behind the next button on frmUser, this form is opened prior to frmDataSelection. (prior to frmUser, is a form where the user selects survey type QC or QA) I DO need those append queries Norman... Private Sub cmdNextStepGen_Click() On Error GoTo...

Hi Norman, I'd appreciate that but I thought I would include a note that I sent to someone via email who is looking at the entire database. Some of the stuff in that db is being reused from another db that I created. They will both be used for the same thing but for different departments and...

Well, I thought that was how they worked! I must admit that I am having a heck of a time learning some of this stuff. I have completed one database for another department and this new one has to have the special sort for bridges etc. Some of the items in my current db has been imported from...

Hi Norman, They are append queries.

Thanks again Norman! I found that mistake '1' it should have been a '4'. I really appreciate you pointing that our for me! Rhonda

Hi Norman, Thanks for finding the error. There shouldn't be a 1 in the table and I'll track it down and correct it. Must have been a typo on my part, it was question number 626 so I'm not surprised! Gets a little blurry after a while. Now for the other items, the sheets and project number...

Yes, they are append queries. There is one tblQuestions which contain all the questions for the survey. The 5 queries append to tblQuestionsResults after the user has made selections from frmDataSelection. On frmDataSelection are 5 options groups. Each of the options have been assigned a...

Hi! Good to hear from you! I came accross the execute command just yesterday, 'I think in one of your posts'. Thanks for the link, which lead me to the code. (I'm helpless when it comes to code, but slowly learning.) They pulled me away from Access for 6 weeks to put together a 400 page...

Hi Pat, I'm wondering if you told someone else to turn the warnings back on after running the queries. I don't recall hearing that before...But I am becoming more and more forgetful :) How do I do that? What I'm trying to do is create a checklist that is generated by selections made on a...

I have 5 queries that are run at once. Each query works fine on it's own. The problem is that one query may pick up a question and 2 other queries may pick up the same one, resulting in duplicate questions reported. Does anyone know some code that would limit the queries to reporting the...

I can't delete the records with tblQuestionsResults because the information is retained for future use. (or will be, once the checklist is built and the questions are actually answered!!) I've also tried changing my index but then it won't store the answers more than once. If I try to made...

More Info I've been looking at my append queries. I am appending to tblQuestionsResults. I have QuestionTypeHeading from tblQuestions appending to QuestionTypeHeading with the following criteria: [Forms]![frmDataSelection]![txtAbutmentTypeValue] Each append query having a different...

If you look at tblQuestionsResults at questionID you'll see some of the duplicates. The code was run only once when I saved this file. I don't understand what is happening at all. The first row has questionID "1" then questiontypeheading "0" (the zero is not valid and should not be there!)...

If you want you can direct your expertise at this post: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=62110 :p

NOOOOO!!!! I've seen second questions asked before and get ignored. So I thought I was supposed to start a new thread cuz it's kind of another topic. Hope you aren't mad!!