Search results

  1. J

    Run Macro Every XXX Minutes

    @plog - i like the idea of using Task Scheduler to open the Database. That is a good thought so then the database is not opened constantly!
  2. J

    Run Macro Every XXX Minutes

    If the table contains rows, then I want to run a few queries, and run a report and save the report as pdf all through VBA. If the table does not contain rows, then there is no action needed.
  3. J

    Run Macro Every XXX Minutes

    Hmmm...so this means that I must leave the access database open constantly in order for the code to execute? I was hoping for a solution that wouldn't require the DB to be open.
  4. J

    Run Macro Every XXX Minutes

    I have a user uploading excel workbooks to a website, where data is then inserted into MS SQL Server tables. These SQL Server Tables are linked tables into MS Access Database. I need a way that once records are inserted into those MS SQL Server Tables to run a MS Access VBA Module. What would...
  5. J

    Solved Split Each Locale To New Page

    I drag down the page break from the toolbar but nothing shows in the footer. Do you add that differetnly than other controls?
  6. J

    Solved Split Each Locale To New Page

    It's not splitting it to a new page with the header. It's adding in a grey filled area but that is it
  7. J

    Solved Split Each Locale To New Page

    I have Group On Locale Group On Test - with test I have "with a footer section" In the properties of the report footer, I did All - force new page - After Section But everything is still on one page.
  8. J

    Solved Split Each Locale To New Page

    Doesn't work because the locale is the same.
  9. J

    Solved Split Each Locale To New Page

    This should be basic but I can't figure it out. I want each page to only show data for one Test. Each time a second Testdisplays I want to go to a new page. My desired display is Header 501 ------- Logo 1 Then page TWO header 501 ----- Logo 2 Attached is a sample databse with a...
  10. J

    Solved Convert Multiple Rows To One Row

    @sgrgeta - holy cow that is awesome and exactly what I need!!!! @Uncle Gizmo - that is a super handy tool, I am going to bookmark it as I'm sure I can use this for multiple projects
  11. J

    Solved Convert Multiple Rows To One Row

    I receive a spreadsheet that is imported into access, and it needs to be manipulated to make columns out of some of the rows, and get counts for locations. Attached is a database that shows with two tables, the Received which is the direct spreadsheet import, and the needed which is the table...
  12. J

    Solved Barcode Added With VBA

    I was initially having issues with my barcode not displaying but I resolved that, now my issue is the barcode won't scan. I'm using the 3of9 barcode. Attached is a sample database, with scrubbed data. Does anyone here see an issue as to why the barcode is not scannable? I tried to upload here...
  13. J

    Solved VBA Function To Accept A Parameter And Return A Parameter

    Okay, I figured it out but I don't understand it. All I had to do was this retVal = GetRecordSetResults(sqlString) Why do the parens make a diff?
  14. J

    Solved VBA Function To Accept A Parameter And Return A Parameter

    Insted of Sub Test It should be Function Test Is that what you are saying needs changing?\ Err...just kidding, I tested that theory and same error even if I place it in a function.
  15. J

    Solved VBA Function To Accept A Parameter And Return A Parameter

    The table that I'm looking at is always less than 1,500 rows so I am not conerned with speed at this point, but I will keep in mind DLookup is quicker. I see you assigned the result to the function name, I didn't know you could do that! :) My remaining question is, would I get the value in the...
  16. J

    Solved VBA Function To Accept A Parameter And Return A Parameter

    I'm sure this can be done, I just can't wrap my mind around doing it. I want to pass in a sql string to a Function that will open a recordset and return the result of the recordset to the calling function. I'm trying to do something like this Sub Test() Dim sqlString As String sqlString...
  17. J

    Solved Write RecordSet To Excel

    I have this function that I am using to pass in the recordset, filename and the querySQL to export to Excel. My last remaining issue, is that even when the workbook is saved and closed in Task Manager I still have an instance of Excel left. What step am I missing to properly clean up Excel...
  18. J

    Solved Write RecordSet To Excel

    @arnelgp - each recordset would be going to a different workbook.
  19. J

    Solved Write RecordSet To Excel

    @Uncle Gizmo - I'm using a recordset and not a query. I know I could change that recordset into a query rather quickly tho. The link you provided seems to be a dead link, when I click on it I get an error on the page
  20. J

    Solved Write RecordSet To Excel

    @June7 - how about the code below? I'll probably convert this to a function where I can pass in the recordset as I'll need to write about 5 different recordsets to Excel, but for now - is this code what you were referencing? Dim rst As DAO.Recordset Dim userSQL As String Dim xlBook As Object...
Top Bottom