Modules & VBA :: Form Window To Popup On Opening Database
Dec 4, 2013How I configure my Form Window to pop up as soon as I open my Access Database?
View RepliesHow I configure my Form Window to pop up as soon as I open my Access Database?
View RepliesI'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?
I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.
I tried that database on 3 different PC's with the same effect.
Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.
Thanks for any help and advice
Josef
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 RelatedI must be missing something simple here.
The opening switchboard of my db is set to popup but on opening the db it is showing full screen. On reopening once closed it pops up. How can I make it popup to start with?
Settings are:
Default View - Single Form
Auto Centre - Yes
Auto Resize - No
Border Style - Dialog
Hello,
I am trying to run a macro on doubleclick in a subform (dataview) that will open the same record in a popup form (tabular).
I've enter in the macro Where Condition the following statement to only show the record I doubleclicked on in the popup. The only problem is it's asking me for a parameter value for the LogID. Its apparently not picking up the LogID I doubleclicked on. Is there any way I can fine-tune this WHere statement so that it knows the record LogID I clicked on. (The pop up form should show only the same record).
[LogID]=[Forms]![CommunicationLog Subform]![LogID]
I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different sizes. I would like to know if there is a a way that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes. I was thinking that it could be something in the on click event.
View 7 Replies View RelatedHi,
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.
I have three forms:
Form_A (main form for the application - should always be open)
Form_B (always open, but sometimes has visibility set to false)
Form_C (opens from button on Form_B)
When I press the button on Form_B, the only code behind it is DoCmd.OpenForm "Form_C". This seems to hide Form_B, and open Form_C behind Form_A (which is the main form of the application) inside of an Access window.
I would like Form_C to open in front of Form_B. I suspect that I set up the form incorrectly or something when I created it, and it is therefore opening inside an Access window.
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.
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
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] ....
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?
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 RelatedHello team,
My database window is hidden.
I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article.
On the form with the graph, I have put another button to print it. The code behind that button is:
Private Sub printpriceevolution_Click()
On Error GoTo Err_printpriceevolution_Click
Dim stDocName As String
Dim MyForm As Form
stDocName = "frm_priceevolution"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False
Exit_printpriceevolution_Click:
Exit Sub
Err_printpriceevolution_Click:
MsgBox Err.Description
Resume Exit_printpriceevolution_Click
End Sub
The funny thing is that after the printing (which works fine) my database window is shown, where it is supposed to be hidden.
Any idea what could trigger this? Does it have to do with pop-up dialog box settings?
Thanks
Greetings,
I am a bit drained today and can't think clearly.
How do I stop a new window opening everytime I open a new form. When I get going on the latest project, inputting data I can have up to 6 different windows open.
~rbinder
I have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be able to press a button and have the second tables form pop up and add that that specific Project_Number. I added the button and went through the wizard process. I then added the linking info through the builder. It works fine if there is already data entered for the project_number in that specific field. but if the field is empty, the popup window doesn't recognize a project_number and doesn't add it to that record. below is what I am using. The project_number in the 'main' table is text and the Project_Number in the 2nd table in a number since it is a lookup field.
Private Sub CongressionalDistrictCmd_Click()
On Error GoTo Err_CongressionalDistrictCmd_Click
Dim stDocName As String
[Code]....
Hi guys,
I've had this problem before.
The debug window will open and stop at a line of code even though it has no breakpoint.
Any suggestions please.
Thanks.
I am using Access 2010 and creating a front-end for a customer database.
Take a look at the screen capture I added to this post.
What I want to happen is on that "Supplier" button. When I click on it, it opens a new window with the "Supplier" form and on the specific supplier for this product. There is an attached image of what that macro looks like.
The problem I am having is that I do not want the Supplier form to open in a new window, I want it to open within the Navigation Form, replacing the what is currently on the screen.
I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies View RelatedI'm using access 2010.
How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.
I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.
I need Access to open an Excel file prior to pulling information from it, because the Excel file itself only updates when it is opened. I was able to achieve this with the code below:
Quote:
'Opens a hidden Excel window.
Dim app As New Excel.Application
app.Visible = False
Dim book As Excel.Workbook
Set book = app.Workbooks.Open("S:OperationsAssistantDataba sesBUSES.xlsx")
[code]....
This works fine if NO Excel window is already open, but if the user happens to have some file open in Excel already, my code doesn't seem to work right. The file does not open in a hidden window. Instead, it opens in the window already open, and additionally, the file is not closed afterward, which leaves the user wondering where the hell this random file came from, and they have to close it. I need this Excel file to open, but I want it to be completely hidden from the user.
Hi,
I successfully made this work, but when opening a report to preview it (using a button click) . it doesn't show up, is there a workaround with this? Thanks in advance.
Kind Reagrds.
Nelson
i have a button opening forms however when they open they appear in window mode and not full screen. is there an option or a line of code of code i am over looking to make it open in full screen mode?
ps. i am using access 2010
Hi there,
My problem seems somewhat simple, but I guess since I'm posting this it was quite the contrary. I've completed my form and have linked all queries and reports and created all my macros for the form. Everything looks great but I when I created a .MAF shortcut to access the form directly from my desktop, it opens the form really big and maximized. Every time I open it, I hit the 'restore down' box-in-box button on the top right and it makes it just how I want it. Can I retain this as a default setting when I open it? I've checked in the Form options but no luck.
Richard
Using Access 2007, can I return a value for CurrentProject.FileFormat WITHOUT opening the database?
I'm looking for a way to determine the file version of a given Access database without actually "opening" the database in Access (I don't want it to ever be visible at all or in any way).
So to open a database in Access 2007 "without opening it," I'm using:
Code:
Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase("C:Path-ToFile.accdb")
From here, there are at least two different "version" indicators that can be used, as in this example:
Code:
Debug.Print db.Properties("Version").Value
Debug.Print db.Properties("AccessVersion").Value
Now, if you run this code on an Access 2002/2003 .MDB file, you will get:
Code:
4.0
09.50
If you run this code on an Access 2007 .ACCDB file, you get:
Code:
12.0
09.50
Note two important factors:The db.Properties("Version") seems to be returning the JET version from what I can see in research. This is NOT what I'm after.
The db.Properties("AccessVersion") returns THE SAME VALUE for an '07 ACCDB as it does for an '02-'03 MDB, since Microsoft never updated it, apparently.
Now.... the one way that I have found that ACCURATELY describes the version of a given access database file is to use:
Code:
Debug.Print CurrentProject.FileFormat
...as this will always return, for example, 2.0 for an Access 2.0 .MDB file; 10 for an Access 2002/03 .MDB file; and 12 for and Access 2007 .ACCDB file (and there are others; these are AcFileFormat bitmask constants as described in Access support).
BUT, this CurrentProject object doesn't seem to be available (so far as I can see) when using the "open without opening" method described above.
SO, is there any way to return the FileFormat value without opening the database visibly? (Merely basing it in the extension isn't right either.... that would be easy but not accurate as several formats use MDB.