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!

  • Congratulations strongm 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. mhudson

    Corrupt database help needed

    If anyone can help I would surely appreciate it. About three weeks ago one of my users reported that she could not open previous records in one of our R5 databases that until then had been trouble-free. It is about 68 Mb in size, and the property sheet allows it to go to 2 Gb. When trying to...
  2. mhudson

    Need help on inventory database design

    As a matter of fact, I am currently using Excel to perform this tracking, but it sure seems tedious to do it that way. Each day I have to insert new columns to enter the WIP, Packed Goods, and Shipped Goods quantities for the previous day. I then have columns for calculating what remains in each...
  3. mhudson

    Need help on inventory database design

    I am struggling with how to design the tables for an inventory database for our company. What is giving me problems is that we have 3 levels of inventory; WIP, Packed Goods, and Shipped Goods. Of course, what gets packed comes out of WIP, and what gets shipped comes out of Packed Goods. We are...
  4. mhudson

    How to handle null value in a @DbLookUp

    Hey pmonett, I tried using your code as the basis for the modifications, but no matter what, I never could get it to work (kept fussing about the syntax). Could you please give me a verbatim set of code to use (based on the code I posted)? If you can, I would mbe most grateful.
  5. mhudson

    How to handle null value in a @DbLookUp

    Thanks! I will give it a shot and see how it works. I am not all that knowledgable on Notes programming, so I may have to ask you to really dumb it down so I can understand it more easily. Thanks again.
  6. mhudson

    How to handle null value in a @DbLookUp

    A user has asked me to add a lookup value to an existing field on a form. The new lookup looks for values (amount of scrap)on a given date to be added to the scrap on a different form (different sources of scrap) to get a total scrap amount. The formula looks like this...
  7. mhudson

    Cannot create a "Clean" new view

    Thanks, ABOzIT! You were dead-on with your solution. Still being kind of green on Notes, this is something I had overlooked, as I hadn't clicked on the blank area within the Designer view to see the SelectForm. Once I changed it, the view did as it was supposed to. Thanks again!
  8. mhudson

    Cannot create a "Clean" new view

    I am working on an existing database in order to make modifications for its primary user. She needs a form to do a part price lookup, so I created a new form to input the part number and price into. Since lookups require a view to work from, I have created a new view using a blank template in...
  9. mhudson

    Excel macro help needed

    I have to import into Excel a tab-delimited file from another application from which to generate a new spreadsheet on a daily basis. The result is a sheet with numerous rows of unneeded data which have to be manually deleted. Is there a way to write a macro (or VBA script) which will delete a...
  10. mhudson

    Outlook address book not available in Word

    I have a user running Office XP who uses Word as the default email editor. When sending a new email, clicking on the "To" button fails to bring up the Outlook address book. The address book and Contacts folder work properly otherwise. I've already checked to see if the contacts folder...
  11. mhudson

    "Invalid or nonexistent document" help needed pls!

    Thanks for your reply, Pmonnet. I did check all the permissions on the database, and the server had maximum privileges. Also, all people in the ACL had the proper privileges. Not being one to give up and sit back waiting for someone else to solve the problem for me, here is what I did to fix the...
  12. mhudson

    "Invalid or nonexistent document" help needed pls!

    Last week a very important Notes database began giving this error whenever any record was selected. I tried fixup, checked all the settings (which match those for all the other databases which work just fine), refreshed the design, and none of this worked. Yesterday I wound up restoring the...
  13. mhudson

    media player problem

    I am having the same problem as Goss on a new Toshiba laptop. Nearly every time Media Player tries to play a file (no matter the extension) it crashes the OS. I have gone through the manual uninstall/reinstall, but it didn't fix my problem as it did his. Any other suggestions? Your help will be...
  14. mhudson

    Database keeps failing - please help!

    This an update to the failing database situation which I had erroneously thought had been fixed. After having tried all the excellent suggestions you guys generously provided to correct the problem, I thought I had that dog whipped, only to see it fail again. What I finally wound up doing was to...
  15. mhudson

    Database keeps failing - please help!

    Hey guys, after restoring the database from the Tuesday backup, it is still running without problems. Why the Wednesday backup would work and then fail later is still a mystery to me. Hopefully we have brought an end to this saga. I have learned a few things I didn't know before, and I want to...
  16. mhudson

    Database keeps failing - please help!

    I checked all the properties of the offending database, and it is not inheriting anything. The backup I was restoring from was from Wednesday 2 weeks ago, which worked briefly last week before failing. After restoring that same file and getting repeated failures, I restored the file from Tuesday...
  17. mhudson

    Database keeps failing - please help!

    Yes, there is an older version on the system , but it is just kinda "there" and not in the way, being in the Sysvol share. The Notes.Ini file was in the C:\Notes folder and that is the one where I removed the Design from the ServerTasksAt1=Catalog, Design entry. I rebooted the server...
  18. mhudson

    Database keeps failing - please help!

    Hey Packet7, I checked the Notes.ini file and these entries were found: ServerTasks=Replica,Router,Update,Stats,AMgr,Adminp,Sched,CalConn ServerTasksAt1=Catalog, Design ServerTasksAt2=UpdAll,Object Collect mailobj.nsf ServerTasksAt5=Statlog I have removed the reference to Design and saved the...
  19. mhudson

    Database keeps failing - please help!

    Thanks, guys, I'll check on these itmes when I go back in Mon. morning.
  20. mhudson

    Database keeps failing - please help!

    Sorry for the sparse information. When the database is accessed, it says "Unable to initialize - there are no views selected", then goes on about replicating the database. Hope this helps. By the way, I restored it again yesterday from the last good backup of it on tape from the week...

Part and Inventory Search

Back
Top