I have been trying to figure out a best way to attach files to specific records. Up until this point have been using Hyperlink to link files that have been stored in shared folders. This seemed to be a very good option for quiet sometime; but some users wish to play god ! Since I have to give them RWX permission on the folder; they go into the Shared folder and either rename the file or move it around or worse, DELETE the file permanently. Thus messing up the hyperlink.
Now I am planning to use the wretched Attachment data type in Access. I know it will bloat the DB, but this seems to be a safer option. As I can control DELETES/EDITS. So I was thinking to use a stand alone DB, just used for Attachment tables. As these records will not be accessed everytime.
My problem is, I remember vaguely using two linked backend DB files, put a lot of strain on the front end. Thus making the connection very slow. Sometime even upto 10 seconds to simply load the login form.
My idea is to establish a persistent connection to the two DB files on front end opening. Thus the connection is always there so it might not be that slow !
Or is there something I could look into to manage the Files/Attachments more efficiently, other than Hypelinking?
This may seem to be a couple of strange questions, but nevertheless, I have not been able to find anything that have answered my question, so, please help me:-).
I am currently working in Access 2003 (nop, an upgrade to 2007 is not an option:-/) and I am making a database containing my companys employe, their workplace, plans for the future etc etc.
I would really really really like to be able to attach a picture of the employes in in this database, but I really canīt find a simple way to do this, not even in MS help.
Furthermore, I would like to be able to attach files, such as documents, so that I cah doubleclich on them, whereafter they open in etc Word.
Is this possible, (in a simple way) or do I have to go deeper into Access.
I am looking for a way to store thumbnail images for specific records. I want an idiot proof way of selecting a jpeg image and then storing a 200x120px bmp version of the file in the database. Is this achievable with VBA code?
I have a table in my database whose forms are refusing to open to specific records. They only open to a blank record--either by using other forms to open to specific records or simply by opening the form straight from sidebar. Even the Navigation bar doesn't allow me to move from one record to another; it only shows "1 of 1".
The "initial" form, which creates new records in the table, works perfectly--in creating a new record. I can create a new record, use the Navigation bar to move to a new record, create it, and move back to the first. But then when I close and re-open the form the above issue once again comes up.All my other tables--and the forms that are associated with them--work perfectly and I can open them to specific records without a hitch.
I have some code that loops the clone recordset of my subform and generates a email with attachments. I have mainform and continuous subform within the subform I have field called address this holds paths to files and another field called send and this is a yes/no field
Now what I'm trying to do is loop through the subform if send field is true then attach file from the address path but if send field is false then do not attach file
Code: Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim olAttach As Outlook.Attachment Dim rstAttach As DAO.Recordset
Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem)
I have created a database that saves a link of technical data. Now i have forms where you can add the hyperlink of the data in the database. You can also type information about the data into the form (like location, what kind of part etcc.)But I was asked to save the data in a specific folder that you can select.
So what I have to do is:
Browse for a file in a form.Save the hyperlink of the file in the database.Don't save the file in the database, but copy the file that's selected when browsing to specified folder
I'm using a function to find all files/folders in a specific directory, then copy each one to a specific destination folder. I'm going to use this on a weekly basis to backup files on a computer. I would like to use the vbarchive in GetAttr/SetAttr so I only need to copy these if they have changed since last backup.
Something like:
If GetAttr(strFile) And vbArchive = 32 then filecopy xxxx, xxxx else rs.movenext
As I understand it, a value of 32 indicates that the file has been modified since it was last backuped up (i.e. since the file attribute was "reset"). How do I "reset" the file attributes to clear the vbArchive?? I've read some google searches and the only thing I could find was the files were set to vbnormal however I'm concerned that this will erase program files that are vbReadOnly or VbHidden.
In an Access 2010 form is it possible to export select records and fields in those records to a specific location?
Code: Set objDialog = Application.FileDialog(4) With objDialog .AllowMultiSelect = False .Title = "Please select a File" .InitialFilename = "C:" .Show If .SelectedItems.Count = 0 Then MsgBox ("Action Cancelled") Else
[code]....
The user can select the directory using the code above, but can specific fields in records be exported to a excel workbook in that selected directory?For example, if the are 5 records in the database can the fields LastName,FirstName,BirthDate in records 1,2,3 be exported to Setup.xlsx in that selected directory?
First of all, apologies if this is in the wrong forum, it's my first post and I'm new to the site.
I'm currently working on an Access database that stores personal details.
I would like to be able to link the database to a network drive so a user can see all related .doc .pdf .xls files on the network that are associated with that record.
************************** Here is the ideal situation:
User looks up record with unique ID 123456 in the database
Database then displays screen showing content of S:Users123456 (Where S: is a network drive)
User clicks database record showing "Personal Details.doc"
pretty Excel sheet full of conditional formatting that is used as a vehicle assignment board where I work. I know I can embed the file into an Access form using an unbound object, and therefore "integrate" it into Access, however this creates a copy of the file, and therefore when people change the sheet, the original Excel file is not updated. Is there any way to embed the excel file in such a way that the Excel document itself is also updated? Basically some sort of an active, two-way link rather than what amounts to just importing a copy of it? I need to be able to pull data from various cells in that Excel file so it needs to be kept up-to-date.
I need to import a number of .csv files every day and overwrite the old tables with the data from the new .csv files. However, each day, the filenames will change.
For example,
Day 1: Import fileA 1.csv, fileB 1.csv, fileC 1.csv Day 2: Import fileA 2.csv, fileB 2.csv, fileC 2.csv Day 3: Import fileA 5.csv, fileB 5.csv, fileB 6.csv
The files will be named fileA [#].csv, fileB [#].csv, fileC [#].csv, and so on, with a different number each day (with no pattern to the numbers).
Is there a way to write an import specification or VBA script that will import these? Perhaps something that allows a regular expression in the file path so I can import "C:fileA*", "C:fileB*", etc.?
I need to daily import files that start with same name, but the remaining part will be Bill of lading ID (e.g. TEST_BOL 1234.csv). The next day will be TEST_BOL 1235.csv) and so on. I need for Access to import the file based on the "TEST_BOL" into my database and then delete the file from the folder. I don't know how to initialize Access to look for the prefix and import in.
So I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.
We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.
Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.
I have a form for adding new records. They are for people and I add in a bmp image of them. I want to create an automation. Where you press a button to add a photo. Find a jpeg you want. Then it is resized, converted to bmp and saved in the database. Is this easy enough to achieve? (size 256x188px)
I am trying to make a stand-alone version of a database whose files are mysql files connected by odbc. When I copy the linked files and save them as local files, they come in with the auto-numbered id field still marked as the primary key, but as just "number" and not auto-number. It does come in marked required. I can't change the type to auto-number, so it errors when the user tries to add a record using the input form. Also, I have the fields used to keep true/false data set up in the mysql files as integers with default values of 0. When they are saved as local tables, they come in marked required but without a default value. Hence, when a user enters a new record in a form that doesn't use that particular check box, it errors. What am I missing? Is there an easy way around this?
I have a table that has over 6000 rows with two columns. One a title and the other a memo column with transcripts from interviews (some being extremely long). I do research using content analysis and to do that on these interviews, I need each one saved in its own text file.
Specifically I need to export each transcript into its own text file and save that file using the title from the other column. So I would end up with over 6000 text files all being saved using the title from the corresponding row as the transcript. Is this even possible?
We have an Access frontend with a Sql back end on an external server in the cloud.One of the things I need to do is allow people to attach files/documents to a record. I have set this up okay with the document being copied and saved to a new location and the path string being associated with the record. This will only work for people in my office though. I need to enable people in other cities to be able to upload or view these documents. Each office has their own server.
My IT department said they had created a VPN for this. They gave me a web URL which enables me to log in to QNAP. From there I can click to open the 'file station' and use the 'folder window' that appears within the browser to click through to the relevant folder - and there are buttons for uploading and downloading documents.
I could try writing some code that will automate all these steps - maybe. I'd rather not, but I can't see any alternative. It looks like a real pain to go through the HTML elements (and I think there may be errors coming up about certificates)
The files can't be uploaded to the external host server the back-end is on incase any of the documents are confidential. They don't want it saved anywhere other than on their own servers.
Beginner using 2010. I wish to play MP3 files from a command button on a form. I would like to avoid third party / ActiveX controls if possible.
I am aware that use of "CurrentProject.Path" will be useful to locate the MP3 file within a directory within the Project Folder.
But have be baffled by the sparse previous postings about this subject (going back to 2004). Searching this forum yields zero results on the term "MP3".
This accdb/e will be used to present historical information to a small number of people and will be used with runtime without user input.
And all I need is Play / Pause / Stop. No other functions required.
My computer crashed and I had to reinstall Access 2010 a new computer with Windows 8 and put my Access files on the computer from my backup USB drive. If I attempt to open the Access files from the USB drive, the computer has attached the Excel icon in front of the file name, even tho the type of files says ACCDB, and attempts to open with Excel. I get the following message: "'the file is not in a recognizable format".
The interesting thing is that if I open Access 2010 first and then 'find' the same file that I moved from the USB drive to my desktop, the file will open even tho it has the Excel icon.
How do I change my Access back to where they have the Access icon preceding the name, rather than the Excel icon?
I have an Application with several users that share tables located in a Design Master file at a server. The tables are shared in several computers with a Replica of the Design Master in each computer. When we try to synchronize any Replica with the Master Design, it gives back an error message stating that the "Number of blocks of shared files are exceeded" And the message ends stating that I must increase the MaxLocksPerFile in the Register.
I have an application where I have to read a big VCF file in VBA, extract the information and place it into records of a table. Of course I can read as a text file, but the structure is quite cumbersome to implement with many fields missing in different records and it is not a one time job.