Recent content by play2mefish

grape, strawberry and

I just created a quick database and this is how I did what you're asking to do: Dim foldername As String foldername = "j:\ema shared\legal\records request\" Shell "c:\windows\explorer.exe " & foldername & Me.patientname, vbNormalFocus Since my data all resides on J: drive, just...

I just did this very same thing in a db that I use every day and here is how I would do this: Private Sub desc_AfterUpdate() Me.ProvisionDescription.value = Me.cboCode.column(1) End Sub Hope this helps.

I have finally solved this issue. It appears that the me.command163.hyperlinkaddress was the issue. As it would always remember the last record that would work. So, I changed the me.command163.hyperlinkaddress to a shell. Here is the code that worked: Dim strdell As String strdell = "your...

JackKaptijn, Thanks for the reply. I tried your suggestion of the CASE statement, and I got the same results. If a record matches DELL and has a serial number it goes to the web site as advertised. If I switch records to a Cisco and no serial number, it will still start the DELL web site with...

Hello everyone, first I would like to thank this board for all of the help I have received before I ever signed up so I could post my questions. Over the years I have always found a solution on this forum for everytime I had a problem. But now I have an issue and I can not for the life of me...