Search results

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 ...

Steve, What I have done is created 3 querys and three forms. On your recurring form, when the user clicks everyday, the form daily event is linked to on-click. When the Daily event form comes up, if they add new record it willl assign the days with the ticks. Hope that helps

Could u send me a copy of what you have so far?

Steve, If you manually type in the day on your table, then try the attachment I ave made up for you. Notice how I have put the word Sunday in the query? Hope that helps m8!!!

Steve, If your form is run off a query, then you could put date() in the search criteria in the date field. This way, the query will only show any activity from today. If your button is referring to that query then hey presto!!! Hope that helps!!!

Thanx Again Kevin & G Hudson, I am a day or two away from starting the security wizard. I have looked over quite a few threads in this subject and from what I have read, I will need to read up a wee bit on it first. I have kept a back up off the MDB & MDE version of the database - so I will...