Search results

  1. K

    Need help for VBA to run reports daily based on 24 hour period

    I need help formulating a 24 hour period that would capture emailed files daily for a given 24 hour period automatically. There is a report that reports on emails received from 4PM one day until 4PM the next day. How can this be done using VBA? I haven't been able to figure out how do it...
  2. K

    Push a report out programmatically as HTML.

    There's a daily report created in PDF format that gets emailed to a number of recipients. I'd like to be able to programmatically push the report out to a network folder for access with the push of a button. Just one file, in any given accessible format, really. PDF is fine but leaning...
  3. K

    Find number of records based on Date Difference

    Do a count of serial numbers grouping on the years
  4. K

    Programmaticallychange a field type to Hyperlink

    Is there a way to use VBA or Access SQL to change a field type in a table to Hyperlink? I can change a field type to text using the following SQL: ALTER TABLE TableName ALTER COLUMN ColumnName TEXT(255)... works like a charm. However, the following SQL fails: ALTER TABLE TableName ALTER...
  5. K

    Question Working with Access Projects

    Hello all, I've recently worked on a development project that required the use of an Access 2003 Project connected to a SQL Server 2005 backend DB. It didn't take long to realize that there were writing issues to be dealt with. The only way I could do any inserts, updates or deletes was...
  6. K

    How to do this on Access...

    Thanks a million!!! ByteMyzer rocks!!! Spread the word!!!
  7. K

    How to do this on Access...

    I have the following in Excel: Interval Time Diff in Minutes T1 3/24/2007 2:31:55 PM 0.000000 T2 3/24/2007 2:39:21 PM 7.433333 T3 3/24/2007 3:07:08 PM 27.783333 T4 3/24/2007 3:11:09 PM...
Top Bottom