Re: Change in table does not update existing records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MacDermott (macdermott_at_NoSpam.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 06:30:42 -0500

You might want to study up on relational integrity and cascade updates.
There are many Access texts out there which can explain this better than I
can in a newsgroup post.

"GI Smith" <GISmith@discussions.microsoft.com> wrote in message
news:D0E2CA7A-7B91-4DF3-AA50-6081285EC4DF@microsoft.com...
> Created simple Reports tracking database for reports going to outside
> agencies in Access 2000.
>
> Consist of tables with fields: Permit Info (Permit_Number (PK),
Type_Permit,
> Responsible_ Person, Department, Regulatory_Agency), Report Name (EventID
> (PK)), Report_Name, Monitor_Rqmt), Report Frequency (Frequency), Month
> (Month_Name, Month_Nr (PK)), Installation (Installation_Name, UIC (PK)),
> Command (Command_Name, UIC (PK)), and Activity (Activity_Name)
>
> The Layout - the permit numbers are specific to an Installation and may
> apply to multi Commands and Activities. Report Name will apply at
multiple
> Installations, Commands, Activities. Report Frequency consists of Annual,
> Semi-Annual, Quarterly, Monthly and some occassional weird rqmts such as
> every 6 years etc (Did not set up predetermined peiod start and ends
> timeframes because the quarterly and semi-annual periods are not always
the
> typical quarter, semi-annual). Month is typical with a thirteenth month
named
> Varies - this table fills the Month_Due, Period_Begin and Period_End
fields
> on the data entry form. Installation lists physical location, Command
lists
> commands (can have more than one on same installation) and Activity lists
the
> actual department (Maintenance, Facilities, etc.
>
> Problem - when I make a change in any of the tables, such as Report Name,
I
> run the query but my Data Input Form does not change the name in exisiting
> records. I use a Data Input Form to populate a Reports Data Info
database.
> It does show the new name on the Data Input Form (combo box linked to the
> query) for a new record. I'm sure I'm overlooking some part of the data
> relationship. I did a drag and drop of the fields in the tables to the
> Reports Data Info database fields, thinking this will allow the automatic
> updata if I changed any of the information in the tables.
>
> What am I missing?
>
>
>
> --GI Smith

Relevant Pages

  • Re: Report problem
    ... Access uses the printer metrics to calculate the layout of the reports, ... the printer installation is still the problem. ... If that is not the case, open a code window and choose References on the ... > mode or preview mode and with in VBA, DoCmd.OutputTo yada yada it returns ...
    (microsoft.public.access.reports)
  • OSX 10.5.6 installation tips.
    ... Mac OS X 10.5.6: ... Failed installation (stuck on configuration installation) By far the most ... Sample reports from MacFixIt readers include: ...
    (comp.sys.mac.advocacy)
  • Re: Urgent: Acess will not allow me to create a report
    ... Under the about section it says "Microsoft Office document image writer ... a printer, apparently, but a driver) it allows me to print preview and create ... print, print preview, or create reports). ... Now, this sounds like a mistake in installation or something, where some ...
    (microsoft.public.access.reports)
  • Re: SMS2003 - no reports available, importing smsrprt.mof fails
    ... and the wbem logs for more information. ... but this time all reports are missing. ... > tried to repair the SMS installation, ... > MOF file has been successfully parsed ...
    (microsoft.public.sms.setup)
  • Re: WSS3 and Excel Web Parts
    ... Manager set up more reports as and when he needs them.. ... I've thought of the possibility of setting up a WSS2 server in a VMWare ... can get the data across from WSS site to site. ... We have a standard WSS3.0 installation on a Windows 2003 Server. ...
    (microsoft.public.sharepoint.windowsservices)