Search results

  1. G

    adinteger declaration in ado

    oops, in here http://www.w3schools.com/ado/ado_datatypes.asp i've found a relation table ado datatype with access datatype. It covers access integer, long and autonumber
  2. G

    adinteger declaration in ado

    I'm using ado statements to pass values to my stored procedures. for instance myado.Parameters.Append myado.CreateParameter("Autonummerbusbeperking", adInteger, adParamInput, 4, lngAutonummerbusbeperking) lngAutonummerbusbeperking is declared as a long value and fetches an autonumber. The...
  3. G

    tabbed pages - code doesn't seem to work

    I can't find the on change event ont the tabbed page. I've set it to display buttons, i'm using the on click event of the buttons but can't find an on change
  4. G

    tabbed pages - code doesn't seem to work

    I'm using a 5-tabbed form and have put it in my detail section. Within the on click event of one tab knob i would like to activate some knobs in the form header where the tab resides on. I've coded everything properly but in one or other way access doesn't seem to communicate between the...
  5. G

    Professional Database Developers

    Sorry Len in this context I mean ASP as application service provider: a web hoster which provides access to applications (like salesforce.com) in this way to overcome the need for organizations to administer local servers . You do also have the ASP technology as offered by microsoft like you...
  6. G

    Professional Database Developers

    Access is a nice tool but we're moving toward ASP (application service providers) or in-house client-server computing using your webbrowser as the client interface. A desktop program needed to run your program doesn't stand the philosophies of modern time even if it's architecture is capable of...
  7. G

    redirect to a site showing the original url

    it should be possible as long As i'm using an IP which doesn't already point to a domain. Otherwise two domains pointing to the same IP..I donna know, probably technically possible but I wonder or it is allowed
  8. G

    redirect to a site showing the original url

    Ok dan-cat a good hint, I'll be giving it a try!!
  9. G

    redirect to a site showing the original url

    Is impossible, many country domains can only be hosted by providers registered with the country authority. They abuse this (or the fee for membership with that country authority is that high) that they charge much money for hosting. For instance if you have .nl you come along higher prices...
  10. G

    Professional Database Developers

    It's a little bit odd to notice ADP is being phased out, maybe because (like concluded in here) access heavily depends on using same versions and hardware. Like someone else concludes use .net if you have the chance to overcome version and hardware issues. Personally I would use Java instead...
  11. G

    Professional Database Developers

    Pat thanks for your info, good to know that ADP is being phased out. The only thing I'm missing in Access is to easily deploy web applications. Desktop solutions are losing ground to the web solutions so If you can tell us anything about access 12 and web solutions I would love to hear it
  12. G

    Publish products from access on website

    What i did is the following. Content management system joomla and installed the component virtuemart which is a webshop. 'This webshop has a csv upload routine and now it works great
  13. G

    redirect to a site showing the original url

    I would like to redirect my site to another site while keeping my URL in the browser. I'n using a country domain name which only can be hosted by several companies asking too much money. So I bought the name (with a simple hosting account without mysql) and would like to connect to another site...
  14. G

    workgroup security - bothers my deployment

    Thanks hudson. With some help I found a solution to work around the login screen, I used a shortcut, but this time I explicitly mentioned msaccess.exe . Now he automatically logins with the following shortcut (somebody who reads this should replce the my stuff). "C:\Program Files\Microsoft...
  15. G

    workgroup security - bothers my deployment

    I've designed an access ade file (based on sql server) and distributed it at the network. Somebody else has made another database (mdb) and placed the users in a access workgroup file by placing their windows logons into the workgroup file. These users happen to be the same users accessing my...
  16. G

    Publish products from access on website

    Hi Pat, As they also needed a website i've used a content management system. As I don't lack any database skills i'm going to abuse a news category to automatically fill it with products. So with some fantasy it will work.
  17. G

    Publish products from access on website

    I would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures. Within my access database i have a link to the product picture...
  18. G

    Professional Database Developers

    Even for small projects i preferrably use the access adp solution (access tied up with sql server in the backend). You might lose some development speed when using sql server as a backend (access will then not be the easy click development application) in the adp solution and you really need to...
  19. G

    return to selected location in continues form

    Namliam has right and if you ever find code for bookmarks don't use it. In the after update event or after insert event you can capture the primary key. - Use docmd.findrecord to find the autonumber after your requery - use docmd.gotorecord .... acnext to goto the next record after the one...
  20. G

    Adding Parameters to a function

    If you call a function within the procedure you should also specify the arguments for a parameterized function I don't know by head how the function is being called within a SP but like in query analyzer all you need to do is to fill the values between the ( and ) I think an example would be...
Top Bottom