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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DaveMac

  1. DaveMac

    Design Help with Printing Many Files

    They can be moved anywhere so the directory should be fine. As for the scripting I did plan on using Access 2010 VBA. If you find samples that owuld be great however I think I have the chain understood given your description. Thanks for your help!
  2. DaveMac

    Design Help with Printing Many Files

    Andy, That sounds like what I need. Do you have any samples of that code? I hate to ask but I am not a programmer so I always take forever to connect the dots. Thanks!
  3. DaveMac

    Design Help with Printing Many Files

    I need a little design help on the follow problem, thanks in advance. Current state: We have 121 rtf documents that users open in word to prepare for a survey. Use factors: Users select between 5 and 25 documents to print and take with them. The selection is up to the user and cannot be...
  4. DaveMac

    Rarely used Method Help

    Sorry folks I know this is not a typical VBA question but it is driving me nuts. Situation: I recently changed jobs and have moved from a Blackberry to no work phone. I purchased a Driod and would like to get my calendar events on my Driod Gmail calendar. I can by using Forward as Ical...
  5. DaveMac

    Create Many Linked tbls Quickly

    Need VBA to link tables to many identical DBs I have 24 servers that are running the same application. I would like to connect to these via code rather than having to create 240 linked tables. Need: To link to 10 tables on 24 servers Good news: I have a local table that has all 24 server...
  6. DaveMac

    Help getting away from static criteria

    I have several queries that have static criteria typed in. These are each specific to the user. The users are spread out and need to only see their data sets so I set the criteria then rename and send the DB. My question is how could I point the various queries and various fields to a table...
  7. DaveMac

    Help with ODBC code

    Thanks for the help one last thing now that I have done it. How would I set this as a Trusted Connection? I need to use the AD for users so I do not have to always add them. here is what I have: Option Explicit Private Const REG_SZ = 1 'Constant for a string variable type...
  8. DaveMac

    Help with ODBC code

    Looks like I have some more reading to do. I appreciate the help and will repost what works so there is a record. Thanks for the help!
  9. DaveMac

    Help with ODBC code

    Answered my own question. I changed the ODBC on my PC and then tried to open the linked tbl and the link failed. So it looks like the linked tbl is still there and not a new DSN-Less tbl. Any suggestions or advice?
  10. DaveMac

    Help with ODBC code

    How can I tell if the code worked? I ran FixConnections "svrdw", "sales" in the ctl-G window with code listed below but in my linked tbls I do not see any change in linked tbl mgr? Any suggestions? Sub FixConnections(ServerName As String, DatabaseName As String) ' This code was originally...
  11. DaveMac

    Help with ODBC code

    I am out of my comfort zone and it shows. I would like to create a command button that creates an ODBC connection for users automatically. I do not care if it is “on the fly” or if the created connection is now present in their ODBC system connections. I have 2 tables in the DB that get...
  12. DaveMac

    How to make 5.5 by 8.5 pages

    OK I really tried to figure this one out and can’t. I need a report that prints Images from a table with images in it on ½ of a sheet of paper. The paper can then be cut in half to make a 5.5 by 8.5 page for books. So I need to know how you would format a report that is: Page size 8.5 by...
  13. DaveMac

    Design question. Should I use ODBC or is there something better?

    I have an access app that uses 2 linked tables that are linked via standard ODBC. I use a lot of linked servers in MS SQL and can create those dynamically on the fly. I would like to be able to create the most robust connection type possible given my need. The use would look like this: 20...
  14. DaveMac

    Format date-time so it can be used as filename

    sweet! BTW I had to make the variable a variant not date. not sure why date did not like time?
  15. DaveMac

    Format date-time so it can be used as filename

    And today is beginning like yesterday. Help with format date. As you can see I want a file saved at 8 am on Jan 1st 2011 to be strfiledate “0800 1-1-2011”. I just need a date/time down to the minute, seconds if it is easy, so I can ensure unique filenames...
See more

Part and Inventory Search

Back
Top