By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

dialog box

100+
P: 140
hi all,

help me
i ve person name repeated so many times in my table. while loading the form i want a dialog box has to open and i ve to enter a name on that. then it has to display all details abt her work. is this possible.

suggestion and help with codes yeah
Nov 13 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
hi all,

help me
i ve person name repeated so many times in my table. while loading the form i want a dialog box has to open and i ve to enter a name on that. then it has to display all details abt her work. is this possible.

suggestion and help with codes yeah
All you need is a form based on the table showing all records.

Another form with a combobox (cboUsers) listing all users with a unique id (PK of the table ideally) field hidden.

Then behind a command button (cmdFindUser) put the following code:

Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub cmdFindUser()
  3.  
  4.   DoCmd.OpenForm "First Form Name", , , "[UserID]=" & Me.cboUsers
  5.  
  6. End Sub
  7.  
  8.  
Nov 13 '06 #2

100+
P: 140
All you need is a form based on the table showing all records.

Another form with a combobox (cboUsers) listing all users with a unique id (PK of the table ideally) field hidden.

Then behind a command button (cmdFindUser) put the following code:

Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub cmdFindUser()
  3.  
  4.   DoCmd.OpenForm "First Form Name", , , "[UserID]=" & Me.cboUsers
  5.  
  6. End Sub
  7.  
  8.  

this master form showing all the details. there i placed the command-

cmdfinduser.

and create seperate form with combobox. then i placed the code behind the

command-cmdfinduser


Private Sub cmdFindUser_click()

DoCmd.OpenForm "searchuser", , , "[Person]=" & Me.cbouser

End Sub

compile error is coming. method or datamember not found

pls help and sort out the problem yeah
Nov 14 '06 #3

100+
P: 140
this master form showing all the details. there i placed the command-

cmdfinduser.

and create seperate form with combobox. then i placed the code behind the

command-cmdfinduser


Private Sub cmdFindUser_click()

DoCmd.OpenForm "searchuser", , , "[Person]=" & Me.cbouser

End Sub

compile error is coming. method or datamember not found

pls help and sort out the problem yeah

its working now..

i ve placed the cmd in searchuser form. and i ve given ID.

thank u
Nov 14 '06 #4

100+
P: 140
its working now..

i ve placed the cmd in searchuser form. and i ve given ID.

thank u
hi its working but only detail is coming at a time
since i ve repeated names in my table. when i enter name as"pinky" in the combo it should display all the work he did. how to do that.

help me
Nov 14 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
hi its working but only detail is coming at a time
since i ve repeated names in my table. when i enter name as"pinky" in the combo it should display all the work he did. how to do that.

help me
You've repeated the names but only one UserID

If you want to go back to using the name you just need to surround it with single quotes designating text as follows:

DoCmd.OpenForm "searchuser", , , "[Person]='" & Me.cbouser & "'"
Nov 14 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.