Search results for query: *

I encountered this problem a good bit in the past, and I found that it was only occurring on forms where I had a table as the Record Source (which was left over from when the app was MDB and wasn't good design anyway). When I changed the Record Source from a table to a stored procedure for...

I have an Access ADP file created in Access 2000. It contains a report that has a stored procedure as its Record Source, with the appropriate Input Parameters specified in Properties. Basic stuff, and it works fine... Recently, I removed one of the parameters in the stored procedure and also...

Thanks for the quick tip. That did it!

I need to convert some dates to yyyy-mm-dd format for XML. I know the following: convert(varchar,GetDate(),126) --> 2004-06-02T16:13:49.293 My question is, how do I get just the yyyy-mm-dd component without the time? Thanks for any suggestions!

I never found a resolution or a workaround, so the problem still exists. I still use the control, and it works very well, but only for fields that I know (or hope) won't exceed the height limitation. I still consider this a major limitation of the control... What have been your experiences...

Can anyone recommend a good one? I just want to be able to compare stored procedures, UDFs, tables, etc. across two databases and get a report of differences. Thanks...

I use Access 2000 (ADP) as a front end to a SQL Server 2000 database. I read about the FMS Total Access Memo product for adding rich text formatting to memo fields (or text fields in my case), and I immediately got excited about being able to offer this functionality to my users. I purchased the...

I use Access 2000 (ADP) as a front end to a SQL Server 2000 database. I read about the FMS Total Access Memo product for adding rich text formatting to memo fields (or text fields in my case), and I immediately got excited about being able to offer this functionality to my users. I purchased the...