Search results

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

I don't know if this will help but... http://support.microsoft.com/default.aspx?scid=kb;en-us;815281 http://support.microsoft.com/kb/305995/EN-US/ K

You can make a form that lets you pull up old records to update. And you just add what you want to the notes field. We use a number we assign to a customer that is unique to them and our department and we can use that to pull up call records to update. K

Check this thread out: http://www.access-programmers.co.uk/forums/showthread.php?t=80648 It is along the same lines as what you are asking. K

Okay I think the big confusion is that you originally said you wanted the data not the tables. Now you are saying you should not be able to see the data. Is what you need really the database structure without the data? So you can add your fake data to play with? If you want just the contents...

Question related to this... By using workgroups, can you make it so they can not open a db exclusively? We have a person with just a tad too much knowledge who does it so they can do their work faster. K