Recent content by LeonAtRC

Might be easier to just: Dim fd as object It's the: Set FD = Application.FileDialog(msoFileDialogFilePicker) that makes the object a file dialog object.

We have from 10 to 30 computers running an Access 2003 ADP program with the back on SQL Server housed at a service provider. The computers all have their own copy of the access program. On any given day there will be up to 100,000 hits on our web site which is driven, in real time, from our...

I have some Access forms in text format that were exported using "SaveAsText". I want to put these into a sql table using a varchar(max) data field. How do I load each text file, which has up to 1000 line of code, into a single record using the VARCHAR(MAX) field? Can the text in the sql...

I'm trying to do a simple FTP out of a Windows 2008 cloud server to a 2003 server. The file is created on the 2003 machine but it is empty. Error message states that it cannot establish a data connection. I am logged in as administrator. The same commands work well from any other machine...

Here is the actual code I'm running to copy data from one set of tables to another. The table structures are identical. SET @runCmd = 'INSERT INTO dbo.' + @dbTable + ' (' + @fldList + ') SELECT ' + @fldList + ' FROM dbo.' + @tmpTable EXECUTE (@runCmd) @dbTable is the new table @fldList is the...

Not sure if this is the right forum. Please advise me if not. Using LogMeIn I often transfer large files (500 MB to 5 Gb) to and from two of the servers in our rack over the internet to my machine at home. Server a typically transfers at about 300 KB/s Server b typically transfers as about...

sql

You need a tble of clients with an integer field that is incremented each time a client gets a referral. When the form opens populate the box with the current number from the cient table. then update the fild and the box every time a new referral is created.

I'm trying to export data from a table into a text file using Scripting.FileSystemObject in a VB module I don't want to copy fields that are Identity field or Computed fields. rs.open "SELECT * FROM SomeTable"... buf = "" FOR EACH fld IN rs.fields IF fld.type <> COMPUTED THEN IF...

Thanks markos. In 12 years I've never come across that!

Tbl_A fName fSex aKey Tbl_B fHome fSex bKey These two tables are inner joined on the aKey and bKey in a view (theVue) that outputs these fields: Tbl_A.fName, Tbl_A.Sex, Tbl_B.fHome (The keys and tbl_B.Sex are not included in the view.) The query is: SELECT * FROM theVue...

How do I go about finding other computers on my local area newtork? I can use FileSystemObject to search for drives, folders and files but It doesn't allow me to look beyond my own machine. Is there another method or catalog that I can use? (I need to do this programatically.) Thanks.

I think you should be requerying Me.Field1

Never mind...I figured it out: If the name of the server's "Data Source" is numeric then it's remote else it's on the net.

Not sure if this is the right forum but I'm programming in Access ADP. My program can use SQL Servers that are either on the local machine, on a server on the local network or a remote machine through an IP address. I need to copy files from the applications machine to the sql server machine. If...