The database is used to track issue that we receive from each client. We have a main issue for that is where the main information is entered. We would like another form that will link file names to each record. One record could have many attachments though.
Supposed Client X has an open issue and they sent me an email with 2 attachments and also I have created a document regarding this issue.
I need to be able to...
lrw0831
Last Activity: Nov 19 '08, 03:13 PM
Joined: Sep 15 '08
Location:
-
Adding file path names to an access record
I have an Access database that is used to keep track of issues that the department receives. What we need is a way to add attachments to issues, but only by adding the path name that is a hyperlink to open the document.
More information -
I need to open a form from the main issues form (which I can do that).
The attachment form needs to have a browse button that allows the users to search through their... -
Adding Attachments
I need to link attachments to each record. Some records will have multiple attachments.
I have a form with Issue_ID, description, Filepath (this is a hyperlink) and a browse button.
My problem is, the attachments are not saving.
The Attachments table is as follows:
ID (Autonumber for the attachment)
Description (memo)
Filepath (hyperlink)
Issue_ID (number)
... -
Form to Select Criteria for a Report
I would like to create a form that allows users to select criteria to run a report. There will need to be 4 list boxes where they can select one or multiple options in each list box.
The list boxes are:
Product
Status
Priority
Type
I then need a report to run based on these selections. I am new to access and I'm not even sure where to start.
I appreciate the help and... -
Email Current Record
I want to email the current record that I just entered. I created a report that I will email but when I send it, I receive all of the records, not just the one I entered.
How can I get it to just email that record? -
Adding to list box from a Combo Box
I have an Assigned to part on my database. You select the department and then the employee combo box displays just the people in that department.
How would i create a listbox next to the assigned to part so that they could click an "Add" button and the employee selected in the combo box would be put in the list box and another employee could be added. -
Thank you for your help. I was able to get this to work.Leave a comment:
-
I am new to Access and I'm not sure how to do this. Could you tell me what to add to the code?Leave a comment:
-
Adding the quotes did not work. It caused it to not populate the module combobox.Leave a comment:
-
Combobox selecting wrong value
On my main form I have a Product drop down. Once a product is select, the Module combo box is to be popluated with modules related to that product.
The combo box populates correctly, but if I click on any module, it automatically selects the first item in the box.
Example:
My Product is CA, the modules are Assessment, Capacity, Implementation, Planning, Evaluation, REports, Other.
If I... -
How would i code it so that it only copies a few of the fields, not all of them?
SUpposed I just want Product, Entered BY, Issue Type, Priority, Request from, and Status to be copied and pasted onto the next issue.Leave a comment:
-
Copy and pasting within a form
I have the main form where employees enter "issues". Some issues have fields that are the same. My fields are
Issue ID (auto)
Product
Entered BY
Issue Type
Priority
Request from
Status
Assigned to
Model
Description
Is there a way to have a "Copy" button that would copy all of the information in the form, and then paste it into the same... -
Copy fields in form to populate blank record
I have the main form where employees enter "issues". Some issues have fields that are the same. My fields are
Issue ID (auto)
Product
Entered BY
Issue Type
Priority
Request from
Status
Assigned to
Model
Description
Is there any way to have a check box next to each field and also have a copy button, that would copy and paste into a new blank form.... -
Auto Generated E-Mail
I'm creating an issue tracker database. The main issue for contains basic issue information (issue_id, product, issuetype, status, description, request from, assigned to).
What I am trying to do is to auto generate an email that will send the issue to the employee it was assigned to. So say I enter an issue and select "Bob Smith" as the assigned to employee, I want an email to be sent to him with information about this... -
Popluating Combo box from another combo box selection
I have a table named AssignedTo. In this table are the fields: AssignedTo_ID, Department, Employee.
On my form, I need to create 2 combo boxes. The first one will select the department. Based one what department is selected, the second combo box will be populated with employees in that department.
Can someone help me on how to do this? -
With regards to the Continuous form....
I have a form with a continuous subform in it. I want to be able to filter the subform. For example, say a customer calls and wants to check the progress on an issue. I want to be able to filter my continuous form first by the customer, than by the status (active). This should then only display the records for that customer that are active.
With regards to the additional...Leave a comment:
-
For the first question regarding the sorting the cont form. I want to have a drop down that will show the products, followed by a drop down that will have the status. Once those are selected, the continuous form will populate the appropriate records.
With regards to the second question, I would need to additional comments to be stored back into the main issue tableLeave a comment:
-
Filtering continuous Forms
Hello,
I have a few questions. But first I'll give a little bit of info about my database. I'm creating a issue tracker, in a sense. It will be used to enter calls from customers for upgrades, bugs, reports, ect. There is a main form for information to be entered into the database. Then there is also a search and edit form, so if you need to enter addtional information for a specific product, you would search a continuous form...
No activity results to display
Leave a comment: