I am currently building a db that will handle information on many events around the world. What I would like to do is set a check box that when people scroll through the different records they could check it and it (the current record they are viewing) will go into a compiled list wherein the iindividual record details of that list which the user created by their choices could be exported to an excell sheet (to automate a reporting need in the job) I have seen functions like this in large websites particularly the classified job sections in the seattle Times . where as you scroll through you see something you like you mark it continue scrolling mark another and then when you are all done you go to a page that has all and only your selections.
Can anyone tell me where to start on this one what am I Looking for Etc.
This will be the next big step in this my first database.
All help greatly appreciated
I've been here for two months and answered over 400 questions. I'm seeing a pattern here, and I have decided to post the best ways to make sure you are never answered.10) Blood, sweat, and tears are for losers. Spend no time figuring things out on your own.9) Announce almost ceremoniously that you have no VBA experience.8) Fail to use the search functions of this forum.7) Try to put every example you're given into a macro.6) Believe that this is the only source for answers, because Access Help provides nothing. Nothing, I tell you!5) Have us write your homework for you and then complain when you don't understand it.4) Post in German.3) Have a belief that your particular problem is the most important issue ever, and post in every sub-forum possible. Then bump it.2) Be vague, and then be belligerent.1) Have no appreciation for the people that are answering your questions in the first place. I know this sounds cold and mean and otherwise uncaring, but we are here to answer questions, not give you fish, as it were. This is a place to say, "I've done most of the work, but I need help over this hump," not "I have this crazy project/idea and I want you to write it for me." I've written over a dozen example DBs for people, and I know that I know what I'm doing. But, myself along with perhaps the majority of others that answer the majority of the questions, I'm asking on their behalf to please take the time to figure some of this out. If you can't do VBA, you are using 25% maybe of Access. If you can't understand your own DB, then asking us to fix it is a solution, but not a learning opportunity for you. If you can't understand what I'm getting at, it's that so many posts are the same. Again, I'm not trying to be an ass, but if you want to be a decent Access programmer and a programmer in general, then please, take the time to learn it. There are plenty of books (look at the bottom of this forum) and there are plenty of resources. I don't think any of us are teachers by trade, but the best teacher for something like programming is always trial and error. Programming is a language, a passion, a "something you figure out" if you will. If you're spoon-fed the entire time, you don't learn. I will continue to answer as I always do and I apologize if anyone was offended, but jeez, make sure you've tried everything offline before asking for help. And don't forget to search first, both here and Google.Sorry for the long read. :)
Hello, I was hoping someone can help me how to put the following statement in right format. I have 4 fields idResult, QuestionNumber, Description and Result.
So If Question Number and Description have same idResult then Result is (results are defined in the table) there are 30 combinations.
I have set it up and now need to create an invoice section. An invoice needs to be issued every month and is worked out on a percentage of works complete. For example in one job there may be 10 items of work and for 8 of these iems 25% of the work is complete and the other 2 no work has started. Therefore my invoice needs to be able to calculate 25% of the value of the 8 items and work out a total price to be invoiced. Each time an invoice is created I need to be able to store the invoice value and the percent value of each item complete. Does any one have any ideas as to a good way of doing this. That is if you can undersatnd what I am asking for. Thanks for any help.
I'm trying to find out what's the best (or good ways) to open and close a database (*.mdb) in ASP without worrying about it staying open. The website stops running (page not displayed) after it has been visited several times I think, or it's happening when I'm creating new scripts I made which crash several times during debugging. Not sure what's causing it.
Here's how the db connections work. I'm basically using (includes) to do lots of this.. every web page that requires the DB, I do this format...
(includefile: open database) (includefile: create constants/variables) (includefile: load functions used) - the html page, which access functions when needed - (includefile: close database)
the includefile that holds all the function scripts does not open or close the db at all but only the recordsets semi-example function (function) rs.open "", cn <--- the cn was opened in the database script - blah = the stuff - rs.close (end function)
Is this a good way to work with the database? I'm using access. Yes, i know sql servers are better, but I was told that since I have only access, I want to minimize the number of connections, so I open the database once during the page being opened, and close at the end of the page.
Like I say, the problem is, the site works great for a while (no real visitors yet as it's new), but it suddenly says "page not displayed" after a while. NORMALLY this happens when I'm making new functions/webpages and did the coding wrong while the database is still open. I'm thinking it's crashing because there were too many errors during the database being open.
PLEASE HELP!
BTW, is it possible to just run a script that finds ALL the open connections after a crash and close them?
It is now possible that some of the products can also be a product group, and a product group would then consist of multiple products. (Note: if a product is a product group as well, both of them have the same names. therefore for consistency, if in future someone alters the product name, that should be reflected for the product group if that product happens to be a product group as well)
So, I started of by thinking that the products table should contain a binary filed like "Is_this_a_ProductGroup", where for any product that is also a product group, while creating or editing the product the user would flag this field "Yes" and "No" otherwise.
S, my revised products table is like:
PRODUCT ======== Prod_id Prod_name Is_it_a_ProductGroup Dept Type :
Based on some earlier suggestions in this forum, I tried to create a junction table like
and joined the Prod_id above to the Prod_idin PRODUCT table and created a copy of the PRODUCT table and joined the Prod_Group_id to Prod_id in the PRODUCT_Copy table.
I would like some help now on:
1. whether this design is really correct?
2. If so, how does one go about the process of data entry through forms for these tables?
I have a database that, vaguely looks like the following
NAME Value Category A Value Category B Value Category C
Name A -50 0 0 Name A 0 50 0 Name B -100 0 0 Name B 0 75 10 Name B -25 0 0 Name C -100 0 0
Etc. etc.
What I'd like is to find a query that will first, generate a Category D which should be a total of all the values in the three different categories and consolidates the names to one line. So it should spit something like this out.
NAME Value Category A Value Category B Value Category C Total Name A -50 50 0 0 Name B -125 75 10 -40 Name C -100 0 0 -100
After this, I'd like to have another query that will only display the values that are NOT zero.
NAME Val Cat A Val Cat B Val Cat C Total Name B -125 75 10 -40 Name C -100 0 0 -100
Each month I get the previous months data. In that data, I have a list of names that have duplicates in them. Some of the names have last, first middle. Some have just last, first. I want to combine the like names and leave the unlike names not combined.I want to combine in this situation
ex. Smith, Peter Smith, Peter W
I do not want to combine in this situation ex. Smith, Peter M Smith, Peter W
My goal is to get the original name in a table with the combined name next to it.
In an Access 2010 form is it possible to export select records and fields in those records to a specific location?
Code: Set objDialog = Application.FileDialog(4) With objDialog .AllowMultiSelect = False .Title = "Please select a File" .InitialFilename = "C:" .Show If .SelectedItems.Count = 0 Then MsgBox ("Action Cancelled") Else
[code]....
The user can select the directory using the code above, but can specific fields in records be exported to a excel workbook in that selected directory?For example, if the are 5 records in the database can the fields LastName,FirstName,BirthDate in records 1,2,3 be exported to Setup.xlsx in that selected directory?
I need to consolidate mailing addresses so that many records are grouped to one invoice based on the address they fall under. I am currently using an update query to change addresses that are similar to match exactly. Is there a way to make it so the addresses group together based on similarities rather than exact matches? For example I have two addresses:
1301 W Johnson Street Phoenix, Arizona 85725 1301 West Johnson St Phoenix, AZ 85725-7201
These are the same property however without cleaning them up manually to match, two invoices will be printed. Is there a way to consolidate these?
I have 3 tables of data, where I want to cross reference information to produce exception reports.
The tables all have Employee number held within them, and these form the basis of my queries.
We want to be able to cross reference locally held staffing information with centrally held HR and payroll records.
The type of information we want to be able to check, is if the hours of the individual are the same in all 3 records, the grade they are being paid for, the cost centre, and that the names match.
Currently we run separate queries for all of these, and I want to be able to consolidate the exceptions in one report, to save looking at the same persons record more than once.
For example, if John Smith has a different name, grade and cost centre are all different - we may be accessing his record 6 times, once for each variance against payroll and HR records.
Is there a way that I can pull all this information together to speed up the reconciliation process?
I have a few duplicate customer queries (different duplicate fields etc). I would like to construct a form to make it easy for an end user to remove the duplicates.
The main problems are...
1. the newer customer is to be deleted
2. any/all orders from the newer customer will be moved to the older customer before deletion.
3. preferably an easy way to switch between the duplicate queries in the same form, though if this is a problem I could just have one small dialog box/form, linking to 3 different duplicate query/forms.
I think other changes between the customers will be easy enough to just do in the subform, i.e update email address/tel/status/salesperson etc. These can just be edited directly?
But the transferring of orders can't be edited directly because there may be several orders and could be errors etc.
So all that needs to be updated is [CustomerNumber] in tblCustomerOrders. All orders for the newer customer to have the CustomerNumber field updated to match the older customer. Then the newer customer is deleted.
I would just have a button with a message box to run the code, update CustomerNumber/s and delete record.
The above table suits me well for data entry.For analysis reasons, I want it to have another table or query or something (let's call it "Teacher Info") that looks like this:
Is there any way that I could do this? I have been struggling with this for a while.Just so you know how this data is connected - At the moment, I have a form where I put in new Teacher information. I have a subform attached to that, where I put the student names and numbers. This way, the students are linked with their student #s, and each of them are linked to a teacher. Unfortunately, the table ("New Teacher Registration") that this creates looks like this:
id....Teacher Name 62...... Alice (+ tab).........A.........432 ...................B.........674 ...................C.........875 18.......Katie (+ tab).........D.........934 ...................E.........345 4........Dan (+ tab).........F.........134 ...................G.........734
I created the "Student Info" table (above) from this to work with data entry (drop-downs and such). Now I'd like to create a "Teacher Info" table (above) for analysis.
Each month I get the previous months data. In that data, I have a list of names that have duplicates in them. Some of the names have last, first middle. Some have just last, first. I want to combine the like names and leave the unlike names not combined.
I want to combine in this situation ex. Smith, Peter Smith, Peter W
I do not want to combine in this situation ex. Smith, Peter M Smith, Peter W
My goal is to get the original name in a table with the combined name next to it.
Original NameNew Name Smith, PeterSmith, Peter Smith, Peter WSmith, Peter
I have one Master database and multiple child databases in a folder. Each of these databases (both Parent and Child) have identical table called "source". I need a VBA code which will consolidate tables of child database into the Parent database table.
I have two tables in my Access database. Table 1 has three columns, First Name, Last Name and Phone Number. Table 2 has just 2 columns, First Name and Last Name. What I would like to do is write a VBA macro to consolidate Table 2 into Table 1 and insure any duplicate First Name-Last Name combination is removed.
Table1
Code: F.Name L.Name Tel.N. John Smith 12345 Larry Miller 12344 Tony Woods 12333
Table2
Code: F.Name L.Name Albert Black Larry Miller John Bush
Table1 Post-Macro
Code: F.Name L.Name Tel.N. John Smith 12345 Larry Miller 12344 Tony Woods 12333 Albert Black John Bush
How can I get a Query Criteria To Select All Records or specific records in query design section.
I have a table that shows many departments with credit card transactions. I like to run a query to see specific department, or have an option to see all the departments when the query is run.
Hi, My question 'sounds' easy, but i can't think of a way to do this. Please help!
Ok, i have an 'employee' history table with 200K records. Each employee could have multiple records with different 'effective' dates(please see below for an example of two employees' records). What I want to do is to run a query where it will pick up ONLY the top TWO records of each emplyee. How would I go about doing this?
Thank you.
Joe
Employee History Table: SSN--------------------EFFV_Date 123-45-6789---------------01/02/2006 123-45-6789---------------12/03/2001 123-45-6789---------------08/22/2000 222-33-4444---------------05/28/2003 222-33-4444---------------07/01/1995 222-33-4444---------------06/30/1990
Query result should be somthing like this: SSN-----------------------EFFV_date 123-45-6789---------------01/02/2006 123-45-6789---------------12/03/2001 222-33-4444---------------05/28/2003 222-33-4444---------------07/01/1995
Is there a statement that will allow me to select a range of records in the middle of a selection of records? e.g. Rather than TOP 10, can I get like records 10-20, or 50-65 etc? Prodigy.
I was wondering if anyone has seen a easy way to use a calender to select records rather than having to type in a "between such and such a date".
Because what i have now is a qry that pulls data from a table between two dates. And i would like to make it more GUI rather than typing to prevent user imput error if you understand what i mean.
I tried searching but didnt know what to search for.
Ok I am probably goining nuts by now. I could have swore that I had a referance book that showed how to set up a form with multiple combo boxes that were used to filter forms/reports for desired records. Now I can't find that referance anywhere! Does anyone know how to do this or can they point me to a referance with this information? Please help me, this is one of the final touches I need for a project I have been working on for months.
I currently have a ListBox which I am using on a form as a "jump To..." record selector. It has to show 4 values to the users, and so far it has worked quite well. However, I recently added some queries to the footer of the form to help narrow down the data for searches, or if the user wants to see all open data of a certain topic. I'd like to have the ListBox "refresh" and only display the results of the query, but I cannot for the life of me figure out how to do it. The root of the problem seems to be that the initial SQL for the ListBox is selecting values from the under-lying table, and when the filter is applied, it simply doesn't care. When you click on entries that aren't in the filtered dataset, it doesn't error out or anything, and when you click ones that ARE in the filtered dataset, it does work properly... I'm close... How do I filter the listbox as well?
