Forms :: Click On ID In Subform Datasheet To Open Single Form View

Apr 3, 2014

I have a Project form, which holds StockArtProduction_Subform in datasheet view. I need for them to be able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID.

Ideally, it would also work for new entries in the StockArtProduction_Subform, but the StockArtProduction form would have to "auto populate" (did I use it right?) with the ID of the currently open Project form.

View Replies


ADVERTISEMENT

Using Subform In Datasheet View To Open Other Form

Oct 21, 2006

Well, I couldn't find this using the search, so here it goes:I have a form in which I enter data to create a new client. Within that form I have a subform in datasheetview which is based on a query which holds/retrieves certain (important) fields from a table that holds case info. So in that one view the client data is displayed on the form and all cases and the most important data from those cases is displayed nicely in one screen.Now, when a client calls I navigate to that client and see all previous and all current cases that are open and/or closed for this customer. So the customer says case this and that number is the case I need to discuss with you. Now, what I would like is to be able to click or double click anywhere on the line that, for instance, says case nr 55, so that the form(s) belonging to case nr 55 pop up and all info concerning that case is displayed and can be edited as needed. My problem is: I'm still a newbie and if it was a simple thing like using the on_click event to open the form that's needed, I would not have to post this question. But that can't be done (as far as I know) since the subform is based on a query which is displayed in dataview.Am I overlooking a very simple solution to this problem or is it really going to be as difficult as I think it's going to be?For clarification of the idea I have included a screenshot of the form in question. I assume there are tons of databases out there which use such a layout or idea as this one. Please, never mind the buttons etc. It is still a work in progress. ;)

View 12 Replies View Related

Forms :: Datasheet Form - Click Specific Record And Open

Apr 10, 2013

I have created a Datasheet Form which when opens shows lots of records. I was looking to see if there was a way that if i clicked on a specific field name within a record it would open a new form with all the information of that record only.

View 5 Replies View Related

Forms :: Open A Form In Datasheet View

Nov 4, 2014

i have the following code and i want that the form opens in datasheet view but i don't know how.

On Error GoTo Err_Befehl14_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Copy Of frm_logistik_zeitfehlerein"

[code]...

View 14 Replies View Related

Forms :: Datasheet View - Specify Ribbon To Open On Form Load

Aug 11, 2015

When you open a form in datasheet view, the default ribbon is of course the "Datasheet" tab. I would rather have the "Home" tab ribbon open up, because I have one field in this form set up as hyperlinks to open another form, so the filter and search buttons would be more useful to the user. I'd rather not go to the trouble to create a custom ribbon, so is there anyway to set the default ribbon tab to "Home" when you load the form? There is a ribbon property for the form, but I don't know the reference name for the tab.

View 5 Replies View Related

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

Forms :: Simply Open Three Reports On Single Click?

Jun 16, 2014

I'VE objects in ACC2003 as per following :
Form name : INVOICECreate
Query Name : db_InvoiceSet
Reports :
1st Report : Report_Inv1
2nd Report : Report_Inv2
3rd Report : Report_Inv3

All Reports based on Single db_InvoiceSet due to some cross and different manipulation of data for different office department

So, I need is:

Open All Reports in Print Preview Mode with Single Click of Button in Form INVOICECreate

View 2 Replies View Related

Forms :: Open Form To Show Full Details When Double Click On Subform

Jun 16, 2015

I have a subform 2SiteList (Datasheet View) with the field SiteName... i also have another form SiteDetails.

if possible i would like to be able to double click on a SiteName on the subform and have the SiteDetails form to open to show the full details.

View 1 Replies View Related

General :: Click On Datasheet To Open Specific Record In A Form

Jul 16, 2012

I have two forms. One is a datasheet. One is a form with a default view of Single Form (which contains combo boxes).I want to have the user select (click) on a record in the datasheet and have the second form open to that record. The datasheet form acts as an advanced search on two title fields.I tried the open form macro but I dont know how to have to second form open to a specific record.

View 9 Replies View Related

Forms :: Limit Records Shown On Open In Datasheet View

May 16, 2015

I have a question on number of records displaying in datasheet view on a form. Is there a way to limit the number of records showing on open.I have a command button on a Navigation form that opens a frmEnterPartsOrder using a Macro.

I have set the Macro to OpenForm, View Datasheet then GoToRecord, Record New..Works perfectly, but it does open the form and fill the screen with records, putting focus on the "new" record at the bottom of the form. Is there a way to set it to open this form, but only display say last 10 records and then focus on "new" record.

View 2 Replies View Related

Forms :: Subform With Datasheet View

Oct 31, 2014

I have recently added a subform to a form and wish to display the subform in Datasheet view. Whilst I can get the proper data and headings to display, I cannot figure out how to get the column widths to persist. I can adjust the column widths while in (main) form view right on the subfirm columns themselves but after I save and reload the main & subform form, the widths revert to some sort of default value.

I have also tried adjusting the columns in the subform's associated data table itself as well as adjusting the text box widths when the subform is displayed in Form view but it does not affect the column widths when the subform displays Datasheet view.

What is more annoying is that I have another subform in which I was able to make the Datasheet view column widths persist but I don't seem to be able to properly recall how I did it.

View 2 Replies View Related

Forms :: Updating Subform In Datasheet / Continuous View?

May 1, 2014

I m having a subform in datasheet view. whn i use a join query as the record source for the sub form, i am not able to add or update any record in the datasheet. Is there anyway to use a linked query as record source of the datasheet with editable property.

View 2 Replies View Related

Forms :: Cascading Combo Box In Same Datasheet View / Subform

Oct 10, 2014

Is there anyway that we can do cascading combobox in the same datasheet view of subform? Basically I'd like to filter "Account Name" based on "Plan#" selected in the same record of subform.

View 3 Replies View Related

Forms :: Column Order In Subform Datasheet View

Nov 22, 2014

I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want.

For some reason, right-clicking on a column header in Form View and selecting Freeze Fields will shift that column to the left but I can find no consistent pattern to it and no other way of shifting a column. Reordering the columns in the table itself seems to have no effect on the order they appear on the subform and moving the controls around in the subform in Design View also seems to have no effect.

View 9 Replies View Related

Forms :: Design Changes Not Reflected In Subform Datasheet View

Aug 15, 2013

I have a subform whose design I am trying to change. When I make changes such as moving fields or adding fields the changes appear in form view (and layout view), but not in datasheet view. However, if I delete fields, the changes appear in both form and datasheet view.

This situation results in behavior where I can have the subform open in design view and toggle back and forth between design and datasheet view, and they are different. However, toggling between design and form view shows the changes as having taken effect.

View 7 Replies View Related

Opening Single Records From Datasheet View

Apr 15, 2015

I have a form in datasheet view that has a user directory with a list of each person. On each row you can click to open another form that contains the users details using the below VBA:

DoCmd.OpenForm "User Details", , , "[ID] = " & Me.ID

But once you open to that specific record, no other records are available to navigate to.

I want to be able to stay on that detail form that was opened and go to another record.

How do I continue to pull up that specific user in my detail form, but also load the others so I can navigate to them from the detail form without having to go back out to the datasheet form?

View 7 Replies View Related

Undo Changes In Subform(in Datasheet View) From A Cick Event Of A Button In Main Form

Aug 5, 2005

Hi everyone!!
This is my first thread in this forum..Hope to get best from this site ..well i m facing a problem..i have a main form and a subform (which is in datasheet view) . Now i have a button called "close_form" in main form on whose click event i have writen this code :

Private Sub close_form_Click()
On Error Resume Next
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
Me.Controls.Item("fees sub").SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
DoCmd.Close
End Sub

1. If i run this form directly from Access and there are no changes i do in the form and click this button then it gets hang after showing error "run time error 2046 ; the command or action undo is not available now " "press End or Debug or help"

2. As i have created a Custom menu, if i run this form from that menu then it does not show any error. But it runs fine for the first time but nothing happens on clicking this button the second time i open the same form ( in same session).
What to do ?? Please help ..
shikha

View 2 Replies View Related

Open A Form On Double Click From A Subform

Aug 16, 2006

I all I have looked in the forum but can't find anything that matches I have a form containing a subform called eventswich shows some events in date order, as I have too many information on the table events I could not put them all in the subform if not only the essential information, what I need is if I double click on the field "DATE" it would open the "EVENT" form and show me all the information contained in the record.At the present time I have the filed SELECT RECORD set to NO on the form properties!
Hope I have given a good explanation!!!!
Thanks
Marco

View 9 Replies View Related

Duble Click On List Box To Open Form And Subform

Apr 7, 2008

I have the following code attached to a form:
Private Sub Go_To_Project_Click()
On Error GoTo Err_Go_To_Project_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Project Main"
stLinkCriteria = "[R&D ID#]=" & Me![lstsearch]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Go_To_Project_Click:
Exit Sub
Err_Go_To_Project_Click:
MsgBox Err.Description
Resume Exit_Go_To_Project_Click
End Sub

Private Sub txtsearch_AfterUpdate()
Me.lstsearch.RowSource = "Select [R&D ID#], [SKU#], [Project Name], [Construction level], [Manufacturer], [Hobbico Status], [R&D Work By], [Product Manager], [Desktopper]" & _
"From [Project Main]" & _
"Where [Project Name] like '*" & Me.txtsearch & "*'" & _
"OR [SKU#] like '*" & Me.txtsearch & "*'" & _
"OR [R&D Work By] like '*" & Me.txtsearch & "*'" & _
"OR [Product Manager] like '*" & Me.txtsearch & "*'" & _
"OR [Desktopper] like '*" & Me.txtsearch & "*'" & _
"OR [R&D ID#] like '*" & Me.txtsearch & "*'"
Me.lstsearch.Requery
End Sub


Private Sub Exit_Search_Click()
On Error GoTo Err_Exit_Search_Click
DoCmd.Close
Exit_Exit_Search_Click:
Exit Sub
Err_Exit_Search_Click:
MsgBox Err.Description
Resume Exit_Exit_Search_Click
End Sub

Basically a text string is entered in the txtbox and a list of matching records shows up in lstsearch box. One selects the desired record in the lstsearch and clicks on the "Go to project" button and the appropriate form (aka "Project main") and subform (aka Project History) open up with the desired record and record history.

What would I need to add to lstsearch so the users can double-click on the record to open it instead of selecting it and clicking on the "Go to project" button?

Thanks

mafhobb

View 10 Replies View Related

Modules & VBA :: Subform DS Click Field To Open Tab On Another Form

Apr 19, 2015

How do I reference a subform DS field to open up a tabbed form on another subform.

Here's what I have.

field one on the Sub DS opens up tab one on another form, as does field two on DS open tab two on another form.

but..

how can I click on "any" field on the DS, run an IF statement, and it checks if that record on the Datasheet, contains information in regards to, IF field one OR field two contains any data, and opens the tabbed form respectively on the other form?

View 3 Replies View Related

Forms :: Double Click On A Row In Subform And Open Related Table Using Common ID

Jun 21, 2013

I want to Double-Click on a row of a subform to open a related table/form that are connected with a common ID. So far, I tried the following code, but it does not work.

Private Sub PackingSlipT_subform_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ProductT"
stLinkCriteria = "[PackingSlip_ID]=" & Me.PackingSlipT_subform.Column(1)
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

View 14 Replies View Related

Subform Open In Form View??

May 16, 2006

Is it possible to automatically open a subform in form view as opposed to datasheet view?

If so would someone very kindly advise me on which code to use and where to implement it?

Many thanks folks.

Paul.

View 2 Replies View Related

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Opening A Form In Datasheet View

Sep 17, 2014

I'm trying to open a form in datasheet view using the following code

Code:
Private Sub Run_Activity_Duration_Totals_Click()
DoCmd.OpenForm ("frm_Activity_Duration_Totals_25_Hours"), AcFormView = acFormDS
End Sub

I keep getting a message saying

Compile Error: Type Mismatch

and the equals sign is highlighted in my code.

View 2 Replies View Related

Forms :: Navigation Form In Datasheet View

Nov 21, 2014

I've created a Navigation Form and one of my tabs brings up another form bla bla but what I want is to bring this form up in datasheet view...is there a setting for this or due I have to create a query to get the look that I want?...

The Form that I attached to the tab when opening it up by itself (out of the Nav form) comes up in a datasheet type format,and when I open it up in design view it changes from the datasheet type format to texts boxes stacked on top of each other. This is also how it opens up in the Nav form...

Does it have to do with how the form I'm putting in the nav form was created?...style wise...

View 3 Replies View Related

Forms :: Possible To Show Form Header In Datasheet View?

Sep 9, 2014

I have a form with a query as rowsource.When I open the form in data sheet view form header is not showing(Though it is visible in form view).Is it possible to show the form header in datasheet view?

View 2 Replies View Related







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