Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sfm6s524

    Report Name Argument Error

    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...
  2. sfm6s524

    Report Name Argument Error

    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...
  3. sfm6s524

    Report Name Argument Error

    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...
  4. sfm6s524

    Expression Builder

    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...
  5. sfm6s524

    Expression Builder

    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...
  6. sfm6s524

    Access VBA creating a HTML report from a HTML template

    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...
  7. sfm6s524

    Access VBA creating a HTML report from a HTML template

    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...
  8. sfm6s524

    Expression Builder

    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.
  9. sfm6s524

    Access VBA creating a HTML report from a HTML template

    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...
  10. sfm6s524

    Access VBA creating a HTML report from a HTML template

    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
  11. sfm6s524

    Where used?

    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...
  12. sfm6s524

    Change Font Size When Exported to Word

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

    Calendar / Clock

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

    Calendar / Clock

    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...
  15. sfm6s524

    Trouble creating a subtotal in Excel from Access

    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...
  16. sfm6s524

    Calendar / Clock

    Good idea, I'll take a look.
  17. sfm6s524

    Calendar / Clock

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

    Calendar / Clock

    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
  19. sfm6s524

    Calendar / Clock

    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...
  20. sfm6s524

    ListBox --> Report Batch Process

    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...

Part and Inventory Search

Back
Top