Search results

Create a form with text controls where you enter this information. Have your queries reference these controls rather than asking for the info each time. --Forming Mac

Not sure from your post exactly what you're after, but it sounds like you want a text control on a form that also has a button on which generates the report based on whatever criteria the user has typed into the text control? If so, add the text control, give it a meaningful name, then in the...

F1 is your friend! From MS Access Help: There is an example is the Northwinds db. --Reminding Mac

F1 is your friend... As always, start w/ MS Access Help. Put in "about subforms" as your topic. Then check the Northwinds sample to see how they do it. If you need further guidance, search this forum on the keyword "subform".

There may be a better place for it, but in the OnChange event for each of your "parameter" text boxes put: me.requery me.refresh This should update your subform anytime someone changes the contents of any of your parameter controls. The OnChange event is going to trigger very frequently...

Subform? Perhaps I'm missing something, being a bit rusty, but what about an Experiments subform within your Papers main form?

Check out the .requery method, placed in the AfterUpdate event code.

I'm always ready to be wrong, but my understanding is that the Dim statement is just letting Access VBA know that it needs to set aside resources for a new instance of a Word.Application object. The object is not created until the CreateObject() call, which returns an object pointer to the...

Hey Gang! I've searched the archives but haven't found this one yet, and the MS KB was entirely unhelpful. I've created a tool to simplify and automate a lot of advance tasks for a touring stage production. In the interest of max flexibility for the end users, several of these tasks revolve...

Slightly off topic? Thanks for opine-ing Wayne. Any tips/references on best methods to "streamline the amount of data that you access"? --Beginner Mac

Dear Assorted Access Gods: I'm (maddeningly) slowly working on my first split FE/BE project. This will be a distributed .mde FE that hooks to an Access BE stored on a web server (via, I THINK, providing the FE with linked tables that point at the server--but I haven't gotten around to...

You may also want to check Lebans. --Unpaid Mac

and, from another thread:

Re: register ActiveX Control in Runtime Which solves the registration problem neatly (thanks for the tip!) but not the (IMHO) poor design of the control to begin with. Yes, the little red circle on the selected date is fun, but the control is not an efficient way to choose dates any farther...

The Ken Getz code was a little farther down in the thread. I think you'll find it a little more flexible. --Limber Mac

Are you using the Ken Getz code? The TestIt() function shows an example of filtering on multiple file type extensions. --Multiple Mac

Out of curiousity, what are you wanting to accomplish by this? It looks suspiciously like you want to get a list of records in "table 1" sorted by the week number, or use the week number as a selection criteria. You could get that result much easier by creating a select query based on "table...

Peggy: The second step when you hit any snag in Access should be checking the forum archives. This question has been answered many times, including in this thread. --Reminder Mac

just say no I'm sure I'm in the minorty here, but I avoid using the MS ActiveX controls entirely. I've had so many problems with the date/time picker, in particular, that I've simply built my own. Mile-O-Phile does that with the calendar control--I know 'cause I stole his method of passing...

Thanks Pat! --Appreciative Mac