Hello,
I'm having trouble deciding how to design this simple database. The main problem is that I have separate tables with the field 'fiscal year' but I want them to be joined into one when querying.
The goal of this is to create a database to store project information where users will be able to create reports on project funding, status, etc. I've created an 'entry form' with subforms for contacts, partner, fte,...
erog
Last Activity: Mar 21 '11, 06:26 PM
Joined: May 12 '10
Location:
-
just got the report working too :) -
Ok got it working... That wasn't that hard. I spent my whole morning looking at settings and why this wasn't working in the Northwind and other tutorials. The tutorial above it must be using a more recent version of access.
The bad thing about checkboxes is that there can be three values:
0/-1/Null
I may try to change it to a listbox.
Having 0 and -1 user responses will more likely give unwanted results. Thanks...Leave a comment:
-
Hi SmileyOne
Thanks for the quick reply. I'm following this tutorial:
http://www.fontstuff.com/access/acctut08.htm
This tutorial is very similar to what I want to do. Instead of having a dropdown box, I would like to have Yes/No checkboxes. I already have yes/no fields in one of my tables called "Project Leads". Anyways, in step 2.3 in the tutorial, it says I can "Test the query" by pressing...Leave a comment:
-
MS Access Query Criteria Form Does Not Display
Hello
I've tried using the MS Access Northwind sample DB and I've downloaded a few other sample Microsoft Access DBs from their website. I keep on running into the same problem for trying to retrieve user input from a query form.
In the Northwind DB, there is a query named "Invoices Filter". In the criteria for the OrderID field in the Invoices table, the following is entered: [Forms]![Orders]![OrderID] ...
No activity results to display
Leave a comment: