How to pass Date Parameters to a Form in Access From VB.Net?

Posted on 2007-08-02
Last Modified: 2013-11-26
How do I pass date parameter to a form in Access from VB.NET to run macro queries? I'm using Access 2003 and Visual Studio 2005 on Windows Xp.
Question by:GeneBat
    LVL 77

    Accepted Solution

    Can you just confirm the application structure here as it sounds a bit unusual.
    You normally have Either an  Access frontend OR a VB frontend to a Jet(Access)  database .
    You appear to be using a Vb frontend to connect to an Access front end which presumably connects to a Jet database - is that correct? (The obvious next Q being - if the Access frontend already does this why are you adding another layer?)

    The other issue to clear up is terminology - in Access a macro and a query are different things - the term 'macro query' doesn't mean anything.  I would guess that you mean you want to run a saved Access query (a query that has a name) but again we need to be clear on this.

    Author Comment

    Yes your right I have macros that run queries. I have a VB frontend that run other stuff and I was trying to use that front end to launch Access to run the macro's and then go back to VB if the user wanted too.
    LVL 27

    Assisted Solution

    If you have a VB app that you are running then you should go ahead an change your VBA to run in the vb app., this makes it easier to pass info to and from Access.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now