Search results for query: *

I've been trying to make an Import Specification for a macro into a table and while I'm at it, import data into a table. No problems with the Specification, but when I try to import the text file into a table, an error pops up. The error said no search key found. I haven't ever seen that...

Thanks, I've got a batch file put together that works. There is only one problem. The files I get from the ftp site sometimes have files with the same name except for a time stamp as part of the filename. Is there a way to get all the files? The files are in an ftp folder that contains...

I've found out how to get around it. I'm posting this for others to reference. In the code Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP") objXMLHTTP.SetOption 2, objXMLHTTP.GetOption(2) <-------Add This Line objXMLHTTP.open "PUT", url, False, user, pass objXMLHTTP.send...

I'm trying to use Access VBA to automate the upload of several files into several folders on Sharepoint. I found this code by Jeff Jones but I cannot get it to work. -----Start Code--------- ' Written by Jeff Jones 3-30-2004. Pure freeware, please redistribute...

I'm trying to find out if there is a way I can programmatically upload a series of files from my local hard drive to several Sharepoint folders. I'm trying to automate a process so I can stop this tedious process of manually uploading 20+ files to 20+ folders daily. Any ideas would be...

I'd like to code in an FTP batch process into a module and I'm not sure how to go about it. I want Access to write the batch then run it. Has anyone done something like this? I'm running Access 2003 SP2 on WinXP.

Thanks PHV! I tried to compile and it worked fine afterwards!

I tried using just Right([CustID],4) too and it still is giving me a compile error.

I'm getting a compile error and I've got a basic function in my query. I haven't had this before and I'm at a loss at what to do. This is the entry that is giving me trouble. Key2: [first name] & [last Name] & Trim(Val(Right([CustID],4))) How can I get this to work?

I could really use some input on this. I'm sure somebody here knows something. Please Help!

I'm trying to find out if I could use PGP Command Line software to automate a decryption process using an Access module. If it is possible to automate and run the software through Access, I would appreciate if I could get some info on how it would be done so that I can justify the purchase of...

I'm trying to automate placing a file onto a Microsoft SharePoint location but I don't know if it is possible. There are a few popup windows, one of which is for a username and password. Is it possible to populate these fields from user input on a form in Access? Also, how would I get Access...

Thanks a million! It worked great!

I'm trying to get the results to a particular worksheet in an existing Excel file. I do have a variable in the query, but that is set before I run this. I select a date on a form, and the query works fine, it just won't work when running this.

...Set appXL = New Excel.Application 'Select the data you want to output !!!Here is where it happens!!! Set rst = dbs.OpenRecordset("SELECT * FROM [qryMou];") 'Open the receiving book and activate the required sheet appXL.Workbooks.Open "c:\OutputTest.xls" appXL.Worksheets("Output2").Select

Opps, I forgot, it is Excel 2003!

I'm trying to concatenate the values of two cells into another. I can write a formula for that, but I wanted to know if there was a function that can set the font size so that one value can be larger than the other.

Thanks you guys. Problem I'm having now is that since it's code, The text in the cell isn't dynamic anymore. Is there an Excel function that can provide a change of font size?

Thanks, but I still need the box to be dynamic, if the source cell changes, this cell would need to change as well.

I've got a formula that takes text from one field to another and I want to add another bit of text from another. The thing is that I want that second bit of text to be in a different font size than the first. Is there a formula or code that can do that?