Recent content by teresamichele

I feel really silly but I don't understand what you're saying. A bit more explanation on my database - the data imported contains the employee ID, the project code, the fiscal month, and the time worked. I DO have a table containing just the project codes. However, every instance of a code...

Hi all! I created a database to track time entry for my group. Now we're at fiscal year end and I want to get a big huge Excel spreadsheet together for my boss but I'm encountering a problem. I have some projects that are worked on every month, without fail. Others, we worked on for a month...

Hi! I'm building a database that will contain all of our time entry records, and then writing reports so we can see the data in a way that is useful (as opposed to the massive Excel spreadsheets we get now that no one reads). It will be set up to be able to sort by employee, manager...

I'm trying to understand what you're saying, but I really don't. I added the "SELECT ID" bit where I thought it went but it's saying that it's invalid syntax and I may be missing something. If I'm in Query Design View, where would it go? :) Thank you!

I am using Access 2007 on Windows XP Professional. That out of the way, here is my issue. It involves forms and reports and tables so the General forum seemed as good as any! :) I have a form that people use to enter data to a "Project Entry" table. All of my forms, reports, etc, feed from...

HA! I had googled it and it said something like that, but I was on the "Home" tab - where there is a Totals option - but it's not active in design view. I knew if you suggested it, it was right, though, so I kept clicking and found it. Thanks a ton! :)

I have a database in Access 2007 that I can upload our time entry data into. Each project has a "code" and the primary key is actually 3 fields - the employee ID, the fiscal month, and that code. I created a query to view the hours worked by code...but it shows each individual entry. So if...

I'm using Access 2007 and having a bit of a problem. I have a form with a field for due date. I have an After Update event assigned to that to assign a priority code based on the distance from the current date to the due date. The priority code then appears in another box on the form. The...

I tried something like that and it didn't work (I'm sure it was user error). So instead, because I hate having a problem I can't solve, I created a hidden field that calculates the difference between the current date and the due date, and then used the value of THAT in the IIf function in the...

Hi! I'm trying to do something fairly straight-forward, I think, but I've hit a wall. I'm using Access 2007 to create a form for project entry. My form has a date logged, a date due, and a Priority field. I figured out DateDiff so that it will tell me the difference between date logged and...

You are AWESOME! Thank you! :D *scampers off to play in the code*

There is no Access Options - all I get is "Close Database" and "Exit Access". I know what you mean, because it's there in every other database, but she managed to get it to go away. Part of it is that I'll be editing what is there - they want more options and new fields, so I don't mind...

I'm just getting started with Access 2007 and I love it. I have a crush on relational databases. However, I am trying to re-create a database someone built in Access 2002. I can do queries and reports - that part is fine - but she had set up a sort of "front page" where people could click on...