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!

Recent content by childrenfirst

  1. childrenfirst

    Checkbox headache...

    Hi, The checkboxes in the subform are under a column called "delete", and after users select which record they want to delete from the record table (there are two columns in the record table, one is called Delete, and the other is called Approved. Both columns are needed for other reasons.)...
  2. childrenfirst

    Checkbox headache...

    Hi, I am sure that it's a simple question to all the experts on this site. I have a subform that is a continuous form which returns records from a SQL stored precedure. Each returned record has an associated checkbox,txtCurRec, in the subform. The checkbox's control source is set to be...
  3. childrenfirst

    how to pass the scope_identify value back to Access form?

    Hi, I have a stored procedure that runs after Access form passes the global variables to SQL. New records will be inserted into a SQL table at the end of the stored procedure and the primary key for the table is an auto-id. I would like to pass the auto-id inserted into this SQL table back to...
  4. childrenfirst

    How to display a "Timer" in Access as SQL is running in the back?

    Hi, I am not sure that this can be done in Access Project... I have a search form created in Access, and when users click on a command button, the event will launch the SQL stored procedure to search for results based on the search criteria. Search results will be returned to a different...
  5. childrenfirst

    How to update control's value before running the stored procedure?

    Oh my goodness. It's finally fixed... I modified the line of code to Forms!frmAuditList.subfPreviewNewList.Form.RecordSource = strList and the system was able to find the second form and the subform and return the records, strList, to the subform. Thank youuuuuuu all for brainstorming with...
  6. childrenfirst

    How to update control's value before running the stored procedure?

    Hi IGPCS, Thank you for clarifying it for me. I have a silly question: the stored procedure returns multiple values (for example, report number, employee name, record date and etc.), and there are also multiple fields in the subform (for example, report number, employee name, record date and...
  7. childrenfirst

    How can I pass multiple values for a single parameter?

    Hi, I am not sure if it can be done. I have a form which shows several records. Users get to check the checkbox associated to each record if they want to delete the record. After users click on a command button on the form, the on click event is supposed to pass the ID number of any (can be...
  8. childrenfirst

    How to update control's value before running the stored procedure?

    Hi IGPCS, I added a line of code, MsgBox strList to show the value of strList, and the message box shows Exec s_ViewAuditList 2 (Note: 2 is based on the report number I selected on the first form) So, it seems that strList is grabbing and passing the parameter correctly to the stored...
  9. childrenfirst

    How to update control's value before running the stored procedure?

    Hi Randall, Could you post the exact code you tried that worked since there are different suggestions to my question and I am a little bit confused now...? Thank you very much!
  10. childrenfirst

    How to update control's value before running the stored procedure?

    Hi IGPCS, Thank you for the suggestion! I replaced my Me!subfPreviewNewList.Form.RecordSource code with your suggestion but it did not work. The stored procedure returns values for multiple fields, and that's why I wrote the vba code to pass records to the subform instead of value to a...
  11. childrenfirst

    How to update control's value before running the stored procedure?

    Hi Randall, Thank you for your idea:) I guess I need to fix the data source in the properties of the subform. Can you make some suggestion? What should I enter in RecordSource in the subform's Properties in order to show the results from the executed stored procedure? Thanks a bunch!
  12. childrenfirst

    How to update control's value before running the stored procedure?

    I run these code in a private sub on click of a command button in the first form.
  13. childrenfirst

    How to update control's value before running the stored procedure?

    Hi IGPCS, Thank you for the idea! I thought about that before but I got stuck when I tried to pass the result from the stored procedure executed in the first form, frmMain, to the subform in the second form, frmList. Part of my current code in the first form: Dim strList AS String strList =...
  14. childrenfirst

    Is it possible to get the value for another form?

    Hi all, Thank you for all your help! DMaxt worked out perfectly! Thank you, PHV, and of course, other ideas! Happy holiday:D

Part and Inventory Search

Back
Top