Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BibleMan

    Office Certification

    I was hoping someone could help me on a non-technical question. I am studying for the MS Office Master Instructor certification, and it appears that Exam Cram is no longer an option (God, I loved it). Can anyone recommend a good publisher of books that offers information directly related to...
  2. BibleMan

    Weekdays between dates - DateDiff() function

    Robert: I appreciate your quick response. I had reviewed the FAQ you referenced, as well as performing a search of all forums for the answer before I posted. The FAQ referenced is much larger a solution than I was looking for - kinda like driving finishing nails with a pneumatic nailer. :^)...
  3. BibleMan

    Weekdays between dates - DateDiff() function

    All: I am trying to create a calculated field on a Form that will calc the number of Weekdays between an existing field "[Letter 1 Sent]" and today. I have written the following statement and the results returned are incorrect. When I substicute "d" for "w" in...
  4. BibleMan

    Outlook form data to Access

    Combination of all. Mostly yes/no checkboxes, but a couple of fill in the blanks fields. -Joe
  5. BibleMan

    Outlook form data to Access

    I have created a survey form in Outlook that I have sent to thousands in my company, and would now like to import that data to Access (God, I don't want to key it in). I know this can be done, but can't figure out how. Has anyone done this before? I appreciate your insights, as always. Joe
  6. BibleMan

    Programatically Compact Database on Exit

    I have a database with multiple persons entering data on, residing on a Network drive with limited space. I have a button on the form that exist the database and MS Access. I would also like it to Compact the database on the way out. Is there a way to do this? Thanks. Joe
  7. BibleMan

    Querying 30 days back in Access

    If you wish to use the DATE()-30, you can use: BETWEEN DATE()-30 AND DATE() This will give you the date range between 30 days ago and today.
  8. BibleMan

    copy table from one access .mdb file to another

    Another option would be to create a link to the tables in the first database, rather than copying them over. This would take less disk space, as well as allowing to only have the need to update one set of tables.
  9. BibleMan

    Create report grouping by "buckets"

    I am looking to create a report from a large table, that shows the number of instances of a certain criteria on a weekly basis - grouped in 7 day buckets - over the course of an entire year. Is a report the best place to start this? Maybe start with a query first that creates the...

Part and Inventory Search

Back
Top