Search results

it was easier than that I just put mailto: infront of the email address

Hi is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?

Could I still add information straight onto the report? The db I am making is a driving instructor pupil db. I have a form which has all their details and I also want a way of recording their progress each week. I would use word for this however I want to be able to acess their progress report...

Its just to record notes on a weekly basis, so each text box will contain different information but i dont want empty text boxes to be visible mainly as I will have to print the form

Thanks for that. It works great but not exactly what I am looking for as that makes every empty text box invisible but what i forgot to say is that once I have put some text in a box I need the next txt box to become visible so I can use it. Any ideas???

HI I am trying to create a form where i have lots of txt boxes but I want all the empty ones to be invisible. I have sorted the code so that i can make the empty boxes invisible however what I want to know is what is a quick way of selecting multiple txt boxes in a code i.e my code is: If Not...

Hi Can anyone tell me what the advantage (or difference) is in using a switchboard rather than just creating your own form and using command buttons etc? Thanks

I have sorted it now Thanks for your help!! :)

Where do I put that?

Do you know how to change the workgroup file so that my security will let me into the new file?

I had already done that, when I open up the properties it shows the new address but then once I try and open it it comes up saying that it cannot find the old file.

Yeah I can get the properties When I try accessing it via the origional file it says that I dont have the necessary permissions for the file name. Do I need change the workgroup info file address to the new one? If so how do I do it?

I cant open it because of the internet security! Any other ideas??

Hi KeithG I have a shortcut but I have also tried opening it from the origional file. Yes there is user level security requiring a user name and password to "log in" Hope this helps

Hi I have just found out that my admin team have re-named all my folders so now teh folder that my DB was in is called a different name, so now my DB wont open as it says that it can't find teh file (as its still looking for teh origional folder name). Is there an easy way around this? (I cant...

Hi I am trying to create a search box on my form. I can create an unbound txt box and use a comand button to open a form and display a particular fields fine however this isnt quite what I want. I want to be able to use an unbound txt box and be able to search different fields. So I would...

Just had a thought a box where you could put the date into would probabily be a better idea i.e. you click a command button which displays a msg box taht you can put a date into then the query will show a report with all teh items with a date before that one

Hi everyone I am tring to create a query so that when I click a command button I can get all the records that have a date between now and the next 7 days. the reason why I want this is because my DB is a servicing schedule and I want to be able to click the button and have a list of all items...

Hi Yeah there will always be a number and yes it will always come last. the format is CON WD [NUMBER] so e.g CON WD 1 I hope this explains better Thanks

Hi Thanks for replying. I have text as well as a number e.g. "con wd 1" etc so could you explain abit more about how to do CLng (where to put it) please Thanks