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...
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?
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..
Still no joy, below is my code (CboSelectServer is Combo1)
Private Sub CboSelectServer_AfterUpdate()
Requery
Me![CboMedia] = ""
Me![CboMedia].Requery
End Sub
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?
i just need to know how:
When i select an option on Combo box 1 it displays cetain info in combo box 2. I cant seem to retrieve it.
The info in combo 1 and combo 2 both read from different tables, but both are linked?
so, when i select an option in combo 1, it gives me certain options in...
im not getting errors now, but nowt aint happening. here my code
Private Sub CboSelectServer_AfterUpdate()
Requery
Forms!Change_test.Form!Change_Subform!txtMasterServer = Me!CboSelectServer
End Sub
if u want the code for that whole form, just ask.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.