Hi all,
Does anyone know how I can, as stated, change a report's query dependency? I copy and pasted several reports and want to make macro buttons to access the reports and put them on a form. However I want each button to point to a different query, which in turn point to different reports.
When I copy and pasted the reports, I go into "Objects that I depend on" and I can't change the query it points to! Help!
Richard
Hi All,
I have a report that is driven off a query which in turn is driven by something like 20 odd queries
I have been asked now to produce the same report by a categorical area
Now my understadning is that if there is 3 categories for instance then i am looking at soething like 3 X 24 queries effort to get this working
Let me know if this is common practice among access applications because i had a feeling that this is quite long winded and was hoping for a quicker way of producing these reports
thanks
hi guys. i am just a newbie here. i just wanna know if do i have to make a query for each report that i need to create?
thank you.
I have designed a report that took ages to do the layout etc for.
Now I just want to use that as a template and just alter which query it gets its parameters from.
I can't for the life of me figure this one out
Any help would be very much appreciated
I have built a database with only my department in mind that tracks three types of documents; Which works fine. Now some of my fellow department heads desire to use what I have built.
This is not a problem as their data structure is the same. The difficulty lies in changing the 30 queries. In the queries I hard coded my department number in the receiver (department field) criteria.
Additionally, my HQ is requesting me to perform some analysis on the other department's data. So other than manually changing the department number each time; Can I use a form or report to modify these 30 queries? I attempted to use a combo box but it would not hold the value when I closed the form.
I saw this thread today, http://www.access-programmers.co.uk/forums/showthread.php?t=102036 , but am not sure it will do what I want.
Suggestions welcomed.
Gunner...:confused:
Objective to have a report generated from a query (Based on a Storage Table) in the record-source however need to make adjustments to each record based on the query output ie User Id is outputted as number as it needs to be for everything else but on the report loading needs to run an sql query on that ID number to get the name and then replace that value with the name and so on for each record and each appropriate column
Problem:I can either change All of the records outputted with the first records info or nothing at all. i need this process to occur individually on each outputted record
Hi
Apologies, if something similar has been posted.
I have created a databse, that handles, names,addresses, items bought, and so on.
Because of this, the database uses the internal variable Date().
I recently fitted a new hard drive, and when I came to run the database, to print out addresses, it complained that a missing DLL (Iaiexplore.dll) was needed. I clicked OK, and every field or line of code that uses the Date() variable no-longer works without this DLL. Which is off because this particular DLL belonfs to the Intervideo WinDVD player!
My database handles a lot of things, but it doesn't play DVD's!
If I create a new database, the Date() variable works, it juswt doesn't work in mine without that DVD player being installed.
This has baffled me.
I did have this app installed, but I switched to another DVD player, after fitting the new Hardrive.
For one-reason-or-another my database has a dependency for this DLL, and the Date() string won't work without it. And this of course, has a knock-on effect of stopping something else from working.
I went to Macros/Tools/References, and removed it from there, but it still didn't cure the Date() problem. Although it didn't ask for this DLL again.
I cured it the last time by re-installing the DVD player, but this is ridiculous, and seems overkill.
Thanks
Hello : )
I am currently taking a database design class using Access 2003 and am looking for some help. I am trying to draw a dependency diagram before I create the tables based on the following attributes / fields in one table named Student:
StudentNumber, StudentName, StudentMajor, student's AdvisorNumber, AdvisorName, AdvisorOfficeNumber, AdvisorPhone, student's NumberCredits and student's Class (freshman, sophomore, etc.)
So far I have identified the Primary Keys as StudentNumber and AdvisorNumber and this is what I have:
Table #1 - Student = Student Number functionally determines Student Name, StudentMajor (?) NumberCredits and Class
Table #2 - Advisor = Advisor number functionally determines Advisor name, office number and phone
The problem I run into is with the the StudentMajor / Advisor / StudentNumber relationship. Since one student can have many majors and therefore many advisors since there is only one advisor per major, and each advisor has many students I am assuming it is a many-to-many relationship.
The problem I am having is determining the third table (and fourth if there will be one) and the relationship between StudentMajor / Advisor / StudentNumber.
Should StudentMajor be included as functionally dependent on StudentNumber? If it is there would be redundancy due to multiple entries in that field for each row so I guess I can't include it actually. :confused:
Wouldn't there have to be another attribute named AdvisorDept for this to work properly....that way there is a relationship between Advisor and their department they work in so I can link the student's major to the advisor :confused:
Any pointers and suggestions would be greatly appreciated
Thanks
must i install a printer in order for me to change my report to landscape?.. This doesn't sound right to me.. currently my report is set to portrait and when i go to page setup (menu option) i receive a msg saying i must install a printer first.. is this the only place where i can set my report to landscape?.. is there a property i've overlooked?.. thanks!
View 4 Replies View RelatedHi,
Is there any way to change orientation of report in report footer? I mean, I want to produce report header, detail etc in landscape and after detail I have given page break, at last page only report footer should be in portrait.
Rahul
I have a report with subreports contained in it. Each subreport gets it's data from a different table.
I noticed subreport 1,2,3,4 are pulling the data from their corresponding tables. However, subreport 5,6, and 7 are pulling their data from the table relating to subreport 1.
I've checked the subreports themselves. They are referencing their own tables if I open them individually but not when opening the main report.
The report names all seem to be correct.
I've never seen anything like this before. Does anyone have some ideas??
Thanks.
OK. I have a report that I want to use as a master and use with about 4 different querys. In the report properties I've bound it to a query. I've tried for ages to change the record sources with on click command bottons on another form. I think things have become complicated because there's a subreport on the report I AND a there's bunch of code to make things invisible in the on page event of the report.
anyway, here's what I'm using:
DoCmd.OpenReport "rpt_master", acViewPreview
Me.RecordSource = "qry_rptPrintRollClass"
Is this the right way to do it??
Any ideas on how I can clean it up??
Thanks
Damon
I have a form with command button, when clicked it displays My report in Preview. I want to change the report title whenever i click a button from the form. I believe it is to do with VBA and am new in that.
View 8 Replies View Relatedhow to change existing comments on a report?
View 1 Replies View RelatedWhat I'm trying to do is make it so that a certain area of my Detail area in my report changes colors based on whether or not a field name for each record is set to "Yes". The effect I wanted was produced easily enough by creating a Rectangle, coloring it Red, and setting it to not visible.
Putting RedBox.Visible = True in the Report On Load procedure works just fine. The problem I am having is attaching a condition to it.
Code:
If Me.FormatBox.Value = "Yes" Then
RedBox.Visible = True
End If
This compiles ok, but doesnt do anything to the actual report. Will it not work because the report has x amount of FormatBox's because it gets replicated for each record that is displayed? I should also note that I tried using a DL Lookup within my If statement and that didnt work either. That just colors all the boxes red and ignores the check.
Code:
Dim TestVar As String
TestVar = DLookup("Priority", "Table_Lancaster_Dispatch", "Priority = 'Yes'")
If TestVar = "Yes" Then
RedBox.Visible = True
End If
I have a report that contains game and its rating, the rating goes from -10 to +10, I would like to highlight the games that have a rating 1 or more with green color, rating 0 with yellow, and -1...-10 with red color, allso I would like to make a link on the game, so that when I click on it, it will open a form where that game is registered, for example it I want to change rating.
View 2 Replies View RelatedI'm looking to change the record source of a report and then print the report depending on what button the user clicks on.
Is there some way to do this?
I'm getting seriously frustrated with Access now so I hope some of you can help me out.
I have made an access application to enter various types of products (eg paint, tools, glue etc).
The organization I have built this for has asked me to create a report which can be used as
a catalogue of all their products.
They want this report to keep different categories of products in different sections. So say the paints
will go into a section with an orange background and the tools have a blue background. I thought
I could just let it print a number of reports (one for each type of product) however this will give
problems with the page numbering and indexes etc.
Anyone have any ideas how I can let the lay-out (mainly colors) change if a new category kicks in and also
force this category to start on a new page? Any help is very much appreciated!
Cheers Thomas
My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3.
When I open these reports they see the A4 'default' printer.
If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change - it keeps the default 'A4' and/or Access crashes.
If I change my workstation default printer to
The A3 printer and then open the Access file & report it works Ok (it picks up the A3 printer as default).
Can I use VBA to set the default printer and page setup to A3 when the report opens?
I have a report that constists of 4 subreports.I need the first two subreports to render in a two-column format and the 3. and 4. in a single column format.Unfortunatelly I cannot it work as I need to.I have read, that setting the main report in a single-column format and the subreports in a two-column format with "first across then down" setting (Or something like that) is and option.
Unfortunately this option does not fit my requirements.Is there a possibility to set the number of columns through VBA and change it across the different parts of the report?
In MsAccess 2007,I want each row color to change based on a column value in the report.
For example: Select Name,Age,Salary from table 1 -creates 3 rows.
Name Age Salary
A 15 1000
B 25 2000
c 35 3000
if Salary column is less than 1001,row should be in red- Row 1
if Salary column is less than 2001,row should be in green -Row2
if salary is less than 3001, row should be orange-Row3 .
How to do conditional color formatting of the entire row in Msaccess2007 based on a column value of each row.
I have a report which is counting and totalling numbers, but in the numbers show as negatives - I need them to show as positives.I managed to change the total in one counting field to positive but I've forgotten how - or where I put the code....
View 8 Replies View RelatedDoCmd.OutputTo acOutputReport, "Estimate", acFormatPDF, "c:TestMyReport.pdf"
the following code saves my report in a folder called test as a pdf file with the name MyReport. I have a string variable called RepName. How can I make the report get saved under that name.
I tried
DoCmd.OutputTo acOutputReport, "Estimate", acFormatPDF, "c:Test&MyReport&.pdf" but it dosent work.
I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report.
I have tried searching this forum and other but not quite sure of the terminology so not getting good results.
how to change background color of MSAccess Reports using VBA? How can I do border coloring. What are the vba codes for all color options like light green, light blue etc. How to change the font type to bold etc using vbaI did some changes to text box coloring in Detail Section on format click event.
View 3 Replies View Related="Summary for " & "'Location' = " & " " & [Location] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
NOTE: I need the number of the location to convert to the name instead i.e. 6 to Delaware.