How Do I Set Up A Popup Window To Inform Me Of A Due Date

Jul 5, 2005

I am setting up a database for a group of roll on roll off students. It would be really usefull if i recieved somesort of pop up message informing me 2 weeks before any particular student is due for release from the course. I have all their details plus their release date in a table. :confused:

Thanks in advance

View Replies


ADVERTISEMENT

Javascript Popup Window

Oct 25, 2005

I have created an asp popup window that is called by a javascript function from another asp page. The popup window is generated from a database. The code on the mainpage to generate the popup window is:

Code:<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"><!--function showCalendar(i) {// declare variablevar tbm;// assign field name to variable // based on argumentif(i==1) tbm='FrontPage_Form1.PerDate1';if(i==2) tbm='FrontPage_Form1.PerDate2';if(i==3) tbm='FrontPage_Form1.PerDate3';if(i==4) tbm='FrontPage_Form1.PerDate4';if(i==5) tbm='FrontPage_Form1.PerDate5';if(i==6) tbm='FrontPage_Form1.PerDate6';if(i==7) tbm='FrontPage_Form1.PerDate7';if(i==8) tbm='FrontPage_Form1.PerDate8';if(i==9) tbm='FrontPage_Form1.PerDate9';if(i==10) tbm='FrontPage_Form1.PerDate10';// call pop up calendar// passing field name variablewindow.open('../../calendar/calpop.asp?tbm='+tbm,'ncal');}function showDirectory(i) {// declare variablevar dept;// assign field name to variable // based on argumentif(i==1) dept='FrontPage_Form1.TaskOwner1';if(i==2) dept='FrontPage_Form1.TaskOwner2';if(i==3) dept='FrontPage_Form1.TaskOwner3';if(i==4) dept='FrontPage_Form1.TaskOwner4';if(i==5) dept='FrontPage_Form1.TaskOwner5';if(i==6) dept='FrontPage_Form1.TaskOwner6';if(i==7) dept='FrontPage_Form1.TaskOwner7';if(i==8) dept='FrontPage_Form1.TaskOwner8';if(i==9) dept='FrontPage_Form1.TaskOwner9';if(i==10) dept='FrontPage_Form1.TaskOwner10';// call pop up directory// passing field name variablewindow.open('../../ProfDirectory/DeptPeople.asp?dept='+dept);}//--></SCRIPT>...... <tr> <td width="118" height="22" align="center" nowrap> <p align="center"> <input type="text" name="PerDate1" readonly="true" size="8"> <A HREF="javascript:showCalendar(1);"><IMG SRC="../../calendar/10Min200011cal.gif" WIDTH="39" HEIGHT="21" ALT="Click here to select date" BORDER="0" align="center"></A> </p> </td> <td width="160" height="22" align="center"> <p align="center"><input type="text" name="TaskOwner1" size="8"> <A HREF="javascript:showDirectory(1);"><IMG SRC="../../calendar/10Min200011cal.gif" WIDTH="39" HEIGHT="21" ALT="Click here to select date" BORDER="0" align="center"></A></p> </td>

The first popup calls up a calendar. The calendar works fine. The second popup calls up a staff directory. This popup does not work.

Code:The code for the staff popup is:<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"><!--function SetTaskOwner(d) {opener.document.<%=Request("dept")%>.value = d ;self.close ();}//--></SCRIPT>......<%Session.timeout = 1Set conn = Server.CreateObject("ADODB.Connection")txtDSN = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=d:InetPubwwwrootpagescommoncivil.mdb"conn.Mode=adModeReadconn.open txtDSN,"",""Set Session("people_conn") = conn%><%sql = "SELECT WebData.* FROM WebData WHERE (((WebData.class)='faculty')) AND (((WebData.Status)='active')) ORDER BY WebData.LastName"pagetitle1="Faculty sorted by last name"Set rs = Server.CreateObject("ADODB.Recordset")rs.Open sql, conn%>....do while Not rs.eof.... owner = rs.Fields("UWID").Value webpage="javascript:SetTaskOwner(" & owner & ");" %> <tr> <td><a HREF="<%=webpage%>"><%=name%></a></td>.....rs.MoveNextloopconn.close'session.abandon%></table>

The popup appears and the database generate the results as expected. When I click on the hyperlink the javascript gives me an error. I can see in the status bar though that the hyperlink's value is: javascript:setTaskOwner(me), for example. So I think the error is due to the opener.document.<%=Request("dept")%>.value = d or self.close (); lines of javascript.

View 1 Replies View Related

Modules & VBA :: Form Window To Popup On Opening Database

Dec 4, 2013

How I configure my Form Window to pop up as soon as I open my Access Database?

View 3 Replies View Related

Forms :: Popup Window To Save File At Any Location

Feb 23, 2014

I find the following CODE online (Print to PDF). Which work perfectly for me, the only issue and/or modification I am looking for "Popup Window to save the file at any location", instead at fixed location.

Option Compare Database
Option Explicit
Function PrintToPDF(SrcFile As String)
On Error GoTo PrintToPDF_Err
'Function can be called from any report with this: "PrintToPDF(Screen.ActiveForm.Name)"

[Code] ....

View 1 Replies View Related

Modules & VBA :: Login To Database - Close A Modal Popup Window

May 2, 2014

I've tried to add some basic login (not really security) to my database so that when a different name is entered into the login box a different form is opened.

I got this working but the login form stays in foreground and I can't click anything behind it and can't get to the design view to change any properties of anything.

I've also changed this login form to the startup item so it always loads when i start the database.

Is there way to get back to the design view or do i have to start again from my backup?

View 2 Replies View Related

CTRL W Shortcut (to Close Form Window) Not Working With Popup

Nov 28, 2011

As the title says, ctrl-W works on all my other forms but not on the one which has Pop-up set to "Yes".

View 1 Replies View Related

Reports :: Display Report In Popup Window And Maximize In Print Preview Layout

Dec 22, 2013

I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.

Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?

View 4 Replies View Related

Make Popup Form (Dialog)'s Height As Same As Window/Montior/Screen Height

May 7, 2008

Hi,

When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.

Please let me know if you have one.
Thanks.

View 1 Replies View Related

Don't Know If This Is Possible Please Inform If Not.

Dec 4, 2005

I have a form that users fill in data form both combo boxes as well as Text boxes. I have a field called Problem Description, this field is is a text field. What I would like to try to do is be able to perform a search of this field looking for similiar problems (they will not be exact because different users different problems desc. but they should be similiar enough to search. Is this possible??

Jon

View 1 Replies View Related

Start Date And End Date In One Prompt Window

Jun 3, 2014

Right now I have this in the query criteria row:

>=[Enter Start Date:] And <=[Enter End Date:]

This makes two prompts pop up one at a time. I was wondering if there was a way to combine both start and end date boxes in one prompt so I can see what dates I decide to type side by side. Is this possible?

View 10 Replies View Related

Popup Calendar, How To Choose The Day Aswell As The Date

Nov 30, 2006

hi.. i have attached a simple db.. 1 table.. 2 fields..

jobdate and jobday

open the form and double click on the jobdate.. it opens a calendar.. when you choose a date it puts it into the jobdate field..

i have created a simple drop down underneath the jobdate with the days of the week..

is there a way to tweak the calendar module so it also chooses the job day.. because the days are clearly displayed along with the number dates.. so it must be possible..

here is the db in 2000 and 97 format..

thanks in advance.. i think this will benefit many users using this calendar

View 6 Replies View Related

Forms :: Expiry Date Warning In A Popup

Dec 9, 2013

Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour?

View 7 Replies View Related

Forms :: Setting Popup Reminder On Form Load For Expiry Date

Jul 26, 2015

I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).

I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).

View 2 Replies View Related

Automatically Sort Through Report By Date - How To Choose Multiple Dates Through Popup

Jul 26, 2013

I created a pop-up that appears when i open my report so that I can automatically sort through the report by date. However, the report will only allow me to choose one date and i need to be able to choose multiple dates. This pop-up is connected to a list box which has the multi select turned on. How can choose multiple dates through my pop-up?

View 1 Replies View Related

Help: Pass Argument From Child Window To Parent Window?

Feb 15, 2005

Hi,

I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.

How does one pass argument back from child window to parent window?

From parent window to child window, I used
docmd.openform ,,,,,,[argument] and me.openargs in the child window

thanks in advance.

View 4 Replies View Related

Forms Are Opening In Same Window / How To Open Forms In Different Window

Oct 21, 2013

My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.

View 3 Replies View Related

Subform Popup

Jul 16, 2007

I have a subform I am using on a form. I would like to modify the code below that I have for a button on the form. I would like to use the master and child field link in the code below to only show candidates related to the main form. The link is candidate id. I have this working with a subform on the form but I would like to have this only display as a pop-up once the user clicks the button on the form. Is this possible? Thanks..

Private Sub Candidates_Click()
On Error GoTo Err_Candidates_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "CandidatesCPR_Frm"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Candidates_Click:
Exit Sub

Err_Candidates_Click:
MsgBox Err.Description
Resume Exit_Candidates_Click

End Sub

View 1 Replies View Related

How Do I Set To Popup And Modal?

Apr 25, 2005

How do I set a form to popup and modal? What field in properties do I use the expression.popup?

View 2 Replies View Related

If Then Popup Question

Dec 21, 2005

I have a form that we use to enter our workorders (jobs) into the database. The bottom of the form runs a query and returns record information if a car has been in our facility before.

I would like to program it so that if the query does in fact find a previous record it pops up a window or message that says so.

Basically I need something like...

If the arrival date (and/or) item number is not null then popup a message that tells you the car has been here before.

Thanks!

View 7 Replies View Related

Popup Form?

May 17, 2006

I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice.

So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.

But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.

Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?

Thanks!

View 11 Replies View Related

Popup Subforms

Sep 14, 2006

Alright, I did a search for this and came up blank, but I'm sure its been asked a million times, sorry for the inconvenience:D

Is it possible to make a subform a popup form? I have a client table --1--to-many--> service table and want the service form to popup out of the client form. But I also want to the foreign key to autopopulate just like a subform would. Is there any way to do this? Are there any pitfalls to doing it this way?

Thanks in advance,
Ox

View 3 Replies View Related

Popup Reports

Sep 14, 2006

Hello,

I have an application where all the forms are popup (i.e. the PopUp property is set to True). It was done because the customer wanted to see only one entry of the application on the taskbar. Now I have a real problem! When the customer opens reports in preview mode, he gets it opened BEHIND the application forms =( So he can't see it. And there is no "PopUp" property for report... What should I do? How can I put the report ON TOP?

View 2 Replies View Related

Comfirm Yes No Popup

Dec 21, 2006

How do i go about making a confirm yes and no dialog.

I know i can do it with a form, but would rather have a proper one :D

View 2 Replies View Related

Popup Keypad

Dec 22, 2006

I would like to make a form that would pop up in a standard keypad format. This would allow me to enter the number and on close, it would place it in a chosen field. I saw the one that was is a previous thread and it does make sense to me.

Thanks for the help

View 1 Replies View Related

Create A Popup

Aug 30, 2004

I am using an Access generated number for a "ref. number" I would like to know how when im in a form shown the box that would house that number, and someone clicks on the "ref, number" box a popup "search" would appear.

View 1 Replies View Related

Popup Problem

Sep 22, 2004

i have a Simple form called people. it has three feilds on it called
name
address
city

i have a button next to address that onclick popups up the form called address.

once the user finds the data i have a ok button. Now what i want done is when they click ok
it populates the address field on the people form. no one seems to be able to help me?
NAy examples would be great
thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved