Search results

  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
  16. L

    creating a search form

    Try this one... you should be able to pick user OR put in a date or both... I still think you need to take a look at the date format though...the date on the "EnteredOn" is a different format than that of MeDate.
  17. L

    On Current Error 3075

    Got it sorted out...had something to do with one of the table having "duplicated OK" when it shouldn't have.
  18. L

    Unwanted parameter for report

    Are there any labels or headers on the report that has a reference to a parameter?
  19. L

    On Current Error 3075

    Hey missinglinq, I recieved and email notification that you commented on my "On Current Error 3075". when I looked at the forum it isn't here. Any who...I was using the Nz() function wrapped around the Dlookup(). My problem is that the combo boxes won't show the value when navigating back...
  20. L

    creating a search form

    It has to be an issue with the date format. I added the Date/time "EnteredOn" to the query and changed the search code to look for that and it ran fine. The EnteredOn date/time is formatted as MM/DD/YYYY Then MeDate date/time is formatted as DD/MM/YYYY See attached database.
Top Bottom