Search results for query: *

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...

PWise: Thank You!! For years I've assumed the External Import was just for data files. I had no idea it could be used for objects. I've beed fighting with numerous errors in trying to use LoadFromText but this solves my problem completely.

You don't indicate what "Me.Name" is but that would be a good place to put the table name. Then use the On Open event of the form to set the table: Private Sub Form_Open(Cancel As Integer) If Nz(Me.OpenArgs, "") <> "" Then Me.RecordSource = Me.OpenArgs End If End Sub This could...

I have two tool bars containing 32 items. Some are drop down menus with numerous items and sub menus 2 and 3 deep. I would like to transfer these to another adp file but nothng I've read about exporting user defind tool bars appears to be what I need. I would prefeer to export as text files and...

I'm importing text files that were exported from Access. Some included the identity field and some did not. So I need to know which files have identity fields in them. (The text files do not have all the fields that are in the SQL tables.) Dim cnn as new adodb.connection Dim rs as new...

Got it folks! Thanks George...you code Does work just fine. By the way...this SP has to work with numerous table so that is what necessitates the use of variables. Thanks again to all.