Search results

  1. P

    Need code to mkdir,copy xlxs file to it, etc

    JHB....The 'php' file in the 'Client.zip' file that you sent will not open using any win 8.1 program or others that I 'googled' and downloaded that stated that they could do that. Would you please advise or send the contents of the file as something else? tnx sum more.
  2. P

    Need code to mkdir,copy xlxs file to it, etc

    Oh my! when I unzipped the file, it opened as a 'php'. Then, when I 'clicked-on' that file it invoked my app that I use to create web pages (Eversoft's First Page 2006) and I couldn't get any other program to open it correctly via 'open with' selection. Sorry. David: I can use Excel &...
  3. P

    Need code to mkdir,copy xlxs file to it, etc

    Did not know about the 'ref' setting requirement. Did that, which enabled the code to compile error free. However, It does not make a directory nor do anything towards my objective. tnx for your guidance and patience. Not being able to even have 'mkdir' function is perplexing. I've tried...
  4. P

    Need code to mkdir,copy xlxs file to it, etc

    My code doesn't have the 's'. The 's' in my previous reply was a typo. I surely wish that was the solution to my problem. Hell, I can't even get simple 'mkdir' create a folder from Access 2007 in Win 8.1. Tnx for caring, though.
  5. P

    Need code to mkdir,copy xlxs file to it, etc

    When I try to compile, I get "Compile Error: User-defined type not defined" for "Dim appExcel As Excel.Applications" in the code that you provided. If I 'comment' that code out and compile the code, I don't get any error messages. Wondering if the code is correct for the conditions that I...
  6. P

    Need code to mkdir,copy xlxs file to it, etc

    Here is my code for a control (button) on my form called 'mkmybidder'. The xlsx file with the 9 fields that I want to fill from the fields on the form are in 'C:\MyBidder' which contains the unmodified file 'Bidder.xlsx'. I know that my problem is easy for someone who understands all of the vba...
  7. P

    Need code to mkdir,copy xlxs file to it, etc

    By clicking on a form's control, I want the on-click vba code to: 1. Create a new folder named 'L_Name' from the form's 'L_Name' field; 2. Next, copy a 'model' xlsx file in C: to that folder & save it as 'L_Name Roof'.xlsx; 3. Then transfer contents of form fields 'Name...
  8. P

    Form:open a report grouped on 'A' sorted by dates

    Bob, everything you did for me worked exactly as I needed. I agree with you that I need to use more meaningful names. Always planned to do that, later. Just in a hurry to finish. Again, thank you for your dedication to solving my requests. I've learned some more about how to use the db from...
  9. P

    Form:open a report grouped on 'A' sorted by dates

    Thank you Bob for what you did. That fix solved my date sorting problem. I still have to solve the problem where I pick a 'broker' from a combo box list on a form that opens a report that presents all of the records (eg, Broker, Deposit Date & Deposit), but only those deposit records for the...
  10. P

    Form:open a report grouped on 'A' sorted by dates

    Me again, Punice: I discovered what "PM" was and am ok.
  11. P

    Form:open a report grouped on 'A' sorted by dates

    Re your last, where you said "PM coming with email address." Stupid question: what do you mean by that, particularly' by "PM"?
  12. P

    Form:open a report grouped on 'A' sorted by dates

    Hey, no apologies necessary. After all, you are helping me and others at a very affordable price. I just didn't know if I did everything right when I posted my initial help request. I would prefer to email the db to you rather than post it here. Ok. Punice
  13. P

    Form:open a report grouped on 'A' sorted by dates

    I didn't answer this, when you responded: "So, you are using a form for entering the date parameters and then you say that nothing shows up if there is anything in it?" There is just the headers of the report and a summed column of "0", when I enter any date(s) in the start & end date windows...
  14. P

    Form:open a report grouped on 'A' sorted by dates

    I see a lot of lookers, but no advisers. Am I asking something stupid. (be nice).
  15. P

    Form:open a report grouped on 'A' sorted by dates

    For use with Access 2007, I need a form to open a report that groups on ‘Brokers’ and displays ‘Deposits’ for each group based on a ‘StartDate’ and ‘EndDate’ the user enters on the form and picks the ‘Preview Report’ button that executes some VBA code on-click. Currently, the code...
  16. P

    Punice

    Shenandoah Valley in Virginia...learning Access the hard way. Making progress, but struggling...forums are helpful, though. Thanks.
Back
Top Bottom