Search results

Try searching for ways to create "pivot tables". I think that's what you are describing....

Thanks Bob. I'm calling it quits for today... I have wasted 2 days on this problem and I feel so frustrated. Maybe I'll have better luck tomorrow :(

:o How embarrassing! You would think it would have errored out on that spelling error. Okay corrected that and now I have a null error so it's probably not finding the value. I think I have additional problems because the record is adding blank records in my supervisor table and adding the...

Hi Everyone, Does anyone have some ideas I could try? I have a form that is used to enter new data. The form based of a query that uses 4 tables. As a new record is added, I am trying to programmatically populate some fields so the user doesn't have to enter them. I added this code into...

Similar issue Hi, I've been reading mapat's original post and it sounds kind of similar to what I would like to do, therefore I didn't start a new thread... so hopefully you guys are still reading. I have a form based on a query linking multiple tables. I am adding new records using the...

Thank you Wayne!! It works... I never thought about using DCount :)

Thanks for the reply... I tried what you said If (Not IsNull(StrProject) And (Not IsNull(StrName))) Then it works but I think I still have the logic wrong. <sigh> I'll keep trying.

I was wondering if anyone could point me in the right direction...I'm surprised I got this far by fumbling though... I am trying to prevent users from entering a new record in the database if it already exists. I am looking at 2 particular fields - project and name. If (Not...

...nevermind. I'll just continue to still searching the forum for answers

I think this will work... 1.Open the access application then open your database using File-> Open option. 2. Select your database and on the 'Open' button there will be a drop down - Select 'Open Exclusive'. 3. Once your database is opened, go to Tools -> Security -> Unset password.

You made some good points about trying to come up with a possible hybrid solution! I'll try that. I was just unsure if trying to do everything in Access was worth it or not... I agree that this is a really blunt tool for project/resource management...but this request is from supervisors who...

Aww come on y'all... any replies? Even a "sorry, I know what you're trying to do but it's not possible using Access..." any sort of clue...

I have created a database that stores information about employee utilization in MS Access 2003. It's basic purpose is to forcast hours employees will work on various projects throught the year. I have created the following tables: project, month, employee, supervisor, and data . The data table...

Hi, I am using Access 2003... and I created a pivot table to view data from a query based off several tables. (Row headings: employees and the projects they work on, column heading: months of the year, data: hours billed to each project per month) The pivot table is very pretty and exactly how...