Search results

I have been trying to reach you! Just as an FYI...I have been trying to respond to your e-mails, but our organization's firewall keeps holding it back. Apparantly you can get in, but I can't get out to that provider's addresses. The delay is due to the fact that it does not reject it until...

Pinky? By the way, if Pinky's got your back, should I be concerned about your plots to take over the world? ;)

No probs with e-mail addresses! Actually, I have a free one on Excite, a paid one on Roadrunner, and one at work. I've got e-mail addresses I just let die b/c I couldn't keep checking them all! (Darn Spam!) I just needed one to contact YOU. Thank you SO MUCH for helping me! I will send it...

I have a survey database (please view attached Relationships) that I have been struggling with for quite awhile. The problem is in the data-entry form. This form consists of: frmSurvey, which contains demographic data about the surveyee (which clinic they are in, etc.) and generates a number...

How do I send it? I would love to send it to you, but I cannot figure out how to do this without an address. The "send email" and "send private message" options do not have an attachment options. A reply here is too large, even though the e-mail is zipped, and pretty minimal. Please let me...

I have an appointments form (that is actually a subform of another form) that, upon entry of a patient name that is not in the database (there is also a combo-box to chose), prompts you to double-click the field to enter the data. When you double-click, you open another form that allows you to...

It would seem that the error is in the original template, probably greated in that earlier version. Is there a way to avoid the problem in the future if I use the templates, or can I get new templates without the problem? I rarely use them, but when I do it is b/c I am doing something quick...

Tedious, but effective. Thanks! :)

I just had a very strange error. I just created a new database from a template for Resource scheduling. In know you guys don't like templates, but I needed a quickie in a hurry, and this mostly fit what we are doing. I added a few fields, but did not change the name of any fields already...

OH, that is * SO * helpful! Please feel free to share any other handy-dandy websites you are aware of! I will try these. THANKS!!!

I have 2 problems I hope SOMEONE can assist me with. Briefly, here is the situation... I have a survey database with 2 subforms, A & B. Subform A has a subform...Asub1 Subform Asub1 lists questions, 1 per record based on the survey selected in it's parent, subformA. Neither of these is bound...

Thanks al! I'll try these!

Is there a good book with VBA tips & tricks? I bought "Beginning Access 97 VBA" with is a nice primer for getting started, but is there a reference book that anyone can recommend to get past specific problems & questions? The other book mainly guides you thru their "Whiskey Store" sample to...

What are the odds? What are the odds...someone having trouble with the same problem at the same time as me! Pono1 - your solution worked great for me. I was 99% of the way there, but putting that line in AFTER Update was causing problems. Thanks! :cool:

OK...I got it working by putting cboSubformBID.Requery Under "BeforeInsert", but now you have to select the answer twice for it to save it. But when I put this command anywhere else (On Click, On Current, etc.) it either does not work at all, or is a record behind the Questions form. Also...

OK...I got it working by putting cboAnswerID.Requery Under "BeforeInsert", but now you have to select the answer twice for it to save it. But wen I put this command anywhere else (On Click, On Current, etc.) it either does not work at al, or is a record behind the Questions form. Also, I...

BTW...subform frmActiveAnswers IS based on a query/SQL that links Surveys, Questions, Answers, & Results.

OK...I got it working...not quite like you said b/c I had some trouble getting to work properly, but it works (clumsy maybe, but functional). Now I have a new problem that I think should be easy to resolve. My new setup is this: frmSurvey...Main form * Has 2 subforms...frmActiveSurvey and...

I have a form that has 2 unrelated subforms. Let's call them SubformA and SubformB. SubformA has a subform of it's own...SubformA-sub1. Subform A-sub1 never makes new records, it only displays what is in each record. How can I get SubformB to go to a new record and refresh it's query...

BTW...qryCurrentSurvey ALSO has CompletedSurveyID, but only as a means to get the Master/Child thing to work. Looking at it now as I write to you, I can see that it is NOT updatable. I don't want to update it, but since referential integrety is enforced, that may be the problem. I really...