Search results

  1. K

    Resize Form to Original Size

    I have an Access form which is 8" wide and 6" tall. I minimize it. So far, so good. Unfortunately, when I later maximize it, the form fills the entire screen (which I don't want.) How can I get it to resize to its original 8" x 6" size?
  2. K

    MaxDate and Group

    I have the following table (attached): I'd like to create a query that displays the Max(OrderDate) details by Customer: OrderDate Customer ItemNum SerialNum 10/3/2022 Andy 300 323456780 10/3/2022 Betty 900 923456789 I've read a few...
  3. K

    Solved Make button specific backcolor

    I need to change the default backcolor of a button to #22B14C when clicked. How can I do this? Thanks! kenrav
  4. K

    VBA Issues in Windows 11

    I recently upgraded to Windows 11. I'm fully updated and have the latest Office 365 updates as well. Unfortunately, I'm finding that my "DoCmd.SetWarnings True" VBA actions no longer work in all my legacy Access apps. The action still works fine on my Windows 10 and Server 2019 devices. Anyone...
  5. K

    Adobe Integration Issue

    From within my Access app, I've been able to open, edit, save and close a pdf file using the Adobe Acrobat reference. The app had been running great for several months. Recently, the VBA "Save" command no longer saves the pdf. I have verified this issue on multiple devices and similar Access...
  6. K

    Hide 0 results in query

    See attached query. Is there anyway to not show 0 QOH results? Thanks!
  7. K

    Conditional Formatting Issue

    I have an integer, e.g. 240. I convert it to a variant in hh:mm format, e.g," 4:00". I then save this in a field in my table which is formatted as a string. My report (based on my table) displays the value "4:00" in the report field. So far, so good. I was hoping to do some conditional...
  8. K

    CommonDialog Reference Issue

    I'm trying to create a function that lets users to scan a document and save it to a folder. I start with "Dim scanDiag As New WIA.CommonDialog" However, it throws a ""User-defined type not defined" error. I am referencing the Microsoft Office 16.0 Object Library. Thanks for your help. If...
Top Bottom