Search results

Got it to work - I am such a flippn n00b. I put this in the wrong place and "MyFileName" wasnt populated all the way yet. Its derived from quite a few variables in a loop and I put this function about 10 lines to early. UGGH - i really need to tidy my project up! lol Kinda silly that you...

there isnt a un/pw - its a public server... here is the address I am trying... "http://terraservice.net/download.ashx?t=1&s=10&x=3700&y=22089&z=16&w=2000&h=2000" I get this error - 5 A first chance exception of type 'System.ArgumentException' occurred in mscorlib.dll

If My.Computer.Network.IsAvailable Then If My.Computer.Network.Ping("www.MySite.com") Then Debug.WriteLine("Site Available") My.Computer.Network.DownloadFile(ADDRESS, MyFileName) End If End If

bookmarked :) - Good Stuff guys keep it up!

1st marriage - 2 years 2nd marriage - 2 years Currently - Happy LOL

you have to use code to populate the tree and instead of populating it with variables you COULD hard code those values in. ? - Why use a tree control for a static menu? - Like what LOOK/functionality are you going for?

I cant reproduce any problem.... Any more specifics to re-create the problem?

Can you explain your ? furthur? - when you say distance are you talking about a wireless network? How far can you go on a wireless network?

search for "update" query in Access Help. Should find your answer...

No Internet on that PC so no autoupdates. Did a scan on both and a defragg. MSDN suggest a possible Virtual memory Setting. ghudson - it appears the other sections that would be more appropriate to this ? have disapeared. I have used this site for help for the past 4 years in all aspects...

Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Type OPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long lpstrFilter As String...

OS = XP pro SP2 200GB IDE HD with 134GB free (NTFS) 200GB USB2.0 with 54GB Free (NTFS) Virtual Memory = 1gb (Let Windows Manage) Trying to copy files from a external USB drive to the Hard drive. I have done this a million times and now it decides to foul up. When trying to copy files from...

little late but here http://www.access-programmers.co.uk/forums/showthread.php?t=94515&highlight=link+tables+code

Docmd.SetWarnings False do your code Docmd.SetWarnings True

Not sure if this matters but I always use the chr(34) for text queries DLookup("tblusers.sno", "tblusers", "tblusers.users = " & chr(34) & Me.individual & chr(34)) db.Execute "update tblstock set sno = 15 where stockid = " & chr(34) & SID & chr(34) Another thing just thought of If PID and...

I would point you towards the date/time functions. Such as DateAdd which you can add any given amount of time to a date/time DateAdd("n", 15, Now) '<--This adds 15 minutes to right now DateDiff Search on those and you should find your solution....

Dim strSql As String strSql = "SELECT tbl_MSTR_CTS_RAW_Data.* INTO [tbl_mstr_CTS_Raw_Data" & date & "] FROM tbl_MSTR_CTS_RAW_Data" DoCmd.RunSQL strSql

OK Check this out I created a function for ya You call this function like this Private Sub Command1_Click() AppendFiles "c:\MyFile1.txt", "c:\TheNewTextFile.txt" End Sub Here is the function Public Function AppendFiles(ByVal OldFileName As String, ByVal NewFileName As String) Dim fso As...

I would have to refer you to the FileSystemObject. This gives you access to files for read/write. FileSystemObject Object Description Provides access to a computer's file system. Syntax Scripting.FileSystemObject Remarks The following code illustrates how the...

Solution A.) Create a query to group the data together you want and then export out of Access. Solution B.) Create a new File and then open each file for reading and append to new file. If solution B is your only option search for FileSystemObject.