|
hi friends
i am working on ms access front end, i have Edit form which cotains a combo box this combo box is bound with a table named Department, this combo box have names of departments which have entered in the table, i want at run time when i select a department name from this combo box other information related to this department will be display in respective text boxes of the form.
i am using the following code it gives a etrror there
Private Sub cmbSectorName_Change()
Dim rst As ADODB.Recordset
Dim ch As String
ch = cmbSectorName.Value
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic
txtDeptDescr.Text = rst.Fields(0).Value
rst.Update
rst.Close
Set rst = Nothing
MsgBox "Data Has Shown Successfully"
End Sub
when i change selected name of the combo box it gives error "No Value given for one or more parameter " and get focus to this line fo code
rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic
friends kindly can soem help me
and second this it that after this i want to allow user to change soem information of this selefcted department and then on click event of Edit button it will updeated in data base
i need ur help regarding these two problems may u guide me
regards
Farooq Azam
|
|
|
|
|
Hi,
I am facing prob in searching a perticular text in a web page. I need some help.
Kashif Ashfaq
|
|
|
|
|
We need more information before we can help you.
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Why should you be considered for the job? (i.e. what benefit can you bring ...(continued)
This is the interview question can u give me some opinions??
|
|
|
|
|
You have got to be !@#$%^& joking?
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
If you are going to post all your interview questions why do you post them one at a time? Just post the whole thing and be done with it.
/Johan
|
|
|
|
|
Shouldn't someone ban or at least restirc acces for a month to this user??
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
So why are you replying to me? I'm not the guy who posted this stupidity.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
Sorry, I guess I pressed the wrong post. My mistake, I won’t do it again, please forgive me for this if you can possible find it in your heart to do so.
|
|
|
|
|
I will, but only if you can forgive me for my impatient replies.
This guy has really stirred me up.
Cheers.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
Beacuse I don't know anything about the job, so that I have to ask questions on forums even to be able to fill in the interview form.
---
b { font-weight: normal; }
|
|
|
|
|
pankajgarg12 wrote: can u give me some opinions
If you can't fill this question in yourself, toss the application in the trash and walk away.
Only YOU know if your bringing any skills to the project they can use.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
If I have a programming question, where would I look for help and in which order...
a. Visual Studio Help
b. MSDN website
c. Google search
d. Your workmates
e. The Code Project
f. all of the above in that order
|
|
|
|
|
If I were going to ask stupid questions, where would I post them???? Let me see....
Come on dude, get real.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
1. Google
2. Google
3. Google
4. Google Groups
5. MSDN
6. Workmates
7. Alternate solution
8. Code Project (so far no need to reach this stage)
|
|
|
|
|
In what order?? You're kidding, right?
Do you not know how to do research or tech yourself stuff? You absolutely need this skill if you're going to be a developer, at any level. If you don't have it, your peers are not going to waste their time doing it for you, in ANY job.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: In what order?? You're kidding, right?
Do you not know how to do research or tech yourself stuff? You absolutely need this skill if you're going to be a developer, at any level. If you don't have it, your peers are not going to waste their time doing it for you, in ANY job.
The questions seem like some kind of obscure homework, or maybe pre-job interview testing. Either that or the guy is just taking the piss
Michael
CP Blog [^] Development Blog [^]
|
|
|
|
|
I think your right. I'm guessing it's an application for a job placement, or contract, service that specialized in IT. Or it's part of some "professionalism" lesson or class in some IT ciriculum.
Either way, I think he'll be doing research on "You want fries with that?" next year.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
No, Steve Pullan was kind enough to help this guy when he asked for some typical interview questions[^]. He theen proceeded to take all the example questions Steve provided and posted them, individually, as threads with the title "problem".
This guy has 3 hopes of getting a job; bob, no, & cape of good.
-- modified at 8:34 Wednesday 12th April, 2006
|
|
|
|
|
How should I test a new assembly??
|
|
|
|
|
Mate, I answered your original question re: interview questions in a respectful and honest manner. [See this thread: original post re: interview questions[^]]
Seems like I was incorrect in judging your reasons for the questions in the first place.
If you are for real, then really, there is no hope of you passing any interview - forget it - go dig ditches for a job.
If on the other hand you are stirring me, then I have legitimately fallen into the trap and have only myself to blame.
Either way, you've done your lot with me and AFAIC you can RTFM.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
-- modified at 2:23 Wednesday 12th April, 2006
|
|
|
|
|
Go back to Programming 101. You develop a set of tests at the same time you write the code. There's even a great argument for writing the tests BEFORE you write the code it's going to test.
If a function is expects to return values between this and that, the you script your test to try input values that are inside and outside of the range of inputs that the function expects to see what its output would be. You especially try input values on the "border" of what the expected input and output limits would be.
If you function epects an input value of 0 to 99, what happens when the function gets a negative number? What happened at -1, 0, and 1? What happens at 98, 99, 100? What happens with excessively large and excessively small numbers? Is the output of the function as expected?
If you can't figure this out, toss the job application in the trash now. You're not ready...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
When, if ever, should we force the garbage collection to run??
|
|
|
|
|
Please don't cross post.
Please don't spam the forum.
---
b { font-weight: normal; }
|
|
|
|
|
Why should we not use global variables??
|
|
|
|