Search results for query: *

Your code may have been meant to recognize the value in the Vendor field, but obviously it's not. If none of your choices in list14 are exactly PS, CC, IE, or LW, your report will fail. And if the Case Else statement is there, the Msgbox "Can't find report for Vendor " & Me.List14 & "." is...

Was the error you were seeing after you added the Case Else line, did the error message start with "Can't find report for Vendor ...?" If so, then none of your choices in list14 were exactly PS, CC, IE, or LW, and stDocName will never be set. So, the Vendor List (list14), does it have more...

You could try adding a Case Else line to catch those that don't match your Me.List14 value: Select Case Me.List14 (//this is the vendor box//) ... Case Else Msgbox "Can't find report for Vendor " & Me.List14 & "." End Select Or set stDocName to a default report before...

It sounds like you didn't set a breakpoint to pause the code. Open the Visual Basic Editor, go to the calcmaterialrisk function, and click on a line of code after the Dim statements. Press F9 to set a breakpoint on that line (should turn red). Open the form and update one of the fields. As...

The code you found in the modules is most likely evaluating form fields and calculating the MaterialRisk. So I'm guessing you will find the =calcmaterialrisk in the AfterUpDate event of any field that affects that calculation, and maybe the Open event of the form. I think what you may want to...

Wow! Okay, it looks like the MDE file that gets compacted into the folder you choose when creating a new distribution package is named Survey.mde, in a folder named distrib, within your current MDB folder. For example, if your MDB app is C:\Survey\Survey.mdb, then it will use...

I suggest taking a look at code in the the DistributePackage sub and see exactly which MDE file it is copying to your destination folder. Perhaps immediately after running the Distribute routine, check the file data/time on the MDE in that destination folder, and compare to the source MDE. Or...

calcmaterialrisk is referring to a function located in the VBA code of either the form or one of the modules. Usually if you click the 3 dots off to the right side, it will take you right to the appropriate code.

colval, I'm confused about what you mean by "create the MDE." Typically in the Access world it refers to a specific file created from your original MDB file within Access (menu Tools, Database Utilities, Make MDE File). Basically it takes your MDB file and removes the source code and compiles...

It looks like MaterialRiskString is a function in one of your modules. Open any of your code modules and do a search (CTRL F) for 'function MaterialRiskString' in 'Current Project.' Ken

This might be a start for your queries. Type the code below into a module, then in the Immediate Window (Ctrl-G) type ? TableInQuery 2,700 queries? That may be a record! :) Ken Function TableInQuery() Dim DB As DAO.Database Dim QryDef As DAO.QueryDef Dim X As Long Dim FindThisTable...

I'm confused as to why your own solution won't work. What is the truncating issue you are seeing? Ken

Thanks. New version also has that 15 minute clock for really rounding those times.

You'll need to strip out the Demo form control names (optDisplayMode & cboFirstDayOfWeek). I did make some changes last night, which now includes a source code tab, which generates the code with your control names for the desired calendar features. Your code should be: Dim Date1, Time1...

If you can't get the direct handling of the Excel object to work, perhaps using a method I thought up for my "I want the Excel export file to look just like this" crowd. Basically, I use the Access report itself to open the Excel object on the On Open event, write the headings, details, and...

Good idea, I'll take a look.

3 seconds! :( My 500 mhz laptop is 1...I guess I need a slower machine to develop on.

Hmmm...Just tried it on another machine and it worked okay. I did replace zip file though. I guess try again and let me know. Thanks, Ken

I just finished rewriting the calendar I wrote years ago, and posted it at http://www.frontiernet.net/~firch/Cal/Cal.htm (2000 format). My aim was to create a calendar that I could easily distribute, and flexible enough for all the different flavors of choosing dates and times, with just 1 form...

I've done it for a known number of reports by putting each report in a subreport with a pagebreak afterwards. But one that's as dynamic as yours would be a bit hairy to code. I'm not sure what the limit is for subreports on a report, but if you setup a report with x amount of subreports with...