Recent content by rambo12

Hi I have a subform with 15 columns and im having trouble fitting them in. Is there a way i can display the header vertically or multilined?

Yes, I would like to know this too. So far ive managed to get most out but it still showed the windows button and the top bar. I despise the 07 interface its so in my face.

Yes Brill Thanks for your help. I'll probably be back in a few hours with a load of new problems :)

I think i solved it anyway.. i saw somewhere Setting wait_timeout=3D28800 would work. I couldnt find the option in MyODBC 5.1 so i installed 3.51 and did that and all appears to be working. Now I can get working on some ERD's. Has anyone ever tested this over a usb modem? (3g/gprs) I dont know...

4.1.22 Mysql with MyODBC 5.1 and i have enabled the automatic reconnect under data sources in control panel. It's 20 seconds of inactivity that does it... if i keep opening and closing the table it doesnt go off. Once it does go away i have big trouble getting it to work again and usually just...

Ran into some troubles - Keep getting "MySQL server went away" after a while and then it just doesnt work. Timeout on hosts server is set to 20 seconds. Is there a way to get access to connect, do its stuff, then disconnect?

I never knew Access could use MySQL!! Just connected it up and looks promising.

Thought i might add that they do not have a server that could be used for terminal services. It's a small business and I think they have one PC which is only turned on when needed. I already host their website so i was thinking of using a mysql database and giving them a usb 3g adapter to...

I'm thinking of having an application written in VB to interface with a web based MySQL server which would allow both of them to connect and see the data. Would this work well do you think?

Hi, I have a scenario where there are 2 engineers with a laptop each. They go out and about completing jobs and would like to type the details instead of writing on multi-part forms. What would be the best way of achieving this? I was thinking a few things including hosting the mdb on a web...

got it... thanks guys. Found the example and put together my own code and it worked!!! thanks

how do you store the unit price at time of ordering. Sorry not very good in access

Hi, I have a table holding all product information like its price. I also have a table for orders & order lines. How can i store the price of the product at the time of ordering inside the order line table so that they do not change when the product table is updated i.e price increases? Could...