Chooser Form

**rivergum23** · rivergum23, March 23rd, 2009 08:37 AM

Hi Ben,

Can you help me with this one....

Since we've (more like AOG123

)have added this command button and the code to enable the button when the skills avail. table is empty we have created a bug that does the following.

If you enter "Roofing" or any other skill into the scan box and press enter it actually adds the Roofing skill as it should, but also navigates to the next record?? Not sure how to fix this bug??

Also, while I have got you is it possible to add a button that clears the EmployeeID and EmployeeName field boxes and enables you to enter a new
EmployeeID and EmployeeName??

Any help much appreciated.

Brett

**sbenj69** · sbenj69, March 26th, 2009 12:03 PM

Heh, picked a bad week to ask me..... we are doing a major version upgrade of our software at work this week, plus our company is opening another location, in which I'm responsible for setting up. I will have an answer to this this weekend. In a previous example, I set up a blank unbound textbox as the tab index after the scan box (and set it to invisible), then on focus, I setfocus back to the scanbox. Don't ask me, it was a weird deal..... after doing the insert, it went to next record..... As far as being able to change the name or add a new one, that's simply a matter of unlocking and enabling those fields, and adding a standard button to add records (thru the button wizard).

**rivergum23** · rivergum23, March 27th, 2009 04:17 AM

Hi Ben,
Look hold off on this one as I think I have almost sorted these problems out. Stay tuned as I may still come unstuck yet

.

Cheers,
Brett

**sbenj69** · sbenj69, March 27th, 2009 11:54 AM

ok, keep us informed as to the resolution.

Thanks,

benji-

**rivergum23** · rivergum23, August 20th, 2009 08:19 AM

Hi Ben,
Wondered if you could help me out with reporting for this never ending DB I am creating. I'll explain using your program and reverse engineer it to mine if you can help.

What I want to know how to do (if its possible) is to be able to click a button on the Form page and run a report that will tell me what skills that person has that I'm currently viewing on the form page in a report.

So basically, the report will display;
------------------------------------------
Employee ID: 303
Employee Name: Bob Builder

Skills Possessed

Roofing
Electrical
Plumbing
------------------------------------------
Sounds easy I know, however I'm not much good at designing quires to give me the information I require which of course is the base of the report(s).

Can you shed any light on this? or anybody else out there perhaps??

Any help much appreciated.

Cheers,
Brett

**AOG123** · AOG123, August 20th, 2009 09:25 AM

This is relatively straight forward, the existing skills possessed query is referencing the current emp id of the form, [forms]![formmain].[employeeid]

Paste this into SQL view in a new query, then base your report on it,

Code:

SELECT tblEmployees.EmployeeName, tblEmployees.EmployeeID, SkillsPossessedQuery.SkillDescription
FROM tblEmployees INNER JOIN SkillsPossessedQuery ON tblEmployees.EmployeeID = SkillsPossessedQuery.EmployeeIDFK;

The layout you require on the report can be achieved by grouping the emp name.

**rivergum23** · rivergum23, August 20th, 2009 06:24 PM

Hi AOG123,
Thanks heaps for your help!! I have been trying to make a new query this morning and keep getting a syntax error. I must be doing what you suggested incorrectly

Could I get you to add this to the database and upload it for me so I can see how to do it and more importantly where I'm going wrong.

You help greatly appreciated

Brett

**AOG123** · AOG123, August 20th, 2009 07:27 PM

hi, see attachment,

regards,

**rivergum23** · rivergum23, September 6th, 2009 04:12 AM

Hi Guys,
Got another question or how to. When I transfer a skill from "Skills Available" to "Skills Possessed" on the form I want to also be able to transfer the "SkillDescrip" as well as the "SkillID" from the TblSkills table.

At the moment when you transfer a skill from the form it adds the SkillID into tblEmplyeeSkills and tblEmplyeeSkills but not the "SkillDescrip". Is it possible to do this?? I have tried myself but are unsure how to capture the description out of the table.

Are you guys able to help. (No doubt)

Thanks Again,
Brett

**AOG123** · AOG123, September 6th, 2009 02:50 PM

Hi,

Your thinking here is not correct, Why would you duplicate the description in 2 tables,

The SkillId is all that needs to be stored as any other relational information in the Skills Table can be returned in a query.

Thread: Chooser Form

LinkBack

Thread Tools

Display

RE: Chooser

RE: Chooser Form

RE: Chooser form

RE: Chooser Form

RE: Chooser

Similar Threads

Time Entry Form

Simple way to email form

Generic Form Handler

filters on a form

Bookmarks

Bookmarks

Posting Permissions