Access Error #2335
Access 2003. OS: Win XP Pro
For a client I have created a database to track customers details and purchases. I have designed a form for data entry, the form is tabbed, the first tab is Clients Details, the second is purchase details.
I have used one subforms to allow entry of date and amount, and to show the history of that client, the second subform is linked to a Query to show the total purchases for the client.
I have tested the database on my computers, it works as I wanted it to and have installed it on the clients peer server, where it is also fully functional, the same on another workstation.
The problem I am having is that the workstation that the data will be inputted from returns the error message when opening the form:
“You must use the same number of fields when you set the LinkChildFields and LinkMasterField s properties. You entered a different number of fields for one property than you did for the other.
If you use the Relationships command (Tools menu) to define a relationship between the tables underlying the form and subform, Microsoft Office Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterField s properties.”
I have checked that the relationships are correct, I have uninstalled and reinstalled Office on the workstation but still receive the error message. I have double checked that the options are set identically for all the workstation, but I can not resolve the problem.
Has anyone experienced this problem before, or have any suggestion which route I should go down to cure the problem?
2 3408 MMcCarthy 14,534
Recognized Expert Moderator MVP
This is a new one to me. I would suggest the following checks.
1. Check the subform object and see what master and child fields are showing. Even if it looks correct hit the button with dots to the right and make sure the correct fields are available in the dropdown lists.
2. Check the library references on the problem computer and make sure that no libraries are marked as missing. Also check that the list corresponds to your own computer including version numbers.
3. Compile the database from the VBA editor and make sure no errors are appearing.
Mary
This is a new one to me. I would suggest the following checks.
1. Check the subform object and see what master and child fields are showing. Even if it looks correct hit the button with dots to the right and make sure the correct fields are available in the dropdown lists.
2. Check the library references on the problem computer and make sure that no libraries are marked as missing. Also check that the list corresponds to your own computer including version numbers.
3. Compile the database from the VBA editor and make sure no errors are appearing.
Mary
Many thanks Mary for those suggestions. I have now checked out all of your suggestions and have turned up no problems, but the database still returns error # 2335. The machine is very new, Windows is correctly installed, all of the tools I use for checking the registry and virus / malware return a negative for any problems. I have even restored to a date that would have been before any input errors by the user coud have changed the setting of the program or the machine.
My next move will be to create a compleatly new database that can use the tables that have been created so far.
Many thanks again
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Nicola |
last post by:
Hi Everyone,
I am new to programming and would like to know how to
open an access Report from within vb 6. I am trying to write a program
to organise cross stitch threads. I have found out how to use a database
table
but all I want to do now is to click a command button to display this access
report.
Any suggestions please ?????
|
by: Mehroz |
last post by:
Hello everybody,
Please let me know how to avoid giving physical path & line number in the
error messages of web applications. Instead i would like to replace it with
general error message to the user.
Regards,
Mehroz
|
by: Marcin |
last post by:
Hi,
The problem is the following: I have experienced some ASP errors in my
web application and I'm unable to reproduce those errors because IIS
is configured in a way that does not send any debugging messages to
the user (and I cannot change it). Only standard string "An error
occured on the web server when processing the url..." is sent. So, two
questions:
1) Is there any way to log such situations to the eventlog, a file,
database or...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
| |
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
|
by: Bob |
last post by:
I have a client app that writes a value to the registry (camera device ID).
I have used Application.CommonAppDataRegistry to write the value in my test
app.
How do I retrieve this data from a Windows service? Is the application
object accessible at all?
Cheers
|
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in '/CinemaBookingSystem' Application.
--------------------------------------------------------------------------------
ERROR General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
|
by: vinodkus |
last post by:
How can we handle asp error
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: 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...
| |