Totals On GroupFooter From Field2 Base On Criteria Of Field3
Mar 9, 2005
Getting the total in a GroupFooter from a Field2 based on Criteria on Field3. For instance, I could total values from Field2 based on criteria “KEY” of Field3, however my problem is when I try to get the valued from Field2, which has the same value for all records based on criteria “NoKEY” of Field3.
I’m not sure if this is the best way to explain my problem, but I’ll try to give you a better scenario for you reply. I really appreciate if you help me out in anyway that lead me to the right procedure.
Here is my code for the ControlSource of my unbound for Field1
=Sum(IIf([Field3]="KEY",[Field2]))
How can I capture the value on [Field2] based on criteria [Field3]=”NoKEY”?
I’d like some assistance on the following if possible:
I have a database where I want to update a field (Agree_ID) based on the data input in a second field (Pond_ID). Agree_ID uses only a portion of Pond_ID. I’d like some routine (macro or VBA code) to assist.
Example: Pond_ID – keyin "05-04-1P" Agree_ID – updates to "05-04"
I used “=Mid([Pond_ID],1,5)” to update Agree_ID which appears to work. However, I have to close the record; run a macro that runs the code; then go back into the form and open the record. I’d like this to happen automatically when I keyin the data in Pond_ID.
Any ideas would be greatly appreciated. Thanks, SKK
I have 2 fields in access table. In one field i fill numbers eg (1,2,3,4,5) drop down list. In the second field I need to fill another data. When I chose one of the numbers from Field 1, I want automatically fill the second field with appropriate data.
Hey all! This is my first post. Been searching through the net all day trying to find a solution to this problem. Basically i have a table that looks like this (regular text is what i have and bolded text is what I need:Name Date Qty MOBrad 12/12/2007 23323 4423John 12/11/2007 3445 4432 John 12/11/2007 344 4432 John 12/11/2007 45 4432 John 12/11/2007 44 4432 John 12/11/2007 3445 4432 Grand Total: (Qty)And then I'd like to be able to carry this over and display a grand total at the bottom of every page of a report that I would need to generate. Our company produces forms and we sometimes have 60 - 70 people working on a single job. We want to see their hours individually but we would also like to see a grand sum of all their hours. If someone could help with this or needs more info let me know. Thanks for all your help!
I have a theoretical solution to making a basic form for an Access Database, but how can I create a form from the VB IDE?
The toolbox cannot be selected from the dropdown menu.
I have 3 small tables in the database and am trying to create a form which will enable me to update a total on one of them, but as I say I can't even make the basic form, let alone program it.
Hello all, I am a new registration chair person for a small convention for 200-250 persons. I would like to set up a database that I can access to print out address labels and name tags, by selected specific cells or sections. Is there a way to do this with a Microsoft Database or Spreadsheet programs? Any help would be appreciated Thanks Leneda
I am just beginning to design a small data base, where end users will mainly use an Access Form to search and view data.
The (lab) data will be arriving to our group occasionally over the next 2 years, and will be put into an Excel file (formatted the same, each time). The new data could be appended on the end of a master file...so I could link just one file to a table in Access. I need to build a Form, based on this data.
But, I am not sure if I should link the file from the beginning (since I've read that I cannot change data types or field sizes, if I link)....
Maybe I should import one existing file, manipulate the table parameters as needed, then design my Form....then link later?????? :confused:
I am very new to Access, I do work for different companies inputting data. I usually use excel and then I have to retype the information into another database.
One of my companies is a school. I have to print certificates when the class is complete, but what I'd like to know is, is there a way I can take the names of the students and using Access just have the names appear on the certificates without having to retype all of the names individually?
I would appreciate any information you can provide for me, this sure would save lots of time.
(this is a repost ) I will skip the basic intro of "Hi im new to access and i dont know.." anyways, what I am trying to search for and I dont know what Im looking for is this.
Q1) I would like to be able to open a zip file, read the NFO/txt file from within and import certain areas of the NFO file,the NFO file of course is layed out with ascii art but there is a predetermined area where certain info is obtained. for example: I would like to capture/import the URL, testers name, date avaliable, zip file name.THEN the text imported would be written to the database. It would be nice to figure out how you go about importing certain lines but im not sure how to ask the question and find the answer the right way. ie...(ascii art found here http://www.ascii-art.de/) -= I did search import text and get text and didnt find what I was looking for=-
Q2) How do I write to an ascii file/nfo/txt using access, there is a template or a layout that is pre done,and i need certain fields filled out, just like they above layout.
thanks for all your help, you guys are awsome, and keep up the good work!
I am looking to basically update the hyperlink base every time the database is opened to be the folder that the database is currently in.
We are trying to make the database and supporting information portable, so that people can copy the entire folder anywhere on their computer and all of the links will still work. I can't put all of the info in the database because we are already pushing the size limit.
I would like to keep it from getting terribly complicated, as others will have to update this database with more info in the future and make the links themselves.
If there is a better or different way of getting the same result without going through the hyperlink base, that is fine.
I want to create a new data base from an existing one in Microsoft Access. I want to use all the fields but not the data. Can I do this? I also want to keep the form that I created. Can anyone give me suggestions? Thank You!
hi i want a call out database with a calender with blocks in to represent slots booked and free, with a form with time start, duration (default 60mins) address, work to do, and milage. and the a report for the customer to sign. i have tried for about 6 months with different ways and means, to no aval, it would help if i had som knowledge of vb programing, ect, i have basic knowledge of access, eg add data, search data, and reports. please can someone helpme design one, as i would be very greatful, thanks in advance
I am a doctor working in Sri lanka wanting to use access to make our clinic work faster. Only fields required are clinic number (Unique), patient name and last clinic date. What i want is
1. In the form when i enter the clinic number the name should come up where i need to confirm to proceed.
2. Once a patient has come to the clinic that clinic number cannot be entered till 4 weeks are past!
I tried and tried to write macros or vb...(i'm a novice in these) but failed. This looks simple though. Can anyone help? any suggestion welcome.
ps:- this is a charity work. i'm not earning money from making this database!
So much has been discussed on the main boards about the techniques available to solve technical problems.
When you read books on data base design; much is discussed on the structure of databases and much more is left out concerning how people actually work. A properly designed data base enhances work flow and changes workers bad work habits into useful and efficient ones.
My primary market is emerging small businesses. Typically my customers have been using spread sheets and Quick Books to keep track of ordering, scheduling, resource allocation, and accounting.
As you can imagine it’s a disaster. Individuals in the company have spent much time working out their problems in Excel. This poses a real challenge, many of the user are very emotionally attached to the existing non-system, and they are often determined that the “new database” will function in the same way as their tried an true spread sheets.
So to open the discussion.
I’m curious. What do ya’ll do to ameliorate this and what is the general theme you prefer when creating a system for people that have never had one before?
When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the screen? :confused:
I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.
I want to be able to create a list of parts for purchase for the completed unit.
I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.
I am having trouble with the queries or what should be in the table.
I am developing a membership data base from a MS Template. It aleady has the means to print member lists and invoices, but no letters. I would like to also have the capability of writing a letter to one or all of the members directly from the data base.
How can I stop agents from leaving a database open after they have finished there days work. I maintain and modify a database from home, but some agents forget to close the database at the end of the day. That prevents me from doing any modification on the database. Maybe a simple message that would come up and close on a regular timed bases. Or some other simple way of reminding them to close before leaving for the night.
Hi i've read a few post regarding sharing db accross a network but still not too sure if i'm doing it correctly. please bear in mind i'm new to access.
ok so far i've created my database (db1.mdb) which consists of 1 table 2 queries & 1 form. i've placed this on my XP pc which is my dedicated server, Access is installed on this pc. i've split the data base which creates db1_be.mdb, now am i correct in thinking that db1_be.mdb is the back end file which needs to be placed on my local pc's.? i've also linked to the table & sorted out all the permmisions stuff.
but i loose my queries & form.? (on the local pc) what i really want to be able to do is store the database on my XP (server) pc & each user only requires the form to be available strickly for data entry only.
i may need to modify the form or queries at a later date but this will be done from 1 pc. am i on the right track.?
What access and vb, are all about are images - I want to display in vb, form containing bit map images. I am trying to display on a vb form data that is stored as a bit image in an access data base- (the image is stored as a ole object in the access data base). I have tried having the object linked and also tried embedded in the access data base. It displays just fine on the access form running under access. However, when i open the file in vb do the select, then the movenext, and then try to assign the value of the field to a picture variable and other types of variables i come up with a data type mismatch error -
this is a repeat of an earlier post, but i'm hoping this wording might get a better response
OK, here is my situation. I am just starting out with Access, so please be patient:
I have a database which keeps track of two things: Student Information and Student Visit Information. The student information keeps some general information about my vistors, and is rarley added to, with only one entry per student, while the Visitor Information has new data updated regularly, when people come in.
Basically, what I want to do, is create some sort of Report, in which, if I want to pull up "Billy Bob", it would bring up not only his information but also all of his visiting information. Here's the thing--the Visitor information has "Billy Bob"s name in it more than once, as well as everyone else who has visited:
Example:
(Student)May Alle (Visited) 10/26/2004 (student)May Alle (Visited) 10/27/2004 (student)Billy Bob (Visited) 10/26/2004 (student)Billy Bob (visted) 10/27/2004 (student)Billy Bob (visted) 10/28/2004 (student)Candy Cane (visited) 10/26/2004 (student)Candy Cane (visted) 10/29/2004
You get the idea, so each student is in the Visit Information multiple times (maybe there is a more effective way to do this, I don't know...)
But basically, I want to be able to get all of Billy Bob's info, including his visits, on one page. Something like this:
I want TO Attach my ASP PAGES WITH ACCESS DATA BASE THROUGH DSN...WHAT WILL BE MY CONNECTION STRING IN ASP PAGE???
RIGHT NOW..I HAVE MENTION DATA SOURCE NAME IN MY ASP PAGE...AND MY CONNCTION STRING IS..... conn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Mydb.mdb" .......... Now..i want to connect through dsn...plz tell me what altration i have to do in my Connection string..and secondly what will be the location of my Access Data Base
