chiefmic
asked on
combo box to open a form from the switchboard
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 ?
Select Combobox 34
Case "Name "
strDoc = "form name "
Case Else
end select but nothing happenes
suggestions ?
ASKER
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
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
ASKER
the name (a lis now ) is list38 ,
nad th ecodes were in the evenr private sub list38 afterupdate
nad th ecodes were in the evenr private sub list38 afterupdate
ASKER
sorry I have my right hand with stiches so its a bit harder to write properly , if you cant understand please let me know
ASKER
forgot to mention im working from the swithcboard
better if you upload a copy of the db.
ASKER
can i email it to you ?
ASKER
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
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
ASKER
the file
ASKER
NOw is small enough lol CRM-1.zip
chiefmic,
what is the purpose of this db application?
why do you have forms for each employees?, you only need one.
what is the purpose of this db application?
why do you have forms for each employees?, you only need one.
ASKER
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??
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??
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?
do you follow so far?
ASKER
IM going to upload one with a bit more data in it so you can see what aI mean
ASKER
with data
-CRM-Database2007.zip
-CRM-Database2007.zip
ASKER
Sorry, Yeah I created the employee column in my table
what is the table?
ASKER
TBL_CRM
what is the name of the field that you added?
chiefmic,
you should not post your email address here.. click on the Request Attention above and ask to remove your email address
you should not post your email address here.. click on the Request Attention above and ask to remove your email address
ASKER
Capricorn1, the name of the field is employee name
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|
see how the table were designed
http://office.microsoft.com/en-us/templates/CT010142824.aspx?av=ZAC&AxInstalled=1&c=0#ai:TC001225343|
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
Still heaps work to do , thanks for you help .
Although Perhaps a Switchboar its all its need it ?
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