Recent content by stephaniem

Re: Create a count of records that were "open" during a given time period in the past Problem solved. Just wanted to give an update. There are a bunch of loops involved. There are some projects in our database where the EntryDate isn't populated (not my doing, whoever designed the...

Finally tried about everything I could think of and this worked DoCmd.OpenTable "TableName", acViewPivotChart For some reason, it really didn't want parentheses.

Really can't... a lot of it is intellectual property with Product Development. I know, that would make life a lot easier.

I was trying to avoid that, since it has to do with another post on here. But, I'll give it a shot. I plan on going back to my original post and posting what I did, but I had this hiccup. ----- I have two recordsets. One has all of the records with a classification of "Development" and "New...

Trying to open a table I have populated through code... Cant figure out why it is snarking at me that it wants an = sign for this command? DoCmd.OpenTable(strTable, acViewPivotChart, acEdit) Anyone have an idea?

Re: Create a count of records that were "open" during a given time period in the past That was helpful, but how do I work that into a loop where it repeats for every month between the given date range? For example, for the entire year of 2012, I want to see a breakdown by month of what...

Create a count of records that were "open" during a given time period in the past I posted this in the "queries" forum, but I'm thinking it's going to need some code work and you guys are the best: Here's the setup: This is a DB of product development records. The date the project is first...

Here's the setup: This is a DB of product development records. The date the project is first entered is stored, as well as every date that an update is made. There is an open/closed flag on each record as well. I need to create a trend chart that will show how many development projects were...

Ugh. I didn't use the NewData to populate the Division... New problem though, is that it is creating 2 new records. One has the Company and Division filled in correctly, and one has the Company blank and the Division filled in. Stepping through the code doesn't show it going through twice...

I attached the zipped file. It is scrubbed of most of the data, but the menu gives a good idea of some of the things it will be doing... I will look into some breakpoints, while you look at this. One of the Comboboxes is still called Combo2, I changed the code to Company, but hadn't...

Private Sub Division_NotInList(NewData As String, Response As Integer) Dim Db As DAO.Database Dim Rs As DAO.Recordset Dim Msg As String Dim NewID As String On Error GoTo Err_Division_NotInList ' Exit this subroutine if the combo box was cleared. If NewData = "" Then Exit Sub '...

I added the "Forms!", but it comes up with the "NotInList" standard error after I say I want to add the Division. Testing the form shows that it adds a new record with the Company field populated correctly, but the Division is still blank. Any ideas why it would accept the...

Hey all. I am trying to use a form to search/add records. Using a combobox notinlist event, if a user enters a division that does not currently have a record in the database, the code should ask if they want to add it, and then take the data from the form and create a new record. I get an...