Search results

I have an Access 2007 DB we are using to both track issues, and do some project management on. My boss wants to add a function to it where it will show how many days a project has been assigned to a specific location (these projects will get assigned to us for testing, then assigned to another...

oh for the love of all that is holy. Ok, I can't even blame that on having too much to drink, or being overtired...just plain old being stupid! Thanks!

Ok, I have worked this query up one side and down the other. It's simple, so it shouldn't be giving me so many problems! All I want is a query that doesn't show anything with a status of "Closed", "Cancelled" or "Unfunded" Here's my query... SELECT Issues.* FROM Issues WHERE...

Yes, this is on AfterUpdate on a field in a form. I put the me!Status in there, and all I am getting is the error that another user already updated it, do I want to save record. When I say save record, the close_dt still doesn't update? Is it because I am running the status change log...

I am an infant when dealing with databases or coding, let me just put that out there up front. :) I am trying to put an If statement into a set of code that will update a field only if the status = "closed". Here's the code I have: Private Sub Status_AfterUpdate() Dim rs As...

Ok, I will say up front that I have no idea what I am doing. :D I would like to create a form that users can use to reset their access 2007 database password. I have a query that is the row source for a combo box that will only return the current user logged in, and have 2 unbound text boxes...

Has anyone ever integrated Access 2007 with Windows login? What I would like is to do is allow anyone to open the DB and view information (run reports, etc) but only allow users on an ACL to be able to input/modify data. Ideally it would be integrated with the smart cards we use to login, and...

Ok, well now I just feel stupid! When I tried that before I mistyped something and it threw up on me...but pasting your line in there worked. Yup...feeling pretty stupid right now. I bow down to the superior intellect! Thanks for the help! :-)

The form is actually based off a query, but I don't know any way for the query to return values based on a function in VB? Here's the query I'm using: SELECT Issues.ID, Issues.Title, Issues.Model, Issues.Due_Date, Issues.Status, Contacts.login_name FROM Contacts INNER JOIN Issues ON...

I have a datasheet form in Access 2007 that I need to filter on load to only return results for the person currently logged in. The form is going to be used to show what items are due in the coming week and be sort of a time management "solution" for staff. I have a module fsUserName which I...

I'm trying to figure out how to create a progress bar based on the date a project was opened, and estimating the average time it should take... For example, if I say the average time to complete a standard routine is 365 days (a constant), and I use datediff() to show a project has been open...

I would like to know how to have access pull the name of the field that had data changed in it. I have a form, that has AfterUpdate set to the following... Set rs = CurrentDb.OpenRecordset("Audit") With rs .AddNew !tblProject_ID = Me.ID !last_update = Now() !updated_by =...

I have an Access 2007 DB with a table called tblLastUpdate which contains 4 fields: ID, Issue_number, last_udpate, and last_update_field I would like, whenever anything in a separate table (Issues) changes to have it the tblLastUpdate. What I'd like is to have last_update show the time/date...

Thanks! It worked. I don't fully understand HOW it worked, but it worked! Thanks for the help!

Ok, I'll admit that I am confused...if I want to group by only the issues.ID field, why do the others need to go in as well?

I have a query in Access 2007 that I am trying to run where it will only return 1 instance of the ID Field, and thought that GROUP BY was the way to go, but whenever I run it I am getting "You tried to execute a query that does not include the specified expression "Issue_ID" as part of an...

I'm trying to create a report in Access 2007 that will show all the comments that occured in the last 7 days. The comments field is a memo with the columnhistory method set, and what I would like is to only pull comments made in the past 7 days. I tried doing this, but just get an error...