Search results

Here's my code. It will create the folder for the ClientId but will not copy the DebtorID pdf to the new folder. I'm stumped Sub PDF() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT ClientID, DebtorID FROM tblDocuments WHERE NOT ClientID IS NULL and NOT DebtorID IS Null...

Here's what I have so Far Sub MovePDF() On Error GoTo Err_Proc Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT DebtorID, *.PDF FROM tblDocuments;") While Not rs.EOF If Dir("C:\ClientDocs\" & DebtorID, vbDirectory) = "" Then MkDir ("C:\ClientDocs\" & DebtorID)...

Hello All, I'm Trying to move PDF Files associated with a customer to there specific folder The query gathers the data, Gives me a list of files by account number Now I want to use the results of the query to move those files I have tried to modify code I found on here but I'm not very good...

Hello All, I want to move documents associated with one customer from my main document folder to another. I've looked at some sample code but nothing seems to work I want to run a query to get the document list Run the code to move these files ( PDF Files )To a new folder. and It's done...

Hey There! I am trying to produce a list of e mail addresses from a query. I do not want any blank fields to show up. So I put "Is Not Null" (without the quotes) in the critera section of my query. I still get null values. Any Suggestions? Thanks Rich1968

OK sometimes its something as simple as an index......Yep an INDEX!!!! Thanks guys fixed the indexes and wam speed. Still going to run thru all my code. Rich1968

Thanks Mahenkj2, found it, Gonna go thru it and hopefully I will satisfy my need for speed. Rich1968

No Bob, The BE is on the server and each of us has a FE, linked over the network. I wish there was a program that could look at it and tell me what to tinker with. I have read all of the posts, and tried all the suggestions. When the third person logs on wam, it slows down. Every FE is a...

Thanks Bob, When we have 3 people on the system it slow down alot. I keep a form connected to the BE at all times and I have gone thru the forms to make them perform better. I still have a need for speed! Thanks Rich1968

We are currently running a split access 2003 database. 4 users and it's slow. I am trying to come up with a solution. A friend suggested SQL. My question is there any easy way to this conversion. Will sql increase my speed I know nothing about sql, is it easy to learn? Thanks Rich1968

Bob, Finally got it right, I appreciate your help! Here's my final code: Option Explicit Function Import_multiple_csv_files() Const strPath As String = "C:\Core\" 'Directory Path Dim strFile As String 'Filename Dim strFileList() As String 'File Array Dim intFile As...

The Project Name is CMS(CMS Management)

Thanks for the help Bob, Here's my currect code: Error code 5 invailid procedure or call pops when I run this Function Load_Core_Data() Dim NextFile As String, ImportFile As String, FileCriteria As String, ctr As Variant FileCriteria = "C:\Core\*.csv" ' create field with path...

Access 2003

I'm using 2003

Hey Bob, Thanks for the help. Sorry to say i'm still getting the invalid call for ImportFile = Left(FileCriteria, InStr(1, strFile, "*") - 1) & NextFile This should work. I even changed the declarations. same problem. Thanks Rich1968

Bob, Thanks for the help. I tried this line and got an invalid call or procedure. ImportFile = Left(strFile, InStr(1, strFile, "*") - 1) & NextFile Thanks Rich

Ok here's my latest code. I have taken out the *.csv reference in the FileCriteria line and get message no files to import. If I put FileCriteria="C:\Core\*.csv" (This is the path to my data) I get run time error 3011 can't find the object. and it highlights my DoCmd line. Any help is...

Yes the error is occouring on the DoCmd line. doing the step through this afternoon. I'll keep you posted. Rich1968

yes I'm using mget in the script. but I am having a problem logging on to the ftp site. It's a secure site. The password is masked so I think theres an issue there also. I'm determined to keep working the problem. At least i'll learn something in the process. Thanks Rich1968