Search results

Thanks Mark. This is a godsend. I didn't have time to start from scratch without using a sample. I've been away from Access for a while and I need to knock a program together asap, so this has been a great help. Cheers Andy

Lagbolt, The sample you posted is great. I don't have any knowledge of treeviews and wondered if you could give me an idea on how to amend the code to set the root node as a specific folder and then add nodes for the sub folders and files. I just want to show the files and sub folders beneath...

You best bet is to use MySQL and PHP. MySQL is a database system and PHP is programming code like HTML is retrieve and update/delete data from the database. I'm unable to give you some specifics at the moment but if you do a search for MYSQl and PHP , there are a number of tutorials on the...

Dave, Do a bit of research if you can on the webhost before signing up? Create a support ticket or use there online resources to see what response times you get when they reply to your query. Check out there community forum, if they have one? Maybe also check out - www.webhostingtalk.com...

Tom, I'm no expert with flash by any means. I'm not sure on the error message to be quite honest. I started in flash by usinf flash help(F1) and searching the help files. You can actually add the code via menus in the action panel. Undo anything you have done since I posted, then click on the...

Tom, You should be able to add an action on the button by using actionscript. You could use fscommand or geturl I suppose. on (release){ geturl("filepath.mdb","about_blank")} Or something similair to the above. Not tried it so i hope it helps. Andy

Hi, You don't need to use the registry etc. things like browser and IP are done through cookies and/or sessions. The most popular ones are in PHP such as: REMOTE ADDR HTTP USER AGENT REMOTE HOST These are just some variables used to retrieve the values, then you can document.write or echo...

Maybe this will explain the supported formats in 2003. http://office.microsoft.com/en-ca/assistance/ha011472041033.aspx#EnableGraphicsFilters Scroll up the page where it states Supported files and the Graphic Filter option with some formats. Andy

To do this you have two options: 1)Export data from Mysql into csv then import into local mdb 2)Ask your web host for remote access to mysql (doubt they will do this unless you have a static IP with your ISP.) HTH Andy

Ahrint, Talk to your webhost. Chances are they will not allow access without a dedicated IP. Maybe you will also need to talk to your ISP as well, especially if your ISP IP is dynamically routed. Your web host should be able to guide you as to the best way forward. Andy

Sorry Mark! Forgot about Firefox.:( Regards Andy

Mark, A workaround is to upload your html file to your webspace then rename the file on the server as webpage, leaving the .html from the end of the filename. When the browser calls http://www.mywebsite.co.uk/webpage it will then display the page. Andy

Can you post the db? Is it small enough? Andy

I tend to trap reports and display a messagebox when there is no data. On the Report_NoData Event msgbox "No Data Available",vbinformation,"Cancelling Report.." cancel = true However you can trap it on this event by doing what action you like. Andy

OK, not entirely sure but you can check a couple of things: 1) When you enter the password, trying pressing F11 to show the database window. This will show all objects in the database. 2) Go to Tools > Options on the menu. Click on the Advanced Tab and see whether the 'Default open mode' is set...

Tom, I use the following code: 'Call Shell and Reference HTML Help Executable 'otherwise you will get the windows file open warning Shell "C:\Windows\Hh.exe C:\Path to Help File",vbnormalfocus HTH Andy

This entirely depends on your table structure and the data you want. Do a search on the forum and post specific problems that require help that you are unable to resolve. Data is entered into a table, queries pull specific data you want. This is also called filtering. Depnds on what you want to...

Glad to Help and welcome to the forum Juan.. Andy

Ron, It works for me. Try creating a new report and put the etxtbox and enter the expression and see if it works. If it does then you must have some formatting on the textbox or report that is over-riding the xpression. Double check on the Format property of the textbox to ensure it is blank...

Ron, Put apostrophes not single quotes around the yy part of the format: ="January" & " " & Format(Year(Now()),"yy") Andy