Open Web Page When Form Loads

Jun 8, 2006

I have a form that displays data based on a simple query. The query asks for a PO number (from the query) and then displays the data. I wish to open a web page after the PO number is put in. What is the vb code to do so and is it on the onLoad or onOpen portion of the form?

Also, the web address needs that PO number. So, the web address would be: http://www.mydomain.com?PO=PONumber where PONumber is what was entered into the text box that was prompted by the query. Any ideas on where to start on this one? Thanks!

View Replies

Forms :: Form Doesn't Open At Top Of Page

Apr 8, 2013

I have a main form that opens on an autoexec macro.When ever i open up the database the form opens but for some reason it always opens a little way down the page so that you cant see the top and have to scroll back up to the top.

This is rather annoying because i have a tab control and it means you cant click the tabs until you move it back up.

View 1 Replies View Related

Modules & VBA :: How To Open Form With Page Up Screen

Dec 26, 2013

My form opening with page down screen, how could I open it with page up screen?

View 7 Replies View Related

General :: Open Tabbed Form To A Specific Page?

Jan 21, 2014

Can I open a tabed form to a specific page?

If I'm in the form I can move focus by using

Me.[Page 12].SetFocus

but when opening using that code produces and error Page not available?

View 3 Replies View Related

General :: Login Form To Open Home Page When Correct Credentials Entered

Jun 16, 2013

i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)

i just need a code that checks what the users level is and then open home lvl#

(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...

View 5 Replies View Related

New Record When Form Loads

Sep 25, 2006

How do i set a form to start on a new record when it loads? I have tried the data tab in properties but there isn’t anything there what do I do? Can I use some VBA code?

View 2 Replies View Related

MsgBox Appear After Form Loads?

Mar 16, 2005

hello all,
i have a form which I have set so that it opens a blank record once opened. After it has been opened I want a msgbox to appear. my code so far is:
---------------------------------------
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec

Select Case MsgBox("Please select the Registration Number from the drop down menu or type it in", vbOKOnly, "Select Registration Number")

End Select
End Sub
-------------------------------------------

but the problem is that the msgbox appears before the form is opened.
any ideas how to fix this would be grately appreciated. thank you

View 4 Replies View Related

Child Form Loads Before Parent?

Jan 26, 2006

Hi,

I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database.

Unfortunately I'm finding that one loading the new record, the child form seems to be loading before the parent, ie the child form_Current event occurs before the parent form_Current event. Is this how it should be? It seems intuitive that the parent should load first.

I'm sure I can develop some cunning logic to get around this problem but I'm sure there must be a better way. Has anyone any experience of this parent/child set-up with linked, central database tables?

thanks!

Dave

View 5 Replies View Related

Controlling Scroll Position When A Form Loads

Oct 20, 2004

I have been trying to make forms open scrolled to the top and have had very little success.

I found a function on the following site http://www.lebans.com/SelectRow.htm that works great as demonstrated and when I attach the following code to a text box the form scrolls to the top.

Private Sub Text98_Click()
Dim lngret As Long
lngret = fSetScrollBarPos(Me, 1)
DoEvents
End Sub

What I am trying to do is have the form scroll when it opens but by attaching the above code to the form's on_open event there is no effect.

What am I doing wrong.

Any ideas

View 5 Replies View Related

Combobox To Show Only Last ID In List When Form Loads

Mar 4, 2015

How I can get a combo box to show only the last id in its list when the form loads.

View 1 Replies View Related

Event On Parent Form After The Subform Loads?

Jan 7, 2013

I have parent form and child subform. one field in the parentform is calculated on sum of records on the childsubform when the parent form loads initially the value in the calculatedfield is 0 then it shows the correct value when the childsubform value is populated i have another-field i want to change the property of the onotherfield.backcolor= RGB(0,0,255) when calculatedfield.value<0 but its taking the initial value(0) not the calculated onewhich event shall i invoke on the form so that it waits the subform to complete then fires ... i tried current, load, activate events .. with no success.

View 2 Replies View Related

Un-enable Buttons On Subform When Main Form Loads

Jun 19, 2006

I did a search in the form forum and couldn't find anything close that had a response.

I have a parent form and a sub form.

I have the parent set up to make the enable property false for the command buttons that aren't appropriate when you first open the form: Like Save and Undo.

I want to do the same for the child form, which has different data linked to the parent form.

The parent form always grays out the inappropriate boxes.

The subform will gray them out only if I open it as a stand-alone form. When I put the code in the Open, or Load or Gotfocus events I get an error message that it cannot locate the subform.

Any ideas where to go?

Thanks-

View 2 Replies View Related

Modules & VBA :: Switch From Form To Report As Soon As Database Loads?

Mar 21, 2014

I have VBA code that switches a form to a report that works with buttons but refuses to work when first loading up the database.

Ideally I want the database to open , with a control form set as the default load form, and then this immediately loads a report, which it does, but it doesn't ever switch to it?

I use as standard: DoCmd.OpenReport "rpt_here", acViewPreview, , , acWindowNormal

And now I've tried:

Application.DoCmd.SelectObject acReport, "rpt_Embroidery_Screen"

Which will both run and work fine using buttons but not on initial database/form load.

Using Access 2010.

View 1 Replies View Related

Forms :: Command Button Outline When Form Loads

Dec 5, 2013

I have a couple of command buttons on a form. They have embedded bitmaps as pictures with a caption below. For some reason when the forms loads (and also in design view), there is a narrow white outline / border around them. As if the button is drawn on a slightly larger white square?This border disappears as soon as I hover over the button (in form view) or click on the button (in design view).

View 3 Replies View Related

Forms :: Empty Combobox Values When Access Form Loads Vba

Feb 25, 2014

I want to empty the combobox every time when form loads. Using the below code

Quote:

Private Sub Form_Load()
combo1.RowSource = ""
End Sub

But Combobax is not emptying.

View 6 Replies View Related

Modules & VBA :: Show The First Primary Key Field In The Combobox When The Form Loads?

Aug 30, 2013

I'm using a combobox to select a record based off my primary key field, and then a separate button to print that particular record.

When the form loads, it has the first record selected but the combobox is empty so that if I press my button it will still print the first record.

when I press the combobox my list of entrys in the primary key field shows up and the combobox is no longer blank.

How do I show the first primary key field in the combobox when the form loads?

View 6 Replies View Related

Forms :: Splash Screen While Other Form Loads In Background On Startup

Jan 4, 2014

I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :

I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.

Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.

View 4 Replies View Related

Forms :: Make Column Invisible In Subform When Main Form Loads?

Sep 22, 2013

How do I make a column invisible in my subform when the main form loads?

View 3 Replies View Related

Forms :: One Page Form Printing Blank Second Page

Oct 21, 2013

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 Related

The New IE7 Will Not Open All Images On The Page

Oct 16, 2006

I have a query.
I've just installed the latest release of IE7 and it does not download all
the images on a page.
Does anyone know how to fix it?
thanks

View 2 Replies View Related

Forms Open Down The Page

Mar 16, 2006

When I open my form, it doesn't open at the top of the page. How do I get it to open up at the top, so that I do not have to use the scroll button to go up to top?

View 3 Replies View Related

Open Word Specific Page

Apr 5, 2008

Anyone able to help. Can a command button be coded to open either a Word or PDF file at a specific page number? Any help really appreciated.

View 1 Replies View Related

Command Button To Open Web Page.

Oct 26, 2004

Hello,

I would like to make a comand button in my form that will open a specific web page.
Can some one Help Me Please?

View 12 Replies View Related

Open A Specific PDF Page On Access

Oct 20, 2015

I want to create for each record I'm introducing in my database a link to open a specific page of a pdf file I stored in a folder.

View 7 Replies View Related

Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form

Jun 24, 2015

I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)

View 5 Replies View Related

How To Continue A Form Page After Page Automatically

Jul 9, 2005

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

View 1 Replies View Related