?
Solved

combo box to open a form from the switchboard

Posted on 2011-03-15
24
Medium Priority
?
379 Views
Last Modified: 2012-05-11
Im doing a simpe CRM sysem but I cant make a como box or list  to open directly a form in any way . I tried :
Select Combobox 34

Case "Name "
strDoc = "form name "
Case Else
end select but nothing happenes

suggestions ?
0
Comment
Question by:chiefmic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 15
  • 9
24 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35143918
in what event are you using the codes you posted?

what is the name of the combo box?

here are the event that you can use to open the form
* afterupdate event of the combo

private sub comboName_afterupdate()
dim strDoc as string
strDoc=Me.comboName
docmd.openform strDoc

end sub
* click event of a button


private sub  Button_click()
dim strDoc as string
strDoc=Me.comboName
docmd.openform strDoc

end sub
0
 

Author Comment

by:chiefmic
ID: 35144095
Ok Im sorry but  my eyes are sqaure by now and  havent being able to do it yet m

I need from a list of employees ( ist box or combo box )

I created in design view and it looks up from the employee tables

I need that each name in the list, if selected, opens the CRM fom tha belong to their name ,

Like
Oscar Omegna
selected opens
FRM_CRM_User_OscarO

the code tat I was using just didnt want to work ,

I just learn all this while I was developing the CRM so if you can be very basic withme tha would be great Thanks  
0
 

Author Comment

by:chiefmic
ID: 35144128
the name (a lis now ) is list38 ,
 nad th ecodes were in the evenr private sub list38 afterupdate
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:chiefmic
ID: 35144131
sorry I have my right hand with stiches so its a bit harder to write properly , if you cant understand please let me know
0
 

Author Comment

by:chiefmic
ID: 35144141
forgot to mention im working from the swithcboard
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35146954
better if you upload a copy of the db.
0
 

Author Comment

by:chiefmic
ID: 35164783
can i email it to you ?
0
 

Author Comment

by:chiefmic
ID: 35186124
If Any One can Help Me Please What I need to do is as following :

Instead of the Buttons I put in, I need a list box that opens forms from the switch board( cant seen to work it out ) , And Also that from a new employee entree the required queries and forms are automatically created.

I just being pass to many projects and this one has being taking to much of my time < please let me know if possible and we can work something out
0
 

Author Comment

by:chiefmic
ID: 35186130
the file
0
 

Author Comment

by:chiefmic
ID: 35186397
NOw is small enough lol  CRM-1.zip
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35194003
chiefmic,

what is the purpose of this db application?

why do you have forms for each employees?, you only need one.
0
 

Author Comment

by:chiefmic
ID: 35194335
Thats where I drop the ball ,

Because I couldn't actually make it work as I want it , (auto creation of forms and stuff) I just work around it and produce a master copy to be added manually ,

The purposeis a crm where each employee can enter the data for new customers and the followed it up , so in each entry they put the details of the customer and it show them where are they , if its waiting , or due ,etc....
I need to know the entries for each employees because some have different functions , and Im work to sort how can i make  , for examples , Sales take care until contract is sign them automatically goes to admin and founding , and after they are done automatic service providers , ( all part of the company ), But im stock in this now . any Ideas??
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35194458
the first thing that you need to do is to add a field to your table that will hold the name of the employee responsible or who created the record.
do you follow so far?
0
 

Author Comment

by:chiefmic
ID: 35194534
IM going to upload one with a bit more data in it so you can see what aI mean
0
 

Author Comment

by:chiefmic
ID: 35194569
0
 

Author Comment

by:chiefmic
ID: 35194579
Sorry, Yeah I created the employee column in my table
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35194593
what is the table?
0
 

Author Comment

by:chiefmic
ID: 35194615
TBL_CRM
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35195146
what is the name of the field that you added?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35195231
chiefmic,
you should not post your email address here..  click on the Request Attention above and ask to remove your email address
0
 

Author Comment

by:chiefmic
ID: 35195518
Capricorn1, the name of the field is employee name
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35195556
see this link and download the sample template.
see how the table were designed

http://office.microsoft.com/en-us/templates/CT010142824.aspx?av=ZAC&AxInstalled=1&c=0#ai:TC001225343|
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 35195561
0
 

Author Comment

by:chiefmic
ID: 35195665
Yeah they are really helpful I guess the best way is to modify one the templates to suit me , and drop the crm .

Still heaps work to do , thanks for you help .

Although Perhaps a Switchboar its all its need it ?
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question