Main/subform. Subform works but main form doesn't.

Bill Strass

Problem: Access main form/subform as front end to SQL Server backend.
Add/edit via subforms work fine. Not so with main form.
Set up a master-detail form-subform using two
views linked from SQL Server. The subform allows inserts an updates,
while the main form will not.
The only solution I can think of is to
recreate using tables imported from SQL Server, so that the data is
all
local. This is despite the fact that the views in SQL are updateable.
The one updates while the other doesn't.
The only other obstacle I can
think of is that there may be too many joins on the main view (i.e.
12)
for the Access form to handle.
Any ideas would be welcome!

Nov 12 '05 #1

Subscribe Reply

2192

Rick Brandt

"Bill Strass" <wi************ ******@hotmail. com> wrote in message
news:b6******** *************** ***@posting.goo gle.com...

Problem: Access main form/subform as front end to SQL Server backend.
Add/edit via subforms work fine. Not so with main form.
Set up a master-detail form-subform using two
views linked from SQL Server. The subform allows inserts an updates,
while the main form will not.
The only solution I can think of is to
recreate using tables imported from SQL Server, so that the data is
all
local. This is despite the fact that the views in SQL are updateable.
The one updates while the other doesn't.
The only other obstacle I can
think of is that there may be too many joins on the main view (i.e.
12)
for the Access form to handle.
Any ideas would be welcome!

When you create a link to a view on a SQL Server, you should be asked to
define which fields in the view Access can use to create a unique index
against to allow for updating. Did you do so?

Can you edit the view directly in the link's table datasheet?

It is not unusual for a view (or query) with joins in it to become
read-only. I would think that one with 12 joins would almost always end up
this way. While joins are fine for queries and reports, they are not often
used in a form where you expect to be doing updates. Perhaps you need to
rethink that part.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #2

Similar topics

3331

Refreshing Main Form Field

by: William Wisnieski | last post by:

Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text field called . It gets populated based on what the user selects in a field on the sub form (code in the AfterUpdate Event). Here's the issue. If the user deletes a subform record. The field on the main form shows null even if there is a value in the preceding subform record. What I'd like it to do is immediately refresh to

Microsoft Access / VBA

3826

Call Subform Function From Main Form

by: TDIOwa | last post by:

I have a form (frmAppointment) with a subform on it (frmAppointmentsub1). I have placed a command button on the main form which calls the function below from the module. The purpose of this function is to make fields beginning with YY invisble OnClick of the command button on the main form. It works for the fields on the main form but not on the subform. What do I need to add or do to make it work on the subform? Any help would be...

Microsoft Access / VBA

7004

Main Form & Continuous Subform (with Requery) Problem

by: Dave Boyd | last post by:

Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the user enters the last qualifying field on the main form. In one case this works fine, the subform shows the data the user wants to update -- which means showing all the data put in previously (ie showing this via the requery and the continuous...

Microsoft Access / VBA

13593

Undo subform from main form

by: Darryl Kerkeslager | last post by:

I don't do much with subforms - in fact I've deliberately avoided them - but .... I have a tab control that will contain several subforms, each bound to a separate table, and each table/subform will relate to the same person - but the subform data will not be 'linked' to the main form. I want to have one Cancel button for all the undo operations on all the subforms, so the individul subform's Public Sub, Form_Cancel will be called...

Microsoft Access / VBA

3850

Returning Focus to Main Form

by: Neil Ginsberg | last post by:

OK, this is a stupid thing, but I can't seem to get this to work. I have a form with a subform (in continuous form view). A combo box on the main form has code in the AfterUpdate event which adds a record to the subform (based on the value of the combo box) and requeries the subform control. I want the focus to return to the combo box on the main form when it's done, but I can't get it to do so if the user enters a value and presses Enter...

Microsoft Access / VBA

3393

Navigating from Main form to subform to sub-subform

by: dBNovice | last post by:

Please help! I have 3 forms: Task, Subtask, Elements. Elements is a subform of Subtask and Subtask is a subform of Task. I am able to navigate from Task to Subform to Element and from Element to Subtask to Task by pressing a button that makes each subform invisible/visible. The problem exists when I try to navigate from Element to Task to Subtask. Sub-subform Element will become invisible and show Task but when I press the button to go...

Microsoft Access / VBA

8382

main form + 3 subforms / manual forms linking

by: darnel | last post by:

I have 4 hierarchical tables and want to display it all together as a form and 3 subforms, when subform displays (and allow to add/edit) only relevant items from each superior subform. Tables are: Clients --> linked thru id_client --> Orders --> linked thru id_order --> Licences --> linked thru id_licence --> Regkeys Access' Form Wizard allows only form + 2 subforms. I tried to create last subform and its link manually, but I'm not...

Microsoft Access / VBA

34534

Update Main Form from Subform

by: mlcampeau | last post by:

I'm fairly new to this so I'll try to be as clear as possible. I have a database that stores employee information and all job titles available. I have a main form that is based from a query and displays all job codes and job titles in the Job table. I also have a text box in the main form to keep track of the total number of positions available for this job title: =DSum("","","=!") Where JobVacancy is a table that contains JobCode, Department,...

Microsoft Access / VBA

6947

Subform not linking to Main form

by: rlamber | last post by:

Hello, I have 2 subforms in a Main form, one links fine, the other doesn't. I am trying to link them both to a "tracking ID" on the main form. The Tracking ID is a text field that is a combination of an auto-number and an Alpha expression. The subform that links fine is a comments form (continuous form with just date field and memo box) and the subform that won't link is a larger, more detailed form where I would like to add more than one...

Microsoft Access / VBA

8465

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8895

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8809

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8588

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8658

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

4206

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4386

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2032

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1788

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General