Recent content by lcook1974

  1. L

    Embedd picture in Report

    Hi, I have a database "report" that is actually a letter head statement that will be sent to different hospitals based on the donor and different procedures completed. There will be a total of 6 people using the database. What I want to do is have a "hidden" picture of their signature and...
  2. L

    Subform reference

    Thanks GalaxiomAtHome...I think my head me explode but I get it. sort of...I may have to read it again and again to get it to sink in. :D
  3. L

    Subform reference

    I'm not totally sure...I would suspect it has something to with the fact they aren't "linked" to the main form. This tells Access exactly where to look: Forms!frmMasterSales!sbfUser_Default!chkCustomerCo ntactInvalidDefault=True This is using "Me"..which I would assume "me" is...
  4. L

    using a form to update a listbox

    Does that form write directly to the table? What you need to do is requery "another" form when that form closes... So after DoCmd.Close acForm, "Add Cart", acSavePrompt Add Forms!Mainform.Form!ControlName.requery I use this code because I'm requerying a subform and it works fine where...
  5. L

    Multiselect Listbox and Reports

    Is the table linked to another table in the query?
  6. L

    using a form to update a listbox

    so the form that pops up...what do you have behind the "Close" button? it's a completly seperate form from the one that listbox is on correct?
  7. L

    Unwanted parameter for report

    Glad you got it worked out! This forum is fantastic...you can find just about everything you need here.
  8. L

    using a form to update a listbox

    compact and repair the DB...see if that reduces the size.
  9. L

    using a form to update a listbox

    Did you put it in a zip file? There's a 'size' limit for uploads.
  10. L

    Subform locked out

    Can you post a sample db?
  11. L

    using a form to update a listbox

    Can you post a sample DB?
  12. L

    using a form to update a listbox

    Try putting a button that will close the form with that code behind it. Not sure it it will work on the On Exit event. Forms!Mainform!ControlName.requery
  13. L

    else without if error

    Are you using the bound column in the "IF" statement containing cmb_Greeting1?
  14. L

    using a form to update a listbox

    When they close the form you need to "requery" the listbox. something like: DoCmd.close forms!formname!listboxname.requery http://access.mvps.org/access/forms/frm0031.htm The link above is a great reference. Larry
  15. L

    Subform reference

    here's a good reference for that sort of stuff. http://access.mvps.org/access/forms/frm0031.htm
Back
Top Bottom