I am totally new to access and i want to be able to extract information from my database using a form. Basically I am using the database to generate a bill of materials. I have a product that has many different options. SO I want ot select a checkbox on a form for a particular option and hten have that extract the correct data from the DB into a report or spreadsheet.
View RepliesHello,
Does anyone know how I can create a form which asks for the name or lastname of the customer and does a search throuout the database and brings up all that customers informtation. And if their is more than one thats are the same you can switch through them untill you find the right one.
Thank you
I am trying to extract some values from a PDF (attached) and write them to an Access database. I am unsure of the approach, especially extracting values from the file.
View 2 Replies View RelatedI am attempting to create a patient tracking database for a clinic I work in and I am stuck at one small but major part.
I have a parent form called frm_Patient_index. On this form you can enter patient details such as personal details, observations ect. I need to create a lab request form for certain tests to be performed.
I want so that a button on the frm_patient_index form opens a subform where the relevent tests can be requested via tick boxes. Now here is my problem I have managed to create all of that except for the information to be entered into the frm_lab_request automatically and get SAVED to its corresponding table. It will not save for me.
I can get the information such as Badge Number, First Name, Surname and DOB to all enter into the fields automatically but getting them to save to the table is not happening.
I need some help. I created a database to capture information from an employee survey. Most of the answers required a check if they agree or no check if they do not agree. There was one "memo" field inwhich we allow the employee to VENT. I have provided the team with all sorts of reports with percentages and figures. Now they want to remove any comment that had money, pay raise, bonus etc. They also want to organize the comments in some type of flow. Like all the "pats on the back" in one area, Day offs in another, plaque on wall grouped together, etc.
Can one of you experts, please give me some help?
Thanks!
I am trying to extract information from a fillable PDF form that my company has created. Rightfully so, they have completely locked down all options, so I am not able to convert the file in Adobe Reader to a text file. I've seen options to extract information using VBA code with Adobe Acrobat; however, I do not have a license for the program. Is there any VBA code that uses Adobe Reader to extract information and put it in an Access database?
View 9 Replies View RelatedI've been attempting to link a ms access database to our company's website, but now each time I try to view the page I recieve the following message:
" HTTP Error 403
403.1 Forbidden: Execute Access Forbidden
This error can be caused if you try to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.
Please contact the Web server's administrator if the problem persists. "
...rude.
Here is the code...
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include virtual="/Connections/TRIAL2.asp" -->
<%
var Trial2 = Server.CreateObject("ADODB.Recordset");
Trial2.ActiveConnection = MM_TRIAL2_STRING;
Trial2.Source = "SELECT * FROM [website update] ORDER BY Price ASC";
Trial2.CursorType = 0;
Trial2.CursorLocation = 2;
Trial2.LockType = 1;
Trial2.Open();
var Trial2_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Trial2_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style6 {font-size: 12px; font-family: arial;}
-->
</style>
</head>
<body>
<table width="82%" border="1" cellspacing="0" cellpadding="0" summary="List of property details">
<tr>
<th width="22%" scope="col"><span class="style6"> Code </span></th>
<th width="18%" scope="col"><span class="style6">Address</span></th>
<th width="28%" scope="col"><span class="style6">Suburb</span></th>
<th width="17%" scope="col"><span class="style6">Price</span></th>
<th width="15%" scope="col"><span class="style6">Title</span></th>
</tr>
<% while ((Repeat1__numRows-- != 0) && (!Trial2.EOF)) { %>
<tr>
<td><%=(Trial2.Fields.Item("Property Code").Value)%></td>
<td><%=(Trial2.Fields.Item("Address").Value)%></td>
<td><%=(Trial2.Fields.Item("Suburb").Value)%></td>
<td><%=(Trial2.Fields.Item("Price").Value)%></td>
<td><%=(Trial2.Fields.Item("Title").Value)%></td>
</tr>
<%
Repeat1__index++;
Trial2.MoveNext();
}
%>
</table>
</body>
</html>
<%
Trial2.Close();
%>
I can't find any info on this error through google, so i'm not sure what step to take next. Any advice would be great, I'm willing to try out other databases (obviously retyping the data would be a pain in the arm but if it works its worth it)
Cheers:p
I am brand new to Access. I know a fair amount about excel. However I think Access may provide a better platform for what I am looking to do. With that being said i have some questions.
I am looking to create a database. However this database will very seldomly have new information added. Information may be updated here or there. Most of what i have researched uses access to create a database that will constantly have new info added.
What i am looking to do is to create a database that will have drop downs that merely link to other "databases" to view.
Example: I have have a database in excel that has one main interface. when you click on a cell it takes you to a new worksheet with multiple entries that fall under that group. and repeats itself. each cell on this page will is linked to another worksheet.
Lets say these groups are named; 1,2,3,4. Any time you click on on of these, it takes you to a new worksheet that has info for each group. Once on the new worksheet, it will give you the drop downs for these values and if one is selected it will take you to the new worksheet (show the new info) once again.
I have two third-party library programs that allow you to type in an ISBN and the software searches, say Amazon, and grabs particular missing data: author, cover jpg and summary etc, and imports the info to the program. I'd like to replicate this process with Access. If I can type in an author, title or ISBN to Access, I'd like it to search Amazon to gather and input the missing data to my assigned fields. Is this possible? Or am I stuck to typing in the information separately.
View 10 Replies View RelatedI would like to know if there is a way to update information in my Access database via e-mail.
I tried to do this, but when I collect from the e-mail, it creates a new entry in the database.
setup a data base in Access that collects information from the attached spreadsheet pictures from A1:FO26...Spreadsheet is macro enabled and updates automatically with data.have tried to setup Access data base but when Excel Tab updates it copies over the data that was last copied into Access.
View 14 Replies View RelatedI have several data entry forms in my DB. What I would like to do is capture the windows user name of the people adding records and changing records. How do I go about doing that? I was think of an on change event to a given field that would then pull the username and insert it in another field/object.
Lets say the an on change of me.cmbModel update txtUserName.
If you are using a form as a sort of user interface and you've got a user entering in information into the form, is there any way possible to print a preview of the currently entered form information without saving it to the database first?
I'm thinking a kind of validation thing. Like, "Click here and preview what you've entered. Sure this is what you want?" type of thing.
i have been trying to create an employee database to record:
1. Name , Address
2. Telephone
3. Date of birth
4. employee ID#
5. Emergency contact -name, address, telephone
6. Photograph
7. Other pertinent information related to employees
So far I have incorporated the contacts database forms into my new database but I am unable to link the forms into one form that will incorporate all the information needed. Is there an existing employee database that I may edit to suit my purposes?
I'm trying import some information from excel file into Access Database but I need have imported information formatted in specific way.
Import file is looking like:
City - Week / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8
London / 3 / 1 / 4 / 5/ 5/ 9/ 1/ 3/ 4
Chicago / 2 / 1 / 4/ 8/ 3/ 3/ 2/ 1 / 5
Paris / 9 / 4/ 1/ 7/ 8/ 9 / 1 / 1 / 2
And i need table in Access looking more like
City / Week / Value
London / 1 / 3
London / 2 / 1
London / 3/ 4
London / 4 / 5
and so on for each city.Is there any option that this can be done within DB or It would need be some kind of macro to transfer this into other format?
How to publish an Access db with Windows IIS but without Sharepoint
View 1 Replies View RelatedWhat I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
Hey guys,
Bit of a nightmare, put loads of information into my database, and when i look in the table all information is still there but can not get it to be displayed in my form, what has gone wrong??
I have forms in a database that I am looking at. How can I tell which table the forms are connected to?
Easiest thing, I know. Help much appreciated.
-Mike
I am attempting to place a label on the top of a tabbed form and I am having a problem. Here are the important parts of my database:
tblInstructors
InstructorID Autonumber PK
RankID FK to tbl Ranks
LastName
FirstName
tblRanks
RankID Autonumber PK
Rank
I have a tabbed form with a combo box for RankID and text boxes for FirstName and LastName. Obviously there is more information than this on this form, it is tabbed and I would like a label on top of the form that shows the name and rank of the person's record that is being edited or viewed while the user is on another tab. Normally I would use =[RankID] & "" & [FirstName] & "" & [LastName], however this isn't working since the RankID control is passing the Autonumber from tblRanks instead of the actual rank (yes this is military rank abbreviation). For example I get the number six instead of TSGT. I need to find a way to show the text value instead of the autonumber that represents it.
I have searched to the best of my abilities to find anything on this forum about this as I am sure it has come up before but have been unable to find anything.
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
View 1 Replies View Relatedhey,
i have a main form with multiple subforms on it, and a command button for each subform.
when clicked, how do i go about opening the relative subform in its own window with the linking value (histnum) already defined
:confused: ok basically im trying to create a form for customer details for a project at college, what I want is:
select customer ID from a drop down list, which then should display all their details below such as address etc(from the linked table), which cannot be edited or nothing, like looking up information. can anyone help me please???
all help would be much appreciated! :)
I have previously posted this on another message board with no responses. I am hoping that someone here can help.
I have a form that has several subforms. The forms are linked Child to Master using a Company Name Contol. In the table where the Company Name is set up, it is not indexed.
It is not a primary key. When the EU (in test) enter data with the company name a second time (a second record for the same company), all the information in the first record populates the second record. If any changes are made to the second record, then it is also reflected as changed in the first record. I hope that I am clear in my explanation. What have I done to cause this?
Alan
Im having problem with my database, i have managed to set up a calcualtion so it does the sub total thanks to a query, however i want the information to be displayed in a text box on the original form. Is there anyway i can transfer the ammount over to the original forms text box?
Any help would be appreciated
I have 2 tables
Main table called Site Details
and another table called expense codes
On the form I want to use a combo to look at the expense Number 52, 53, 54 ect
the in the next field to show the description of the code it relates to
How do I do this?