Recent content by Phantazmo

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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