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

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.

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

I'm havign trouble with some code to export to Excel. I keep getting a too few parameters error. Please Help! Here is the code I'm using. Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim intStart As Integer Dim appXL As Excel.Application Set dbs = CurrentDb Set appXL = New...

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.

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?

I have a worksheet with some text bpxes on it for user input. I am trying to set up a format so that when the user inputs a number, it shows as a percentage, i.e., user enters 30, and text box shows 30%. I have used some VB to set other text boxes to show $ for currency fields, but I cannot...

In Excel 2003, I have some text boxes for user input on a worksheet. Is there a way to format them so that when someone types in the numbers, it shows up as a percentage in the text box?

I've got a form I created by taking combo boxes from the Forms toolbar and putting them onto a worksheet. I wanted to know if there was a way to move from combo box to combo box by tabbing, or hitting enter. Thanks.

I have a form in Excel with text boxes and combo boxes for user input. I don't know how to set it up so that the user can tab from one field to the next. Please help.

I'm stuck trying to figure out if this is even possible. What I'm trying to do is take a table with 12 months, Jan, Feb, Mar,... and so forth and be able get the data from the first month with a value greater than zero. In the end, I'll have a new table with 1st month, 2nd month, 3rd month, etc...

This may sound like a stupid question, but I have a table with only one field, one record. I want to have that value show up in a text box on a form. I can't seem to get that to happen.

I've been agonizing over this all day! This is the SQL for the query that I built: UPDATE [Compl P129 A3C] INNER JOIN MasterFundSch ON [Compl P129 A3C].LOANNUMBER = MasterFundSch.[Loan Number] SET MasterFundSch.P129OldInv = [OLDINVNUMBER], MasterFundSch.P129OldCat = [OLDCATNUMBER]...

I've got an Excel Macro in Access that works once and then gives an error or does not perform correctly afterwards. I close the database and re-open it and it works fine the first time only again. Here is the Excel part of the code. I'm trimming a part of an Excel file and importing it into...

In my database, v2002, I run a module that imports data from another database, then runs a few queries. My problem is that when the module is finished, Access is frozen, I cannot get it to do anything. I have to exit Access and re-open so I can do anything else with it. Any help would be...

I'm trying to import a table from an Excel file. The problem is that the file is shared and I get an error saying it cannot decrypt the file. I tried to copy the file and import, but the shared status remains. I then tried to just copy the worksheet I needed into a file and then import...