Display Form As Datasheet With Many-record Queries?

Jan 2, 2007

I want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view.
However, the problem is that they want to also see on the same form Contact details (Name & Tel.no). This is a one to many relationship with the underlying query so I cannot build this data into that query as it then makes it un-updateable.

I had thought of putting the contact details into a subform and then putting that onto the continuous form but Access does not allow that.
I am currently trying to get it work using an Unbound listbox and then using either a query or DLOOKUP but so far I cant get it to work.
It seems to be something to do with it being on a continuous form.

Any ideas please?

View Replies


ADVERTISEMENT

Forms :: Subform Datasheet Record Selected Display

Dec 2, 2014

In Access 2010, if you have a form with a subform in datasheet view, and you move the focus away from the subform, how can you tell which record(s) on the subform are selected?

When the subform has the focus, the selected row is shown with a blue/grey tint. But as soon as the subform loses the focus, this disappears and all rows look identical.

Its an issue as I have 2 datasheet subforms on my main form, with the 2nd showing records related to the record selected in the 1st. But as soon as the 2nd subform receives the focus, it is impossible to see which record in subform 1 was selected.

I have tried conditional formatting, but that does not work.

View 1 Replies View Related

Forms :: How To Display Form In Datasheet View From Switchboard

Jul 31, 2015

Have created a form to display/change table info in Datasheet View and added the form to a switchboard.When selected from switchboard, it displays a single record. When executed from the Forms (objects), it displays in Datasheet view.? How can I get it to display in Datasheet View from Switchboard?

Default view = Datasheet
Allow Form View = Yes
Allow Datasheet View = Yes

View 1 Replies View Related

Modules & VBA :: Form To Display Subset Of Records In Datasheet Mode?

Feb 3, 2015

I created a form to enter the lookup data and build the SQL string to create a recordset in VBA that is a subset of the original data. Using the Form wizard I created a form that displays ALL of the records in that original table (actually a QUERY). What I want to do is open this second form but have it reference the recordset I built in VBA.

View 1 Replies View Related

Forms :: Display Description Field Instead Of Primary Key In Datasheet Of Split Form

Aug 8, 2014

I have a split form on my database where I have my combo boxes bound to a primary key but they display the description field so it's much easier to understand. Is there a way to do this with option groups? In other words, I would like the datasheet part to display the option group labels rather than the values so it is easier to understand.

View 1 Replies View Related

Queries :: Return Record In Datasheet View

May 21, 2013

I have a query that returns records in datasheet view. I need a field to accept the user selection from a drop down, then save that to a table. The query is based on a couple queries and one of those queries is based on the table i need to save the user input into. When i make a selection from the drop down list it puts the selection in that field for all the records and then doesn't save.

View 1 Replies View Related

Forms :: Clicking A Record On A Datasheet Form To Open Record In A Pop-up

Apr 23, 2013

I have a form "IntUnderwriterSearchByName" which is based on the query "Search by Name". This form opens with a parameter (please enter name of broker) and is set out like a datasheet with the following fields- "Broker Name", "Domicile", "Broker Code" and a couple of others. I'd like to be able to click on a record and open the form "IntUnderwriterPopUp" so that the details of that specified record are displayed.

Broker Code is what I'd like the form to look for and this Broker Code is unique for every one of the 900 or so records. This code can be numerical e.g. 01233 but also can be a mixture of both e.g. EU2885. It is also worth noting that this code is not the primary key- i have an autonumber (called ID) that does this- but this field does not appear on the form.

View 7 Replies View Related

Opening A Form Relating To A Record In Datasheet

Jul 16, 2006

In Filemaker, when you open a table in datasheet view and then select a record you can then open the form relating to this record. Can you do this in Access - I can't get it to work.

View 2 Replies View Related

General :: Form With Subform Datasheet - Record Deleting

Aug 17, 2015

Currently i have a form with subform datasheet

Form from Purchase order table
Subform from serial table(Brand,Model,Type,Location,Serial) with serialtrans table(InOut,AQty,Comment)
(SELECT tbl_Serial.*, tbl_SerialTrans.*
FROM tbl_Serial LEFT JOIN tbl_SerialTrans ON tbl_Serial.SerialID = tbl_SerialTrans.SerialID

when i click on the datasheet row and delete the row it only delete the record from tbl_SerialTrans but record on tbl_Serial was not deleted

is there any way to delete it?

View 3 Replies View Related

Select Current Record In Datasheet And Show In Main Form?

Aug 20, 2007

Hello everyone,
I have a query that runs from the main form when the command button is clicked. It displays the results in datasheet view. I want the user to double click a specific record and jump to that specific record in the main form. How do I do this? Sorry, if this is a dumb question. Please help, my boss is breathing down my neck. :eek: The main form is called Contracts. Each record has a unique ID.

Thanks,
Jason

View 11 Replies View Related

Updating Main Form When Deleting Record From Subform Datasheet

Dec 21, 2006

Hi, I have a problem I don't know how to solve it. I have a subform in datasheet view, linked to the main form. There is a running total on the main form based on a dsum on a field of the subform.
When I delete a row on the subform datasheet, the main form calculation is not automatically updated. I had to create a "update" button to do the refresh.
Is there a "on record delete" event available for a datasheet sub form?
Thank you for any help.

View 1 Replies View Related

Forms :: Datasheet Subform Not Updating From Main Form Add Record?

Jun 23, 2015

I have a navigation tab with 6 sections, of the 6, 5 of them are self-made split view with a form view on top and datasheet on bottom and upon adding records through a command button on form view I would like the datasheets to update.

On other forms it would (I believe) update to the bottom of the datasheet, now on the ones I've been banging my head against it either replaces the top record or doesn't show up unless I switch tabs and switch back. From my searches I assume this is in need of a requery...

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

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

Queries :: Display Last Record On A Report?

Jun 30, 2014

What I am trying to do is have the user click a button to open a report based on the current specification they are updating. Now for each specification there are multiple revisions so i added a 'revision history' table. When the user prints the specification, I only want the latest revision number, date, and rev descr to show. I tried using the following:

Private Sub Report_Load()
Dim db As Database
Dim Rev As Recordset
Set db = CurrentDb()
Set Rev = db.OpenRecordset("SELECT tblRevisionHistory.revnum, tblRevisionHistory.revdate, tblRevisionHistory.revision FROM tblRevisionHistory;")
Rev.MoveLast
Me.Text23 = Rev.Fields("revnum")
Me.Text26 = Rev.Fields("revdate")
Me.Text28 = Rev.Fields("revision")
End Sub

The above only showed me the last record in the table regardless of the specification number filter.

View 4 Replies View Related

Double Click On A Record In Datasheet Opens A Form To Enter Data

Mar 1, 2008

I have a list of incidents in my Incidents Management Database. It comes up as a grid view when users open the database.

This is what it looks loke (paste the following into address bar of your browser. lh5.google.com.au/snehal.dabhi/R8oc22J_RfI/AAAAAAAABz0/bbIkCzg5whk/image001.png

I want particular incident to open in a form when users double click on any particular incident from the list above.
For example double clicking on the first incident (dated 1/03/2008 in the list above) should open the form below with THAT PERTICULAR incident. And double clicking on 22nd incident should open the following form with 22nd incident loaded, so users can edit that incident

please Paste the following into your browser to see the image.
lh6.google.com.au/snehal.dabhi/R8oc3GJ_RgI/AAAAAAAABz8/vGSjfr5rZ10/image003.png?imgmax=640

Any detailed help is much appreciated. – I am too new to understand macros and vba.
Thanks!

View 4 Replies View Related

Forms :: Main Form Show Record Selected Within Datasheet Subform

Sep 30, 2013

The situation is i have two forms, looking at the same table, but the main table shows more records, I would like to select a record in the datasheet subform and have the main form flick through to the corresponding record.

View 5 Replies View Related

Queries :: Displaying Query Results On Datasheet Form

Jun 24, 2014

I have a simple database with a query that "SUM"s an amount.

I created a form with a sub form that is linked by Account number. I want to be able to open the form in datasheet format and it to display the SUM value from the query.

When I open the form it responds with #Type until I click the + symbol to open the linked query then it updates the #type field with the data from the query.

View 14 Replies View Related

Queries :: Form With Datasheet View - Trim Data In A Query

May 1, 2013

I am trying to create a form with a datasheet view that will show me all exceptions worked on all member accounts. I have over 10k members that each could have multiple issues (exceptions) worked on their account. I am using MS Access 2007.

Example: I have a member John Smith, with member id of 1234-00 that has multiple "exceptions" worked on his membership, say 5 database records for his account. My initial query I only want to see him listed once. I then would double click his Member ID to open all activity of his account.

I found the code below and modified it to fit my database and it brings me back the results I need for the above. However, if a material change is made on John Smith's account, his number is incremented. His number would be incremented to 1234-01. The next material change 1234-02, etc. I am looking to modify the code below, or another way to do it, that ignores the "-" and any numbers after it. The numbers before the "-" will never change. I searched and saw the TRIM function but couldn't get it to work.

Below is the code I'm using that has the correct names from my database. I have a primary key set up that increments and is tied to the exception, not the member id.

SELECT firstname, lastname, exceptionswrkd.memberid
FROM
exceptionswrkd AS base
INNER JOIN (
SELECT memberid, Min(id) AS which_id
FROM exceptionswrkd
GROUP BY memberid
) AS sub
ON base.id = sub.which_id;

View 3 Replies View Related

How Do I Display Records In Datasheet View

Jun 2, 2006

Hi, this problem is probably very simple to solve but I can't seem to find an answer to it.I have created a search form that returns all records meeting the criteria back into the search form. What I want to be able to do is to display the records in a datasheet view. This is what I currently have and it works ok but how do I convert?Private Sub cmdSearch_Click() Dim LSQL As String Dim LSearchString As String Dim LTownString As String Dim LActive As Integer Set LSQL = Me.RecordsetClone If (Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True) And (Len(txtsearchTown) = 0 Or IsNull(txtsearchTown) = True) Then 'MsgBox "You must enter a search string." Else LSearchString = txtSearchString LTownString = txtsearchTown Select Case Me.Frame99.Value Case Is = 1 stActive = " AND Active = -1" Case Is = 2 stActive = " AND Active = 0" Case Is = 3 stActive = "" End Select 'Filter results based on search string LSQL = "select * from tblContacts" 'LSQL = LSQL & " where LastName LIKE '*" & LSearchString & "*' AND Town LIKE '*" & LTownString & "*'" & stActive If Form_frmMain2.RecordsetClone.RecordCount = 0 Then MsgBox "No records found" Else Form_frmMain2.RecordSource = LSQL End If 'Clear search string txtSearchString = "" txtsearchTown = "" End IfEnd Sub

View 2 Replies View Related

Forms :: Display Subform As Datasheet And Allow Filtering

Feb 9, 2015

I am using Access 2010. I have a subform(continuous form) that I display as a datasheet and allow filtering. I display the record count by using Me.Recordset.RecordCount in the subform's form_current event. This value updates properly based on the column filtering except when the filtering displays 0 records.

When there are 0 records, the form_current event does not fire and I cannot figure out how to trap when this occurs so that I can display '0 records found'. How I can tell when the column filtering causes 0 records to display in the datasheet? Is there an event that fires when the user filters using the column headings arrow?

View 5 Replies View Related

Display Labels Instead Of Values In A Subform Datasheet

Sep 10, 2014

I have a subform that is displayed as a datasheet, and the source of this data is from another database. Essentially, it shows someone's name and status, but the status is displayed as a number. The people using the database don't know what this value means, so I was asked to display the label instead.

The values still need to remain in the database where the data resides, but can I use a lookup table or some other mechanism so that the label is displayed in the database the users are viewing? How exactly do I do this?

i.e...the data below resides in Database A but is displayed in Database B:
Col1 | Col2 | Col3
John | Smith | 2
Jane | Doe | 1

And in Database B only, it should show as:
Col1 | Col2 | Col3
John | Smith | Inactive
Jane | Doe | Active

Note that the users of Database B will not be updating Col3 data, they will just be viewing it.

View 1 Replies View Related

Modules & VBA :: Display Query In Datasheet And Output To Text

Mar 24, 2014

The user will select two dates. Start and End date. The user will hit the run button and the application will read an excel file with employee data and only display/output the records within that date range selected (employment date).

Code:

Option Compare Database
Function DeleteTable()
'Delete old records from AllEmployeesData table
On Error GoTo DeleteTable_Err

[code]....

I am not getting the query displayed on the datasheet after it is done executing. It's just a blank sheet. Also the output file is just this:

Code:
ssn
last
mi
first
employ

I did a quick query test using SQL in Access and it worked fine there. I am guessing my error is somwhere in this section:

Code:
'--Display query result on Datasheet and Output query to text file
With db
Set qdf = .CreateQueryDef("NewHireQuery", strSQL)
DoCmd.OpenQuery "NewHireQuery"
.QueryDefs.Delete "NewHireQuery"
End With
db.Close
qdf.Close
Set qdf = Nothing

[code]....

View 5 Replies View Related

General :: Bound Form With Search Box - Select Record In Dataset And Display In Form

Aug 19, 2014

I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?

View 1 Replies View Related

Open A Form And Display Last Record

Mar 29, 2005

Hi,

I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen...

Thanks

Ryan

P.S. This is what i Have so far...

DoCmd.OpenForm "frmAbout"

View 2 Replies View Related

Sub Form Record Display Dilemma

May 26, 2005

I have a form with a sub form that opens based on a record search for a patient, whose details are displayed at the top in the main form.
The sub form displays visit information for that patient (there can be multiple visits).

On opening the sub form is filtered and only shows one record at a time. I would like it to open and show all existing visit records for the patient and be ready to enter a new visit!

View 2 Replies View Related







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