So I've recently dove into the world of Access databases and for the most part, it went really well. I created an inventory database from scratch that was completely functional. Now it was completely stumped me!
I'm using a split form that displays recent data that's collected in a query. The table could be updated at the bottom, while the recent data was displayed above it and it had a nice little header at the top. However, I was having a problem getting the current inventory column to work. Fixed it today by adding its proper table into the query the form is built on. When doing that I created another problem, fixing that created another problem and here I am not able to fix it. Here comes some screen shots.
This is what the database currently looks like. The entry fields are present and function as they should. However, we have hundreds of fields entered and are not being displayed.
This is what the database looks like, sometimes. Notice the "Current Inventory" column is not working. This is was I fixed today. Since then, the data entry option is gone, highlighted in red. I should have open empty boxes here.
This is a split form with a query as its record source. Going to the form's record source's properties brings you here, the Inventory Trans Ext's query builder. This is how the relationships looked before I fixed the current inventory column problem.
And after. The values were being calculated by another query simply named: Query1. Query1 is where the bulk of calculations and data is done and used.
Somehow, fixing this column has made a bigger mess. I can no longer enter data with the column working. So I took out my changes. I put everything back the way it was and was going to retrace my steps. Then the database appeared like it did in the first screen shot. Totally blank.
If I open Inventory Transactions Extended on its own, all the data is there, saved just as it should be, and I can even add new records (actually in its table, but it's still displaying like it should.)
So after this started happening, I started to put things back the way they were. I took out the added table and the added column. Database stayed blank. I closed the database and reopened it, all blank. I had been working on this on my laptop, not on the computer that actually runs it. So I tried that one, all blank. Then I thought I must've changed a setting somewhere, who knows where. I'll just update the backup copy with the 10 or so new entries and use that one. That one looks the same. Hasn't changed in 2 weeks and the backup copy is also blank! :banghead: But if I check the inventory transactions records, all records are there. They're just not being displayed.
I'm just totally at a loss. Any help on this would be greatly appreciated.
I'm using a split form that displays recent data that's collected in a query. The table could be updated at the bottom, while the recent data was displayed above it and it had a nice little header at the top. However, I was having a problem getting the current inventory column to work. Fixed it today by adding its proper table into the query the form is built on. When doing that I created another problem, fixing that created another problem and here I am not able to fix it. Here comes some screen shots.
This is what the database currently looks like. The entry fields are present and function as they should. However, we have hundreds of fields entered and are not being displayed.
This is what the database looks like, sometimes. Notice the "Current Inventory" column is not working. This is was I fixed today. Since then, the data entry option is gone, highlighted in red. I should have open empty boxes here.
This is a split form with a query as its record source. Going to the form's record source's properties brings you here, the Inventory Trans Ext's query builder. This is how the relationships looked before I fixed the current inventory column problem.
And after. The values were being calculated by another query simply named: Query1. Query1 is where the bulk of calculations and data is done and used.
Somehow, fixing this column has made a bigger mess. I can no longer enter data with the column working. So I took out my changes. I put everything back the way it was and was going to retrace my steps. Then the database appeared like it did in the first screen shot. Totally blank.
If I open Inventory Transactions Extended on its own, all the data is there, saved just as it should be, and I can even add new records (actually in its table, but it's still displaying like it should.)
So after this started happening, I started to put things back the way they were. I took out the added table and the added column. Database stayed blank. I closed the database and reopened it, all blank. I had been working on this on my laptop, not on the computer that actually runs it. So I tried that one, all blank. Then I thought I must've changed a setting somewhere, who knows where. I'll just update the backup copy with the 10 or so new entries and use that one. That one looks the same. Hasn't changed in 2 weeks and the backup copy is also blank! :banghead: But if I check the inventory transactions records, all records are there. They're just not being displayed.
I'm just totally at a loss. Any help on this would be greatly appreciated.
Thankfully it was just some weird setting. Thanks for your help. 
