Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Forums > Access
 
Microsoft Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students can post here. If you'd like to become a student, all you have to do is enroll in one of my courses, which you can do for as little as $1. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion

Please read the FORUM RULES before posting.

 

SubForm Like ABCD Upload Images   Link 
Joseph Messina 
2 months ago
Hi Richard:

   I have my contact database setup like you have in the ABCD database with the EMail, Phone and Address tab.  I accidently deleted my database and thank god had it backed up so i had the Sub forms created for the EMail, Phone and Address and also added contact history and documents.  I was following your videos how to do the tabs like you have in the ABCD database did it step by step was following along with the vidoes.  I have everything all setup now an good to go.  I have question about my database.  When i click on a tab flashes.  I don't know why it does that when i click on each tab.  Can you help me with that please?
Adam Schwanz
2 months ago
When you click on a tab the tab flashes? Does it flash off and on or is it just a blink once?
Joseph Messina
2 months ago
Hi Adam:


Flashes once when i click on a tab.   Can I send you my database so you can see what it is doing?  Also I had a tab for documents and when I go to the documents tab to add a new document and I click on the browse button to add the file and after I do that and clickm opn another tab for example like email all the tabs turn black.
Michelle Maughan
2 months ago
Hi Joseph
I think this is in the Private Sub SwitchTabs
DoCmd.Echo False
Stuff
DoCmd.Echo True

Is this right Richard?
Joseph Messina
2 months ago
Hi Michelle:

I know i hsve to put thst in the VBA code.  Do i put it under the on open event?  Can u please tell me where i hsve to put it.  I know VBA.  I been learning the lessons i get from Richsrd snd also watching the techhelp videos.
Joseph Messina
2 months ago

Joseph Messina
2 months ago
Hi Michelle:

Please see screen shot above,.  This is how i have my database setup with the tabs.
Joseph Messina
2 months ago

Joseph Messina
2 months ago
Hi Richard:

Please see screen shot I did a lot of changes to my contacts database.  I truly understand if you are very busy and busy with other projects and other thigns.  I want to know if I can send you my database or if someone else can look at it.  I want to make sure everything in the VBA looks good and everything.  Can you please let me know.  I can have someone else wlook at it if you can't
Richard Rost
2 months ago
Michelle is correct. DoCmd.Echo stops the screen from updating, which prevents the flashing effect. Watch the videos for where to put it. I am booked solid right now, Joseph, so I don't have time to look at your database. Sorry.
Joseph Messina
2 months ago
Hi Richard.  

No problem.  I truly understsnd u r booked and very busy.  I will do that tge code Michelle wrote.  Thank u for letting me know.  I been learning from the lessons and techhelp vide8s will xontinue to learn.  Are u talking sbout watch the ANCD videos to see where to pyt the code?
Richard Rost
2 months ago
Yup. It's in there. Just like she said... in the SwitchTabs sub.
Joseph Messina
2 months ago
Thank you.  Really appreciate it!
Joseph Messina
2 months ago
Hi Richard:

I have awsome news.  I got it fixed.  I'm not getting the flashing anymore when i click on a tab.  The only thing is when I click on the documents tab I created and when i click browse to upload a file to a contact after I click a file to upload al the tabs go black when i click on another tab.  Can you tell me why that happening?
Joseph Messina
2 months ago
Hi Richard:

I thouhgt I had the flashing fixed when i click between tabs that i created like in the ABCD database.  I'm looking into it and trying to figure out where that code goes that michelle told me to do.  Also like I was telling you in the last reply also the the tabs turning black when I click browse onn my document tab when i go to upload a file to a contact in my database.
Joseph Messina
2 months ago
Hi Michelle:

I did the code what you told me to do.  I think i did it right in the on click event.  Still flashing when i click on a tab.  Also when I cli k on the documents tab i created I go to click on the browse button to pick file to upload and after i upload the file and click on different tab all the tabs turn black.  Can I email u my dstabase to take a look to see what I'm doing wrong?  I created the tabs right like in the ABCD database Richard building.
Michelle Maughan
2 months ago
Hi Joseph
As much as I wish I could help you, I do not have the knowledge to do so.
I am still learning just like you. I only answered you because I was confident I knew the answer to the flashing problem.
Maybe you should run through Richard's troubleshooter tips, or as painfull as it might be, start again.
Sorry Joseph
Michelle Maughan
2 months ago
Hi Joseph, I noticed you said in the on click event. Its not the on click event it is the Private Sub SwitchTabs see below.
Also check for spelling mistakes.

Private Sub SwitchTabs(TabName As String, FormName As String, FocusField As String)

    ResizeForm False
    DoCmd.Echo False
    DoCmd.GoToControl "FirstName"
    SetAllTabsOff
    EntitySubF.SourceObject = FormName
    Me.Controls(TabName).BackColor = EntitySubF.Form.Section(0).BackColor
    DoCmd.GoToControl "EntitySubF"
    DoCmd.GoToControl FocusField
    DoCmd.GoToRecord , , acNewRec
    DoCmd.Echo True

End Sub
Joseph Messina
2 months ago
Hi Michelle:

Thank u for the info.  I will try that code.  I've been learning with the courses I get from Richard every week.  I love Access.  My fsvorite database program.  I know I will get there for everything zi want to to do.  I'm on expert level.  Thank u again.
Joseph Messina
2 months ago
HI Michelle:

I know yiou and I are still learning.  I have the code you gave me.  I'm just trying to figure out where it goes.  I know it Private Sub.  I just trying to figure out where to put it in to stop the flashing.
Joseph Messina
2 months ago
Hi Michelle:

I got it to work.  Thank u so much.  All fixed.
Michelle Maughan
2 months ago
WOOHOO! Good job. Glad you got it to work.
Joseph Messina
2 months ago
Hi Michelle:

Thank you. So glad I got it yo work too and I'm learning the lessons from Richard.  Iove Access.  I always use it for my databases.  If I always need anything will always ask for help.  I been using Access for a long time.
Joseph Messina
2 months ago
Hi Michelle:

I also want yo let u know also figured out think ehy when I was clicking on a tab like email or address or phoneand was flashing everytime I clicked on a tab not sure it had to do with tab control I have set up in my main form.  I copied my main form as a diffeent for name and copied the fields and created the tabs like in the ABCD database Richsrd been building and I clicked on email field to tedt it and nothing was flashing.  I didn't even have the code u gave me I didnt hsve it in the new form and nothing was flashing.  So not sure if it had tl do with the tsb control I hsve in my form.  Just curious do u have tsb control in your database or like tsb controls?
Joseph Messina
2 months ago
Hi Richard:

All the tabs i created like in the ABCD database are working fine not flaashing anymore.  The only thing is when i click on the documents tab and click on the browse button to upload a file and after i pick file to upload into a contact record and I click on another tab example like EMail all the tabs go black.  I don't know why.  Can you help me with this or point me in the diirection to fix the problem please?
Richard Rost
2 months ago
I've seen that happen before when the system gets low on memory. Restart the database. Does it still happen? If so, then reboot Windows.
Joseph Messina
2 months ago
Hi Richard:

Than you.  I restarted the database and worked.
Joseph Messina
2 months ago

Joseph Messina
2 months ago

Joseph Messina
2 months ago
Hi Richard:

Please see screen shots.  I did a lot of changes to my contacts database.  I changed my form around and did it like the ABCD database with the tabs.  I was trying to put the tabsopn the right of my form like you have in the ABCD database.  but, it didn't work, cause of my documents tab had to make it so see everything in the documents tab,.  Or if you know whyI can fix the documents tab so i don't have to have the full file path on the documents just the dfile name. I also tookm out the tab controls and did it llike this with the tabs
Joseph Messina
2 months ago
So proud of myself I fixed up my contacts form with the tabs like in the ABCD database.  I'm learning.  I'm getting there.
Add a Reply

Show All Comments

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access forum  PermaLink