Search results

Hi Group, I've inherited an Access application - part of the code allows a user to set their Branch number using a form. The new Branch number is then held in the registry using the following code: If blnBranchNumberChanged = True Then strNewBranch = txtBranchNo.Text If Not...

Hi Group, I have the following code: newname= "H:\nob\" & left$(strFile,len(strFile)-4) & ".txt" but what is returned for newname is the literal string. I want the file to go to the H:\Nob folder which exists. left$(strFile,len(strFile)-4) resolves to this 6310104. So what I want is...

Hi Group, I'm using the FileSystemObject and the common dialogue control on one of my forms for a user to navigate to a designated folder. I list the files in a list box once the folder has been selected. I now need to loop through this list of files and move some of the files with a certain...

have I overcomplicated things..... I need to process some files (with the following extensions .xy, .cc, .aa and.pp) Two of these files are fixed-width so I've created an import specification for them. What I envisage doing, is: 1.Create folders for each type of extension. The files have the...

using VBA. I can select a folder from my existing application, using an API. I now need to read the file names in the folder selected. How can I achieve this? Kind regards

Hi Group, I've used a import specification to import a Fixed-width file. However because of the layout of the initial file, i.e the fields' header starts BEFORE the fields data, I need to do some manipulation to get rid of the extra space in each row. How can I loop through each record of the...

Hi Group, Is it possible to process more than one file from within Access. I've seen the Open <FileName> for input as #1 but no examples on how to use this for multiple files. Regards