Recent content by charlesandrews

Now you've totally lost me lol.

Thanx SJ, I will try that when I go home. Do I just include that code in the VB form?

Hi SJ, Glasgow is very bright today eh? SJ, I was wondering if you could point me in the right direction. I have been using MS Access and Visual Basic for access for the past two years and have managed via the help of this forum to create cool functional databases. However, I have recently...

Hi Hayley, It's been a while since you posted this topic. Can I ask if you have had any success as I would love to incorporate that feature into my mp3 database. Regards

After searching I have a similar problem. I have included 2 picture and an explanation the best I know how. Any help would be massively appreciated!!!!!!!1 :)

Hi SJ, I see exactly what you mean. Sorry :) Ok, here goes .... I have three fields as follows: CallStart, CallEnd and Cost. If the user clicks on call start on a form, the call start field is automatically set with the date and time as per click. On the cost field, If the user types in...

Anyone? :)

Hi, I am creating a small call logging database and I would like the user to receive a message 1minute before the call is due to end. I was thinking something like: if [callend] =now() then msgbox "Call Due To End" Can anyone help? Many thanks Charlie PS, I have searched, but to no avail...

Many thanx SJ, I followed your example and all works fine. The only thing, is that I put it on the open form event. Seems to work fine, do u see any problems storing the function there? I do not know where you meant be to place your code. Many thanx Charlie

I have a form with three fields: CallStart CallEnd Cost When a call is logged, I have it set that the time is entered automatically viz =now(). I would like it where if the cost = £20.00 the call end would be automatucally 30mins ahead. If the cost = £40.00 then the call end would be 1 hour...

Thanx Lagbolt, Saves me a good bit of time there :)

I have tried searching a few threads, but can't get the answer or perhaps i'm tired. Anyway I have a YES/NO field and a command button. I want the button to be visible only if the yes field has been selected. No = invisible button. Thanx

Thanx Dave, I look forward to seeing tha m8. Dave, I notice when I scroll through the form you created, Media Player increases in size. Is there any way to stop this, because the play button becomes invisible? cheers

Hi Oldsoftboss, Thanx for your reply mate and sorry for the long awaited reply back :) I had a look at the hyperlink you sent me and it doesn't really help with what I need. I have created a field called hyperlink in my table and that's where I link the title to the song. Since my original...

Shawny, I have the perfect solution for you. What date, would you like the database to start from? Watch this space ...