Search results for query: *

no. can you give me an example? thanks J.

so i have popups for customers to view add'l html files via getURL("xxxx.html" _blank); but when users approve IE to accept popups from my site - it starts the entire flash movie over (a pain). is there any way around this? what options do I have thanks in advance. J.

Hello all - been awhile. I have searched this forum, but have not found a suitable answer to my needs.. hope you can help. I have the following text fields in a form: form.Sname. form.Semail form.Sphone form.Salt form.Smodel form.Sserial form.Sdescription i want to add validation in the...

SeeThru, thank you for you reply.. im heading in the right direction. unfortunately, I am very weak on VB code.. Here is the code on the button which is in this form we are discussing: Private Sub btn_AddDate_Click() On Error GoTo Err_btn_AddDate_Click Dim ctl As Control, DL As String...

firstly, thanks all for your feedback thus far.. it has really helped. table structure: tbl_ReferralData ReferralID (PK auto#) Client Name Client DOB tbl_Assigned_Thx ThxID(PK auto#) ReferralID Date TOC sent to billing Date TOC rcvd from billing Currently, I have frm_TOC_rcvd i have a...

sorry. yes thank you very much.. I appreciate everyone's help. I am getting a bit better at this thanks to all the support. whoknows361

I figured I would add an additional question which should give me about all of the info I need for form creation from here on out (I hope)... So I know how to create a form to go to the correct field when a user clicks a name in the combobox (by putting combobox in header).. But I need to know...

Thank you both for your help! And thanks AceMan for field validation code.. just what I needed. One last question for ya in regards to this.. (what you gave me was added and works perfectly).. But this form also has subforms and I would like to add the same field validation with this as well...

hello all I have a form which users enter data based on which client they pick from a combo box. the combo box(combo_client) is in the header so that when a name is picked the detail section shows the correct record, so that users can enter info for this client. the combo box(combo_client)...

Hello all. I have really received from great advice (fneily, PVH) on my table and db structure.. and i have had some successes. But I am having trouble with my form "frm_OpenEpisode_submittd". As you will see when u open the form it shows record 1 of 3. the First combo box "ClientName" is the...

PHV! thanks so much, that is perfect.. now one more follow up and I should be golden... i think i should re-describe the current db so anyone viewing this post will be caught up and address my current question. I have 2 tbls. tbl_Referral_Data ReferralID PK (auto#) Client Name Client Address...

Yes, PHV... so I changed the bound column so that it shows the correct number.. hoewver, when u click on the down arrow on the combo boxes it shows all the names... when u choose a name it puts the correct number in the text box... and it all saves correctly in the table.. but what I want is...

Fneily, thank you so much, I just didn't understand the many to many relationship. But it makes much sense now. I did as you stated, created the tables, and the relationships. I created the form with one hitch. I created the form based on the junction table as you stated, was able to turn...

thank you fneily this seems an obvious fix.. and i got it to work. But I continue to have the same problem whenever I am trying to add data to other tables than tbl_Referral_Data based on the Refferal_ID field. Here's what I mean. 3 tables : tbl_Referral Data Referral ID (auto#) PK client...

Hello all. I have 2 tables: tbl_Referral_Data Referral ID (autonumber) PK client name client address client dob etc. tbl_Open_Episode Referral ID (as each referral ID has only one Open Episode) Admit Date Date Sent to Billing I want to create a form which will display a combo box where users...

fneily.. I totally created exactly what you have above last night, prior to your post. I understand now what you were saying all along. Sorry it took so long for me to understand. I think I get it now, and the value of the specific ID for a table when there is a one to many relationship...

Thanks for your continued help. I'm sorry but I think I was not clear in explaning this: Each client has multiple diagnosees, each represented on a different axis (1-5). (axis 1 for mental, axis 2 for personality, etc.)Not just one sole diagnosis. And each client can have more than one...

oh yeah.. one more note. these 5 axis diagnosees occur at client open, and then every six months after.. and can also occur at any time the therapist decides to changes the 5 axis diagnosis.

Maybe clarifying the axis diagnosis sys might help. Each mental health diagnosis has 5 axis. axis 1: mental health diagnosis (ie. major depressive disorder) axis 2: any personality disorder axis 3: any medical condition axis 4: any psychosocial stressor axis 5: is an overall score. (only one...

fneily just a question on the table design above. I understand your main tables.. in regards to the tables to connect them. then i understand connecting the tables through the tbls ClientTherapist and ClientCAseMan. I am a little confused on hte dx tables: so for tblDIagnosis there is an...