General :: Sum On Subform Datasheet - Enter Result To Table Record

Aug 20, 2012

I already make textbox name: TbBanyak on subform footer with control source =sum([Jumlah])

I success display it on mainform with texbox control source =[Jualsubform].[Form]![TbBanyak]

how to enter/record the result to table record??

View Replies


ADVERTISEMENT

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

Modules & VBA :: How To Enter A Record In A Table Via Subform

Sep 18, 2013

I have a main form with several tabs. Each of those tab has one subform linked to its related table. I would like to be able to enter a new item in one of the table via the subform and I used the following code:

Code:
Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.tblEmetteurs_AddItems_subform.Name, acNewRec
End Sub

I obtain a msg error from the debogger: "Compile error: Method or data member not found."

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

General :: Enter Value In A Form / Run Query And Display Result On Form

Jun 15, 2013

Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return the value of count function in to anther text box?

View 5 Replies View Related

General :: Subform Enter Parameter Value Error

Aug 11, 2012

I have 2 form

main form = "TanggalF"
subform = "MerkFsubform"

I have a query with 2 field "Combo28" and "Combo30"

I use it in subform with query [Forms]![MerkFsubform]![Combo30]

Combo30 is combo box on MerkFsubform

If I open in subform "MerkFsubform" work, no problem

but if i open on main form "TanggalF" it get errror "Enter Parameter Value" Form!Merksubform!Combo30

View 3 Replies View Related

Forms :: Datasheet In Subform Won't Allow To Add A New Record

May 15, 2013

I have been handed an Access database (Access 2002-2003 file format) to clean up and update as necessary. Currently I am trying to add new rows to a datasheet that is in a subform. I have had no trouble in the past adding rows and for some reason now I can't.

In some instances I can update an existing row but never add a new one. Also, the records options are greyed out in the ribbon except for a select few that are not useful (refresh all, totals, more). Can't add new record from their either. I am in the main form that contins the subform which contains the datasheet, in form view.

View 5 Replies View Related

Forms :: Obtain Record Value From Datasheet Subform

Dec 23, 2013

How can I obtain the value of a record from my subform in datasheet view?

Ideally I could double click in the "cell", for lack of a better word, and grab that value to pass through to another function.

On double click event? What then?

Edit: I suppose the user could select the row that the value is in as well. As long as I could then find the field I need from within the row. That might make things easier.

Edit 2: Sometimes I post before doing proper research. I've figured it out. Here is a quick example. The below code references an unbound subform called "Main_AU" where the field I want is "Description". The MsgBox is used to confirm that the code is grabbing what I want it to.

Code:
Dim test As String
test = Main_AU!Description
MsgBox test

View 3 Replies View Related

General :: Datasheet In Subform - Editing Restriction For User

Nov 14, 2012

I have designed a datasheet in a subform and it has a nested datasheet inside of it. I have it all designed and now I want to disable the user from doing anything to either, such set column widths, set colours etc. How would I do that?

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

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

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

General :: When Enter A New Record / Combobox Is Not Being Cleared

Sep 30, 2013

I have a problem with a DB I just designed. It has a combobox that is populated from a query, and it works great. However, the problem is that when I enter a new record the combobox is not being cleared, and is "holding" the data from the previous record. How can I get it to "reset"?

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

Forms :: Edit Record From Query Result As New Record To Another Table?

Aug 22, 2013

I have a form that using "Query A" as data source. The Form need add (edit) a field value before save that Query Result to another Tabel. Is it possible to do that?

The PROCESS simply like below: Tabel A --> Query A --> Form -->Edit value a field -->Save to Tabel B

if it is possible, are there some requirements that have to be fullfilled?

View 2 Replies View Related

General :: Count Number Of Record With SQL Result In MS Access

Jul 21, 2013

I want to return the number of record with the SQL search in MS Access. I am using the following code, the expected result will be a value. But somehow, it does not give any result.

StrSQL = "SELECT COUNT(*) FROM table1 WHERE [Condition]='A' "

How do I return the count value with the search?

View 3 Replies View Related

General :: Open Datasheet With Last Record At The Bottom Of Page?

Sep 18, 2014

Is there a way to have a datasheet open with the last record at the bottom of the page? I now have it opening to the last record, but it has the last record at the top and can't see the records before it without scrolling.

View 2 Replies View Related

General :: Main Form With Two Lists Boxes - Show / Hide Datasheet Columns In A Subform

Aug 24, 2012

I've got a main form with two lists boxes. I want to show the visible columns in my subform (which is a datasheet) in one listbox and show the hidden columns in the other. Also I want to allow the user to hide / show columns using right or left arrow buttons between the list boxes. My subform is bound to a stored procedure using ADO.

View 5 Replies View Related

General :: Create Combobox On Form To Enter Record Not On List

Jul 22, 2012

I'm creating a simple database to document our supplier's contact information, addresses etc. However, when I create a combo box on the form and try to enter a record not on the list it gives the message "The Text You Entered Isn't an Item in the List".

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

Modules & VBA :: Highlight Rows In A Subform Datasheet Table

Jan 25, 2015

I have a main form users enter info into then submit, which adds it to the table being displayed in the subform...

One of the options is a "Urgent" tick box, if they tick this box, once it has submitted to the table, i need that row to highlight red...

View 3 Replies View Related

Forms :: Subform Datasheet To Populate Main Table

May 19, 2014

I have a subform that is essentially a blank table which users can create rows depending on how many they require and fill the table in.

I then want to be able to append a main table with the records that have just been created in the subform's table... but here is where an issue lies.

Main Table has 6 columns... subform table has 5.

I already have the value to put into the 6th column but Im just not sure how to do it... the value is obtained from the original form.

For each record, copy that record into the main table + adding another value into the extra column.

Is this possible? or doable?

View 4 Replies View Related

General :: Show Query Result In Form Textbox Immediately After Updating A Record

Nov 24, 2014

I am building a Inventory Management Application for Tyre Shop. I have SaleMainTbl and SaleDetailTbl both used for preparing daily sale summary. I have Mainform based on SaleMainTbl with TxnDate and Total Amount (Sale) and the TxnDate is in one to many relation with SaleDetailTbl. FormSaleDetail is multiple row(continuous) form that makes billwise summary of each day having -TxnDate--BillNo--ItemSold--Company--Qunatity--Rate--Amount fields. I have inserted this form in FormSaleMainTbl.

So FormSaleMainTbl is Main form and FormSaleDetail is subform. TxnDate in FormSaleDetailTbl is automatically taken from SaleMainForm. I have further added text boxes in Main Form to show company wise sale for each day for which there is a query build one for each company that takes the currently loaded date from FormSaleDetail and calculates the Sale (Sum) of each brand (Company) of Tyres. All these objects are working very fine. However I have to close the MainForm and reopen it for result of query to appear in the appropriate text box in Main form.

Is there way to do this as soon as record is entered or at least at the end of completing the entry of each days sale transactions without closing the form. So the gist of the problem is realtime display of query result in text box on a form or updating the form screen immediately on updating any record or at the most after completing the updating of form but without having to close the form.

View 5 Replies View Related

Search Record In Other Table And Show Result On Current Table

Apr 11, 2012

Actually I have a small form of customer details, that i made in excel, the field name mention below,

Customer Details Table
First Name
Last Name
Contact Detail
Address Detail

Postal Code
Last Purchasing Date
Remark

Now i want to make a search form like this

Search Form

Contact Details

& the result is show which I insert the contact number.......

View 1 Replies View Related







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