Search results for query: *

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...

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

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

(be kind - I'm still pretty new to .NET) I'm attempting to set up a useful base web page for a project. I've figured out how to subclass a page, but I'd like that subclassed page to have a masterpage assigned (and possibly some other properties as well). If I try to set the masterpage in the...

OK - I think I'm set. I cycle through all Controls in the page Controls collection (and recursively through any controls' controls collections) looking for specific webcontrol types. Based on the webcontrol type, I set readonly or enabled. It seems to work fine! Thanks for your help! Bill...

OK. Disabling the controls seems to work OK, although on grids that have paging won't that disable the paging functionality too? Bill Kuhn - MCSE bkuhn@kuhngroup.com The Kuhn Group, Inc. http://www.kuhngroup.com

?? I do not see a ReadOnly property for DataGrid or GridView controls. Am I missing something obvious (it would not be the first time)?? Bill Kuhn - MCSE bkuhn@kuhngroup.com The Kuhn Group, Inc. http://www.kuhngroup.com

I've inherited a website that we are trying to build some security into w/o major rewrite. This is in ASP 2.0 with VB codebehind. We are using ASP.net forms based security and that is working well. We now need to add a user role that will have READONLY access to a bunch of the existing forms...