Search results

In the Report's Properties, set both Pop-Up and Modal to True. This will have the report display in front of other database objects as well as have it keep the focus until you close it.

GJT, you have Workgroups set up on this db, so it won't allow an unauthorized person to open it. CSCS, open a blank database and Import all of the objects from edu.mdb into it.

Mike, I'd like to get this working as, to this point, I've been using a fairly complex and costly subquery as a Counter in my recordsets. I've been toying with your code but instead of the function being called for every record in the query as expected, the function seems to be called once when...

Your problem is not new; I've had many problems with Excel not cleaning up after running an Automation procedure. I've found that using Late rather than Early-Binding (which is what you're using) cuts down on the problem. I've also read articles in the MS Knowledge Base on getting around this...

That's a fine design there, Mile. I am looking through your Modules to get a better understanding of creating Objects (all of my friends who've been doing this longer SWEAR that OOPs programming is the only way to go, but I just don't see the benefit; they all say that they said the same thing...

ok, I'm starting to think that this topic should be in MS's FAQ's on Access (if they have one). You need to set a Reference to the DAO 3.5 or above Object Library. Open a Module, go to Tools->References->Microsoft 3.5 Object Library.

ok, this really wasn't that difficult, I tooled around for a couple of hours and got it working. I'll post the code and some keywords if, on some distant day, some other egghead thinks that this would be a good idea: Option Compare Database Option Explicit Public Function fCreate_subfrm() Dim...

Rather than writing the Iif statement in the combo box's Control Source, try using it as an expression to define a field in the underlying query.

You're right; I meant the SourceObject form will need to be destroyed and recreated.

Well, by playing around with it, I've gotten: Public Function fCreate_Frm() Dim frm As Form Dim subfrm As Control Set frm = CreateForm() With frm .Caption = "My Form" .RecordSource = "qryNDRS_Results" .DefaultView = 2 End With DoCmd.Save DoCmd.Close acForm, "form1", acSaveYes Set...

Right, that's my intention, but I still have to create that datasheet on the fly as I won't know my fields until creation.

I have a form which accepts user-input and builds a pass-through query and its SQL based on parameters that the user inputs. If the query is successful, it pulls the results into a table. What I would like now is a subform datasheet with which to view those results (a report won't cut it as...

You'll need to do this in a form rather than a query. The good news is that you can have a form in datasheet view which looks just like a query. Use the Wizard to create a form based on the query and specify it as opening in Datasheet View. After the form is created, go to Design View and...

Put single quotes around your '100' so that your expression will only return strings.

Yes, very good, thank you.

I see several examples on this and other sites of developers taking screenshots of their forms/reports/etc. and placing the images in HTML pages. How are you guys taking these pictures and what file format are you saving them as?

I found this bad boy for free: http://zimacs.zetnet.co.uk/problems/textdisplay.html

You'll also probably get suggestions to import all of your objects into a new database as well as using the Jet Compact Utility which you can download for free, but neither of these tricks ever seems to work for me. What has worked, however, is to copy all of the code from the offending Module...

You'll need two queries, one's going to be for Month, the other for Year. For the Month, you want to use the Month() function and pass your Date Field into the Function: Month([Your_Date_Field]) You want to get an average over the month, so what you're needing to do is count the number of...

Continuous Form Independence Question Re-revisited Hi all, I have a Bound Continuous Form with 7 text boxes and one Combo Box. The effect that I'd like to have is, if the Record is New, then all of the Text Boxes will be Disabled and can only become Enabled once a Selection is made out of the...