Recent content by Robson8112

goto file, get external data, then select add/modify FTP locations.. or when u add a new table, click import, select HTML file type, put the web address in.

I need my database to access the web and retrieve information every time its opens. I already know how to retrieve the info into a table, however, that info changes every day. When a button is clicked it opens a form displaying that info from a table, the table contains the info from the web...

nice one.. Thanks for your help

wheres the reports bit?

I need to be able to change the font colour of a txt box when it equals a certain value. e.g if the value equals 1 (and above), the text is green if the value is below 1 (-1 etc) the font colour changes to RED. can anyone help?

Cheers mate, i just needed to add in the DoCmd.Close Thanks for the help.

I need to know how you can have a button on a form that closes the form that its on when clicked but opens another different form at the same time. Can anyone help??

i'll send u the data base, i've removed quite a alot of forms and tables to cut the size down, but i've left the ones i've got the problem with. Will be with in a bit..

theres no errors, its just not showing anything..

Still no joy, below is my code (CboSelectServer is Combo1) Private Sub CboSelectServer_AfterUpdate() Requery Me![CboMedia] = "" Me![CboMedia].Requery End Sub

Gives me an error, Cannot find Macro?

It gives me a "Cant find Macro Error" this is what i put in the after update: Me![cboMedia] = "" Me![cboMedia].Requery

no errors this time, however its not showing any things in the combo 2 box

This is how mine looks, and it dont work SELECT DISTINCTROW TblMediaServers.Media Servers, TblMediaServers.Masters Servers FROM TblMediaServers WHERE ((TblMediaServers.Masters Servers=[Forms]![Tapes_Main]![cboServerSelect])) ORDER BY TblMediaServer.Media Servers;

Does anybody know how to create a command that opens up a current date/time in a small form so you can select the date/time from a calender OR a button that when clicked inserts the current time/date into a text box?