QUESTION .
First I will enter info into TBL Radio Receipt, from there I want the information to jump to TBL Radio Info and prompt me to complete this table. Then it will jump to either TBL New Radio Information OR TBL Repair Information. This will need to be completed. How does this happen, I mean-- How do I create the relationships to reflect this path?
2. How do I attach a pics of my problem to this thread?
I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.
View 2 Replies View Relatedi have a db consist of order table of three basics no 1 is battery no 2 is parts and no 3 is i have made a query transaction based on that.
Now what i need is to get total monthly sale amount of above three category .. then same as for daily and also how can i show all these reports in one summary report.
It's been a long time since I have worked with Access. Here is what I did and what I am trying to do. I'm basically at wits end.
I created a table which consists of fields that contain data pertaining to project management. The Engineering manager wants to be able to do reports on the different projects based on what steps of the project has been finished and who it was assigned to.
Here is an example.
Step 2
Heat Transfer complete? Yes/No drop down box
Step Assigned to: Employee drop down box
Date Completed? Date/time field
Commments: A field for text that pertains to the step if there was a promlem etc etc.
As it stands right now there is a total of 12 steps with each step ranging from 1 to 6 questions like the above example.
For the first report he wants me to create, I need to the following data (which I have the query pulling from my table) Project #, Customer, Engine Make, Engine Model, and the first step where any task is marked at No, and the person assigned to the task that is marked no, the step comments, and he wants is sorted by step.
I have all the data fields from the table included in the query as the way I understand it, the query needs to run through each record, and stop when it finds the first no answer for a step and report it for each record. My problem is, I have no idea on how to accomplish this. Anyone have any ideas?
Hi,
How can I separate my application so the users can still use queries and reports on a db? I don't want them touching the tables or application directly so it looks like I need a way to create a separate application or something along those lines that is linked to the tables that the users want to query. Any suggestions?
Thanks,
scratch
I have already used the option in the 'Startup...' menu so that the user only sees the database window with the tables, queries and reports etc. But the user can still press the 'Design button' in the database window. And especially for my queries and reports that would be a problem if they altered things in there by accident.
Is there a way to secure this? Can I hide the queries but still let the user access one table and the reports?
I have tried to search for answers and the runtime command removes everything so that nothing is visible :p
Hope You can help :)
I am trying to create a new query and a new report in my database. The program will not let me. The "new" is grayed out. Can anyone help me? :confused:
View 14 Replies View RelatedI've got several access databases located on our file server. Numerous users throughout the office have access to open and view them as has been the case for several years. Since the beginning of the year we have started seeing a brand new issue occur every couple of months in a few of our databases. One day everything will work fine, come in the next day and all of the macros, tables and most of the queries are gone. I have noticed when this happens the queries vanish in ascending alphabetical order, the first 2-10 or so may still be there but everything after that and in reports and macros are gone. Recently we've also had another access mdb start doing this problem and only one user other than the system administrator has access to that file, it is also located on the server and in a secured folder.
The only fix I've found is to restore from a tape backup from a few days before to confirm it's a good copy but this gets annoying.
Any thoughts as to the cause or solution?
All databases effected are located on a central server, get a nightly backup, have a list of tables almost completely made up of linked tables from multiple ms sql server 2000 databases. The files are Access2000 format.
Thank you in advance for your expertise, I'll add any furhter details you may want/need.
I am updating an existing distributed access database.
I have made changes to an existing report (from my workstation - I have admin rights on the DB). The changes show up on the database. However when a client generates a report, the changes do not show up. What can I do??
I was recently doing a little Spring Cleaning in my database and deleting old tables and queries that were no longer used or had been for experimental purposes. Unfortunately, I unknowingly deleted a query that was being used by a report I still needed and it took me several hours to find and correct the problem.
Not wanting to repeat this mistake, I began searching for a way to display my reports, queries, and tables and all the objects each is linked to. I thought it would be nice, for instance, to have a hard copy list of all my queries that showed where they are derived from and what other objects reference them. Is there a way to do this?
I've tried using the "Relationships" button and working with the Documenter, but I haven't found what I'm looking for. I have also tried a Google search, but, admittedly, I may not be using the proper terminology to get good results.
Thanks for your time.
Hi all,
I'm trying to create a database to track all the students details, I've created the data base with all the tables, relationship etc. i tested it with dummy data too and it worked fine.
I then imported the proper data from a .csv file, using the "File-Get External Data-Import" method rather than a macro, it imports the data with a couple of errors but the data still got through, i had previously created queries and reports and they worked fine with the dummy data but will not show any of the new imported data, its like it hasn't got a link or something but if i create a linked form, it will pick up the data, meaning the relationships are working. hence my problem
Thanks
Dellero
I've inherited a database with many queries (most based on a single table). There is a requirement to change the name of a few fields in the table. Is there a way to find ALL queries/reports that are utilizing the fields that need to be changed so I know what queries need to be modified?
View 3 Replies View RelatedHello,
Am posting this message (also on reports forum) as i dont know whether the problem is at report or query level. Hope you can help.
Hello all, this is probably simple but im new to all this!
I am trying to produce reports that show details for only the past year, at present my reports are bringing up details of all the previous years also. Is there any way you can put conditions on reports ( or should it be in a query) that tells the report to only include dates i.e. today - 365 days. At present i have to change the dates every day both a start and end date. Is this possible?
Thanks
I KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?
Please help!
HI folks
I have a db. I have created a search form which when you click the search button executes a query to find the required records.
The query is currently outputting to printpreview of the query.
What i want to be able to do is have the option to select the correct record and then print it. The search can either be exact and return 1 record or use a wildcard and return a few records.
I have the report setup and working I just can't for the life of me figure out how to link everything.
Maybe I've missed something I don't know.
When I make a search using a search form, I get a table with the results that match.Can I make a link from this table to a report to display the details of the matching product?One of the reasons I need to do this is because one search may bring up more than one product.
View 1 Replies View RelatedI have to compile a report from more than two queries. All queries have a field common between them.
E.g.
query1 gives name, address and contact number of all the 30 students in a class
query2 gives semester wise marks obtained by each student
query3 gives performance in sports of each student.
All the three queries have name of the student common in them.
Now I wish to generate a report card which should be as under:
1. The record of query1, query2 and query3 corresponding to a particular student should come together.
2. The record of query1, query2 and query3 corresponding to the next students should come after that and so on.....
I tried using a sub-report but it ends up displaying all the records of query1 first and then all the records of query2 and so on...
We have a database that has around 30 queries that are ran on a monthly basis. They all have unique criteria (but there is a crossover of fields that are used), and are all set up so they show only the previous month's data (the date is taken from one date field for some queries, and another date field for others).
We run the queries, and only need the 'count' of number of records that fit the query each month.I was wondering if it is possible to create a report that will run the queries simultaneously, and show the 'count' of the query results in predetermined fields.
Hi All,
I’m completely stumped … could be because its so late or my brain has just decided to give up on me!
Short of not going into too much detail, could someone advise … does one HAVE to create a query in order to create a report based on a form OR can one create a report based solely on a form?
Is there a right way and a wrong way ... ?!?!
Hope someone can help me ... thanks in advance.
I am writing reports and queries for an Access database used by a small business. I have a copy of their data and am making the report and query additions to that. Now how do I get my additions to the 'live' system?
Robert
Hello All,
I am trying automate some report printing.
I have around 20 reports most of which require a from date and a two date.
If I use the code below, it asks for the from a two date on each report print, but the dates are always the same.
Is there a way of take a two date and a from date at the start of the sequence and insert it into each reports date range prompts?
Private Sub btnME_Click()
MsgBox "Please note, this process can take upto 5 minutes to complete."
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry1"
DoCmd.OpenReport "rpt1", acNormal
DoCmd.OpenReport "rpt2", acNormal
DoCmd.SetWarnings True
MsgBox "Reports have been printed, aggregated results have been inputed into 'workstats_automated.xls'"
End Sub
Ok, so now this is where it's getting more complicated... (though I guess this is where you guys usually start)
When you have a query, and you type in your inputbox thingy like so:
http://reenen.fateback.com/image.jpg
PeriodEnd: [Enter period end date dd/mm/yyyy: ]
And you can have multiple, then it will prompt you for several of them.
Now this is not very tidy, so I'd rather do it on a form. How can I display the form as the query/report runs, and insert the values entered into the form as the inputs into my variables? (This case PeriodEnd)
-Canderel
Grrr... I can't get the image to display.
I have a problem that is very tedious. I have 9 separate copies of the same databse (there is a copy of each database for every branch of my company. Each database has small custom features that show what company it belongs to) i was told to make a new feature, and in the making, i had to make 40 new queries, 12 new forms 8 new macros, 12 new macros and 6 new forms. this feature needs to go into all of the databases. As far as i know, im going to need to copy and paste each individual query,form, macro and form. Thats 72 different things i will have to copy and paste into 9 separate databases. Does access provide an easier way to go about this?
any help?
I understand that I can't set multiple "values" in a crosstab query but I need to have both a UPC and a price display in a report(Price List) for Our Exotic Wood selections like so:
Wood Type 4/4 5/4 8/4 12/4 16/4 20/4 24/4
Afr. Mahogany |||| ||| ||| |||| |||| |||| ||||
$15 $20 $30 $40 $50 $60 $70
Rosewood |||| ||| ||| |||| |||| |||| ||||
$15 $20 $30 $40 $50 $60 $70
I have 2 crosstab queries one that gets the price and one that gets the UPC I can join them and get it to print on every other line but there is no way that i can find to print two lines at a time in a report so my question is there a way to achieve the outcome described above with two crosstab queries? do I need more queries or a different kind of query?
I have a report database that provides my company with clients that took our training modules and notify us of which clients completed our trainings.The clients can complete training in 3 States and "Passed" means they are good to go.
I download an excel report daily and import it to Access on a daily basis. Problem is the Report is over 8,000 rows long and basically I just need the clients that completed training within past 48 hours. The excel report provides a date of completion.
code that only pulls those clients that "Passed" within the last 48 Hours. Here is my SQL Statement I use on the RecordSource.
SELECT report.SPS, report.FirstName, report.region, report.id, report.AZ_Cert, report.AZStatus, report.CA_CERT, report.CAStatus, report.OR_CERT, report.ORStatus, report.Completed FROM report WHERE (((report.Completed)=False));
The completed checkbox removes the record from the cert queue. How can I do this more efficiently? I think I have it right.
Private Sub Completed_Click()
Const cstrPrompt As String = _
"Are you sure you want to complete this record? Yes/No"
If MsgBox(cstrPrompt, vbQuestion + vbYesNo) = vbYes Then
If Me.Dirty Then
Me.Dirty = False ' save the record
Forms!frmRecertView.subfrmRecert.Requery
End If
End If
End Sub
I have a database that reports activities by region.
Each week, my regional volunteers report statistics on a number of club activities. This is in the form of zero to theoretically infinite activity reports that they enter on a website. I download the .csv from the website, add the activity reports to the activity table and send them a totals summary every now and then.
The summary report shows figures for every club in the region, even if no activity reports have been entered for that club that week or ever.
This works fine, including forcing the query to return zeros when no reports have been submitted for that club.
What I want to do is have the report also show (in brackets next to each figure) the position as it was X number of days previously.
I can make the query and report to show the figures now.
I can make the query and report to show the figures X days ago.
What I cannot work out is how to combine the two queries into one report source so that I can get
Club 1 100(50) 75(0) 45(45)
Club 2 0(0) 0(0) 0(0)
Club 3 20(19) 0(0) 200(50)
etc
If I try and make a third query that gets the sums from qryNow and the sums from qryXdaysago for each record in qryClubsByRegion, I get two lines for each club.