Search results

  1. D

    Solved VBA returns record number, not value

    Gasman thank you for taking some time to look at it. Ironically it was when pasting in this thread I saw where I was going wrong. I also had multiple columns within the combobox, and was not seeing all i needed. Thank you anway
  2. D

    Solved VBA returns record number, not value

    Gasman I believe yes (I am very rusty at all of this, been a while) The Combo47 box is popuylated from this.... SELECT operators.ID, operators.f_name FROM operators WHERE (((operators.team)=[Forms]![team_setup]![Combo35]) AND ((operators.plant)=[Forms]![team_setup]![Combo39])) ORDER BY...
  3. D

    Solved VBA returns record number, not value

    Hi all, and if you can....HELP! I have a combobox that is auto populated based on 2 other combo boxes. I select department and team number, and it returns a filtered combobox (Combo47) with the results, which is fine. From the resulting combobox, I want to use the value of the selected result...
  4. D

    Solved Report PDF and white space....help!

    Thank you theDBguy, and thank you for all your help. Really appreciate all of you taking the time to help me!! Dan
  5. D

    Solved Report PDF and white space....help!

    sxschech ... you sir are fantastic, and I am an idiot. enlarged footer space was the exact issue. I had previously used it, and then moved content out of it. Man, I feel pretty stupid. As afore-mentioned its been a long while since I have used this program, so much so that I feel extremely new...
  6. D

    Solved Report PDF and white space....help!

    Micron, I am unsure but its not here now! And yes the issue still persists Dan
  7. D

    Solved Report PDF and white space....help!

    Hi guys. Apologies for my late reply have not been able to get back to my pc for a few days. OK so theDBguy... cannot seem to set a custom paper size. If I switch it over to tabular view I get a little more on each page, but still only fill half of each page zeroaccess...I use only the header...
  8. D

    Solved Report PDF and white space....help!

    Ahh....it looks like the PDF view in Print Preview. Do you know how to make it all look like image 1? It feels like if the PDF is shuffling stuff around to cater for pages, then its moving things that do not need to be moved. Some of the shifted items are a couple of line at best and the...
  9. D

    Solved Report PDF and white space....help!

    Hi theDBguy. Image 1 was in report view. Image 2 is how the pdf turned out Thanks
  10. D

    Solved Report PDF and white space....help!

    Hi all. I have not used access in many years and just getting back in to it. Have a slight issue that is very frustrating. So I have a report (images to follow shortly) and it looks ok as a report. However, when I convert to pdf to email it the report suddenly gains a whole lotta white space...
Top Bottom