Search results

Monday bump, I do have to ask, if this is truly easy can someone give me a little hint this is killing me and I need to find another way to calculate it if SQL alone cant do it.

You can upload .zip files http://www.access-programmers.co.uk/forums/showthread.php?t=212124

Sounds like one query is for a table on a SQL server and another is from directly in access. Thats the only way I have seen the value change, so thats a good question I am not sure.

DoCmd.SetWarnings False Just put it before the code.

Uncheck the box that says "Show" when your in the Query design view?

Ok it might be VERY easy and its my ignorance getting in the way, but we will see. I have two dates: AwareDate DateClosed I need to create a report that shows, by month the following: Received - A count of the inital date record was recived (this is just the AwareDate's month) Open - A count...

I dont understand how to get the query to count the values for each month. Currently it will just pile them all onto the first month, I need to spread out the values accross all the months. So if I get a value of 2.55 I cant group all those on Sept, I need to spread the values across Sept and...

I am getting the idea this may not be possible without VBA. Any thoughts?

lol, good point. I mean that I need to account for the days in the month. June = 30 days July = 31 days August = 31 days

Ok I see what your doing here, and I think its the direction I need to take. Now the math is much closer but we still have an issue, if I do it this way it will count up the value and add it to the first month it was over 30 days. I need it to spread that out so its one for each month...

Sorry I tried to think of a good subject :) I have the query below and it works fine SELECT Format(DateAdd("d",[AwareDate],30),"yyyy/mm") AS AwareDatePlus30, Sum(IIf(DateDiff("d",DateAdd("d",[AwareDate],30),[DateClosed])<=0,0,1)) AS [AwareDateOpen>30Count] FROM qryCQA GROUP BY...

Well just as the subject says I want to compare rows of data to see who made the changes. I have a audit log that saves any change and tracks who did that change, the issue is that my users are not going to be able to read that data very well. What I want is some VBA to analyze the data and...

I have a Access project that has lots of tables with relationships etc. The company I have been contracted out to is looking to lower its staffing, so I need to cut my access project very short and make it a Data Entry/Data Export system. Anyhow I need to find the best approach to Export all...

The code runs from the NotInList event. I will see what I can do about posting the database, I need to modify it a bit before I can post.

So I have made all the requested changes but I am still running into the same issues. Code will run asking if I want to add in the record but as soon as its done it tells me that the record selected is not in the list and nothing gets added to the tables. Anyone?

Ohhh, I never thought about that! I was only thinking about the two main tables. I will work on the change and post back. :D

You might be correct but let me point out why its there. I need to let my users select all the related COI's, like you see in the subform, but also they need to choose one thats the "primary" I will need to report on this etc. If you have a better solution I am all ears! I love learning...

You got it: Record Source for the Subform: SELECT tblQSCQAQSCOIJoin.*, tblQSCOI.ProductReturned, tblQSCOI.DateofManufacture, tblQSCOI.Cancelled, tblQSCOI.Terminated, tblQSCOI.MFGSiteOwner, tblQSCOI.Sterility, tblQSCOI.Released, tblQSCOI.Approved, tblQSCOI.Infused, tblQSCOI.Reported...

I changed SELECT to VALUES and still works for all other other fields except for this one darn Many to Many. I cant think of why I am not allowed to add a record to the table, I mean in my mind it should act just like the other tables regardless of the many to many setup.

So I have some code I use to add values to a combo box when they are not allready there. Private Sub cboCOI_NotInList(NewData As String, Response As Integer) Response = fNotInList(NewData, "tblQSCOI", "QSCOI") End Sub Function fNotInList(NewValue, strRecordSource As String, strFieldName As...