Search results

I had received some great help with this problem previously several weeks ago. I made great progress with his help (I COULD NOT have gotten this far without his help!), but I got stuck at an error message I could not get rid of. I had to lay this problem down for awhile to work on other...

Fyi.. Just as an FYI, here is the Row Source from the List Box: [qrySurveyAnswers].[Answer] is the text displayed, [qrySurveyAnswers].[AnswerID] is the result of the query and the number that is saved in the record, but the user never sees this number.

Thanks for trying.. Thanks for trying, but no. We are getting closer though! I am still trying to tweak the thing! Your 1st code gave the same message as before, Too few parameters. NOW, we are getting a different message with your SECOND code. Hallelujah! At least I know the machine is...

Hmmmm. I added the QueryDef as the link you attached suggested (along with theo other "Syntax to set the value of a parameter", but I am still getting the same message. I am relatively new to VBA, so I'm swimming in mud here. What could I be doing wrong? Do you think the references to the...

Just as an FYI, I realized that I should NOT have REMed this out, as this is giving what I asked for to start with! I thought this triggered the DIPLAY of the new records, but this is CREATING them. Therefore, the REMed out code becomes: 'Go throught each selected 'record' (ItemsSelected) in...

OK. This is my last post of the day. I am on my way home. If you are still there, I will check this when I get home. Thanks so much for your time!!! I have tweaked the code for my survey and now have the following error: Here is the tweaked code (the red items I changed, and the green...

Never mind that, I see now that's wrong. I am trying to change the table names of what you've got to match what exists in the real db, but how do I make this work with subforms and sub-sub forms?

Thanks! Thank you. I am in the process of tweaking as we speak. Where did the SQL come from in the code (I am a bit new to VBA, but learning). I copied in the SQL behind the query that the ListBox uses to pull the appropriate answers. Was that the right thing to use? What is that SQL doing?

OH! Now I see! I was clicking in the wrong place! Now I see! I was clicking in the wrong place on what you sent! I was trying to use the combo boxes. Yes, you are on the right track, plus you give a way to delete erroneous answers. NICE! This is very close, except you should only be able...

It should pretty much look like the screen shot I sent (unless we have to restructure it to make it work), but save the selected multiple answers. That answers box USED to be a combo box that just saved one answer to tblResults by way of qryActiveAnswers, but now they have generated a survey...

I'm sorry, maybe it was right. The restructuring of the answer format might have thrown me off. However, it did not seem that it would allow me to select more than one answer at a time. I'm not sure what your question is here. I would like to only see the answers related to the question we...

Not quite... Thanks, but that was not quite it. I can't send you the real thing, because it is too complex and just too BIG! However, here is a screen print of the survey with a picture of what I am trying to do. I want to use "Ctrl" to select multiple answers and save them in the underlying...

Sort-of sample... I am using Access 97, although I DO have 2000. The intended user only has 97. I have tried to shrink the darn thing down, but I just cannot get it down to 100KB. The last time I tried, I got it down to 198K & still have it function as it is supposed to. There are just too...

With regard to the post from Cosmos75: http://www.access-programmers.co.uk/forums/showthread.php?postid=263408#poststop This was VERY helpful to me, and quite timely since I need it now and it was only posted a few days ago. However, I am confused about using it for MY purposes. I looked at...

Whew...panic gone! Just don't ask! Thanks so much for your time on this. There is a little bug though. This line: Field2 = Mid(Field2, 1, FTilde) & TextDate(Mid(Field2, FTilde + 1, STilde - FTilde - 1)) _ & Mid(Field2, STilde, Len(Field2) - STilde) is giving the error "Run time...

Thanks! Thanks for your suggestions. I plan to spend my day working on this & experimenting with the security features. (That was supposed to be YESTERDAY until I locked up the machine!) Thanks for putting me on the right path.

Whew! Now what? Well, we FINALLY got it unstuck. When I opened the database, it pasted my network username into the box and prompted for a password. What *I* had changed was the ADMIN password...apparently for the whole PROGRAM. (You can do that??!!!!) Well, we got that out of there. Now...

OK....I ran the program recommended, and it says the individual database is NOT password protected. In addition, my IT guy WAS able to open said database on another PC. What have I done here?! I have locked up the whole program!

Well that's what I thought too, that it would only lock THAT database. I am sure there was not one to start with, as I did not know that function existed until today. The database is saved in my private folder on the server. It is split, but both files are in the same folder as I am still in...

*sigh!* By the way, thanks for your response. I hope THAT works. I think my IT guys are all laughing at me right now. They just reinstalled the darn thing last week because the import wizard was not working properly. I think I'm the only one in the building who uses these other features of...