Before I spend a load of time on this, thought I'd check to see if it's even possible.
Thanks to some help from folks here, I have some code that allows me to output some reports to a folder and then email those reports as attachments, all from inside my db.
Now I'd also like to delete those files after the email is sent, before the module ends.
Anyone know if this is doable? If so, I'll get started working on the code.
Thanks
BeckieO
Hello,
I have a list box on a form which pick up excel file in my c drive. Is there a way I can delete this files via command button? Let's say I would like to select the file in the listbox, and use the button to run the delete code.
Any help? Thanks.
Hi can anyone help. My database is running on a Citrix server. No real problems except that I am continualy being left with the database apparantly locked by another user. Am unable to delete the LDB file even when no other users are logged on. Is there a way of deleting LDB files in relation to stale Access sessions. I know that in normal circumstances these files close automatically. Problems seems to be occurring when the database is not exited properly or the connection to the server drops for some reason. I've tried loads but can't find a workaround.
Stuart Dennis
I need a way to delete a folder along with subfolders and files associated with a record via command on a form:
The path is stored in a text field "txtDocuments".
For example: "C:UsersWatsonDesktopFY1515051505-010"
So, I would want the code to pull the folder location from the txtDocuments text field and delete folder "1505-010" and all sub folders & files contained within it.
I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .
Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files
[code]...
Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.
What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
View 13 Replies View RelatedI have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.
How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?
I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"
I think my problem has something to do with security but I can't figure out what to change.
Hi guys.
Just a quick one, I couldn`t find anything on this or in any books I have.
I`m assuming I need to create an MDE file befire I can distribute my database for other people to use ?
Anyway, that I have done, but the question is, I`ve done this and have a select number of ppl using my database, entering LIVE data etc.
Once This has been done can I open this back up in access and make changes to the database, eg forms, reports etc etc ?
If not, is there anyway, I can pull the data out of this and import it into my origanal file, which can then be remade into an MDE ?
I hope I have made myself clear.
Thanks in advance for any help!!
Max
Hello,
Once I split up database into mde and mdb files is there a way to put them back togethere ? How can I turned linked table into table?
I would greatly appreciate your reply.
Debbie
HI I hope that someone can help me, I know it's not that hard, but I have never done it. Actually, I have a folder that has like 340 excel files. Is there a way I can write a vba code in either excel or access to get the file names in like a table or so, it's gonna take for ever to type them in manually. I only need to get the file name and they are all excel files. Please Help If You Can. Thanks.
View 6 Replies View Relatedi wanted to convert my MDB file to ADP.
the convertion went well except from on important issue, it didnt convert all mu queries to the new file, i tried another way but nothing.
please help.
all the forms and tables an d everythoing else are in the new file, although, the forms are based on all teh queries.
Is there any way to embed html type help file in an .mdb/.mde file? I have created an html type file, MS Word saves it as an .mht (Whayever that is?). Is my only option going to be to distribute this .mht with the .mde? How do you access the help file from with in Access?
What are some other relatively easy user help authoring options?
Thanks,
Ken
I have a locking file that I can't seem to remove. No one is in the database that's associated with the file but it tells me there's been a sharing violation. Can anyone tell me how to remove those files?
View 1 Replies View RelatedI'm having trouble converting my DB to an MDE file.
I'm programming in access 2003 and saving as a 2000 file format.
I opened a new DB and imported all objects etc... the saved as a 2003 format. Still won't save an MDE file.
Any suggrestions are appreciated
Damon
I was wondering if access has a log system that can log when a user connects to the database and would give date, time and username? My database is setup for multiple users.
View 2 Replies View RelatedI am doing my comptuer science coursework and one thing I need to include is "how does access stored files" and the basic description of file organisation. After some googlging around though I have found nothing, can anyone hlep me out on this?
Thanks
Chris
Hi
I am having much trouble importing csv file into access 2003
My freewebs site have a registration form
The forms are then downloaded into my pc as csv files
According to freewebs, the csv file is access friendly and can be imported into access
so I tried for about a million time and still no luck
where did i go wrong?
this is what i did
help !
regards
frontpageplanners
I wondered if some can advise me as to how to make help files and linking them in to the dabase. i.e. if someone clicked on a certain section for help then it would go to the help for that section. Is there an easy program to help write the files??
View 3 Replies View RelatedDear friends,
I'm working on a dbase now that categories files used for sales. The dbase has 2 functions: searching the texts and saving/editing the texts. I'm not a (Hollywood) star in VBA and a need to build in the search function an option where the user can search in the found documents :( . In the save/edit option the user has to copy/paste the text in access and save the text with his attributes. The texts are saved outside the dbase in the same folder, but when the text is saved i'd like the filepath as an attribute-value. Pls help me!
Apologies to all who have been trying to help me with this db design challenge. It appears my explanations of what it’s for and what it’s supposed to do is confusing.
I think I should explain again, simplifying as far as I can for clarity.
It’s as if I had a number - let’s say 10 - standard letters (that I’m henceforth referring to as ‘styles’) that I wanted to personalise and to be able to send to any name on a list except:
•It’s in audio format meaning I can not do a ‘mail-merge’ equivalent.
• Each name has to be recorded and manually ‘mixed’ into each style* so where my set’s complete for one name I have 10 different sound files with the same file name, each kept in a folder named according to style.
•The primary purpose of the database is to let me enter a name and a style and it will tell me if there’s a file ready with that combination.
There are some things that complicate this:
•There are many ways of spelling some names (e.g. abi, abby, abbey, abbie). Looked at another way, there are many names that when pronounced, sound the same as each other! Each of these needs to refer to the same filename (which could be available in any or all styles). This means I need to associate all the spellings of one name to the one file name.
•Also, there are some names that are spelled the same but pronounced differently (e.g. jean – which can be a male’s name which sounds very different from the female’s name with which English speakers are more familiar).
There will always be unusual names that come up which will need to be recorded and mixed for one particular style, used then disposed of. However, the aim is to have 1500 odd files with the most popular names pre-prepared for each (and yes, I am aware of the scale of the project and no, there isn’t another way!) so they can automatically be dispatched as required. I’m guessing linking different spellings will increase the number of names – available in every style – to around 4000.
I hope it’s appropriate that I’ve explained this in detail here. I think it’s required because this db design is such an unusual one that when I'm asking specific things regarding tables, queries etc. I can refer to this for the context.
I’m not asking anyone to do this for me. I want to have done it myself but I need to be borrowing your expertise.
Also, this posting is not a request for any specific help about the project though, of course, any comment is welcome.
The thread which is currently addressing the data structure and table relationship issue is:
http://www.access-programmers.co.uk/forums/showthread.php?t=106356
I will edit this to link to threads looking ad different aspects as I go along (providing this approach is acceptable with the forum community).
Cheers :)
*This is what’s taking most of my time at the moment (there's a good few thousand already recorded since the project was started).
Does anyone know that path to the folder that the dll files are stored in that Access uses?
View 3 Replies View Relatedhi,
every time i look in or shared area i see a new backup file of one of my mde's...
junior school pastoral log_backup
it seems every time i delete one a new on is there next time...
what's causing this? is a user not logging out of the software properly or what?
cheers
greg
Hi all:
Using Access 2000. I have about 5 databases but only one needs to be secured so I created a system.mdw for it. After doing that the secured db works but all other db's ask for authentication also but since there are no users or groups in the other db's, the authentication fails and I can't use the db's. If I put the original system.mdw back the other db's work but the one that needs to be secured it wide open.
Is there a way to do this??????
thanks :confused: :eek:
Are all mde files locked so that you cannot edit or see design view for forms etc?
Are there any tools out there that can unlock an mde database?
Thanks,
Dave