Clean A Folder Contains

Jun 17, 2005

I've built a Database which creates XML Files to import into another program. It just adds files to the program in a batch, so ever time I run the Export I want to Delete all the existing files for the holding folder. Have anyone done this before?

View Replies


ADVERTISEMENT

Clean The Records

Jun 29, 2006

here is the scenario:

i have a table that includes large number of records (10,000+) we call it raw data

the process is to "clean" the data by eliminating certain records: example eliminate records of Property Name that includes "restaurant" "golf" resort" etc....

The list of words that we want to eliminate (ie restaurant, golf, resort, etc...) is included in a separate table.

How can we produce a new table or query with cleaned records?:confused:
Thanks

View 2 Replies View Related

How To Open A Dialog Box To Move Files Inside A Folder That Is Setup As Current Folder

Sep 2, 2015

I'm trying to automate a process of selecting a set of file/s and move them in a folder. When I click on a button, it should open a current folder that is setup in the code.

Lets say that I have a folder C:documents est, and very time I click on the button, it should open the dialog box with that path so I can select the files from another folder, drag them there and they will be saved in that folder.

This will form part of wider automation that will send an email stating that those file/s where placed in that folder.

I have in the same form where the button is placed, 3 check boxes that needs to be passed to the email as well that one or all the files where placed in the folder.

View 10 Replies View Related

Modules & VBA :: Open Folder Nested Inside Main Folder?

Mar 16, 2015

I'm trying to open a folder based on a BIN nr. This folder could be in a main folder that has diferent subfolder. As there where differnt naming used to create the folderes, one of the things they have always is the BIN nr. It alwasy start with a unique number and maybe I could use it to scan the subfolders and open that one that the BIN nr is equal as in the field BIN.

Now we have serveral 1000th of folders and finding them takes time.

View 3 Replies View Related

Clean Up A Linked Table

Apr 21, 2005

Hi all,
I have a linked table ( see attached image ). In it are several lines with the same invoice number. 1 line with this invoice number has some info I need to retrieve by serial number ( but this line doesn't contain the S/N). My question I guess is how can I retrieve a SerialNumber along with the 2 right most columns from the image?
IE: 0067320, A20900, 502060, 2120202019 23

I hope this makes sense. I was thinking of using a make table query to somehow clean this up, but not sure what to place in the query.
any other thoughts?
Thanks
Kevin

View 1 Replies View Related

How To Clean Out Multiple Tables With One Query?

Mar 2, 2007

Is their a way to edit the following query so that it will delete from more than one table?

DELETE FROM tblSample

Or do I need to write a seperate query for each table I want to delete?

View 4 Replies View Related

Clean-up Access 2003 Database: Prep For CSV/TXT Format?

Apr 18, 2007

Hi,This is my first post here... I hope I am not asking a really stupid question. :)Basically I need to cleanly export an Access 2003 database to a TAB-delimited file... The database in question has 1406 rows and several columns... some cells have nothing in them -- this is a "contacts" database.Long story short, I need to export-out as TAB-delimited (or comma)... I have done this, but when I view my results in Excel, it looks like some things are messed-up... I think there are some tabs hiding around the database that I am not aware of.Any tips on cleaning-up my database for export to CSV (tab/comma)?Also, I have one field that is a dropdown list... When I export it out as CSV/TXT I only get a number and not the actual value of the chosen drop-down... Is this normal? How do I get the actual value and not just the number?Basically, I would like to just normalize this database and get it into a perfect-looking CSV/TXT TAB/Comma delimited file. :)I would be willing to pay for this help... I do not have much cash, but I really want to make sure I get this done right the first time.Many TIA's!Cheers,M

View 3 Replies View Related

General :: Importing Objects From Secured To Clean Database

Jun 3, 2015

I have an access database that was set with security about 10 years ago.

I have now created another database in 2010 and I am importing all the objects to make a clean non secured database.

When I import tables it imports system table objects like MSysRelationships, but as it already exists it adds another MSysRelationships with a 1 on the end (MSysRelationships1).

Should I delete the original MSysRelationships and then rename the MSysRelationships1 as MSysRelationships.

There are numerous others like MSysAccessstorage, MSysACEs etc...

I am gathering that if I don't rename MSysRelationships1to MSysRelationships then the relationship data would be incorrect and the database wouldn't work correctly, but maybe I am wrong.

View 9 Replies View Related

Modules & VBA :: Attempting To Clean Up A Free Form Text Box

Jan 14, 2014

When we are managing incidents, users have decided on their own method of recording the incident... here are some examples

INC002546
INCIDENT002546
2546
INC# 2546
Inc# 2546
inc# 2546
Inc # 2546

The correct way is the following:
Inc# 2546
^ capital I, no space between "c" and "#" but a space AFTER the "#"

Then the 4 digit long number.I was thinking along the lines of trying to identify the number, removing everything else and then placing "Inc# " before it...
currently we allow notes, which should be made like such: Inc# 2546 - Notes.however, people have their own method for this too (however most of them are at least after then incident number so that makes things much easier)another issue is on the same database, some manual requests also appear which have different entry format: RQ# GK034LW2052 but that contains a mixture of letters and numbers... so when identifying the request number... as long as I make sure that it is a number and not a string of numbers and letters, I should be ok..

View 8 Replies View Related

Create A New Folder

Oct 25, 2005

I would like to create a new folder with a specific name.

example

I have a k: drive where i want the new folder created

I want to name the new folder under the k: drive.

Im sure this is very easy to do, but i can't seem to find an example in the forum.

thanks in advance

View 1 Replies View Related

Does A Folder Exist

Feb 21, 2007

Hi,

I've got an Access 97 piece that imports text files, copies and moves the used files and several other things.

I've now been asked to enable it to create a fairly complex folder structure.

I've done that, but I'd like to be able to issue a warning if the root folder already exists, can someone please show me how to check if a particular folder exists (I don't particularly care if its full or empty).

View 3 Replies View Related

Moved Folder

Feb 21, 2008

Hi

I have just found out that my admin team have re-named all my folders so now teh folder that my DB was in is called a different name, so now my DB wont open as it says that it can't find teh file (as its still looking for teh origional folder name).

Is there an easy way around this? (I cant change the folder names)

Thanks

View 14 Replies View Related

Import From DB In Web Folder

Jul 7, 2007

Hi all

I have a few DBs operating in a few geographic locations. I'd like to update them all... could I use a command button in the DBs that I distribute to import new forms etc... from a DB that sits in a web folder?? Kind of like a web update?? This way end users can update it themselves.

Or maybe theres another way to do this??

Ideas are much appreciated.

View 2 Replies View Related

Putting Queries In A Folder

Jul 31, 2005

Hello,

I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible?

Having 40 queries all inside the database window is not so convinient...


Thanks in advance for any replies.

View 1 Replies View Related

Shared Folder Problems

Feb 1, 2007

I'm currently having problems with splitting my database.

The situation as present it:

- I have a shared folder on my laptop, to which i have given full permission rights to a collegue, in this folder is the backend of the db which i split from a database also sat in the shared folder

- I can then go to the front end of my database either on my desktop or shared folder and update tables

- However, this is where the problems start. The copy of the front end that my collegue has (an exact replica of mine) cant access or open any tables. Even if he opens the exact front end that I'm successful with in the shared folder. The following error message appears

"Could not find the file 'D:Testdb_be.mdb'"

the D drive on my computer is where the shared folder 'test' is stored.

Any hints or advice on why this isnt working?

Thanks in anticipation

Ross

View 10 Replies View Related

How Do I Link Images To A Folder?

Mar 30, 2005

Hi there.....

I have a minor problem......if anyone could help me on this one, would be much appreciated.


I have a field "OLE Object".

Great!

BUT!! .......I want to be able to LINK my products to pictures from a file.

IE:
Product 1 = AB1.jpg
Product 2 = AB2.jpg

Both images are in C:/images

So...product ID1 is linked to image AB1.jpg...product ID2 is linked to AB2.jpg.

The images must also appear as images in the FORM.


Any ideas on how I can do this ?

Thanks in advance.

Chris

View 1 Replies View Related

Copy From A Drive To A Folder

Feb 27, 2006

Hi.
I have been searching previous threads and the help file and got half way, but have got stuck.

I want to copy all files from a floppy disk to a drive on a directory on a server. I can check to make sure the directory exists and if not, can make it. All I want to do is copy all the files from the floppy disk drive (A drive) to the direcory I have just created.

I got this from the help in access:-

FileSystemObject.CopyFolder "c:mydocumentsletters*", "c: empfolder"

but can't get it to work......is this the way I want to go?

Can anyone help?

Thanks.

Frank.

View 3 Replies View Related

Fusing Form And Folder

Jun 14, 2006

Okay, so I know how to open variable folders with a button or combobox from Access...but I think I want to have my cake and eat it, too;) Is there any way that an Access form and an Explorer folder can be meshed into one object?

I had an idea where after the user selected a value from the combobox (afterupdate) then the folder corresponding to the combobox value would open (this part I know how to do)...but the folder would open in a specific part of the form. Like binding windows explorer into an object box and then having it jump to different folders as the user changes the combobox selection, aand the user would still be able to drag stuff into WE from the desktop or wherever.

Am I being vague? Can something like this be done? I think if I just knew how to open a folder in a specific place and size I could work something out.

Any help with this would be awesome, I haven't been able to find anything like this in the forums!

View 4 Replies View Related

Current Folder/path

Jun 11, 2006

Hi all

How can I change the output string in the command below to simply save the document to the same folder that the DB resides??

DoCmd.OutputTo acQuery, "qryAwardsExportWord", "RichTextFormat(*.rtf)", "C:dataawards.doc", True, "", 0

any help is appreciated

View 2 Replies View Related

Folder Path To Variable

Feb 28, 2007

I have a form set up and I am looking to:

Set up a txtbox that will house a variable (no worries)

I want a button that when clicked to open a "MS Windows window" that allows the user to navigate to a folder. When done I need that path to be placed in the textbox I set up (Or to a variable)

Does that make sense?

I thank you all for your help it is very appreciated.

Thanks Again

View 4 Replies View Related

General :: DVD Linked Folder

Jun 19, 2014

I back up our databases every Friday to a Dvd. Can I have a linked folder on our DVD backup in case we would like to look at the last current Mdb

Structure

C:MsAccessDatabase.Mdb
C:MsAccessLinkBackEnd.Mdb

View 7 Replies View Related

Modules & VBA :: Up One Folder In FilePath

Jan 24, 2014

FilePath = CurrentProject.path

I am currently using this path, but I moved my database folder into another folder so people won't mess with it. I still need to create files to the original directory. How can I make the FilePath still relative but up one folder from CurrentProject.path?

View 5 Replies View Related

General :: Testing Folder For A Value

Aug 1, 2013

This code below works, but alot of what it does is unnecessary. I have a directory structure named 1000-2000, 2001-3000, 3001 - 4000 etc and within that is the individual folders 1000, 1001, 1002 etc

How do I test to search top level folder thats no larger than correctNum to then test the subfolder for correctNum? I've looked at instr and a few other funtions, but can't find a solution. Below is what I have now, it works but I know it searches everything and that's not correct

Dim filesys
Dim Subdir
Dim folder
Set filesys = CreateObject("Scripting.FileSystemObject")
Dim oDir
Dim bDir
CorrectNum = Serial.Value

[Code] ....

View 3 Replies View Related

Open Windows Folder From Access ??

Jan 3, 2007

Please forgive my Newbieness and accept I am a keen ametuer running a small business and trying to use access as a tool. No doubt I will be back with many questions as you all seem so knowledgeable, thanks in advance.
Can't really do code but get on OK with built in wizards etc. Wonder if someone might be able to help with this one:

Is it possible to set a command into a form that opens up a windows folder elsewhere on the computer or network? For example, receive email from DIY multiple containing kitchen plan, installation costing etc, as attachments. File attachments in folder on server, manually enter detail into access database which generates "Customer ID Number", decides which fitter, surveyor etc. then need to email a report (have managed conversion to PDF and to launch outlook) but then wanted to copy and attach the original attachments to this new email, along with Access report for forwarding to various surveyors / fitters around the UK. Thus require if poss to open file on server, copy attachments and paste in new e mail, thought it would save time to do by one button press to open server file??

May seem easier to just forward original e mail but unfortunately some of the info in the mails from the DIY multiples is not for distribution and filtering isn't possible.

Perhaps one simply can't do it but worth asking, thanks again. Paul

View 3 Replies View Related

Save Attachements To A Central Folder

Dec 26, 2007

Hello,

I have searched and searched for this but I dont seem to find a solution that suits me.

This is the situation. I have a a database wich is used by multiple users through a front-end. The back-end resides on a server.

Is it possible to select an attachement (word, excel, picture, etc) with the front-end and automatically save it to a folder on the back-end?

This way all the attachements are in a central place and NOT in the database.

I know I can easely solve this problem by saving the attachtments to the database itselve but I dont think that attachements belong in a database.

i hope that you guys can help me.

Thanks in advance

View 2 Replies View Related

Auto Relink To Current Folder

Jan 20, 2007

I've searched the forums for days and I can't find exactly what I need to know, even though this is a very common topic, so if it's already been answered, I apologize.

My problem is simple. I have a database that tracks clients for me. I have a front end and back end in the same folder. Under normal circumstances, the static links that Access uses are fine. I just link from the front end to the back end and all is well.

But some other users of the database will need to track multiple people's clients. So instead of putting the database in c:database, I may need to have a copy in c:database, c:database2, c:database3, etc.

So what I need is a (hopefully) simple way to get Access to look for the backend in the current directory, no matter what that directory might be. It may be on a network drive, or the c: drive, or any of a dozen various subdirectories. And the users who will be using the database may be very computer illiterate, so I don't want to have any user intervention required.

And so that I'm not any more confused than I already am by any code you might offer up, the name of the database frontend is tracking.mdb and the backend is tracking_be.mdb

Any ideas? Thanks in advance. You'll make my week if you can figure this out with me.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved