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 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?
I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.
Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.
I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.
In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.
In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.
I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.
So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?
I am facing a critical issue with Access 2003 Forms. The project is successfully running on all PCs except 2-3 PCs. It throwing an error while performing a button click event. Below is the error message which I m receiving. The form works fine if I modify or update and than save, but when create new record it throws an error.
Error Message: The expression On Click you entered as the event property setting produced the following error: Function is not available in expressions in query expression
*The expression may not result in the name of a macro, the name of a user-defined function, or (Event Procedure).
*There may have been an error evaluating the function, event, or macro
Hi all, I was thinking if some could suggest me how could I make DAP which will have only one text box and command button in which will the value written there be forwarded to some parameter SQL when that button is pressed...
Do you know what VB code should I implement in onClick action for that button so he could start some query who would use value placed in that text box and then generate results in DAP....
Hi I am using Microsoft Access 2003. I want to clear the contents of a combobox in vba code. I found that there used to be a method called cmbbox.clear() but cant find this method in Access2003. Can someone throw some light on this. Thanks
I am used to access 2000 but at the moment I am using access 2003. When I first started using it, I had the usual database window showing - by this I mean the one that has the table, forrms etc listed on the left and when clicking on one of them the created tables, forms etc are listed as will as the option to create.
Somehow, this has disappeared. I have made sure that in the startup "Show Database window" is ticked, but after searching the net, have not been able to find any other suggestions as to how to fix this.
Hope some kind person can point me in the right direction so I can see the tables, queries that I have created.
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
Is there a way that I can attach a database that I am building/working on, to an email, so that I can send it to myself and work at home or at work. My work computers do not allow media.
I am new at this and have been struggling for days trying to solve this problem.
I created a database, using the wizard, to keep records of my orchids.
This resulted in a table. I keyed in the information on each plant.
Then I created a form, using the form wizard. Everything worked great. I could switch between the form and the table views.
The other day, the form no longer contained the information from each of my records. When I tried to switch to datasheet view (from form view), there was no longer a datasheet listed.
When I go directly to the datasheet (when starting Access), I can see all of the records (186 of them), but if I try to switch to form view - no form is listed.
I am trying to set up a create table query using parameter called Year. For each year I input , I need to create a new table with the suffix of the year. for example, if i input year 2011, i want to create a table called budget_2011, if i input year 2012, i want to create a table called budget-2012...
I have a report (a contract) which I can send as a pdf file. However, on the printed version of the report, I have the "terms and conditions" on the reverse side. The "terms" are already printed; the report is merely printed on the reverse side.I've saved the "terms and conditions" file as c:AccessFiles erms.pdf. What I would like to do is when I execute the code to send the contract as a pdf attachment via email, the "terms.pdf" file is combined with the report as one pdf file. Is this possible?
I'm sure this is a simple issue, but so simple I can't find the answer.
I have a recipe DB and have calories and fat and fiber fields, I want to have another field which will display a point count for a formula (calories/50+Fat/2+fiber/5) but the catch is if the fiber number entered is over 4 I only want the calculation to use 4 max.
Not sure how or where to create this formula to populate a field in the DB.
As you can tell I'm new to all this and any help would be appreciated.
I have searched for this and have not come up with an answer as yet.
I have query that is accessed by entering criteria in a text box and then the user can click a button which will use the criteria entered in the query and then export it to an excel file.
Is there any way i can get the option to export the file and then open up a new email and attach the excel file
I've created a custom ribbon and it works great however I want to create a separate ribbon and attach it to the report. On this particular ribbon, I'd like the export to excel, export to word and print functions to appear ONLY for reports. Not all reports will need to be exported; it depends what the user does. I've created this XML and I'm not receiving any error message. It loads as expected but my group is blank/empty. Still confused.
I have a form where I need a button that will export the current record being viewed to a TXT file and attach to email, I want to specify the To, CC, Subject and Body of the email, if possible putting a flag on it also.
I'm not doing very well, so far I have
Code: Private Sub MailExec_Click() On Error GoTo Err_MailExec_Click Dim stDocName As String stDocName = "Executive Incidents"
[Code] ....
This now doesn't seem to be working, if I remote email.To= then it does however this only creates a blank email with attachment.
I am currently in the process of creating a form that will allow you to enter details for an email sent, select a number of documents from a list box and then open the mail message pre-written with attachments. The attachments reside in a list box currently, and I am attempting to use a "For Each" with item selected.column(3) as the file path, as column(3) contains the filepath from the table.
Currently my code is:
Private Sub OutlookBut_Click() Dim olApp As Object Dim objMail As Object Dim varItm As Variant On Error Resume Next Set olApp = GetObject(, "Outlook.Application")
[Code] ....
When this code runs, outlook will open as a process when it is closed, but then freeze and not allow me to see it or access it in anyway. If Outlook is opened Microsoft office usually gets angry at me and decides to throw error messages at me.
I need to create a word file (it needs to be word) based on template (not a very complicated template) max 1 to 1 and 1/2 pages long.
the word doc needs to be named from the recordset but for now assume 12345.doc and the next one will be 12346.doc etc (I have a unique number system - available from tables /query .
i can either make the word doc in code or use a template (template would be better) recordset could have 20-30 in it each time i run it - but to be run every week
second half is how to email this out. i had in mind a email system
email to . test@testhotmail.xyz file attach = this folder where the docs are store and attach 12345
in a loop
so either
create word file - email word file in a loop each time or create all the word files and then send them individual
I would like to be able to add more than one scanned document and link them to one record.
If it is possible, I would like to have a command something like "Attach file" on the form displaying the record. The user could browse to find the scanned document and it becomes a link. The user could then scan and browse for another document, which becomes a second link, in some kind of list box.
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)
Am working in MS Access 2013 and I have a form with a button, I need the button to doattach automatically the pdf-report to the email template(i don't want to attach the pdf to a new email)
Right now the command open the E-mail template and create the pdf-report in the desktop
Code: Private Sub Command18_Click()
Dim oApp As Outlook.Application Dim oMsg As Outlook.MailItem Dim oAttachment As Outlook.attachment Set oApp = New Outlook.Application
