Search results

After reviewing the results of a successful run I note that the procedure provided does not really answer the question. It does an excellent job of enumerating the procedures specified in each form in an application. It does not, however, enumerate the procedures in a module. Where I'm trying...

I was able to complete the documentation run after removing the offending class module. Not an entirely satisfactory result. g

I got a similar behavior while trying to track down the error. After several runs, the first IF statement in the trimFunction gets deleted and the procedure fails to compile. Looks like a case of autocannibalism! George

I'm working in 2007 so the object library is 12.0. Otherwise, references are as required. The procedure hangs up when running the above quoted line against Uncle Gizmo's calendar routine clsGetActiveFrm, when varDictItems(m) evaluates to "fChkName" and eProcKind evaluates to 3. There are 26...

Folks, Thanks for the replies. [I might have responded sooner but we fair-weather skiers take our opportunities when we can. Great conditions today!] DCrake: I think not. I ran it against a db, it whirred for a bit. [edit: Cool output, but not what I'm looking for. I'd like a list of the...

I vaguely recall seeing that someone has already solved the problem of enumerating a db's modules's functions and subs. The solution populated a table called documenter. But try as I might, none of my searching has rediscovered the solution. If you know where I could find it, please let me...

Your best bet will be to load the array into a (temporary) table and reference that table in the report. For ideas on how to do this, search for related terms such as "access vba report array". Any code you find that way will be better than anything I could come up with. George

Do you mean one report for each value of the array? Or one report showing each value? G

It would be good to know exactly what the problem is. Aside from the unmatched parentheses, it looks like you're trying to set a filter where CodeBakasha is equal to a value in an array. I'm guessing you will get a subscript out of range error at Docmd.OpenReport...

Okay, I took a run at coding a TOC for a documenter report. Assuming the documenter is saved as a Word document, here's some code that will mark the unique object items in the documenter for generating a table of contents. Other features include removing bold from the entire report and...

In Access 2007: I'm hoping someone already has a technique for generating a table of contents for database documenter output. So far I've gotten the documenter output in Word and can format a portion of the page heading to be marked for a table of contents. [Replace all <tab> Page: # with...

This works in the current situation. It's an adaptation of code I've used elsewhere. Public Function CheckLinks() As Boolean Dim dbLocal As Database Dim tdf As TableDef Dim strConnect As String Dim fs, f Dim localpath As String, localfile As String On Error GoTo ErrorCode...

In ACC2007: I've built an application that, amongst other things, links to data that are imported as HTML tables into a back end database. The back end and original HTML documents are presumed to be present in the same directory as the front end database. A problem exists if the directory...

Thanks to all who have responded. The client advice is necessary because ownership changed hands this year. The application was built for a local government agency. With all the budget mess in California, the application was shuffled off to a larger and, I suppose, better funded agency. I'll...

For those who have charged for their services, a question regarding support contracts. Let's say you have billed a client $x for 50 hours of application development, installation, training and one year of support. It is now time to advise the client that support for the coming year will be $y...

I've made myself a small database to catalog my photos. There were about 300 photos in a number of subdirectories to ..\MyPictures. The file names, complete with explicit path, were in a field in tblPhotos, loaded by a small routine. I then started flopping around with code to update the...

(from the duplicate post) Thanks. For the form's control, in Properties, Format, Show Date Picker. Now set to Never. g

Thanks. For the form's control, in Properties, Format, Show Date Picker. Now set to Never. g

apologies for the duplicate; extraordinary delays made me think the post hadn't happened. In ACC2007: In a form with a date field, I've added Uncle Gizmo's calendar to add or edit dates in that field. Curiously, a calendar control with no presence in design view also appears. There is no...

In ACC2007: In a form with a date field, I've added Uncle Gizmo's calendar to add or edit dates in that field. Curiously, a calendar control with no presence in design view also appears. There is no control over its location or appearance. If I make the Gizmo calendar button not visible, the...