Search results

I have a form in Access 2007 with an "On Got Focus" procedure that is supposed to store the current value for a field. Private Sub with_group_GotFocus() Stop Dim OldGroup As String OldGroup = Me.with_group End Sub Then, the after update procedure is supposed to take that old field value...

What I am trying to do is find the last record in tblWithGroup that corresponds to the Issues table to put an end date on it. So the steps that this function as a whole should be are: 1: put an end date on the last record. 2: Add a new record to tblWithGroup that will a: Set the Issue_ID...

Thanks...I am looking into that, and tried this: Dim GID As String GID = DLookup("ID", "tblWithGroup", "tblWithGroup.Issue_ID = ID") But I get Invalid use of Null?

How would I set a variable to a field that is in a table not controlled by the current form? The form I'm trying update is controlled by the Issues table, and I need to grab tblWithGroup.ID as string GID Problem is, the Issues table also has a field called ID...so when I set the variable to...

I think I actually may ALMOST have it. I had to rethink my logic quite a bit. How do I state a WHERE clause in VB? I want to say Where Issues.group_ID = tblWithGroup.ID set the end_date to date() But apparently in VB, you can't just do "Where" Here's what I have... Dim rs As...

the tblwithGroup structure is this: ID = AutoNumber (PK) Issue_ID = Number (foreign key to Issues table) Group = Text (links to Group assignment from Issues table) Start_date = date/time Short format End_Date = date/time Short format. the Issues table fields that come in to play are: Group...

Like I said, I'm a hack programmer, and most of what I have been able to create is from reverse enginering existing code in my current, and other database. So sorry if my explanations and code make no sense, I'm trying to learn it!

Ok, let me try this again. Sorry for the confusion! I need to track the amount of time individual groups work on projects. I have 4 groups, Group 1, 2, 3 and 4...when Group 1 is assigned the project, I need it to set the date Group 1 was given the assignment. When Group 1 passes it off...

I am trying to track projects as they get moved from responsibility center to responsibility center, and eventually run totals on "total days assigned" so we can start to trend where bottlenecks are, and which group has issues for the longest period of time. (the DB is an Access 2007 DB) So...

Currently the status field is set to Text, as a combo box value list...and then the row source has all the statuses...you are saying there's a more efficient way to do it?

Is it possible to have a field only show in a report if it is not null? I have a report that I want to show the closed_dt field, only if a system has been closed. For all open issues, I don't want to have the field show at all. Just wondering 1: if this is possible, and 2: if anyone has any...

Awesome! You have saved my butt several times! Thanks!

Now I know how to Bang! :-) If I wanted to change it up, and say If me.status = "Closed" OR "Unfunded" OR "Cancelled" How would I do that? Do I do this? If Me.Status = "Closed" Then Me.Close_dt = Now() End If If Me.Status = "Unfunded" Then Me.Close_dt = Now() End If IF Me.Status =...

Yup. That did it. I also realized that while close_dt was in the table, it wasn't on the form, and it kept giving me problems until I added it. Thanks for the help!

I forgot to mention. The other thing I want it to do, is If Status <> Closed set close_dt to Null. So, if a project is reopened, it will delete the closed date. (I need to get part A working first.)

I am trying to write an If statement into the VB event procedure in Access 2007 for a field called Status on a form called [Issues details]. What I would like, is If the status = "Closed" Then Set the close_dt in table Issues to Now(). Both Status and Close_dt are in teh Issues table, but...

Thanks! Where you have Forms!, since I am running reports, I assume I want to change that to Report and MyReportNameHere correct? Or is the first instance of ID calling the report ID, and the second is the Form ID?

OK...I officially hate Access. :-) This is what the Macro starts with before I start messing with it: Full Details, Report, , , Normal So I tried "ID = '" & me.ID & "'" in the where condition... I, being naive and full of hope, hit RUN! and it says WTF are you talking about? What is...

Thanks, I'll take a look. I have a LOT to learn about how DBs work, and stuggle with the normalization and not repeating data! Thanks for the link!

First off, I apologize, but I am not adept at Access 2007 yet, and am still fumbling through some basic tasks, BUT...I have a report setup called rptFullDetails that contains all the information I want to report on. I put a command button on my Issue Details form that will load the...