Recent content by kec

Here is some code to link images in reports. I've seen this asked several times on this board, so I hope this helps... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error Resume Next Dim DBpath As String DBpath = [Forms]![Main]![Img_Path] If Dir$(DBpath...

Here is another view of a hi res image form - this one has 8 images (tabs at the top) attached to it. http://img.photobucket.com/albums/v521/kecline/Access/dvd_sample.jpg -Ken

Here are a few more SS of my statistics form. More to follow.... http://img.photobucket.com/albums/v521/kecline/Access/dvd_db_sample.jpg http://img.photobucket.com/albums/v521/kecline/Access/dvd_db_sample2.jpg http://img.photobucket.com/albums/v521/kecline/Access/dvd_db_sample3.jpg -Ken

I'm in the process of cleaning/fixing up the code, tables and stuff. In the mean time, here is a screenshot of the high resolution image form when you click the small thumbnail on the main form. Currently, you can add up to 8 images per title...

Let me clean it up a bit and I'll post it. -Ken

Thanks Rak! For the life of me I couldn't find the author of the code - and I had looked through Stephen's code, but missed it. -Ken

No problem skea. I just wish I could remember where I got the code from so I could give credit where credit is due. -Ken

Thanks! I was trying to design it so it didn't look like a typical Access DB. Well done! -Ken

Well, since we lost the screenshots thread, I thought I'd start it up again. Here's my DVD database (URL deleted as it is a dead link) -Ken

This code comes from Stephen Lebans, http://www.lebans.com/Report.htm This code draws lines around each field in the report detail and expands with the text. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim CtlDetail As Control Dim intLineMargin As Integer ' Stephen...

Steve, You're not the only one, I'm having the same problem. Although, it seems to work most of the time, but occasionally the user is getting the same message. I haven't been able to get this error on my machine though. This one has me stumped :confused: I tried to look through Outlook...

I agree, the easier for the end user the better. I forgot to mention, In the email I put some text like this: Please follow these steps: 1. Make sure you close your existing database. 2. Click on the link below. 3. Click on open file when prompted. 4. Click OK. ...so the users knows exactly...

It's just basic batch file stuff... C: CD\ CD MAS\ DEL MASQA_Prgm.mdb S: CD\ CD Quality_Control\Share\QC_DB\Updating\ COPY MASQA_Prgm.mdb C:\MAS\ That's it. I wouldn't want to have an automatic update. I like to have control of when the change is implemented. I setup a distribution list in...

What I do is, keep an updated copy on the network then send an email to all users with a link to a batch file that deletes the old DB on each system then copies the new version. It works great. That way I don't have to go to all 30 users to update. I'm sure there are fancier ways to do it, but...

Well, that works, but I really wanted to get the viewer to work so I could implement it into my database so other users could use it. -Ken