Search results

THANK YOU, THANK YOU.............. I just posted a question very similar to this and this was the answer I needed.

Hi, I'm using a tab control form which has 8 different tabs. I have a help document and I have a help button on the bottom of the main form. If I click on a tab and go to that page, I want a variable to hold the page number so the help document can look at that variable and know which...

Because of multiple addresses (physical addresses and mailing addresses) and many different phone numbers, Phone, Fax, Cell, Alternate Phone, I was taught that to normalize this they each needed to be in a different table.

I have a form with a tab control which has 7 tabs. Each one of the seven tabs has one or more subforms. One of the subforms has two subforms on it. The main subform is personnel information. The first of the two subs has address information and the other of the two subs has phone/fax info...

Thanks very much. I decided to only show the second option group after the first option group was selected. That way, I eliminate any need validate those two fields..... Works excellently this way.

Thanks, I followed your advice and my sql statement runs beatifully now.

Thank You I read this thread and was thrilled with this piece of code. THANK YOU! Now though, I can't seem to get it to work with an Option Group. I've changed Combo Box to (Ctrl.ControlType = OptionGroup), but it still ignores the two option groups I have on this form.......... This is...

Well I figured out what I was doing....... strInsert2 = "INSERT INTO tblReportResults2 ( RptResID, DocumentID, SectionID, QuestID, QuestType )SELECT tblReportResults1.RptResID, ltblReportForms_QnA.DocumentID, ltblReportForms_QnA.SectionID, ltblReportForms_QnA.QuestionID...

Okay, this one works now, strInsert = "INSERT INTO tblReportResults1 ([AppID], [DocumentID], [ReportType], [RptDate], [ProjOff], [ProjContactPerson]) VALUES (forms!frmHold.AppIDHold, forms!frmHold.DocumentIDHold, forms!frmHold.ReportTypeHold, forms!frmHold.RptDateHold...

I Am trying to insert data into a table --- some of the fields are coming from a different form (frmHold) DoCmd.RunSQL "INSERT INTO tblReportResults1 (AppID, DocumentID, ReportType, RptDate, ProjOff, ProjContactPerson,) VALUES (" & Forms!frmHold.AppIDHold, Forms!frmHold.DocumentIDHold...

Has anyone found a way to enable having a Continuous Form in a Continuous Form? :):):)