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

    SourceSafe and VBA Access

    Folks, I have a job shop management database that I would like to tie in with a SourceSafe database. ie. SourceSafe currently vaults thousands of NC program for CNC lathes and mills, and I would like to update item records within the Access 97 database to reflect current code revisions...
  2. Phantazmo

    Run query without confirmation from user

    You can use the SetWarnings method. ie. private sub RunQueries() docmd.SetWarnings false <run your queries> docmd.SetWarnings true end sub hope this helps
  3. Phantazmo

    Change file attributes

    Okay, lets just say I forgot to put the "A" after "VB", and I developed the program using VBA.
  4. Phantazmo

    Change file attributes

    Good day folks, I wrote a little VB program that strips attachments from saved email. One problem has arisen however. Since it is for a webmail type system, the reader uses the email file date as the actual email date, as opposed to the header date. So, when I strip the attachment out, the...
  5. Phantazmo

    Valdiate Email Entry?

    If you are doing the entry from a form, you could try writing a bit of VB to do a pattern match. ie. function emvalid(inEmailAddress as string) as boolean const pattern = "*@*.*" emvalid = false if inEmailAddress like pattern then emvalid = true end function Then, after the...
  6. Phantazmo

    Data structure

    Hi Willir, Unfortunately since there is more than one person entering the timecard data, there is almost always an entry error or two per week which don't get resolved until after the fact, a regeneration the calculated values would have to take place. I suppose creating a function or macro...
  7. Phantazmo

    Data structure

    Thank you SQLsister, I must have been reading your mind. I just finished that little project. I submitted all data greater than 2 years into the archive table. p.
  8. Phantazmo

    Data structure

    Thank you. Its from a White Zombie song. :) Now, thats a really useful hint, and something I really didn't know. Particularly when the cost accountant is doing to indepth analysis of a specific project. Thanks Willir.
  9. Phantazmo

    Data structure

    Thank you BNPMike for the troubleshooting technique. The query in question would take the entire timecarddata table and was calculating Cost Of Employee by obtaining the Employee Rate, using a function which authenticates the user each and every time a line of cost was calculated. By...
  10. Phantazmo

    Data structure

    Folks, I currently have a employee management database that stores employee hours. It is spread across two tables currently, timecard and timecarddetail. One-to-many relationship. Timecard detail can conceivably contain records-to-limitation number of records for each Timecard...
  11. Phantazmo

    Access 2003 or other...

    Judging from what I've researched, and what I've read, you are correct. There are some 3rd party plugins that you can get for vs.net that allow access/manipulation of a MySql db, or you can use the odbc.net solution, which is apparently slow. Thanks again Mark. I will play the multiple...
  12. Phantazmo

    Access 2003 or other...

    Hmmm, twice now I've read the learning curve was high for vs.net. I'm looking forward to the project now... What part of vs.net is the most difficult? Is it the IDE or how it drives development? Can you recommend any good reference manuals? Back to your reference of MSDE, i've been playing...
  13. Phantazmo

    Access 2003 or other...

    Thank you Peter, That gives it some perspective. So, I could probably just build another database in Access 97 (or clean up the old one) and then deploy a .net solution as the front end for each user... I guess it wouldn't matter what I developed the actually database in, as long as the...
  14. Phantazmo

    Access 2003 or other...

    Folks, A few years (5 years) ago, I developed a database for a job shop using Access 97. It managed jobs, generated purchase orders and delivery receipts, maintained inventory, tracked costs ... ect .... The shop is now growing, and would like me to re-de the database. The shop doesn't have...
  15. Phantazmo

    Registry Location OE Setup

    That got 'er VBSlammer dude. Many thanks. Have a star.
  16. Phantazmo

    Empty an array

    Hmmm, Try Erase EPArray
  17. Phantazmo

    Registry Location OE Setup

    Thanks VBSlammer, I'll give that a go...
  18. Phantazmo

    Registry Location OE Setup

    (Sorry for the cross post, this was originally in the VBA section ... darn new guyz :)) Folks, This site is a tremendous resource. Many thanks to the powers that be. Quick question: I have written a vba module for an Access97 database that uses outlook express 6.0 (msoe.dll)to forward PDFs...

Part and Inventory Search

Back
Top