Recent content by johnob

can i not do that automatically when i select a letter ?

Hello When I click on a hyperlink that I have added on a form, it will not open. I have added a sample of what im doing if anyone can help. Thank you

Forgot to add Link to see it working http://o-brien.eu/Health/CheckUp.html

Hi all, I have uploaded a copy of my access database as .sql to my website and created a table in the mysql database. Also done a html form of the database and a prosses.php. Evey time I run it I get the following error : Parse error: syntax error, unexpected ':', expecting ',' or ')' in...

Hi all, I have an external program that I export a csv file. In access there is a link to the csv file to a table & query, so that I get use the data , (like the graph in the sample db). Every day the csv file is created, but access will not update unless I use the Link Manager. Is there a way...

Hi, I would like to show my appreciation for all the help I am getting and given on my project. I just cant pop round and buy a beer, so is there any other way ? thank you John

Hi all, I have attached a sample db that I need help with. What I need is when you have selected a page from the combobox, How can you get it to return to [SampleName] automatically ? Thanks

The way I fixed this problem .. Place the following into the Format property of your displaying field £#,##0.00;-£#,##0.00 If you want another symbol just change the £ symbol in the above code. Thanks

sorry sorted

Hi all , I need to have the pound sterling symbol ( £ ) in a field, but only have two options 1- Dollars ( $ ) and 2 - Euros . I have done a search but cant seem to find out. How can I get pounds or change one of the others. Thank you

Hi all, Im using the below code to open a from depending on what option is selected on a combobox. Private Sub DirectPCombo_Click() Dim cboVal As String Dim stDocName As String cboVal = Me.DirectPCombo.Value Select Case cboVal Case "One" stDocName = "TestOneFrm" Case "OneRpt"...

it works thank you

Thanks for that, I see that it works, but I would need to change a lot of things (see attached pic showing the headers and each one has from 3 to 20 forms attached to it.) John

if you could send it , i will put it on John

No its on the create forms menu I have attached a sample db showing the problem John