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 Replies


ADVERTISEMENT

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

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

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 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 :: 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 Forms...

May 25, 2006

I have a Access DB that has securtiy thanks to baxter, however everytime i open a form the windows bar on the bottom starts to get cramped. is there a way to elimante that? For example at least hide them ? I have a form that has 3 forms and next thing i noticed i have no more room...
Thank for any advice..

View 3 Replies View Related

Users Cannot Open Certain Forms

May 21, 2007

I've created a database which works fine and i've tested it extensively on my machine. It is saved on a network drive which other users have access to. I've added a simple security log-in procedure (which I picked up from a sample posted on here) which only determines what buttons the different users can see on the switchboard which takes them to the different areas of the database. The problem I now have is some of the forms aren't opening.

Other Users who try and go into the forms that they have access to - even some of the generic ones cant open the actual forms as it crashes and comes up with the generic error message - "Microsoft Access has encountered a problem and needs to close".

I cant understand why this is happening. The security measures are only linked to the main switchboard and it works fine as it opens up all the other relevant switchboards as required. It's just certain forms on the other switchboards that refuse to open. I hope I have described my problem adequately and someone has encountered it somewhere or knows what I'm talking about and can help. Please let me know if you need further clarification.

View 2 Replies View Related

Using Cmd Buttons To Open Sub-forms

Oct 10, 2005

I am working on a database to hold the data regarding our company vehicles. I have a table for the details of the vehicle (i.e Registration, VehicleType, Drivername etc) and a number of tables for different types of equipment (AccessEquipment, LiftingEquipment, StandardEquipment and others).

I have a form that runs on a query with the criteria to search for the registration number. I have also set up forms to show each type of equipment to use as sub-forms. I would like to have on this main form a number of command buttons that would open the specific sub-form on the main form.

How can I do this? Any ideas would be greatly appreciated?

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

Use Check Box To Open Forms

May 25, 2006

I have a main form with 2 check boxes. The title of the first box is Manufacturing and the title of the second check box is Purchased. I have 2 different forms based on the titles of the check boxes. After the user checks one of the boxes, I want the user to click a command button which opens the correct form based on the box checked.

Using the On Click for the command button, I created this code, with no success:

Dim stDocName As String

If Me.Check14 = 1 Then
stDocName = "frmManufacture"
DoCmd.OpenForm stDocName
Else
If Me.Check16 = 2 Then
stDocName = "frmPurchase"
DoCmd.OpenForm stDocName
Else
stDocName = "frmError"
DoCmd.OpenForm stDocName
End If

End Sub

Thanks for helping with this problem.

Jeff

View 2 Replies View Related

Closing Forms As Others Open

Aug 31, 2006

To try to keep a sane user interface I would like to close forms as another form opens.

If I put a Command button on FormA that opens FormB and it is set to find a record on FormB ... how can I close FormA when FormB opens.

I tried putting DoCmd.Close either before and after the code that opens FormB and ...

If I put it before the code - it just closes FormA without opening FormB ... if I put it after the code, if opens FormB and closes it.

Is there a way of saying on a form 'close the form that just opened me'? (like in javascript where you can reference the form with window.opener)

Thanks for any help.

View 4 Replies View Related

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 4 Replies View Related

Forms :: Cannot Open Any More Databases

Nov 7, 2013

I am using an Access 2007 front end linked to an Access 2007 back end. I have a Report that the user operates by selecting the information he/she wants to see on a pop-up form and clicking a button. The Report works perfectly unless another form, called Shows Form, in the database is opened. When Shows Form is open the Report/button on the pop up form generates Error 3048: Cannot Open Any More Databases. Also when Shows Form in open, the Query that the Report calls on also won't run. The Query gives gives the same error - Cannot Open Any More Databases.

I have been through my code with a fine tooth comb to make sure all DAO.Recordsets and DAO.Databases are closed after they are used. The troublemaker Shows Form is quite complex and has many sub-forms (11), on a tab control (9 tabs). The Shows Form is the work horse of the database and the User needs to have this form open all of the time. It is inconvenient to have to close the Shows Form in order to use the Report. I am suspecting, through my internet reading, that the multiple sub-forms in the Show Form are using up resources and causing Error 3048.

I thought maybe I could look at coding the sub-forms to open only when needed - when the user clicks on the tab containing the sub-form. Would that conserve resources?

View 4 Replies View Related

???open Forms To A Blank Record???

Jun 6, 2005

I'm trying to make a form so that it opens up to a blank/new record. Any tips? Can't seem to figure it out.

Thanks, Jonathan

View 14 Replies View Related

Forms Don't Open In Datashett View

Mar 15, 2006

Hey all, Having small issue with forms opening in form view eventhough I have them set to datasheet default.
If I open them from the database window they will open in datasheet view but when I use a command button that I created on a main menu to open the form the always open in Form View.
Any help would be appreciated

View 1 Replies View Related

Forms Open In The Middle Of The Form

Dec 21, 2006

I have several forms that open in the middle of the form instead of at the top in the first field. Any ideas to correct this problem?

View 2 Replies View Related

Can Open Several Forms With One Common Button??

Jan 23, 2008

Hi all,
I am new to microsoft access. I've got one question that can't solve.
I am making database with several items. Under each item, there got different field lists to fill in. So I made several forms for each of them.
In main form, I put one combo box to choose the item and one common button. So how can I write the code to open the several different forms,one at a time, by clicking one button according to the value that is chosen from combo box??
thank in advance.

View 7 Replies View Related

Forms :: Option To Open One Or Other Form?

Dec 24, 2014

how to give the option to open either forma or formb with a command button.

View 1 Replies View Related

Forms :: Open Form From Combo Box

Jun 3, 2014

Im using the below code to open a from depending on what option is selected on a combobox.

Code:

Private Sub DirectPCombo_Click()
Dim cboVal As String
Dim stDocName As String
cboVal = Me.DirectPCombo.Value
Select Case cboVal
Case "One"

[code]....

If you select the first item [One] it will open the correct form [TestOne]. But when you select any of the others an error comes up saying that the name is no a form. So I added

Code:
DoCmd.OpenReport stDocName

But the no items would select.I know If split the reports form the forms and make two comboboxes it would work, but it would be better it both could be in the same combobox.

View 2 Replies View Related

Forms :: Open Particular Record In Form?

Sep 13, 2013

I have a continuous form that is based on a query. I would like to have an open button so that you can select a record on the form and that particular record opens up in a new form. How do I do this?

If this cant be achieved would I be able to make a form open that shows a particular record based on the query and you just press next record to view the other records that are a result of the query?

View 6 Replies View Related

Forms :: Clear Tick Box Value When Open?

Aug 18, 2014

Im doing an attendance in Access database , i have a Staff table and AttendanceMain table for keep all the staff attendance ...

I also created a query to append the data into AttendanceMain table ... the problem is , I always reuse the staff name , so i created a Staff form , but everytime i open the staff form the previous record still there , anyway to clear the "Tick Box" in staff table and without affecting the name ?(Name also is a record in row by row)

View 1 Replies View Related

Forms :: Open Form From DblClick

Feb 8, 2015

I have a main form. It's only contents is an unbound combobox, and it's used to filter down (via a query) the details in it's sub form (I'm using it to load different account information, rather then type it in all the time).Anyway, I also have another form (Dashboard, or mainmenu) which summarises activity within Each account and is displayed via a datasheet.

What I'm trying to do is double click the accountname (on the main menu)which will then open up the necessary form and load the value from the datsheet accountname, in to the newly opened forms cbo, where I can apply the form to requery on load.I'm going to have to DIM the value, and docmd.openform etc...

View 13 Replies View Related







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