I have recently acquired the job of updating our Access dB (2000 version) and I am a bit over my head here (my work with Access was limited to entering information into forms or running the reports requested - now they are asking me to update/fix/DESIGN these things!!). The database was designed by some other party many years ago, and has been copied to create new databases every year. This data base if for shipping of Christmas trees, so it hold load date, ship date, loading site, carrier, multiple customers (drops) and products. There are various reports that are run for the field crews so that they are always on top of what needs to be cut, what fields those will come from, etc. The problem I have is that this year they have added new product (which I know how to enter into the form that should be putting it in the table - which, in turn, should make it accessable by all reports, right?). The problem I am having are several:
In our Harvest/Product Summary Reports (I realize these names don't mean anything to you, but hopefully it will help in differentiating between the reports), I am able to see and link (in the properties window in design view) to the products that were existing, but I altered the name. However, the new products that I entered DO NOT show up. They show up in the form we use to enter the load information, but they do not show in the properties window - so I can't link these fields. When I look in the appropriate table, they products all exist as they should. However, in my xTab file ALL products that have ever been in any of the databases are listed. I can't change any of them because they are linked tables, so modifying them won't work.
In our Daily Carrier Load Sheet Report, Loads are pulled by Ship Date, show the load number, carrier, and is supposed to show what total product is supposed to be on that load. It is listed out by total product (i.e. if there are 8 drops and each has 2 pallets of D6P, it would show 16 D6P). This whole field is blank. All other information populates like it should. In design view, all that is shown is "Load Synopsis" in the field - but I can't seem to find WHERE the Load Sysnopsis is generated.
I am sure you will need examples, and I will work on getting those uploaded here ... but any thoughts or suggestions would be wonderful!
Thanks everyone!
Sep 2 '10
11 1458 Delerna 1,134
Recognized Expert Top Contributor
Looking at your screen shots
and comparing to your posts
will post back later
Delerna 1,134
Recognized Expert Top Contributor
My first guess is that the join conditions in your "XTabDailyCarri erLoadSheet" query are filtering your new records out.
Its difficult to read it as the tables aren't placed will in the snapshot but it appears
"Products" is joined to "DropDetail " on the ProductID field
and
"DropTable" is joined to the "DropDetail " on the LoadNumber and DropNumberField s
You need to check and ensure that matches exist for them.
Perhaps you should PM me and we can arrange for me to get a copy of your DB
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: noah |
last post by:
Does PHP have a feature to associate Cookie sessions with a persistent
database connection that will allow a single transaction across
multiple HTTP requests?
Here is how I imagine my process: I have an series of interactive HTML
forms. The user begins a Cookie session. A database connection is
opened and a transaction is begun. After the user goes through any
number of pages where they update the database they finish on a page
where...
|
by: Eric S. Johansson |
last post by:
I have an application where I need a very simple database, effectively a
very large dictionary. The very large dictionary must be accessed from
multiple processes simultaneously. I need to be able to lock records
within the very large dictionary when records are written to. Estimated
number of records will be in the ballpark of 50,000 to 100,000 in his
early phase and 10 times that in the future. Each record will run about
100 to 150...
|
by: halsa |
last post by:
hi
I need to append multiple reports to a single report.For
example I have 2 Pending Invoice reports to print.The
report viewer has to preview these two reports like two
different pages and then it has to print. The problem I am
facing now is its checking for two reports but it
displaying thonly last report in the crystal Report
viewer.Could you guys have any idea how to solve this
problem.
|
by: Ken |
last post by:
Help!
I have a MS Access database made up of a single table. The data updates for
this database comes in the form of a single Excel spreadsheet, which is
imported into the database table.
I need to break-out this single database table, into multiple tables to
better structure the database and reduce the need to input the same data
repeatedly.
|
by: Jeff |
last post by:
We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.
Can we have the multiple apps all point to a single State DB? Or do we
need to install multiple instances of the State database on to the SQL
Server (one for each Web app)?
It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a...
| |
by: paul.chae |
last post by:
I have a table in Access with about 3000 records. There are ~60 unique
values in the ID field for the 3000 records. What I would like to do
is automatically generate multiple Excel worksheets within a single
workbook with these records. I would end up with around 500
worksheets, 1 for each unique ID value. I was thinking this could be
done if I have an exported flag column in the table, and I search for
the max (or min) on the ID...
|
by: graham.dreyer |
last post by:
HI all,
I have a problem at the moment where i need to be able to create, edit
and delete records in multiple tables in a single access database, not
sure if it would be better to use SQL or not, strictly in the
development phase at the moment.
My query is this how difficult is it to do the above within an asp
page? if someone could help me it would be greatly appreciated.
|
by: Birky |
last post by:
Is there a way to have Access enter multiple entries to a database based on a form where the user has selected a certain criteria? I am hoping to have my form enter multiple entries within a table but each entry will have different information.
What I have is an event log which tracks all the versions of software which is being installed within our servers. I have four servers which “should” mimic each other therefore, when an application is...
|
by: Marcin Kalicinski |
last post by:
How do I use multiple Python interpreters within the same process?
I know there's a function Py_NewInterpreter. However, how do I use functions
like Py_RunString etc. with it? They don't take any arguments that would
tell on which interpreter to run the string...?
Marcin
|
by: JoyceBabu |
last post by:
Can anyone plz tell me the advantages and disadvantages of using multiple databases / single database for all tables.
I have a site with more than a 100 tables. Current all the tables are in a single database, so that I can access it with a single Database Wrapper Object (PDO). Should I split it into multiple databases? Will it affect the speed?
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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?
| |