Search results

  1. P

    ReportSpecs MDE Source Code

    I added PtrSafe keyword to all Declare statements and decided to give it a try before I moved on to LongLong/LongPtr replacements. It seems to work without issue. Is this because I just happen to be lucking out with numbers that do not exceed 32-bit? Declare statements: Private Declare PtrSafe...
  2. P

    ReportSpecs MDE Source Code

    Steve graciously provided me with the source code! Is there a way to upload it here for the next poor sap to come looking for it? Now for the fun task of making all of the API calls in both the Report Utilities and ReportSpecs 64-bit compatible. I'll post my progress (and requests for aid) here.
  3. P

    ReportSpecs MDE Source Code

    Well then, I'm optimistically hoping it will just work if I do that as well. I was able to run it with Access 2016 32-bit. Did you download the A2K version? I figured I'd end up having to do this in the end but thought I'd try the easier softer way first.
  4. P

    ReportSpecs MDE Source Code

    Not yet, that's my next hurdle. I was optimistically (foolishly) hoping it would just work if I just stuck "PtrSafe" in front of all of the "Declare" statements.
  5. P

    ReportSpecs MDE Source Code

    Is there a way to programatically call on the database documenter? Yes, those are the Report Utilities I am referring to. The source code for Report Utilities is provided but they rely on an MDE, which is compiled with Access 32-bit. The source code for this MDE is not provided, presumably...
  6. P

    ReportSpecs MDE Source Code

    This utility is simply used to determine the top margin, bottom margin, right margin, left margin, paper size, user paper width, and user paper height of a report. I'm hoping I can find another method of determining these details without too much difficulty.
  7. P

    ReportSpecs MDE Source Code

    I have sent an email to Attac Consulting but thought I'd post here as well. However, their website must be quite out-of-date then as it still has Steve Arbaugh listed at the Managing Principal and CEO.
  8. P

    ReportSpecs MDE Source Code

    This is a long shot but I figured I might as well try. I made use of the ReportUtilities suite developed by Stephan Lebans in a project to convert an Access report to Word document. This references ReportSpecs MDE developed by Steve Arbaugh (Attac Consulting). It worked perfectly and saved me...
  9. P

    Tab Index Not Being Respected

    So simple... Private Sub OriginalBalance_Exit(Cancel As Integer) Address.SetFocus End Sub Thank you. I love taking over projects.
  10. P

    Tab Index Not Being Respected

    I have a form that jumps from Tab Index 25 to Tab Index 33 even though there are controls with Tab Index 26, 27, etc. Tab Stop is set to Yes for the skipped controls. Any ideas?
  11. P

    Suppress "missing reference" error caused by referenced MDE

    I was thinking I'd have to run regsvr32 or the like, I didn't realize it was as simple as placing the DLL in the application folder.
  12. P

    Sizing an Access report, opened as acDialog while the main window is hidden

    I tried that originally but found that though a popup form is not hidden with the main Access window, a popup report is. The only way I found to have a report persist when the main Access window is hidden is opening the report with WindowMode set to acDialog.
  13. P

    Suppress "missing reference" error caused by referenced MDE

    How would I go about installing OWC10.DLL? My application is deployed on multiple computers so, unless I can just include OWC10.DLL with the application, installing it probably isn't viable. EDIT: I downloaded OWC10.DLL from Fix4Dll and placed it in the same folder as my application. Voila, the...
  14. P

    Suppress "missing reference" error caused by referenced MDE

    I am referencing an MDE file (for which I do not have the original source) in order to utilize some of its contained functions. The MDE is referencing a discontinued library (OWC10.DLL version 1.0), causing a missing reference error every time I open the code editor. Fortunately, absence of...
  15. P

    Sizing an Access report, opened as acDialog while the main window is hidden

    I already asked this question on Stack Overflow but received no responses. I just came across this forum so thought I might have better luck here. I am utilizing forms and reports from an old Access database in a C# application. I do this by launching the Access database, hiding the main...
  16. P

    VBA Syntax: IF variable is NOT in list

    This is so much better! I really didn't like having an empty case when only taking action if desired the condition is met.
  17. P

    VBA Syntax: IF variable is NOT in list

    I realize this thread is many years old but I am replying for anyone that comes across this in the future. The solution posted by Taruz will not actually work as "Not" cannot be used in this way. The workaround is as follows: Select Case MyVar Case String1, String2, String3, etc...
Back
Top Bottom