I added a new field to a table in the tables database. In the code
database, I added a new column for the new field to a datasheet
subform. I opened it in datasheet view and moved the column to the
position I wanted it. No records are returned by the form's query (it
has a "Where ID = -1" clause and the GoToRecord proc on the main form
changes the subform's recordsource).
When I opened the form and started adding data to the subform, data
from the new column was added to the wrong table field. Also, a proc
that executes an "Insert Into ... " query to do bulk adds put data for
the new column into the wrong field.
The form's query does not use tables directly, but uses them through
aliasing queries. e.g. qselSomething is "Select * From tblSomething".
I decompiled, compacted, recreated the datasheet subform's query and
the problem seems to have gone away.
Has anyone else seen this? Any explanations?
--
Regards.
Richard. 1 2311
I don't use datasheet views, so I'm not sure if this relates, but
occassionally I have found quirky behavior like this in form views. Try
deleting the form's recordsource, compiling and saving the form, then
replacing the recordsource line. Not sure how or why, but it "recompilie s"
the form even when a decompile/compile fails to fix the glitch.
Darryl Kerkeslager
"Richard Sherratt" <ri************ **@NOTHINGHEREb runsley.com.au> wrote in
message news:c5******** *************** *********@4ax.c om... I added a new field to a table in the tables database. In the code database, I added a new column for the new field to a datasheet subform. I opened it in datasheet view and moved the column to the position I wanted it. No records are returned by the form's query (it has a "Where ID = -1" clause and the GoToRecord proc on the main form changes the subform's recordsource).
When I opened the form and started adding data to the subform, data from the new column was added to the wrong table field. Also, a proc that executes an "Insert Into ... " query to do bulk adds put data for the new column into the wrong field.
The form's query does not use tables directly, but uses them through aliasing queries. e.g. qselSomething is "Select * From tblSomething".
I decompiled, compacted, recreated the datasheet subform's query and the problem seems to have gone away.
Has anyone else seen this? Any explanations?
-- Regards. Richard. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ivan |
last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within
that subform is another subform (OrderDetail). That subform (OrderDetail) is
displayed in Datasheet view. When I am entering customers and their
respective orders, the first order entered is fine with the "tab" field
orders correct. On the second and subsequent orders, when I go from the
Order form to the subform "OrderDetail", the curser goes to the wrong field...
|
by: MacDermott |
last post by:
I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.
How can I learn this?
TIA
- Turtle
|
by: LaurenW |
last post by:
Hi Folks,
I have an Access 2K form that includes a normally hidden subform
linked in the normal way. For many months it ran perfectly and it
still does except for one thing -- when we switch to datasheet view,
the subform is expanded and visible for every record even if the
subform was invisible at the moment of the view switch. This just
recently started happening and I am clueless about why.
Anyone have advice on this phenomena?
|
by: Aladdin |
last post by:
I have an MS Access form on which I have a listbox listing tables in
that database. I want to be able to click on any of those tables and
view its contents on the same form using subforms or any grid control.
I tried many grid controls (DBGrid, DataGrid, MSFlexGrid), the ADO
Data Control and everything I can think of, with no success. Here are
the contraints I faced:
(1) Populating any of the grid controls manually is too slow for my...
|
by: E |
last post by:
I have encountered a very strange problem that is hard to describe, but
hope someone has run across it.
I have a form that shows a number of columns from a single table in the
upper portion of the form in a datasheet layout. The user can then
choose a category from a dropdown list, and based on that category will
see further data in the bottom part of the screen. They can choose one
of 2 categories, but both show data FROM THE SAME...
| |
by: s_wadhwa |
last post by:
Hi,
I have a main form "frmBldgFloor" and SubForm within the main form
"fsubBldgFloor".
In the SubForm the values in the text fields are being populated from a
recordsource.
I have these values being populated in Form Detail Section.
Also I have Form Footer where I have text boxes showing Sum of those
recordsource values.
|
by: ghat12 |
last post by:
Hi,
I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
|
by: Ian |
last post by:
Hi everyone,
I have found some bizarre (to me...!) behaviour of the Form_Activate
function. I have a form which has a button control used to close the
form and a subform with a datasheet view showing a list of jobs from
the database. When the main form loses focus and the user clicks the
'Close' button, I kept receiving error 2585 (This action cannot be
carried out whilst processing a form or report event). This was tracked
down to...
|
by: Deano |
last post by:
I have five subforms each living in a page on a tab control. Each form is
in datasheet view.
The time has come to resize both the forms and the subforms.
I am able to change the column widths in the first subform and these are
remembered. However the column widths for all the other subforms change
back to their original widths when I re-enter the form.
I have no idea why this is and I have checked that all the form properties
are...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |