Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wphsp
-
Word 2003 mail merge automation problems (earlier verisions work fine)
You might have to force to open Word 2003: Try this: .OpenDataSource Name:="\\path\folder\FileName.rtf", _ LinkToSource:=True, _ Connection:="TABLE FileName", _ SQLStatement:="SELECT * FROM [FileName]" SubType = wdMergeSubTypeWord2003- wphsp
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
VB Test for which tabbed page is active on a form
Not sure if this will help you but have the subform on the tab unbound and make it invisible. then use the following code, but you Private Sub TabCtl0_Change() Select Case TabCtl0.Pages.Item(TabCtl0.Value).Name 'Case "pg1" ' If Len(sfrm1.SourceObject) = 0 Then '...- wphsp
- Post #3
- Forum: Microsoft: Access Forms
-
Change Color of Tab Control
I am using tabs with subforms and although I am keeping the grey buttons, I do use the following to change whether there is data in the Notes section or not. Private Sub Form_Current() If IsNull(Me!Notes) Or Me!Notes = "" Then Me!NotesPage.Caption = "NO NOTES"...- wphsp
- Post #14
- Forum: Microsoft: Access Forms
-
Form Display
if you put the tabs in the header of the main form instead of the detail section, this might work. B- wphsp
- Post #2
- Forum: Microsoft: Access Forms
-
Tab disappearance on tabbed form ???
I just came on board and not sure if you tried this, but I put the tab control stip in either the header or the footer of the main form, instead of the detail section. This will not make the tabs disappear. B- wphsp
- Post #2
- Forum: Microsoft: Access Forms
