Form With Subform Doesn't Show Totals Unless Keyed

Aug 2, 2007

I have an application that has two tables, linked on a common key. The main data entry form is for invoices, and has a sub-form for parts used. A similar report/sub-report is used for reporting.

Everything is fine for records that are entered via the form. My problem is that when I import data from other sources ( consolidation process ) the calculations are not performed. So when those records are displayed no totals appear until I click on a control that drives the calculations. I don't want to store totals in the database but I need to have them reflected on the viewed form without operator intervention. Otherwise I'm open to incorrect decisions when the operator doesn't notice that an invoice doesn't reflect the cost of parts used.

I'm looking for a "one-time" process that I can invoke after loading new data that would "touch" each record (ideally each "new" record but there's no impact to re-calculating existing ones) and drive the calculations so that the viewed form is correct.

It doesn't need to be "easy" or automated since the end users won't do it, only myself as part of the data consolidation.

Any ideas?

Thanks

View Replies


ADVERTISEMENT

Subform In A Form Doesn Show Controls When Link Child And Master Fields Derfined

Jun 13, 2005

Hello,

I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded.
Is there a setting on the parent form that also has to be changed, to make the new binding?

Thanks,
Aleksander

View 1 Replies View Related

Modules & VBA :: Query Result Doesn't Show In Subform

Aug 22, 2013

I already success to run this dynamic query where the parameters taken from the main form.Now the problem is the query result doesn't show in the subform.But the status bar below tell me that it have 2 records in the subform, but there is no data in the subform, it just Blank.I already apllied the Requery or Refresh to the subform (in the Command Button), but it have no result too.This is the code:

Forms!MsDataWarga.QueryDataWarga.Form.RecordSource = "MyQuery"
Forms!MsDataWarga.QueryDataWarga.Requery
Forms!MsDataWarga.QueryDataWarga.Refresh

View 4 Replies View Related

Help! My Form Doesn't Show Up In Form View

Aug 7, 2006

I created a form in "design view" and everything is there, but when I go to "Form view" it is just blank!

View 3 Replies View Related

Help With Running Query From Info Keyed In Form

Feb 22, 2005

I need help to figure out how to create a form that includes a place to enter date ranges (A start and an end date: the field name in the table is CrossClampDate), patient name, and case number as a search. I have just taken 3 levels of Access classes and saw an example of this, but we never went into it and from the Properties box for all parts of the form I still can't decipher how it was done.

Basically, I want to run the operations a query goes through by inputing this information in a form.

I have created an actual query that performs this operation, and it works. But I am prompted for each criteria separately in individual pop up boxes. I just need to streamline this operation for the users.

Any help would be GREATLY appreciated!!!

View 1 Replies View Related

Forms :: Subform Doesn't Update After Values Being Updated By Another Form

Feb 27, 2015

I'm running into an issue with my forms. I have a form that contains a subform, that contains a list of projects. This list is read-only. To update a record, you can double click on it, which opens another form filtered on this record, and which contains the fields in the first form as well as some others.

I have a command button on that last form to "Save and close", which fires up a macro that saves the record and closes the window.

Now, the issue that I'm having is that, when the window closes and I'm once again in front of the first form with the list of projects, the values of the record I changed are not updated and when I click on another record, Access tells me there's a conflict in the values and asks me if I want to keep the changes, discard them or copy to the clipboard.

It seems to consider the old values from the first form as a change, and thus asks me which to keep between these, and the actual (proper) changes I made in the dedicated form.

For the proper changes to be applied, I need to select "Drop changes".

I tried to requery the first form, also undo the changes to it after closing the window, but none of that worked.

I'm actually basing this on one of the templates, which does exactly what I want and which obviously works...

View 3 Replies View Related

Forms :: Getting Totals From A Subform Into A Field On Main Form

Feb 13, 2015

I have a music database. It's somewhat over the top in terms of the information stored in it, but I like it. My issue is with getting the total number of tracks, as well as the total duration, for a given album (and for each disc, but if I can solve one that should also solve the other).

I have a lot of tables and forms, but for this problem I only need to deal with two of each. They are the tables for albums, the table for tracks, and their associated forms.

In my album table I have information such as album title, artist, release date, and album length. The tracks table contains information on each song - track title, track number, parent album, and track length.

My main form is for the album itself, and contains a subform for the tracks on said album. They correspond to the relevant tables.

What I want to do is obtain the value of the album length by calculating the sum of the track lengths for that album, and the number of tracks. Easy enough - Sum(TrackLength) and Count(TrackID) respectively, both of which can be stored in the footer of the subform.

My problem is that, rather than simply copying those values into text boxes on the main form, I want to copy them into actual fields in the album table. Furthermore, I want them to update as I add or edit the track lengths in the subform.

View 4 Replies View Related

New Data Doesn't Show

Aug 19, 2005

Hi.

I have a subform (based on table "Source") that allows the user to create a new record in another table "Events" (it copies some entries to facilitate entering new data). The data should then be dispayed in another subform. However, the newly created redord is does not show in the subform although I use Me.Refresh. When I close the form and then open it again it works - but there has to be an easier way.

How can I reload the data from the table. I have looked but am unable to find the right method.

The code:

'Create New Record in Table Events

Call AddEvent(EventDate, Country)
'This function opens the table and adds a record

'Open Subform
DoCmd.GoToControl "subfrm_events"
DoCmd.GoToRecord , , acLast
Me.Refresh

Help would be much appreciated!

View 1 Replies View Related

My Record Doesn't Show Up When I Add It

Mar 27, 2006

I was having trouble adding my records to my subform. I think it was going into my main form, which is unbound. When I removed the navigation bars from my main form and added them back to my subform, I lost my records that i had. They are still in my table, but not showing in my subform. How do I get them in there?

View 10 Replies View Related

HTML Text Doesn't Show Right

Nov 29, 2004

In my website I've created a admin login with some ASP pages to edit and update stories.
I use an acces database and installed HTMLarea for WYSIWYG editing.

When I update text, all the HTML tags show als plain text in my website.
For example: I make a headline bold in my wysiwig editor and I update my text, it just shows: <B> here's a new story </B>
If I look in my database I have a field 'text' wich is a memofield and I can see the html tags have been stored into my database. <B>here's a new story</B>

It looks like it doesnt recognize the html tags as HTML, but just as plain text...

Can I use HTML-tags in an acces database and how do I get them to show up right in my website?

View 1 Replies View Related

Tab Control Is Set To Transparent But Background Doesn't Show Through

Aug 31, 2006

I have some tab controls, which for some reason show up white.
I have set their back style to transparent but it doesn't seem to show the grey Windows colour of the background form.
Any ideas why ?

AT the moment I'm having to put grey rectangles in various places to cover this up, which is obviously not ideal.

View 4 Replies View Related

How Can I Show Switchboard Only (i.e Access Doesn't Appear To Be Open)

Jul 19, 2005

Hi,
Does anyone know if I can just show the switchboard only so that it looks like a program, or if I can use an existing MDB to create an .exe??

View 2 Replies View Related

Why Doesn't Primary Key Show Up On Datasheet View

Sep 18, 2015

I have an ordinary table with 20 fields and in the design view the primary field is shown as an auto-number, but it doesn't appear in the datasheet view.

View 4 Replies View Related

Customer ID Doesn't Show Up Correctly In A Query Or Table

Oct 11, 2004

When I open one of my tables or queries and look at the customer Id, the displayed info is a single digit. On my customers table my primary key is the customer Id with auto number with the format like this: "ID"000. This is great however, when you look up the customer id in other tables it only displayes the single digit. I want it to show up like ID001 or ID002. In the customers tables it looks just like that, but if you click in that cell/field it takes away the ID and just shows the 001 or 002. I changed the format in my other tables under customer id to "ID000" but that didn't seem to make a difference. I would like to be able to do a search lets say by customer ID in one of my products table and when I type ID005 or ID012 it takes me to those records. But right now I would have to enter 5 or 12. Datatype in my other tables on field customer ID is set to text. Do I have to do a validation rule? How can I get it to show up the way I want it?

View 7 Replies View Related

Need Zero To Show Up In Column If No Fault Totals Exist

Aug 14, 2007

My problem is if there is no FaultTotals nothing shows up. I would still like for the Four Columns to show data and have a 0 in the FaultTotals.

How can I accomplish this?


In a nutshell I am totaling all Cosmetic Faults based on the SystemGroup CTWT and a Date Range. If there are
no Cosmetic CTWT Faults for the DateRange I want a zero. The query works great as long as there is at least
One FaultTotal for the Date Range.


SELECT "1-3" AS Truck, "Cosmetic" AS Category, WorkUnitsFaultsMainTBL.SystemGroup, Count(*) AS FaultTotals
FROM WorkUnitsFaultsMainTBL
WHERE (((WorkUnitsFaultsMainTBL.FaultCategory)="Cosmetic") AND ((WorkUnitsFaultsMainTBL.TodaysDate)
Between [Forms]![Queries_ReportsFRM]![StartDateTxt] And [Forms]![Queries_ReportsFRM]![EndDateTxt]) AND ((WorkUnitsFaultsMainTBL.BuildID) In ("E010","C809","F001","C810","F187","A910","M173","M174")))
GROUP BY WorkUnitsFaultsMainTBL.SystemGroup
HAVING (((WorkUnitsFaultsMainTBL.SystemGroup)="CtWT"))
ORDER BY Count(*) DESC;

View 3 Replies View Related

Forms :: Prices And Totals Will Not Show In Table?

Aug 14, 2013

I have a problem with a form which I created for a table. The purpose of the form named OrdersForm is to simply add Orders in the table named TableOrders using labels such as Customer (combo box) Products (Combo box) Date (which controls the column Date in the table with a date function) Quantity (the user puts a value) Price (automatic) Totalp (as a Product between Quantity and Price)

My issue here is that when i use the form and enter an order Price and Totalp will not appear in columns in the table TableOrders.

View 4 Replies View Related

Reports :: Show Totals Extracted From Tables

Oct 9, 2014

I routinely produce a report for regular Committee Meetings which includes statistical date derived from the total rows for various fields in 1 or more Tables.It should be possible to extract such data automatically, probably using a query. So far, my endeavors in this direction have been unsuccessful.

View 14 Replies View Related

Queries :: New Record Added To Table But Doesn't Show Up In Query

Aug 4, 2014

I have a database used to track my personal assignments, created about six years ago using Access 2003 on Windows XP. Recently upgraded to Access 2010 on Windows 7. At some point thereafter, I started having the following issue:

When a new record is created, that record gets added to the table, but doesn't show-up in any query, form, or report until after another new record has been added. The most recently added record cannot be located to view or update, except in the table, until after another new record has been added to the table. Queries, forms, & reports now always lag behind by one record.

None of the queries, forms, or reports tested contain filters. I have several multi-user databases that I also support and none of those users have reported having this problem. This is only happening on my personal database.

I've re-created this database once or twice in the past to resolve other issues, but would like to avoid that route this time around, if possible.

View 7 Replies View Related

Forms :: Field Doesn't Show Full Length Of Record

Dec 4, 2013

My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields.

I don't know where the mistake is occurring or indeed I don't know if the error is in the table or in the form.

The form is showing full length of the text but when I look it in the table, it has just one or two bits of the full length.

View 4 Replies View Related

General :: Start Up / Doesn't Show Minimize And Maximize Button

Sep 1, 2012

I created autoexec macrro. But when i open the form as a dialog box it doesn't show minimize and maximize button.. it only shows close button so what should i do..Also i want to create the log in form as well..So here is what i want

1) when i open the database it shows me log in box and if i put right password and username

- if i put wrong password it should keep promoting me until i put right login details and this login shouldn't be displaying the close button otherwise users can easily access through database.

2) the navigation form should be pop up.

View 2 Replies View Related

Forms :: Data Entry - How To Show Current Date That Doesn't Change The Next Day

Jun 27, 2013

I am extremely new to Access. I have my database up and running ok(ish) and would like to know if in my data entry form, I can have the "Date Entered in Database" box display the current date that does not change from day to day. I know you can use the "Now()" function but won't this just change everyday?

View 3 Replies View Related

Subform Total To Show On Main Form

Jan 24, 2007

Hi ALl,

I have a subform that accounts and adds all the expenses for a certain project (for example, total is $27,000). I would like to know how to duplicate the final cost in the subform and show it on an unbound textbox of that linked main form (the unbound textbox in the main form shows $27,000 also).

Thanks in advance, guys...

Caliboi

View 4 Replies View Related

If Subform Is Blank, Dont Show Main Form..

Oct 4, 2006

My title is a little confusing, i have a form with a subform, what I want it to do is this say i have 10 records, 3 of which are missing any data in the subform... then when i show the form it only shows 7 records. This way all records have data in both the main form and the subform... is this possible?

Thanks

View 1 Replies View Related

Help With Totals In SubForm Pls.

Sep 12, 2005

folks,
I have two simple tables in a database. One Table is the entry table and the other is the totals. I then created a Form and a subform from the two tables. What I would like is to maintain running totals in the subform as entries are made in the entry table. Attached is the Database. Please help.

View 2 Replies View Related

Forms :: Create A Filter To Eliminate Any Record From Form Where Nothing To Show In Subform

Jun 7, 2013

I've got a hopefully an easy question - how to create a form filter? I've got a form with a subform. Form is showing all records from a table, but some records on the subform are blank. I want to create a filter which will eliminate any record from the form where there is nothing to show in the subform.

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







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