Recent content by TheEvilBankers

Neil and Pat, Thanks so much for your assistance. Soon as you both mentioned the text bit and I looked at the quotes I realized what had been done. The person who programmed this was trying to do things right and if it is not used for calculations she has them as text. Kim Who is need of a...

What I want is for DCount to see how many times a a Box# appears in a table, if it is 0 it puts a message up that the box does not exist. This is what I have as the code If DCount("[tblLockbox]![LockboxNo]", "[tblLockbox]", "[tblLockbox]![LockboxNo]=" & Me.[txtGLockbox]) = 0 Then MsgBox...

The code for select case is: Select Case (testexpression) Case (Variable) what you want it to do Case (Variable2) what you want it to do ... Case Else What you want it to do end select I usually use it to select reports from an option group Select Case Me!FrameName Case 1...

DVD Decrypter and FlashMpeg is what they are called. Doom9.org is a good site with information about DVD related programs, etc. K

Might want to check the manual. Also depending on what you use to change it to vob the audio track might have gotten dropped. I want to say I use DVD Crypter to rip. I use FlaskIt to convert. Both let me select what I get/convert audio or video. K

Len, I hope this helps. http://filext.com/detaillist.php?extdetail=VRO Have to tried to see if you can rip the file from the dvd then convert it? I might be able to post something tomorrow. I am at work but my home computer is set up for vidding. K

There are several ways to go about it. First I would determine what information do you want them to be able to access. If it has patient information your big concern is you are going to have to keep an audit trail on who is accessing and what they are accessing, because of HIPAA. You are also...

You might want to post this to the VB forums. Things quickly get buried in the general forum. K

I know when the last person that was in charge of this particular database tried to split it, she was reduced to tears...and not the happy kind. Which is why it probably not got split. They never had problems with the database until we were refreshed in May then its been slowly building up to...

Sorry about that...was trying to get the question done before running to a meeting to discuss the issue. Access: Created in 2000 but we are currently using Access 2003. It is a MDB. The only way to make it work was to go in and delete the old buttons and links and redo them with the original...

This happened yesterday at work. The access form froze and they could do other things but Access remained frozen. They logged off and when they went back in Access opened but none of the form buttons or links were working. The database is not split because it is used only by one station at a...

Autonumber selection in the DataType of the Table design. K

I would create an employee table, skills table (the predefined skills) and lastly a table called employee skills. In this table I would have employeeID, SkillID and experience. Then make a form where you select an employee, then a subform where you select their skills from a drop down box and...

Do IPods have the ability to play video? I have been considering an MP3 player too but keep changing my mind. K

http://www.access-programmers.co.uk/forums/showthread.php?t=80704&highlight=password+button Thread had a link to a site that has a sample db. K