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 BillKuhn

  1. BillKuhn

    How do you create an Access 2007 project?

    Be warned - Microsoft has 'deprecated' ADP projects in Access 2007. That is a politically correct way of saying they are buggy as an anthill in 2007. I went through a nightmare conversion of an Access2003 MDP to an Access2007 ADP (using SQL 2005). Incredibly painful finding workarounds to...
  2. BillKuhn

    Function USE() to verify another computer

    No. The USED() function only tells you if a table is in use in a workarea in the current instance of VFP. Bill Kuhn - MCSE bkuhn@kuhngroup.com The Kuhn Group, Inc. http://www.kuhngroup.com
  3. BillKuhn

    do I need version control?

    To me, source/version control is absolutely necessary no matter how many developer you have. I use VSS at home on my personal projects, and I insist that clients I contract my services to (where I work onsite) have source control as well. Being able to back up and recover and or compare to a...
  4. BillKuhn

    Convert Access 2000 .adp to 2007.accdb

    I just realized my original post on this thread said we started with a 2003 MDP. Wrong. It was an MDB. Bill Kuhn - MCSE bkuhn@kuhngroup.com The Kuhn Group, Inc. http://www.kuhngroup.com
  5. BillKuhn

    Convert Access 2000 .adp to 2007.accdb

    You would think so. Office is AFAIK the second highest revenue generator for MS (besides OS). It would be nice to keep some QC in it. This was an upgrade from an Access2003 MDB to ACCESS2007 ADP by the way. The purpose was just to give them the reliability of a SQL data store as a temporary...
  6. BillKuhn

    Convert Access 2000 .adp to 2007.accdb

    Update on the Access 2003 ADP - 2007 ADP conversion I did.. Performance was unacceptable due to neverending queries (1000s per SECOND!) from the project asking for database schema information. this would start after a user did a 'filter by form' filter on a form and then closed the form - these...
  7. BillKuhn

    Convert Access 2000 .adp to 2007.accdb

    Boy I'd like to hear any suggestions for this too! I've 'upgraded' a customer from an Access2003 MDP to an Access2007 ADP with SQL 2005 backend. Major fight to convert and work through bugs. Now performance is absolutely dismal and unacceptable. Apparently Access2003 ADP technology was OK, but...
  8. BillKuhn

    Access 2007 runtime doesn't prompt for parameter

    Thanks! I finally wound up making seperate forms for parameter input and had them call my original forms passing parameters in the OpenArgs parameter (multiple parameters had to be parsed). I removed the parameterized queries and dynamically built a select statement in the Load event of the...
  9. BillKuhn

    Access 2007 runtime doesn't prompt for parameter

    As I continue to try to salvage an ADP project in Access 2007 (and the light at the end of the tunnel has pretty much gone out due to Access 2007 bugs), my latest probable dead end is.. I have a parameterized function called "Walmart_by_completion_info_parameterized" defined as.. SELECT...
  10. BillKuhn

    ADP Table doesn't display all records

    Well I've managed a workaround to that Access 2007 bug. Apparently using a table directly as the recordsource of a form (setting the recordsource in the property sheet)is 'unreliable' and the form may or may not see all records. However if you set the recordsource of the form to the table in...
  11. BillKuhn

    ADP Table doesn't display all records

    In access 2007 apparently this is done by clicking on the idiotic round button, selecting Access Options, Advanced, and setting Default Max Records under the Advanced section to 0 (according to Help). I've done that. I've also set it to various numbers above 10000 which is the default. It has...
  12. BillKuhn

    ADP Table doesn't display all records

    I've inherited an Access 2003 MDB -> Access 2007 ADP conversion project. I'm a SQL, VFP, and .NET developer, not an Access developer. The main form on this project opens a table (not a filter/query/view - just a simple SQL table) which has 9751 records on the SQL server. The form toolbar at the...
  13. BillKuhn

    MaskedEditExtender DateTime mask

    I guess the solution is to not use the MaskedEditExtender at all. It is undocumented (as with all the AJAXToolKit controls) and unreliable. I was really hoping to see a way for ASP textboxes to handle input formatting without major contortions now that we are 5+ years into .NET. Alas, ASP.NET...
  14. BillKuhn

    MaskedEditExtender DateTime mask

    I'm using VS2008 with the current crop of AjaxToolkit tools. On a textbox, I am attempting to use a MaskedEditExtender to show/get properly formatted datetime strings. I've set masktype to DateTime, mask to '99/99/9999 99:99', cultureName to en-US, and AcceptAMPM to True (full declaration...
  15. BillKuhn

    Subclass Page that has MasterPage

    I didn't know you could set a global masterpage in the web.config - that makes it too easy! Thanks! Bill Kuhn - MCSE bkuhn@kuhngroup.com The Kuhn Group, Inc. http://www.kuhngroup.com
See more

Part and Inventory Search

Back
Top