Forum Replies Created

Viewing 15 posts - 181 through 195 (of 274 total)

  • RE: Sending Data from Unbound field in form to table

    Some general information about forms in Access may be helpful as you continue your development. There are times where it is necessary or useful to use an unbound form...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: QR Code-Integration of Microsoft Access and Microsoft Word

    If you are looking to export records or reports to Word, the simplest way is to use the Export function to RTF. There are several limitations in doing that...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: refreshing subform after right click and filter field in main form

    bdog2607 (11/21/2012)


    thank you . if you can direct me to an access forum that would be great. I do SQL developemnt as well and just got stuck with this one....

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: refreshing subform after right click and filter field in main form

    This forum may not be the best for pure Access applications. Most people who post here are working with SQL Server back-ends so they aren't that conversant with strictly...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: refreshing subform after right click and filter field in main form

    Are you linking to a SQL Server backend, or are the tables stored in Access as well?

    Also, what if anything, changed from September 1 to October 1, other than the...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: refreshing subform after right click and filter field in main form

    In order to make suggestions as to what might be going on, it would be helpful to know what version of Access you are using, and what the format of...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: displace input row in Access 2003 and SQL Server 2000

    It's not clear to me why sorting the data would prevent you from adding a new record, but I seldom work with .ADP Access applications. Perhaps one of the...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: displace input row in Access 2003 and SQL Server 2000

    That helps consisderably. It appears that you really want to sort the display by the Description column then. (It also appears that either Access or SQL Server thinks...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: displace input row in Access 2003 and SQL Server 2000

    omid.shokri (11/11/2012)


    1- I used SQL Server 2000 as DBMS.

    That wasn't my question. What is the file extension of the Access database that contains your data entry form - .ADP...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: displace input row in Access 2003 and SQL Server 2000

    We need some additional information if this query is being used as the data source for a data entry form. First of all, is your database a .adp file...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: displace input row in Access 2003 and SQL Server 2000

    Adding an "ORDER BY HID" clause to your SQL statement should correct the sort order.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Ms access add record to table via unbound text box

    sdhanpaul (10/28/2012)


    Okay,

    after thinking long and hard as to how I will go about doing this, I decided that I will use ADP file to creat stuff, stored procedures especially ...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Can Access FrontEnds run T-SQL/XML

    I'm in way over my head on this, as I've never done any .NET programming or worked extensively with xml, but in theory I don't see any reason why it...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Can Access FrontEnds run T-SQL/XML

    I don't see why you couldn't use a pass-through query to invoke the SQL Server function - although there are several limitations with pass-through queries. But Access has had...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Access 2007 front end to SS2K8 problem

    I should say! Extended condolences are definitely in order. :crying:

    There's a common misperception that Access is an insecure system that is also unreliable. As long as you...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

Viewing 15 posts - 181 through 195 (of 274 total)