Hi all,
I opened my database on a newly installed access programme (same version) to notice that the design control page settings had reverted to default for all my forms and reports. I need them to be A4 and not letter when it is opened on any access system. How could I go about doing this? In Code?
Cheers
Tania
Hi
I have created some reports but find difficult to keep permanganate page set up for that reports. I go to design view and do page setup with required margin and Portrait or Landscape set up and preview that reports looks fine. After saving again I check still its fine but once I close that database and reopen again some of reports page setup becomes Portrait with 1" margin on all sides (Not All reports). I cannot solve this. Can any one help??
Funny part is even I copy that report and change data source of that report it changes page setup
:confused:
I have several reports in my system. Some are landscape and some are portrait. Occasionally the landcape ones switch to portrait taking up two pages each. In preview mode it is not so bad that the user can reset the page size, but when one is sent to print this is most certainly annoying.
Any advice?
Is it possible, within an OnOpen even of a specific report, to set the printer selection and page setup (size, margins, etc.) to certain things? If so, how would I go about accomplishing this?
I would like to do this for specific users within our domain (this I won't have any trouble with).
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
View 3 Replies View RelatedI have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.??
(Actually I would also like any State that continues to a next page to not just have the state name but something like
" Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska
Ancorage
Prudo Bay
California
Whittier
Anaheim
Colorado
------------------------Page Break ---------------------------------
Denver
Pueblo
Colorado Springs
Deleware
Dover
-------------------------------------------------------------------------------------------
Thanks !
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
Hi All,
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
How can I stop the page refresh itself?
Thanks and Happy New Year!!
I have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies View RelatedI have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies View RelatedI am trying to create an invoice report. I want to add all the costs from the detail section in my footer. I have accomplished this in either the Report footer and/or the page footer, but the problem is that the report footer doesn't go to the bottom of the page, and the page footer doesn't go to just the last page. I have tested a bunch of suggestions that don't seem to work.
1. Print page footer with Report header = NO - only works if your report is two pages or more.
2. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
Me.[TextBoxName].Visible = True
Else
Me.[TextBoxName].Visible = False
End If
End Sub
The Page functions worked, but it did not change the results from page to page. If it was a two page report, then the if statement is false and the text box was not visible on page 1, but it also was not visible on page 2.
to automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.
So right now my form looks like below
CAD#
Person name
Charge
Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"
Officer name date page # of #
Thanks in advance.
Matt
Hi All
I have added the Allen Browne Calendar 2k control to my form.
My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.
What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.
Any suggestions please?
Many thanks
Tee :(
I've used the following code on the footer on print procedure:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub
This works fine when you view it in print preview, but the footer don't show up at all when you actually print it.The reports default view itself is set print preview.
I have made a report on my query. The page setup is all around merging 0.2" and page size A4
When i view this report in preview it looks all my data whatever i want in a page but after every page it will generate a blank page.
I have included my report.
I have a form with six tabbed pages on it. Since data entry follows in a logical order I would like to put a command button on the bottom of each page (subform) that can be used to go to the next page. What I am going to though? If i put a command button (open form) then it opens the whole form not as a subform on a tabbed page. if I try and put a command button (open page) then it will not let me enter the page number. Hope that makes sense! Any ideas
View 3 Replies View RelatedI am trying to create a report that has the dates go accross the page and not down the page .
Example:
Need:
Jan 2014 Feb 2014 March 2014
Ans so on. I will also need datat under each date.
I am having issues with the reports to give me the output that I need.
Trying to set up a database in access to be used for customers to track payment history problems. how does this sound???? ...
Table 1 would have fields: account # ; account name; region
Table 2 (would need a separate table? ) With fields: account #; date entered; entered by; Comments:
I Need to be able to enter multiple entries for payment history comments as this will be info entered by date to track
So data would look like:
Account #: 111-11111 Account name: test company Region: new york
Entry date: 3/5/05 Entered by: Joe Shmoe Comments: Company short paid, sent letter 3/5/05 requesting additional $$
Entry date 3/10/05 Entered by: Sue Smith Comments: Sales office says there is a problem with the bill, extend grace period.
I can’t put this in one table right?
I will have many entry dates & comments for an account that I would like to print out in a report.
Wouldn’t I need 2 tables with a relationship linked by account #?
Thanks... I will be around the rest of the day to respond to any commments..
please help me with setting this up..
I'm creating a data access page that can be used over the internet to add information into the database. The database is password protected. The functionality currently is that when a user accesses the data access page, they need the database password in order to submit information. We don't have a small number of users and giving all these people the password to the database would comprimise the security of the system.
I am looking for a functionality such that the people that edit the database, either by the front end application or by opening the database directly to be password protected. But the data access page not to be.
Any ideas on how I can achieve this functionality?
I have a database for an event with 2 main tables.
Parents and Children of the parents with a one to many relationship.
I need to be able add the table number that each parent and child will be at (not the same table as parent). I could add another field for the table to each database but not all the entries are attending the event.
Could someone point me in the right direction as to the best way to design this.
WarrenB
I have a database that contains information on football games. There are many
different games from many different seasons, teams, opponents.
I will eventually have a fairly large number of different reports and forms
that will want to be viewed but filtered by the above three catagories.
Usually all of the reports at any given period of time while running the
reports will want to be viewed off the same criteria as the one before. (i
don't think you would want to have to fill out the parameter manually for
each report or you will be entering redundent data as the parameter report
after report.)
I was thinking of having a form with 3 multi select list boxes, [seasonlst]
, [teamlst] , [opponentlst] and having each form filter information based of
the values entered in each box.
Is this the best way to do it or is there a better way?
I have ta table that has the following fields:
factorID (Primary key, AutoNumber)
supplierID (Foreign key to suppliers table)
categoryID (Foreign key to Categories)
Factor
I'd like to ensure that there is only one Supplier/Category pair in the table, but I can't figure out how to set it up to achieve this. Any help will be much appreciated. Thanks.
I've thought I had a decent understanding of database normalization but I've come across a fairly simple problem that I'm having difficulty resolving.
I have a database which I use to track submittals from companies.
Originally it was set up as follows:
tblCompany
Company_ID (PK)
Company (No duplicates allowed)
tblSubmittals
Submittals_ID (PK)
Description
Date
Company_ID (FK)
Now I've decided that I want to add a contacts table with fields such as first name, last name, company, etc. My dilemma is that in the Submittals table I need to keep track of which company the submittal is from but I don't care WHO it is from.
So I created another table as follows:
tblContacts
Contact_ID (PK)
Company_ID (FK)
First_Name
Last_Name
This will work except that when I add a new contact I will have to add code to see if the company exists in the tblCompany before I add it.
It doesn't seem like this would be the correct way to set this up because I'm adding the same data to 2 different tables.
I'm sorry if this seems like a stupid question. Thanks for your input.
HiNew to the forum and pretty new to MS Access.Here's what I intend to do.I want a table for Special Tasks. This will include TaskID, Date, Time, Reason, Description and Dependencies.I want a table of staffFor each task each member of staff will have a tick box for "Needs to Read" and "Has Read".In a form I want to be able to enter new tasks using the task table, I also want to use a subform that allows me access to the list of staff and if they have read the task or not.There is probably an easy way round this but at the moment it's just not clicking into place.Can someone point me in the right direction for table setup and relationships ??
View 1 Replies View RelatedHello, I am having difficulties normalizing my tables. So far, i have 4 tablestblODF:- ODFNumber (PK, manually enter ID)- UserName (txt)- QueueID (number)- ScanDate (date)- Status (text)tblEmployee- EmployeeID (pk, autonumber)- UserName (txt)- LastName(txt)- FirstName(txt)- Extension(number)tblQueue- QueueID(Pk, autonumber)- Queue (txt)tblStatus- StatusID(pk, autonumber)- Status(txt)I am also having problems setting up the relationshipsI want to setup a query and i want all these data to appear:- ODFNumber (txt)- UserName (txt)- ScanDate (date)- Queue (txt)- Status (txt)I am really stuck in setting up the tables and their relationship. So in short, help:DThank you, (some of you might recognize this project)
View 4 Replies View RelatedI've approached this once before but I never did figure out how to go about setting up this table. If anyone can steer me in the right direction I'd appriciate it!
Overview: I have 25 products that I track repairs on. I am given quotas every month for some or all of those products. All this data needs to be kept vs overrighting last months quota information with this month's.
What I have done was created a table with columns of: ProductID, 1/08, 2/08, 3/08, 4/08, etc... and ran that out for a years time. So, that is how my table is currently formatted...
Now when I need to pull out information I have a query that looks at a particular month column and compairs that to my work table. However, every month I need to go into that query and change the column name it looks at in my quota table. This again works, but is it the best way? I also need to pull out history information month by month for a production graph. The query I had to build again requires me to manually go in and enter new month information every time it's needed.
It just seems to me that there is probably a better way to format this quota table. If I remember correctly someone suggested to me that I needed to normalize this table; and the format suggested was more like:
productID; date; quota
But instead of just having 25 lines I will now have 25 each month. That just seems like it'll get excessive real quick...
SO; if there are any great ideas for setting up this quota table vs what I am currently using I would really like to know!
Thanks!!