Can anyone help?!? I need desperately to display a web page in a form but when i insert the browser i cant find where to put the URL in order to display the webpage..........!!?!?! HELP!!?!:confused:
Ben
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.
I was able to get the Query set how it's supposed to be.I now have the SQL for that Query and I would like to use that to display the information on a web page. I need the information to be constant on the page...if the database is updated, the information that reflects on the page needs to update.
The database resides on my standalone server, and is opened from that location. (I'm using XAMPP to create a standalone server in a sandbox environment...
The past few days I have noticed the Access database that I am using for development on a new site has been having problems. I am unable to locate what is going on but it seems as though the ASP page can't access the database, or if it its super slow. It just sits there and times out.
Anyone have any ideas on what might cause this? I have a support ticket into the server admin to have him check it out... just wondering what you all think?
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 RelatedThere are two pages in a word document. All the pages have same headers as attached in word document "Capita.doc". I want to display that header on just first page and on second one page, I want to display watermark stored in "J:PAP107.jpg". The following code displays same watermark on all the pages i.e "J:PAP107.jpg" but I want to keep the header as in the attached word document on first page only and display watermark stored in "J:PAP107.jpg" on second page.
Code:
Private Sub CmdPrint_Click()
Call WordSetupQA("C:CAPITA.dot", "J:PAP107.jpg", Format(DateSerial(ComboBox4, ComboBox3, ComboBox2), "mm/dd/yyyy"), pno)
End Sub
Code:
Sub WordSetupQA(fnTemplate As String, fnBackGroundPic As String, b As Date, a As String)
On Error Resume Next
'MsgBox txtbox
Application.DisplayAlerts = False
Dim strworkbookname As String
strworkbookname = "C:System1.mdb"
Set WordApp = GetObject(, "Word.Application")
[code]....
I'm using a web control to display a page. I want to have a code that can copy to a field in that same form, the html source of that page that is displayed in the web control. How I can do that?
View 13 Replies View Relatedto 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 am working on a change control database where the users can enter a new version for the software they just released and send out a notification to the appropriate persons. I have a form where the user can select a combobox to pick the software version, which is bound to my "Releases" table. From the software version I use a DLookup in VBA to change the value of a another unbound text box using:
Me.Release_Type = DLookup("[Release_Type_ID_FK]", "Releases", "Release_ID_PK = " & Me.Release_ID)
This all works fine when I'm entering data in the form, but if I want to print the form, the unbound text box on each page is only calculated from the first record. The same thing happens if I build a report with the same fields and code.
For example: In print preview the text box on page 1 should say "Cat" based on the current record and the text box on page 2 should say "Dog". However, they both say "Cat"
How do I get the text box to display the new value on each page?
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 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 !
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 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.
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.
Hi
Does anyone know a basic and quick way to write to a table in a database using a web page instead of a form? the webpage is stored locally as is the database
Thanks
Ben
hi
have a page with all my main fields, now i would like to create a sub form and put some of these fields on it.
i tried copy and pasting but a few of the scripts show errors.
im not sure hoe i can transfer exsisting fields onto a subform,
im guessing ive done this the wrong way round should have designed a sub form and then put the fields on
hi folks,
How do I open html based help file from an access form? I've looked at access help, but it only shows how to put the control on the page, and not how to link the control to the webpage? I'm missing somehting here if someone could help please?
It's probably obvious, but how do I get a form to fit one page?
I have to print a lot of forms but cannot get a page break or similar and the form "moves" down the page by the third or fourth record
Hi
I can insert a web browser as an ActiveX control however when i view the form in form view no page is displayed. anyone know how i can view the website within a form?
Thanks
Ben
Hi,
I have one main form, inside it there are 5 pages, is there any code I can use so that when I go between pages the data is refreshed.
e.g. I have a "fault" page where I log a call, then an "open calls" page where the calls go, however I have to close the form and reopen it for the data to appear!
After having designed a series of forms, I have just been told that users would like to occasionally print the data.
On testing this, it seems that the data does not print onto 1 page.
Are there any settings to fit data to 1 page wide only?
Aternatively, is there a better way of doing this? Perhaps by using a report or something like that?
The form has a whole load of calculated fields (calculated control boxes with expressions) so would I run into any problems doing it ths way ?
Thanks.
I have no idea how this happened, but...
I have a form that I use as a switchboard for a database. It automatically opens whenever I open the database and contains various buttons that allow me to import new data, run reports etc.
It has somehow moved a long, long, long, long (you get the idea!) way down the 'page' - i.e. the scrollbar to the right of access is enormously long with this form at the bottom and enything else I open at the top. This means that whenever I use the database any other forms, reports etc that I open are so far up the page that I cannot see them. The only way to reach them is to maximize everything. However, this makes it difficult/impossible if I need to, for example, see the design of two queries at the same time.
I have spent half an hour slowly moving the form up the page manually, but I don't seem to getting anywhere. Is there anyway to return this form to the top of the access page?