Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2013
    Posts
    17

    Unanswered: Web Database Revisited

    I have in my client database a cascading combo box
    works great.

    I've been using the subroutine for my database and now need to move it to a web database. I use the combo box for one selection, to fill in my other fields

    Ive been using the
    Me.TXTHULL_NO.Value = Me.CBO_CONT.Column(1)
    line to input for my other fields.

    How can I use something similar for a web database. (including macros)

    I see that this line in my web database does not work for VB.
    Anyone that may be able to help me in this matter? thanks

    Should I consider going to macros. Is there any advise for help.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by finney View Post

    ...I see that this line in my web database does not work for VB...

    ...Should I consider going to macros...
    I believe you'll find that no VBA code will work, assuming that your web database is done utilizing the Sharepoint services!

    As I understand it, you'll have no choice except going to Macros, as I believe that this is the only available route, under these circumstances, and unfortunately, from your viewpoint, very few of the experts here have any experience utilizing Macros, with the possible exception of an the AutoExec Macro, which is a specialized Macro that runs when a Database first opens.

    If I were going to do something like this, I'd probably develop a Front End interface using PHP or ASP, with the Back End being Access, as was done with pre-2007 databases.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2013
    Posts
    17
    Thanks linq. Thats mostly what I've found on the web.
    seems that VBA is more or less trivial when compared to macro functions

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by finney View Post

    ...seems that VBA is more or less trivial when compared to macro functions...
    Sorry, but you've got that backwards! Experienced developers almost never use Macros! Compared to VBA, they're inflexible, make it problematic using parameters and complicate trouble-shooting. With VBA, in order to do debugging (or even to just understand what is being done) you simply go to the Form's module and everything is there, in plain sight. With Macros, on the other hand, you have to open each and every one separately, to find out what they do or what they are doing incorrectly.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jan 2013
    Posts
    17
    But again web databases do not use vba.. hence my problem.. thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •