Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2007-08-02
Medium Priority
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

peter57r earned 900 total points
ID: 19615787
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

ID: 19615937
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

planocz earned 600 total points
ID: 19617031
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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

810 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