Search results

  1. A

    application.currentproject -- I want a remote project

    I can use application.currentproject for the current project but I want to refer to a different project so I can use .allforms How would I do this?
  2. A

    Auto-suppress/click-through Access startup msgs?

    I am unable to find this sample -- where might I locate it?
  3. A

    Auto-suppress/click-through Access startup msgs?

    Is there a way to ensure processes only run if one user is involved, and that anyone else who tries gets booted?
  4. A

    Auto-suppress/click-through Access startup msgs?

    Yes -- everything is compacted on close, FE/BE separated. The problem is that people lock up the tables or interfere with compact processes /etc and sometimes the errors crop up and ruin other automations.
  5. A

    Auto-suppress/click-through Access startup msgs?

    Yes, plenty of compacting -- but sometimes the errors crop up unexpectedly (via corruption) and we need to fix them appropriately through automation when the databases are run.
  6. A

    Auto-suppress/click-through Access startup msgs?

    Sometimes when opening an Access db you get an immediate message -- sometimes a fatal error"has occurred during the last usage ("caused a serious error the last time it was opened"), or the message that you get when opening Access for the first time. Is there any way to auto-confirm these...
  7. A

    Access VBA FTP uploader

    I have scoured the web far and wide but to no avail. I want something so simple but everything I find either doesn't work or is overly complicated. I simply want to pass a function: 1. Name of server 2. Name of current directory and relevant file to upload 3. Location on server to upload file...
  8. A

    Any way to merge PDFs?

    I am unfortunately using Citrix
  9. A

    Any way to merge PDFs?

    That code seems to require Adobe unfortunately, but I appreciate you taking the time
  10. A

    Any way to merge PDFs?

    Both with and without Adobe Full installed?
  11. A

    Create a zip file

    Is there an easy way to zip a folder? Google is not helping much
  12. A

    Create a zip file

    How would I do this in terms of syntax? Say I have a string, filepath = the path of the file I wish to add to a zip, zippath.
  13. A

    Create a zip file

    I have a loop that iterates through files -- how can i create a zip file containing everything within this loop?
  14. A

    acoutputreport question

    So if I put that line in the Open event, and I have a separate function that does the outputto command, how do I pass in that sql string?
  15. A

    acoutputreport question

    That might work -- how can I change the recordsource of the report dynamically?
  16. A

    acoutputreport question

    I have the square brackets already -- but I don't want this to be a user-input execution. The query is dynamic, as I don't want to make a billion separate reports for exporting each type of what I need. I simply want to be able to pass in a value for the variable in the code. I have an array...
  17. A

    acoutputreport question

    I have a parameter in the recordsource that the Report draws from, where it basically ends with: "Where field=[Input]" I just want to be able to programatically/automatically pass in what I want [Input] to be when I output this report.
  18. A

    acoutputreport question

    DoCmd.OutputTo acOutputReport, "Report_Name", acFormatSNP, "C:\somepath\filename.snp" The line above is outputting a snapshot, but the report is based on a query that depends on user input. That is to say, when I try to run this, it'll prompt me to enter in a value for the variable "Input" so...
  19. A

    Excel Solver can't solve nonlinear equations?

    I have a system where I can solve it with Assume Linear enabled and without a certain constraint, but when I enable said restraint, it suddenly says that Linear Model is not satisfied. However, unchecking that box makes it so it can't find feasible solutions, yet I know they exist because I can...
  20. A

    rs showing values as null even though they're in the query output!

    Before I was using Dim rst As ADODB.Recordset, but the switch to Dim rst As DAO.Recordset fixed it.
Back
Top Bottom