Hi,
I am trying to put together a mailing list to send out invitations to local schools.
I have exceed documents with several school addresses and I need to add to each school, a listing for all of the homeroom teachers (i.e. 1st grade homeroom teacher, 5th grade homeroom teacher, etc.) as well as Art teacher and counselor for each grade
How do I create a querie that adds the title (art teacher, principal etc) to the list of addresses?
I am not very Access savvy so, you may need to dumb it down a bit. Feel free to ask any questions.
Hi guys- totally in the frying pan here...I can't seem to get past this initial stumbling block with Access
i've made a simple form that "should" create a primary key from the first two digits of a clients last name and last four digits of their phone number...i've tried an update query button and a refresh data button...the key field gets filled in on the form, but it will not transfer to the underlying table...I keep getting a null value error for the key....any help would be greatly appreciated...
I'm an access noob, but decently experienced with Filemaker. I learned quickly that they are two very different animals with such a differing vocabulary, I may be in over my head with even the simplest concepts.
My problem: I am creating a quicky book order database for some professors. I have a value list (drop down menu) that references another table's column of professor names, but would like to create another value list dependent on the professor's name that would list the classes he/she teaches.
Table 1 Columns: Professor, Class 1, Class 2, Class 3, etc
Form 1 a) Professor field drop-down menu/value list populated by values in the table 1's professor column b) (need) A drop-down list that displays which classes the selected professor teaches.
What I am trying to do is write either a 'yes' or 'no' to one of my access tables based on the criteria of a linked table. When I build my query, I input the following into the field:
Expr1: IIf(([5WellInformation]![LowPH]<5.5) Or ([5WellInformation]![HighPH]>10) Or ([5WellInformation]![Temperature]>75) Or ... , "Yes", "No")
My query type is 'Append Query'
The problem I am encountering is that I require 39 different criteria to come up with either a Yes or No. If anyone of those 39 criteria fail, than a Yes is written.
When I place the entire expression into the query, half of it is cut off because the expression is too long.
Any Ideas? Am I doing this right... or is there a different way I should approach this.
For my own database which i created in Access i have something called a mutation date. so when i changed something i typed the date of that day. Now i want that to go automaticly. How do i do that??? It would be great if someone could help me with that. Once there's something changed in the record i need to make the date of that record changed. Hope u can Help me SilverBlood
Im building a web application to control the stock of a small company.
I already made the database with all the items and descriptions in one table.
This table would be the main warehouse. so now i have to create 3 different departments in different tables where i have to move stuff from the main warehouse. So if i have 10 boxes in main, and i move 4 to department1. then i would get 6 boxes in main and 4 in dep1.
My web app would be constantly updating the stuff being sold in departments 1,2,3.... so here is my question.
how do i make the database to update the quantities by itself in the main warehouse table if department X sells anything...?
Like in Excel, when you work with different sheets that can update the other ones if you change a number. the rows can be linked... can i do this in access?
Otherwise i would have to write a lot of extra SQL code in the ASP scripts and im really out of shape cause i don't program in ASP sisnce very long time ago... years.
I am trying to create a query that has a self referencing running total based on the values (point totals) of itself (running total of values in the running total column that have already been calculated for all previous records) plus the total of new points being added in the current record, less the total of points being removed in the current record. This running total can never go below 0, if it does, the running total should restart at zero and add in only new points and begin the process again with the next records
I am able to do this in Excel in less than two seconds so I know there has to be a way to port this into a query. I've attached an excel example of what I am exactly trying to do
If it takes multiple queries to complete the required output I am ok with it. In my previous outtakes I have had up to 8 queries but just couldn't seem to do it..
I currently have an Excel Spreadsheet w/ 20 columns and 800+ rows. The columns are such things as Product, Product Code, Description, etc. It has clearly grown to big for an Excel file so I created an Access table from the spreadsheet called All.
Goal - have employees open a form and select a product from a dropdown box and then place check marks next to the info they would like to see for the product they chose.
I created a seperate table called Product, and a query for table All, and a report for the query. I created a form w/ a combo box that lists table Product and has a submit button. I added a criteria in the query under the column product that looks at this combobox. When you run the form, select a product, and click submit it opens a report that shows the results of the query for that product.
The part I cannot get is the check boxes that determine what columns are show in the report. I added a checkbox to my form and then went to my query and unchecked show and added a criteria to look at the checkbox in my form. All that did was erase the column from the query permanently.
I'm sure I'm going about this is the wrong way, but this is my first hack at Access and I'm trying to learn as I go.
I'm a complete newbie to MS Access, and I'm working on my 2nd database.
Just a small and probably retarded issue: I have a table which includes a field, which contains four numbers. In a query I want my users to be able to enter a number, like 6, and the three numbers after that will have to be wildcards.
Example: The field has these entries: 8243 8184 6423
When the user enters "8", it should show the first two records. When the user enters "6", it should show the third record.
i have created a table and am trying to run a qry that counts specific data, i have been searching but cannot find the answer. I have a standard qry that has the criteria of "staff name" and dates between ## And ##. Now when that information is returned, how do i get a count figure for the results. So for example if there were 15 entries for september it would say september = 15 (ish). I have been told to assign a recordset but no other information was forth coming. Can anybody help with code or qrys for creating a recordset.
Please remember the noob status when it comes to access - lol
Recently our system crashed and so I fixed compacted and repaired, and all seemed to be good to go. However, next day a bunch of random fields that our reps were once able to add information to are no longer able to add info to. They seemed to be locked out, however, I go into the various forms that were set up and enable is set to Yes, and Locked = No.
1) I am pretty newbie to this access programming, do forgive me if my questions sounds stupid.
2) Basically I create an application in access capturing or production information for my company. now the top management suddenly wanted whats their main concern:- Total Daily/Monthly, Quarterly, Annual Sales (By Model If possible)
3) I start with daily (Lets don't be too overly ambitious).
4) I try to let user select dates from my calender control and reflect daily sales (in Total & By Model break down) insert into my form.
5) Understand someone told me from my previous post in Calender control I can achieve it either through forms or queries, which is a better way. (in terms of flexibility to change for program maintenance/ scalibility) wise ?
Hope nobody minds but I don't really know Access and I have a table that needs sorting pretty desperately.I have a table with 5 columns that I need to filter out so just the remaing records are left over.http://img208.imageshack.us/img208/7328/untitled1wb8.th.jpg (http://img208.imageshack.us/my.php?image=untitled1wb8.jpg)The column 'fax' is the column with the records in it and the following columns need the record removing if the box is ticked.TimFPS, OurFPS, OnFPS, NeedsToBeFPS, however the column 'NumberWeHave' I'm not too sure about so I'll ignore it for now (I may need to take them out later)Sorry to be a complete noob and if anyone can help it will be muchos appreciated.
I have this program that adds information to a ms database file in a very odd manner.i cant change the way the information comes in but is there a way to move it into the correct location in a new table. information is put in as a group of 19 records.
whats happening is this: these are the colums primary key,group id,info,info,info,group order,info,info,info
i need to information from 4 of the colums into a new table so i have 19 colums and 1 record.
Hello im new to this and i been working since yesterday on a database. Basically I have 1 table that holds names and numbers asociated with and also the current state. that would be "ACTIVE" or "INACTIVE" and after a week or so (actually after i run a report) should change to "ACTIVE Z" and "INACTIVE X".
Now I have all the querrys and tables and forms and all. but what i want to do is to automate something im doing manually.
I run a querry that shows me only the records that have the state "ACTIVE" and i need to change them to "ACTIVE Z". Now what i am doing is, after running the querry i select all and go Control H and replace "ACTIVE" for "ACTIVE Z".
Is there any way to automate this.
cus i tryecd to do a macro that 1st open the querry and then executes the replace command but that just opens the replace pop up. I still have to tipe "ACTIVE" and "ACTIVE Z" in the fields to replace it.
As the title suggests i am brand new to Access (about 2 days). I am trying to create a query that will group the fields according to their names and then add the income for all orders for each individual customer. After that i simply have to sort them. I want to sum the total income per customer and put them into descending order.
Here's a small sample of the list to get the idea:
Customer NameIncome per Order Sanchez, Cindy$1,326.00 Lizzack, Mark$1,326.00 Patel, Mitesh$1,092.00 Sanchez, Cindy$1,000.00 Patel, Maria$780.00 Mui, Sylvia$780.00 Patel, Mitesh$500.00
And what I'd like the results to be:
Customer NameIncome per Order Sanchez, Cindy$2,326.00 Patel, Mitesh$1,592.00 Lizzack, Mark$1,326.00 Patel, Maria$780.00 Mui, Sylvia$780.00
Thanks immensely for any help you can offer. I realize there is probably a very simple solution to my question, but after 5 hours of searching the help button, and various online forums, I'm at my wits end.
Hi. I just started using databases and I am at a loss with some of the definitions. I could do with some help as these are part of my school work! Thanks.:D
What is the role of a 'form'
1.to hold data 2.to provide a 'form' format for reports 3.to provide a tool which sorts the data and prepares it for export 4.to provide a user-friendly data input 'front-end', which can additionally validate user input..
Hey everyone, I'm new to access, I have been using Excel for quite a while and I am familiar with VB and macros.
I have never been much of a book learner, mostly hands on, which means a lot of reverse engineering to figure out why/how things work.
I have a scenario, and found a DB that had some functionality that I liked and I had reverse engineered it to do a lot of what I want.
Where I need some guidance:
1. on my opening form (Clients) I would like to be able to type in Client Number and have it return the correct info.
2. in my Who Has It is there a way to do data validation (or dropdown box) I mean I only want them to be able to enter valid names not crazy stuff like MickeyMouse.
I apologize first of all if this question is bounced up and down through out the forum all the time, and if there's already a topic on this, then it'd be perfect for me. But im not having any luck.
I do not know how to upload my database in a way that it will work when i try to use a page through microsoft frontpage to display results from it.
What are the accurate steps into creating a database connection? Thanks a bunch
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.
Hi all, I'm pretty new to Access, but catch on quick. I have posted this question at another access forum, but have not received any input - maybe it's in the way the question was asked.:confused:
I have a developed a database to track patient ID, patient name, then several other fields of data such as therapies recieved, medications etc. The main form is used to input the data for each record.
The point I'm at now is the switchboard. I have created a command button that when pressed will open the main form at the first blank record for data entry on a new patient.
I want to add another command button that when pressed will open a pop-up/form/text field that will allow me to input a search criteria. The two criteria I would like to use are Patient ID or Patient Name. When the search criteria is entered, I would then like for the main form to appear at the record specified by the criteria for record editing.
Clear as mud? I'm pretty sure there's a fairly easy way to go about accomplishing this task, but I'm clueless. I have tried a couple of different routes, but wanted input from you guys about what would be the easiest way to address this.
I am creating a form utilizing all of the fields of my table (table1). I want the form label names to be from the description of the fields from table1. I have over 50 fields and was wondering if I could do this automatically.
Example:
table1 Field: Description: Policy_Date Date policy began
Form Label: Text Box: Date policy began Policy_Date