Working With Files
Oct 18, 2005
Dear 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!
View Replies
ADVERTISEMENT
Nov 11, 2013
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]...
View 7 Replies
View Related
May 2, 2012
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?
View 3 Replies
View Related
Dec 27, 2014
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
View 1 Replies
View Related
Jan 15, 2015
I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
View 13 Replies
View Related
Jun 20, 2005
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
View 9 Replies
View Related
Jun 21, 2005
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
View 2 Replies
View Related
Oct 4, 2005
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 Related
Nov 2, 2005
i 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.
View 1 Replies
View Related
Oct 24, 2007
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
View 8 Replies
View Related
Nov 29, 2007
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 Related
Jul 8, 2006
I'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
View 4 Replies
View Related
May 22, 2007
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 Related
May 8, 2005
I 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
View 3 Replies
View Related
May 25, 2005
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
View 14 Replies
View Related
Jul 15, 2005
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 Related
Apr 26, 2006
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).
View 1 Replies
View Related
Jun 13, 2006
Does anyone know that path to the folder that the dll files are stored in that Access uses?
View 3 Replies
View Related
Nov 20, 2006
hi,
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
View 6 Replies
View Related
Jan 31, 2007
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:
View 2 Replies
View Related
Mar 12, 2007
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
View 1 Replies
View Related
May 17, 2007
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
View 4 Replies
View Related
Nov 27, 2007
I have created an Access 2007 database on a network drive. I notice that as the database is being used, other files are being created sequencially such as, "database1", "database2", "database3", etc. What are these files. They are quite large and I am wondering if they are necessary.
If anyone has any information, I would appreciate it.
thanks,
View 5 Replies
View Related
Mar 11, 2008
Hi, I am new ( as of today) to this forum. I have been using Access for a few years following on from using Q&A. I manage a database for membership for a club and more recently designed my own database for another personal application. Last weekend I did a full backup on a new laptop I have that has both Access 2003 and 2007 on it ( I don't use the 2007 version at the moment) and following that most of the databases, including backups have gone to zero kb in file size. I tried a system restore to no avail. I can see the files but they are 0kb in size and won't open. Does anyone have any idea why this should happen and more importantly how (if) I can resolve it ?. The laptop has Vista as the O/S.
Kind Regards & greetings from a wet and windy Dublin,
Ian
View 4 Replies
View Related
Feb 25, 2005
Hi, [access 2000 or 2003]
Is there a way i can use one table shared & updated in 2 access files? if yes what are the conditions please
thank you
View 1 Replies
View Related
Sep 23, 2005
I have I table which is linked to a tex file. I created a code in which it will programatically refresh the linked, however, after the refreshed process is done, it always put the first record as a Field Header.
Can somebody help me what is needed inorder not to Access automatically use the first Record of the text file as a Field Header ?
Thanks :(
View 2 Replies
View Related
