I am experiencing an extremely peculiar problem, which occurred immediately after converting a self-contained Access 2003 database to a Front/Back End architecture. When I enter a specific field ([SubLocation]) in a Sub-Form and move the Mouse to other Records within the same field context, all values in those fields will consecutively disappear. The integrity of the underlying data is intact and a Data Refresh, Form/Sub-Form Requery, or Refreshing the Table Links does not solve the problem. The Main Form must be closed and opened again for the data to be properly displayed. This problem does not exist within the self-contained version of the database. There is no code in the MouseMove Event of this field. The Enter Event of this field contains code, which modifies the RecordSource of the [SubLocation] field based on the value of the current [Location]. I am at my wits end – can anyone provide some insight into this situation? Thanks
7 2280 NeoPa 32,556
Expert Mod 16PB
Did you ever get a resolution to this ADezii?
Did you ever get a resolution to this ADezii?
No one from this planet has ever encountered a similar problem, and to this day I have never found the underlying cause. Had to create spaghetti code that writes to a Local Table then updates the Back End on the Server. A real nightmare for keeing the data in sync, since other Users are duplicating this process on their localized Front Ends. Thanks for the thought.
Hmm, I've had some strange problems when a bound field was present on the report, but the field was removed from the report's query.
Perhaps worthwhile to check your fields.
Did you also try to decompile the splitted .mdb ?
Nic;o)
PEB 1,418
Expert 1GB
I am experiencing an extremely peculiar problem, which occurred immediately after converting a self-contained Access 2003 database to a Front/Back End architecture. When I enter a specific field ([SubLocation]) in a Sub-Form and move the Mouse to other Records within the same field context, all values in those fields will consecutively disappear. The integrity of the underlying data is intact and a Data Refresh, Form/Sub-Form Requery, or Refreshing the Table Links does not solve the problem. The Main Form must be closed and opened again for the data to be properly displayed. This problem does not exist within the self-contained version of the database. There is no code in the MouseMove Event of this field. The Enter Event of this field contains code, which modifies the RecordSource of the [SubLocation] field based on the value of the current [Location]. I am at my wits end – can anyone provide some insight into this situation? Thanks
Hi,
I've had the same problem! There is long time that i'ven' t had it but before i've removed all heavy code and expressions.
Pls verify that there is no null data that participate in ur recordset and u check in it for not null data!
Yesterday just i've had this pb with Access 2.0! Imagine only! :)
PEB 1,418
Expert 1GB
Sometimes i've other pb: in All Fields it is written #Name and can't see anything behind!
And in fact also when there is no users and i'm the only one in the front end /back end database this prb appeared!
Check ur expressions! Do them sas simplier as possible! And expect the use of null!
Hmm, I've had some strange problems when a bound field was present on the report, but the field was removed from the report's query.
Perhaps worthwhile to check your fields.
Did you also try to decompile the splitted .mdb ?
Nic;o)
Tried that also, thanks.
Hi,
I've had the same problem! There is long time that i'ven' t had it but before i've removed all heavy code and expressions.
Pls verify that there is no null data that participate in ur recordset and u check in it for not null data!
Yesterday just i've had this pb with Access 2.0! Imagine only! :)
Data in question are all Required, Numeric Fields derived from a multicolumn Combo Box.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: tshad |
last post by:
I have an example I copied from "programming asp.net" (o'reilly) and can't
seem to get the Sub (writefile) to execute. It displays all the
response.write lines that are called directly, but not...
|
by: Andrew Ducker |
last post by:
My unhandled exceptions seem to just vanish. If I put the line:
int x = int.Parse("XXX");
in (which generates an exception, obviously) then the code that's
executing just vanishes, leaving me...
|
by: Kathy Burke |
last post by:
Hi, I'm tired, so this question may be silly. I have a fairly long sub
procedure. Based on one condition, I load another sub with the
following:
If Session("GRN") = "complete" Then
txtScan.Text...
|
by: Michael |
last post by:
After trying to load my java applet from <OBJECT> tag
(rather than <APPLET> tag), it renders fine, except when
you click between the DESIGN view then back to HTML view,
the <PARAM NAME="ARCHIVE"...
|
by: tmaster |
last post by:
When I try to dynamically add a second sub menu item to this ContextMenu
item, I get an error 'Specified argument was out of the range of valid
values'.
Private Sub mnuTopics_Show_Select(ByVal...
|
by: Ron |
last post by:
Greetings,
I am trying to understand the rational for Raising Events
instead of just calling a sub. Could someone explain the
difference between the following 2 scenarios? Why would I
want to...
|
by: Linda |
last post by:
Greetings,
I am experiencing a problem similar to that mentioned in <a...
|
by: Sharon |
last post by:
Hi all.
To prevent access to a sub system internal types,
is it necessary to create the sub system in a different project,
and use the internal access level?
Or is there another way that will...
|
by: mark4asp |
last post by:
The first intem in a DropDownList is vanishing!
My code to load a DropDownList is shown below. Yet when I load the
page after a postback there is no zeroth item present.
...
|
by: TC |
last post by:
I've used Access for many years. Several times, I've encountered a bug
which I refer to as the "Vanishing Joins" bug. When it happens, joins
vanish randomly from queries. More specifically, all...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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,...
|
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,...
|
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...
|
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...
| |