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 Replies


ADVERTISEMENT

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 14 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 :: 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

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

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

Datasheet View In Subform

Jul 17, 2006

Hi. I am trying to create subform in datasheet view with one column (total 3)as drop down list. Is this doable? Thanks.

View 3 Replies View Related

Subform Datasheet View

Jan 5, 2006

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.

I would like a column to be hidden for a certain group of users and have tried the following.

On the subform opening event i have

if vlevel = "engineer" then

me.Hours.columnhidden = True

Else

me.Hours.columnhidden = False

End If

And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True

But neither worked.

Can any suggest something.

View 4 Replies View Related

Datasheet View In A Subform

Jul 25, 2006

Can anyone tell me how to manipulate a single cell in a datasheet view, or if it is even possible?

View 3 Replies View Related

Before Update For Subform In Datasheet View

Jul 19, 2006

I have a small issue with the before update event, it is triggered for every record of my subform in datasheet view rather than just once when the user leaves the subform.

I have a module which is called from my form and all the subforms. It tells the user that changes have been made to the record and gives them the option to undo. This is to prevent accidental editing when viewing records. This works fine, but sometimes the user must enter a number of records in a subform and so they must answer the message box every time.

Is there any relatively straightforward way to accomplish the warning and undo when the user leaves the subform rather than the individual record in it?

A quick attempt at lost focus and before exit demonstrated that these were not the way to go.

For reference, here is the before update code and the module

Option Compare Database
Option Explicit

Private Sub Form_Before Update(Cancel As Integer)
On Error GoTo Err_Handler

Call Confirm_Change

Exit_Here:
Exit Sub

Err_Handler:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_Here

End Sub


Option Compare Database
Option Explicit

Public Sub Confirm_Change()
On Error GoTo Err_Handler

Dim Msg, Style, Title, Response

Beep

'Define message box
Msg = "You have made changes to this record. " & Chr(13) _
& Chr(13) & "Click 'Yes' to save changes " & Chr(13) _
& Chr(13) & "Click 'No' to undo changes "
Style = vbYesNo + vbExclamation + vbDefaultButton1
Title = "Record changed - Confirm save" '

'Check which button pressed
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
MsgBox "Record has been updated with your changes", vbOKOnly, "Record saved"
Else
DoCmd.RunCommand acCmdUndo
End If

Exit_Here:
Exit Sub

Err_Handler:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_Here

End Sub

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

Update Of Subform In Datasheet View On Mainform?

Oct 8, 2006

Hi,

I have a query (SelectedData_Query) , on which a form (SelectedDataQuery_SubForm) in datasheetview is based, which is placed on a form (NAWInvoerForm) where customer adress data is put in. When someone clicks new case button on the NAWInvoer_Form, another form (CaseDateTimeInfo_Form) is opened, data is entered, but when the "CaseDateTimeInfo_Form" form is closed, the data in the subform in datasheetview on the NAWInvoerForm is not yet refreshed. So I tried the following:

Private Sub Form_Close()
'------------------------------------------------------------
' RefreshNAWInvoerForm
'
'------------------------------------------------------------
On Error GoTo RefreshNAWInvoerForm_Err


DoCmd.OpenForm "KlantNAW_InvoerForm", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdRefresh

RefreshNAWInvoerForm_Exit:
Exit Sub

RefreshNAWInvoerForm_Err:
MsgBox Error$
Resume RefreshNAWInvoerForm_Exit

End Sub

Which works just fine. After the form is closed, the name, adress and cases overview form is reopened and refreshed, thus the case that has just been created is shown nicely in the subform which is based on a query.

But it is starting to become bothersome, sometimes when I close the form in which I create a new case, I don't want to have the other form (NAWInvoerForm) reopening again.

So how can i make it so that when I close the form only the data in the "NAWInvoer_Form" is refreshed, without having to reopen the form again. I mean, in the background, the form is still open anyway. It just shouldn't keep popping up everytime.

It can't be hard, but I can't see it. I'm new at this. I have found some similar topics on this forum, but none which helps me out enough.

It should be something like:

On "thisandthatevent" do a "thisandthatcommand" on "thisandthatsubform" in "thisandthatform"

If I know how the syntax of that is done, it would help me out with some other problems I see coming in the near future. I've looked at, and tried some things based on this link: http://www.mvps.org/access/forms/frm0031.htm
But without success.

Can anyone help?

View 4 Replies View Related

Multiselect Listbox On A Subform With Datasheet View

May 22, 2014

Is it possible to have a multiselect listbox on a subform with a datasheet view or do I need a combobox in this situation?

View 4 Replies View Related

Locking Column Widths In Subform Datasheet View

Mar 29, 2005

Hello, all.

I need to use a datasheet view for a subform, but I can't seem to find how to keep users from editing the column widths within the view. Help?

THANKS!

Tom

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

General :: Datasheet View - Clearing Filters In Subform

Jan 4, 2013

I have a subform in datasheet view and a button on the main form which is used to clear all filters in the subform.

The button's OnClick event calls a procedure on the subform. The procedure in the subform has the following code :

Code:
Me.filter = ""
Me.filterOn = false
Docmd.Save acform, subformName
Debug.Print "Filter : " & Me.filter
Me.requery

I also have debug print outs which shows the current filter on the forms OnLoad and OnClose events.

Everything works fine but somehow when I reopen the main form (with subform) the filter gets reset to the previous one.

I can change filters and that saves ok but if I clear filter it always returns to the previous ones when I reopen the form containing the subform...

For reference the filter string in subform looks like "(qrySubformQuerySource.Fieldname)="xx""

View 5 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

I Want Datasheet View... Why Does It Keep Showing Form View?

Apr 6, 2006

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks

View 6 Replies View Related

General :: Datasheet View - Date Picker Not Working In Subform?

Sep 11, 2012

I have a subform that is in Datasheet view. If I open this subform on it's own, the Date Picker works for the Date field. However, if I open the main form with the subform on it, the date picker doesn't work? Nothing happens when I select a date on the calender.

I am using MS Access 2010.

View 1 Replies View Related

What Have I Done? You Can't Open A Subform When It Is Also Open In Design View

Jun 1, 2006

Problem:
Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.

I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.

The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.

(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)

Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.

Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"

Can anyone help me? I've googled this but finding no answers.

View 1 Replies View Related

Tables :: Datasheet View Of Table Inside Subform Not Showing Sorted Data

May 25, 2015

I have a linked table(tblxyz) having property set as ORDER BY ID DESC, ID is autonumber, so my table view gives me latest record on top.

Now I have a subform , where i am calling this Table.....

[Forms]![MainForm]![Sub_DisplayFm].SourceObject = "Table.tblxyz"

This gives me datasheet view of the table inside subform but its not showing sorted data

Interesting thing is it give sorted data view when my table is not linked and is in same access file.

View 4 Replies View Related

Fields Different From Form To Datasheet View

Dec 27, 2006

hello,

I also posted this in the report section, but it doesen't seem like the readers over there have any answers. I'm hoping maybe query people will.
I'm working on someone elses database, and I'm not too familiar with access.

He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.

The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update:
However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.

Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.

Any help would be greatly appreciated.

Thanks

View 1 Replies View Related







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