sending parameters in pass through query 1 34 (6/29/2003 12:57:55 AM)
I need help with the syntax to assign to a command button on MS Access 2.0 form. I need the action to get the values of two fields (start date and end date) on the form and pass them to a SQL Server 2000 databa...
baggett.stephen (1)

how to create a module in access 2002 with vb 2 35 (6/28/2003 12:57:21 PM)
Hi I'm trying to put together a set of tools for access 2002 and i would like to create a module programmatically using vba but can't find any documentation that leads me to believe this is possible. Is it? TIA...
epaulsen7 (1)

Passing parameters inside queries 2 38 (6/28/2003 9:18:28 PM)
Hi there I was wondering if anyone could tell me if it is possible to pass a parameter to a query, from within a query. The sub query returns a SUM of a grouping of records that is dependant on an ID. I do ...
paul3691 (1)

A2K And shapes 5 45 (6/28/2003 3:40:21 AM)
I have A97. I am unaware how to do this in A97 but maybe it can be done in the A2K version. On a form, I want to click a button and it would draw a box on a form. Once the box is on the form. I want the abilit...
finucanp (132)

MS Access Recordsets 1 44 (6/29/2003 12:58:15 AM)
Hi. The following code causes an error. I think its because whwen I assign a value to a variable in one function, the other function can't see it. Public Function OpenConections() 'open connections S...
graeme.howard (9)

storing reports or letters within access97 5 37 (6/27/2003 11:44:17 AM)
I have an access97 invoicing application that I use to generate various reports (letters) to my customers. Some of these might be a confirmation of order, or a reminder to send a payment or a friendly greeting,...
info2073 (75)

Cancel Button in the Logon dialog box in a secured Access db..... 2 41 (6/28/2003 2:21:33 AM)
Can I program it to Close and Quit Access instead of just exiting the Access database and leaving Access open? ...
sshaner (1)

Database Splitter, how to undo 0 54 (6/28/2003 5:45:04 PM)
Hello I recently used the database splitter to split an application. This was my first attempt and now wish that I had kept some of my table with the front end part of my DB. Can I undo a split? How? Thanks R...
someone7751 (19)

!!FAQ! for Date: 20030628 - New Users Look Here! [Last Updated July 24, 2002] 0 36 (6/28/2003 5:01:21 PM)
An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being fla...
FAQPoster (340)

Re: Compile Error--Nuts! 1 48 (6/28/2003 2:01:45 PM)
Great site! Thanks! An article said to reinstall my old version of Access and that worked! I was using Access 2000 but now I am back to Access 97. John From: "PJ Peters" Newsgroups...
Keefy (2)