Open Multiple Forms?

Jan 5, 2007

Hello- I’ve searched the forums and was not able to find the answer, so I was hoping someone would be able to help with this.

I would like to open multiple forms (cascade) in the same .mdb file when the first form is opened. There are a total of 4 forms. This is probably a very simple thing to do. I'm not much of an Access person to simple things like these throw me for a loop. Cheers to anyone who can help. -Tom

View Replies


ADVERTISEMENT

Forms :: Open Multiple Forms When Database Opens?

Apr 26, 2013

Is it possible to open multiple forms when the database opens? Currently only one form opens. I am using Access 2010.

View 5 Replies View Related

Forms :: Search Multiple Fields In Table And Open Matching Records For Editing

Dec 10, 2014

Create form to search multiple fields in table

Return records that match search

Open the record that you want in Form View for editing

View 1 Replies View Related

Forms :: When Open A Form / Want To Open Another From At Same

Jan 14, 2015

when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.

View 2 Replies View Related

Open Reports With Multiple Where Clause

Apr 19, 2007

Hi again! :)

I can't figure this out myself.....so if anyone likes to help, I would be really glad!

Ok, here is the problem:

I got a form with 7 listboxes and a Command Button.

Box1 chooses the report
box2 the clientname
box3 to 7 choose different variables depending on the choosen report.

So i want to do something like
DoCmd.OpenReport "rpDetails", acPreview, , "[clientname] " & strclientnames & "" And Box3-7

I already have done this for every box:

If IsNull(Me.cboGAclientnames.Value) Then
strclientnames = "Like '*'"
Else
strclientnames = "='" & Me.cboGAclientnames.Value & "'"
End If

I tried to build the OpenReport String with one more box, but i get a mismatch error and don't know why :(

View 7 Replies View Related

Open Form Using Multiple Tables

Aug 16, 2005

I have 2 tables, Test Cases, Test Case Details. I have a tabbed form to display the data. How do I open the form and retreive the data from both tables? Tables are related by ID.

View 2 Replies View Related

Open Multiple Instances Of Form

Aug 4, 2005

Is there a way to allow Access to open a second (or thrid...) copy of a form? We need this so we can visually compare the contents for record one with the contents of record two.

Thanks,
David

View 11 Replies View Related

Modules & VBA :: Open Multiple Attachments

Jul 15, 2013

I have a Database with a field that holds several attachments. I want to make a command button for a form that will open the attachment window that pops up when you double click on the attachment in the table. attach_fig7(1).gif.. I'd like the above window to open when I click the command button.

View 3 Replies View Related

Multiple Switchboards To Open In Different Tabs

Apr 22, 2014

I have a main switchboard but because the limit on it is 8 objects I decided to have different switchboards (Main data-entry switchboard, Query switchboard, and Report/Printing switchboard). I can easily add an object on the MAIN switchboard to open the Query switchboard and then on that Query switchboard have a button to go back to the MAIN switchboard but what I would like to do is have each switchboard open in different tabs instead, maybe a macro or "onclick" event needed? Would it be easy to build and customize my own switchboard?

View 11 Replies View Related

Forms :: Click Button To Open Dropdown To Open Record The Filters By Dropdown

Jul 28, 2014

I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.

View 1 Replies View Related

Multiple Users Can't Open Same Access Database

Jul 24, 2006

Greetings. When I create an Access database on my company's "secure" server (through a PIX box), I get this message in a dialog box when I try to open the database again: "Open File - Security Warning. Do you want to open this file?" It then gives the file Name, Publisher (unknown publisher), Type (Microsoft Office Access Application), and From (the file path and name). The bottom of the dialog box has this message: "While files from the Internet can be useful, this file type can potentially harm your computer. If you do not trust the source, do not open this software." When I click on the "Open" command button, the file opens just fine.

There are a couple of things going on here:

1) When I open this same database or any other Access database on another of my company's servers that is not protected by a PIX box, I do not get this dialog box.

2) When two users try to access an MS Access database on the "secure" server, the first user will get in, but the second user will not. The second user will not get ANY warning messages -- nothing happens. This occurs if the second user tries to open the database by either double-clicking on a shortcut on the desktop or by double-clicking on the file name in Windows Explorer. Note that the second user CAN access the same file if s/he starts up MS Access from scratch, and then chooses FILE>OPEN from the main menu.

My goal is to be able to let multiple users access the MS Access databases on the secure server by either double-clicking on the shortcut icon or by double-clicking on the file name in Windows Explorer.

I thought perhaps that the "unknown publisher" issue might be part of the problem on the secure server. So I created a certificate using the utility "SELFCERT", went into the database, went into Visual Basic (Ctrl-G), went into TOOLS>DIGITAL SIGNATURE and assigned the digital signature, and re-saved the file. I then exited the file, went back in, and the dialog box still pops up saying the file's publisher is "unknown publisher"! If I go back into Visual Basic, the database is clearly marked as digitially signed by me. I don't know why the initial dialog box is still showing that the file is not digitally signed.

If anyone has any thoughts about these issues (multiple users not being able to access the same Access database, and why my file is saying it is still not digitally signed), I would appreciate your input. FYI, I am on a Windows XP workstation and our company users Windows Servers.

Thanks,
David

View 4 Replies View Related

Modules & VBA :: Multiple Criteria To Open A FORM

Apr 17, 2014

How to open FORM which has "inner join" in source?

Code:
...
Dim idRS As DAO.Recordset, ShowIdentity
strSQL = "INSERT INTO tblZlecenia (id_zlecenia_info, DataPrzyjecia) VALUES ('" & _
ostateczne & "', " & _
Format(Date, "#mm/dd/yyyy#") & ")"

[code]....

View 5 Replies View Related

Modules & VBA :: Open A Form With Multiple Where Clauses

Sep 17, 2013

I am having trouble opening a datasheet form with mulitple where clauses here the VB that I have so far

Private Sub Command192_Click()
If IsNull(Me.Startdate) = True Or IsNull(Me.Enddate) = True Or Startdate = "" Or Enddate = "" Then
MsgBox "Start AND End dates are required" '
Exit Sub '

[code]....

View 11 Replies View Related

Unable To Open Multiple Instances Of Access 2003

Dec 20, 2005

Not sure if this is the correct forum but its worth a shot.

When I try to open any database, MS Access will hang if there is already another instance msaccess.exe running. I even tried opening two newly created blank dbs with the same result. Has anyone ever come accross this behavior?

I have tried repairinging/reinstalling/checking and unchecking "Windows in Taskbar option"

Thanks for any help!

View 1 Replies View Related

General :: Split Database - Multiple Open Backends

Sep 20, 2013

I have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks.

View 2 Replies View Related

Command Button To Open 2 .CSV's In Multiple Tabs In Excel Workbook

Oct 10, 2006

I want to use command buttons to open two separate .csv files in the same excel workbook on different tabs. Is this possible?

View 4 Replies View Related

Reports :: Summary Of Multiple Records - Open Report With Button

Jan 27, 2014

I have a report that is a summary of multiple records in it. What I have next to the record on the report is a button.I have report that are labeled:

rptIncident Summary
rptIncident Report
and a button labeled
"open report"

I would like to click on the button and then it open the rptIncident Report with all the information, not just the summary. I will put a picture so you know what I am trying to accomplish.Is this a simple Onclick event with a where condition or what? Or does this go beyond to having something to do with VBA?

View 14 Replies View Related

Scanning Barcode Into Search Box Works But Causes Multiple - Cannot Open Any More Databases - Errors

Aug 5, 2014

I'm scanning bar codes into the record search box, most of the time it works as it should but occasionally I get multiple "cannot open any more databases" errors. It still finds the product record but the error messages are super annoying. I am sure to clear the memory on the scanner each time before I scan in a new barcode but it doesn't seem to matter. Also sure to only have one or 2 forms open at a time, that doesn't seem to matter either. Most of the time I don't get the errors but when I have to click through like 10+ error messages (all identical). I only have one database open so I'm not sure what it even means. Also I have tried this in 2 different forms and it's the same for both forms. Seems like I get the errors in my initial scan and then after clearing them it seems to work without errors.

View 4 Replies View Related

Cascading Combo Boxes - Open A Form And Add Multiple Items To A Table

Mar 12, 2011

I have been trying to modify a sample database to suit what I want to do but I am getting stuck on the very first part cascading combo boxes i want to open a form and add multiple items to a table - first i want to select, from a combo box a department - then select a supplier from all the suppliers/manufacturers related to that department then select a stock item based on the description from all the items available from that supplier

I have attached the database I am using to modify and my database.

View 5 Replies View Related

Forms :: Inventory - Allow Users To Update Multiple Fields For Multiple Assets

Sep 25, 2014

I want to create a form that allows users to update multiple fields for multiple assets. Below is what I came up with:

Ideally, I'd like the subform to be filled in by having the user select multiple Assets from the S/N combobox field which would then auto-populate the "Type" field. Then they would fill out the appropriate fields they want edited in the top part of the form. They hit save and magic happens. This would also be nice because only assets they want edited would be displayed (easier on the eyes) and no distinguishing would be necessary. To do it this way, I know I would need to use a temp table but I wanna avoid using temp tables.

I know I can do this by adding a Yes/No field in the "Asset" table, setting the "Asset" table as the subform's recordsource, and then putting a checkbox in the subform and allowing them to check the assets that they want to edit (which would also allow me to sort it instantly so that checked Assets are at the top of the datasheet for easy viewing), but I would like to know if there's a way of accomplishing this without the use of checkboxes.

I know I could also use a listbox and that allows them to multi-select items, but I'm not sure if that allows me to group all selected items at the top of the listbox for easy viewing of selected items. Plus it would involve a lot of scrolling (there are over 2k assets).

View 2 Replies View Related

Forms :: Number Of Buttons Which Open Other Forms And Filter Results Using Embedded Macro

Apr 6, 2015

I have a bit of a problem with a database in Access 2013. On 1 of the forms, I have a number of buttons which open other forms and filter the results using an embedded macro. All has been well until a few days ago when error 2950 pop up box started appearing. After fiddling around for a while it all works OK (without actually changing anything) until next time the database is opened. I checked to make sure the location is "trusted" and all seems OK.

View 4 Replies View Related

Forms :: Button Click Event To Choose Between Forms To Open Based On TextBox Input

Jun 7, 2013

Making a small database, Got 1 Table.

1. ContactDetailTable

Got 3 forms.

1. ContactIDForm
2. ContactInfoForm
3. NewContactFrom

In ContactIDForm it contain 1 textbox name 'TextBox' with Button Name 'Btn'

In ContactIDForm there is only 1 Text Box ContactIDTextBox and 1 Button. User Enters ID in TextBox and On Button Click Event it should check data from TextBox in Table name (ContactDetailTable) in field ContactID and if there is record matching, ContactInfoForm should Open else NewContactForm should open with ContactIDTextBox value in it.

View 10 Replies View Related

Forms :: Open A Form With Previous Forms ID

Sep 17, 2014

I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens...

Private Sub Command12_Click()
DoCmd.Close
DoCmd.OpenForm "Frm2"
End Sub

But I want it to open Frm2 using the ID from the previous form. The stumbling block for me is I close the first form before opening the next so I cant pass the ID across.

View 2 Replies View Related

Forms :: Use List Box To Open Forms?

Apr 3, 2015

I'd like to populate a list box with my forms and be able to double click a row and have that form open.

I'll need a table so I can use aliases for the formn names.

View 5 Replies View Related

Forms :: Open Different Forms From List Box?

Apr 21, 2014

I have issue opening different forms from the contents of list box. is it possible to open different forms by double clicking list box entry..

View 2 Replies View Related

Open Only Forms// I Need Help

Apr 1, 2005

hi



i am new in Access and i make one project with it.
Now i need when i open the indexForm i want open only it and not the access with
table,queries,reports and access menu.

View 1 Replies View Related







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