Recent content by FLCoderMike

  1. F

    OutputTo PDF save to directory

    Okay , have set up cutePDF. My question now is, how do I save the file without user interaction, is there a way of doing that?
  2. F

    OutputTo PDF save to directory

    Thanks, I'll try that.
  3. F

    OutputTo PDF save to directory

    What would that command be?
  4. F

    OutputTo PDF save to directory

    Hi all, looking for a solution to a problem I am working on. I read about OutputTo method, I would like to OutputTo a PDF, is this possible or if not is there a way to automatically save a report without user interaction other than clicking an event button? Scenario: I have 200 customers, and...
  5. F

    About to blowtorch the DB

    I have a simple database, (see attached). I am trying to generate reports based on 4 simple criteria: Status : Paid|Unpaid|Unrealized (checkboxes) Company ID (Select Box) Start Date (Calendar Function) End Date (Calendar Function) I pass these criteria to my class and in there I select the...
  6. F

    Backup Database-Consolidating VBA

    Getting error after splitting database Sorry to jump the post but, I am using the same backup routine and before I split my database everything worked fine. Now that I have split I get an error at "Dim fso As FileSystemObject" declaration. 'User-defined Type not defined' has anyone else run...
  7. F

    Popup Edit Form - Not allowing input

    Fixed, I went back to a previous version. Looks like the forms just got corrupted.
  8. F

    Popup Edit Form - Not allowing input

    Caught me, but now when I set the Allow data entry to Yes, the record can not be found
  9. F

    Popup Edit Form - Not allowing input

    I have two forms that open in pop/modal windows. They both get the records they are supposed to, they both save as they are supposed to, but I cannot input/edit any of the data. Anyone have any ideas?
  10. F

    Page Break by IF Else

    I wish it were that simple, here's he scenario; Customers request the annual records for an applicant, these annual records can be from 1 to 4 years back from the current year. These requests are then faxed to a central clearing house on a batched form, so there are many requests from many...
  11. F

    Page Break by IF Else

    I have a report that has to have a page break set for a specific number of years printed, these years are summed up in a column for each record, each record can have as few as 1 and up to 4 years in it, I then sum this column up in the report and get a number which I have in the report footer in...
  12. F

    Strange Problem...

    I have a form that has two fields that need to be filled from a query, the values are taken from a table that is set up as follows id | name | parentID The returned data can be from 0 to hundreds, what I need to do is be able to retrieve the data by parentID and then display it in the field...
  13. F

    Looping thru an array cheking for values in a table

    Thanks...with a little tweeking it worked.
  14. F

    Looping thru an array cheking for values in a table

    arrLocations = Me!customerBranchLocations.Value 'MsgBox (arrLocations) arrParams = Split(arrLocations, ";") For i = 0 To UBound(arrParams) MsgBox (arrParams(i)) strSql1 = "SELECT branchName FROM...
  15. F

    Subforms...

    Never mind, figured it out on my own, thanks to http://www.access-programmers.co.uk/forums/showthread.php?t=99353 great example guys.
Back
Top Bottom