Search results

  1. Kayleigh

    Report line sizing and textbox alignment

    The vertical alignment works well with individual textbox/labels but if I use 'can grow' option it will throw an error. Not sure if there is any way round this?
  2. Kayleigh

    Report line sizing and textbox alignment

    Good shout! The vertical alignment is excellent - just working on integrating into my project. I would like to try gridlines. Is there any way to specify which borders to display e.g. only left and right
  3. Kayleigh

    Import CSV files into new tables and append

    Hi @Sec3Op41514 I've just read your post here. Did you get sorted?
  4. Kayleigh

    Report image not appearing in Print Preview

    This is a really weird issue because it works on some users PCs and not on others. Generally it works on later versions of Office but one user has Office 2016 but doesn't display. No idea what could be causing this 🤷‍♀️
  5. Kayleigh

    Report line sizing and textbox alignment

    Hi there, I have a report which has a sub-report with a table layout. My issue is sometimes the Item row has more text than fits on the line so using the 'Can Grow' option it will wrap onto the next line. However: 1. the Cost column will remain aligned to the top of the row 2. the dividing...
  6. Kayleigh

    Report image not appearing in Print Preview

    Yes - see attached
  7. Kayleigh

    Task Scheduler not running MS Access fully

    I have this issue where I have scheduled via Windows Task Scheduler to run a MS Access file once a day which triggers a couple of emails. The database works fine when opened by a user HOWEVER when the triggered it will open a locked file and nothing else happens. Also it isn't possible to close...
  8. Kayleigh

    Report image not appearing in Print Preview

    Both image and section is set to 'Always'. And I have tried it not clipped/zoomed. Still no luck☹️
  9. Kayleigh

    Report image not appearing in Print Preview

    I think it may be
  10. Kayleigh

    Report image not appearing in Print Preview

    Unfortunately i have tried JPG, PNG and BMP with no success.
  11. Kayleigh

    Report image not appearing in Print Preview

    Hi there, I have a report which has an image in the header. It will appear no problem in the layout and report view. But not in Print Preview or if output to PDF. Tried compressing image, resizing, convert to JPG etc. Nothing seems to help. This is on MS Access 2016 However it works okay on...
  12. Kayleigh

    Solved Column widths not retaining for datasheet form

    Office 365 It seems to be a bug. The workaround I have found for this is to open the unhide fields dialog box.
  13. Kayleigh

    Solved Column widths not retaining for datasheet form

    Another frustrating issue is I have several subforms which are datasheet view. I would like to expand the column widths but it will not save when I close and re-open. Any workarounds?
  14. Kayleigh

    Drop-down filter in Continuous Form

    I'm looking to implement the functionality of the filter drop-down found in datasheet forms. Is there any option this can be done in a continuous form? Or somehow created? We would use a datasheet but we have some complex formatting requirements which are not possible in that design...
  15. Kayleigh

    Solved Customised Find and Replace

    Thanks. Didn't even know that!
  16. Kayleigh

    Solved How to check for nearest approx number

    Thanks @CJ_London That was exactly what I needed:)
  17. Kayleigh

    Solved How to check for nearest approx number

    Hi, I have a database which calculates quotes for materials required based on the measurements entered (length and width). They now would like to include a table with what they currently have in stock. Then when entering the measurements it should check in the stock table if any length/width...
  18. Kayleigh

    Solved Customised Find and Replace

    Hi I have a simple 'Find' option on a datasheet form. We would like to set by default 'current document' and 'any part of field'. Is this possible?
  19. Kayleigh

    Hide text on focus in continuous form

    Interesting. Will give it a try (y)
  20. Kayleigh

    Hide text on focus in continuous form

    Hi I have a continuous form with alternate row colours (white and grey). I am looking to hide the text in one column when it has focus - usually I would change the text colour to white using conditional formatting. However it would not be transparent in the grey rows. Any ideas of how this...
Back
Top Bottom