I finally got the team's database running but one problem. The database is on the network drive an when more then one member try to use the database, they get an error "database is in use". Is there a way so more then one person can use the database at a time. And this may seem like alot but is there a way to just give viewing access to some people so they edit nothing?
THANKING YOU IN ADVANCE!
How do I query from a table with a specific field (region, for example) that
I need by feeding in another field (location) from another table. The table
with the region field has the matching locations. The user will input the
departure and destination location and I want it to look up the table with
the regions and display the two different regions in the same query.
Do I write SQL statements or is it possible by using the functions within Access?
Regards,
Jason
Howdy all,
I just started my new analyst job and I've been handed an manually constructed Excel file that I'd like to port to Access. Let me see if I can state my scenario clearly so you can point me in the right direction(s).
There are 3 tables listing the following - monthly temperature, monthly humidity, and monthly dew point. The feilds are a Building header and the 12 months. The records are the ten buildings for which we're collecting data.
My source is a pair of log files -Temp and Humidity - for each building. The kicker is that these log file poll every 15 minutes.
So the plan to date is
1) Import the log files
2) Find the monthly average for each
3) Use these to find the Monthly dew point
4) Build a form to display all of this
5) See if there is a way to turn this into a batch process (and in turn a scheduled task)
After browsing this board I think I've got steps 1 and 2 down. I still need help with the rest though. Can you point me to any examples or post that I haven't seen?
I repost to this with more Q's after the lunch break. :)
Thanks
Ok its been a long while since I've set up a date base in access. I run a repair shop and I've set up tables for customers, machines and employees. My issue is when I create my form to enter repairs for each customer the information like address, name, phone number, model.... do seem to be following over to my forms; I'm having to key the information manually each time instead of entering the customer # and having the rest of the customer information populate the additional fields.
Anyone who can help me with this I'll greatly appreciate it, I'm losing sleep over this one.
Thanks in advance for the help.
I have three tables. Each table has the following
TblAA - aaDate, AAFS, AAFT, AAFU
TblBB - bbDate, BBFS, BBFT, BBFU
TblCC - ccDate, CCFS, CCFT, CCFU
The "xxDate" fields are (mm/dd/yyyy)
all other fields contain numerical data. (1,5,10 etc.)
I have linked the tables and it returns all of the results. However, My issue is that I want the user to be able to enter one date range to search all three tables at once.
Let's say tables AA and BB have data entered on 12/01/2006 and 12/15/2006, but CC has data from 11/07/2006. The user would enter Beginning Date: 12/01/2006 Ending Date: 12/31/2006 and they would receive results from the first two tables only.
I hope this makes sense. TBN (Tough Being a Newbie)
We are using acces to track and tag all incoming jobs. Since can be used by multiple users I would like a dialog box that would come up at open and tell me the file is currently being used by another user. Excel has that feature. Otherwise we keep using duplicate job numbers. Any help is appreciated.
View 1 Replies View RelatedHi, I am a longtime Excel user, and am now migrating some work to Access.
I have 2 fields dealing with dates in the format mm/dd/yyyy hh:mm, OPEN and CLOSE
I'd like to get the difference between the two in hours, but I have no idea how or where to do this in Access. I'm assuming it is put into the queries, but it would be easier if I could just put it in the table.
Here is an example
1/1/2008 1:00 1/2/2008 2:00
I want the result to be "25"
Thanks in advance!