I am doing a db and one of the tables we are following patients during in-patient stays and need to document average $/day (both PRE specific treatment and POSTspecific treatment) and same inf...
i have a table with numbers "MC1Reading" / "MC2Reading" / etc...
i would like for the "MC1Reading" to default to the last "MC1Reading" by "date" when a new record is created??????
I have a database with fiscal year 2004- 2007 tables. As there are numerous tables, I would like to select more than one table for a specified year, right-click and add it to the group I have ...
I thought I had this many to many thing figured out and now Im very unsure.
I have these tables
tblClients
ClientFileNo PK(auto number)
SSN
FirstName
Etc
tblFunds
Fu...
After years of having all my questions answered here, now I can't find it and need help.
We are running a DOS based software for our Order Entry/AR/Inventory. The software is still being s...
I read somewhere that it might be a good idea to have all my forms pulled from queries rather than from my tables directly. I also heard that one form should only edit one table at a time. Is ...
I have a query that uses wildcards to indentify keywords in a field in the query (see code snippet). I have run out of space for the IIF statement that I'm using. I want to make this more dy...
What I have: ClientsTBL, ContactEventTBL Client will have many events and events will have many clients (like a mailing list), so I have created a linking table between the two - ClientEventX...
I have an Access 2000 database which I have been progressively been developing in our office over a number of years.
The database has long been split into a frontend (forms, queries, modul...
Experts,
I have a simple question in MS Access table. In one of the fields, we want the data type to be date/time and we want it use a look up wizard. So, first we select the data type to b...
I am working with Access 2000 and I don't think I have the relationships set up correctly, maybe I do. But I need these tables to Cascade Update and Delete accordingly and they aren't. Maybe...
Attached is a database file by mbizup - The request was to be able to add a new record from the top as opposed the the bottom. He did a great job with this.
In short, I am trying to get th...
I have passed OpenArgs between Forms but I always displayed them in a disabled and visible txtbox. I do this to "see" all of the OperArgs transferring.
Is this necessary in order to trans...
In MsAccess i have a query
It returns this (example)
ProdNo EAN
123 111
123 222
123 333
1234 444
I need to return this instead
ProdNo ...
Hello Experts,
I need some ideas for designing a "checkbox" matrix in Access.
Let me start explaining the really easy matrix from an MS-Excel perspective. In Excel, I have a "city/pr...
Ok, so this is actually not homework, its just something I'm working on for my wife. I took a class in ACCESS a few years ago, (1997) and I'm trying to design a database that will work like se...
I have three tables that I'm trying to consolidate into one. The main table would be tblContributionDetails which would contain all information for contributions. I want to create a relationsh...
