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

I want to open a specific form

P: 3
Hi:

The data base (access 2003) I am creating will have 150 employee files in it. I want to open a form to edit employee information. ie, if employee john smith gets a pay raise i want to edit his form to change the data. I have been able to open the table using a macro but not the form. I am a total novice with access but I have been able to use the wizards to create the file. Any help you can offer will be greatly appreciated.
Dec 13 '06 #1
Share this Question
Share on Google+
9 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi:

The data base (access 2003) I am creating will have 150 employee files in it. I want to open a form to edit employee information. ie, if employee john smith gets a pay raise i want to edit his form to change the data. I have been able to open the table using a macro but not the form. I am a total novice with access but I have been able to use the wizards to create the file. Any help you can offer will be greatly appreciated.
Do you want the form to open on database startup or from another form?

Mary
Dec 13 '06 #2

anukagni
P: 53
How much field your table have ... If your using less the 12 field the can us the sub-form to get the employee data and do the modification..

If so reply we will give the solution...

or go to this link to get some example to get the result

http://www.databasedev.co.uk/forms.html
Dec 13 '06 #3

NeoPa
Expert Mod 15k+
P: 31,186
Firstl, I would store each employee data in a single record each within a single table (files don't really come into it in a database).
Have you looked at the form wizard and creating a form based on that table?
You may find this will give you most of what you need.
Dec 14 '06 #4

anukagni
P: 53
IF ur using only one table to store all the data's of the employee
then in an from put an combo box which lise on employees name the designation which ever you feel mandatory . Then create a query with the field which you want to edit or you can use all the fields and in the query give the expression [Forms]![your from]![your combo box] - Your combo box must be the last combo box whichi your using . if your using Employee Name & Designation then you have to use Designation in the query.. did u understand.

Then in the create an sub-from from the Query ..the save the table which ur going to modified... if ur not able to understand reply to us..


anuk agni
Dec 15 '06 #5

anukagni
P: 53
hi,

Take a look the screen shot which iam using for editing inventory ..this form is using in intranet also..

http://anuk.about.tc/shot.jpg


anukagni
Dec 15 '06 #6

P: 3
Thanks to all. I got it working using a combo box in the form. I doubt I will ever be an expert in MS Access but this forum is great and I have already learned a ton.

Thanks again, Don
Dec 16 '06 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks to all. I got it working using a combo box in the form. I doubt I will ever be an expert in MS Access but this forum is great and I have already learned a ton.

Thanks again, Don
You're welcome Don.

Glad you got it working.

Mary
Dec 16 '06 #8

anukagni
P: 53
well you have to ask lots of question , which will keep our mind refresh..
Don't think any question is worse every question make some one sharper

Keep your tempo hoist
have a nice day


anukagni
Dec 16 '06 #9

NeoPa
Expert Mod 15k+
P: 31,186
Never assume you won't master a subject.
Everything looks more complicated when you first start with it.
Come back and remind me of this after you've posted your first hundred :).
Dec 16 '06 #10

Post your reply

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