Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GodofSmallThings

    Create Bulleted list using XSL

    Beautiful... Thanks for clearly explaining the process and taking time to write out the code! Excellent work!! GodofSmallThings
  2. GodofSmallThings

    Create Bulleted list using XSL

    Mulligh, For every item in Inventory. I want the items under DESCRIPTION to render as a square bullete. (The above sample code shows only one item in inventory). - GodofSmallThings.
  3. GodofSmallThings

    Create Bulleted list using XSL

    Hello, Having difficulty rendering bulleted list using XSL. Here is a sample of the code. <INVENTORY> <ID>000001</ID> <ITEM>CAMERA</ITEM> <DESCRIPTION> <P>WAVEFRONT SENSOR</P> <P>SEGMENT PHASING</P> <P>ROTATOR</P> <P>PARTICLE...
  4. GodofSmallThings

    Struggling with txtBox and Subform....

    Hello, I have a form that contains a txtbox and a subform. The subform displays all available training titles. It contains 3 fields. DocNumber, Name, and Select. The Select field is a Checkbox (yes/no) I would like the subform; in addition to showing all available titles; mark selected...
  5. GodofSmallThings

    Build A Database...

    Darrylle, Thanks, glad to see that you agree! It would be great if I could look at &quot;open source database&quot; and say hey; I like that particular method and then &quot;click on a link&quot; and see all the possible solutions. Or vice of versa.... Everybody or only the &quot;Top...
  6. GodofSmallThings

    Can anybody help me combine the f

    Hello again, I have 3 tables. Department, Requirements, and Training. (The Requirements table joins the Department and Training) I created a form that has a combobox containing Departments that shows relevant Training titles in a subform. I would like to create a cmd button to open a popup...
  7. GodofSmallThings

    Combine....

    Darrylle, Thanks for your help. It works, but the whole process is cumbersome. I need a more efficient way of marking selected records, displaying those marked records with the total records, and then removing the marks. ...I'm developing a training database. It contains 3 tables...
  8. GodofSmallThings

    Build A Database...

    Hello, It would be great if TEK-TIPS built a working database with all the tips and suggestions applied. That way you could visualize how a particular question, suggestion or tip was implemented. Even better, an open source database, where you could collaborate on a particular problem or...
  9. GodofSmallThings

    Combine....

    Hello, Can anybody help me combine the following into one SQL statement: UPDATE qryDepts RIGHT JOIN qryTraining ON qryDepts.TrainingID = qryTraining.TrainingID SET qryTraining.[Select] = Yes WHERE (((qryDepts.Department) Is Not Null)); And.... SELECT qryTraining.[Select]...
  10. GodofSmallThings

    Can anybody help me combine the f

    Can anybody help me combine the following into one SQL statement: UPDATE qryDepts RIGHT JOIN qryTraining ON qryDepts.TrainingID = qryTraining.TrainingID SET qryTraining.[Select] = Yes WHERE (((qryDepts.Department) Is Not Null)); And.... SELECT qryTraining.[Select], qryTraining.DocumentNo...
  11. GodofSmallThings

    Update Query

    Hello, I have 3 tables. Department, Requirements, and Training. (The Requirements table joins the Department and Training) I created a form that has a combobox containing Departments that shows relevant Training titles in a subform. I would like to create a cmd button to open a popup form to...
  12. GodofSmallThings

    Preview Report based on Option Group Selection

    Hello, I've wrestled with it, but I get the following message: The Microsoft jet database engine does not recognize &quot;PREMIUM&quot; as a valid field name or expression.&quot; .......Perhaps this would help? The following is an SQL view of the query that the report is generated...
  13. GodofSmallThings

    Preview Report based on Option Group Selection

    Hello, I'm on the trial by error training program. I am not familiar with the debug tools. However, the old school method of printing varibles before execution gave me some glaring clues to this problem. ...I was referencing the wrong Select Group. Once I corrected; another problem...
  14. GodofSmallThings

    Popup Form Based on Current Record in Subform

    Hello, Didn't realize anybody responded. I tried both statments to no avail. When I click the button an error message prompts the Following: Microsoft Access can't find the field 'frmPaperSubform' referred to in your expression. I have since edited the forms since my last post the...
  15. GodofSmallThings

    Preview Report based on Option Group Selection

    Hello, I would like to preview a report based on an Option group selection. The selection is based on [CATEGORY] from my report. The report is generated from a query... The following is code from the Command button on my Preview Menu Form: Private Sub btnPreviewReport_Click() On Error GoTo...
  16. GodofSmallThings

    Popup Form Based on Current Record in Subform

    Need assistance with the following Click event: strDocName = &quot;Paper&quot; strLinkCriteria = &quot;PaperID = Forms!Type!PaperSubform1!PaperID&quot; DoCmd.OpenForm strDocName, , , strLinkCriteria When I run the form It prompts with a message box: &quot;Enter Paramater Value?&quot; When I...
  17. GodofSmallThings

    Filiter Selection....

    Your solution works! I can select PaperType via (Textbox) and have the results properly displayed in the subform (tblPaper) I then created a COMBOBOX and was able to get the desired results!!!!!!!! THANKS FOR HELPING!!!!!!!!!!!!!!! I REALLY APPRECIATE!!!
  18. GodofSmallThings

    Filiter Selection....

    Having difficulites. When I plug in TYPEID in &quot;linkchildfields and masterfields&quot; and then run the form - it prompts with &quot;TYPEID?&quot; When I complete the response all the records for paper are listed in the subform. There is no functionality in the combox - other than the...
  19. GodofSmallThings

    Filiter Selection....

    I understand what you are saying. My tables are linked by TYPEID. However, when I recreate the subform - it does not prompt with &quot;find record based on the value selected in combobox&quot; ....I'm not sure if I'm implementing it correctly? Please advise... Thanks in advance...
  20. GodofSmallThings

    Filiter Selection....

    I have two tables. Paper and Paper Type. For the paper table I created a subform and placed it on a tab control. I would like to filter the form using the Paper Type table as a combo box. ....Do I have to create a query? What is the best solution to this problem??? Your help would be...

Part and Inventory Search

Back
Top