Search results

Hey guys not sure how to fix this one, if you look at the images I am trying to add a sub report for a staff list, but I need the background to be all blue. But it seems access wont let me change that, or I dont know how. This shows the report design: And a preview: If anyone knows a good...

Hey guys, this is the first time I have ever needed to make a sub-select query and my brain is having a hard time understanding what it is I am doing. I am following a tutorial found HERE As for my data I have three fields, fk_SupplierID, AuditStartDate and LeadAuditorAuditHistory I need to...

Hey guys, I will start off by saying http://www.access-programmers.co.uk/forums/showthread.php?t=208324 is very close to what I need. I have a form in my Access 2007 DB that manages filtering all my reports with VBA, as in creates a WHERE statment that I can filter the output with. Now...

Hey guys, I have a report that a user can filter with multiple sets of criteria the issue is that functions like =Count() will just look at the record set and ignore any filter I have. At the bottom of my report I have: ="Total Scheduled Audits: " & Sum("[ScheduleDateCount]") ="Total Completed...

Ok well, this is what I get for loosing my sample code file that holds all the nice sample forms that I find on the internet :( I am looking for a sample file I found back in 2010 that has a interface that looks like this: I know its a long shot but if anyone has an idea where I can get...

Hey guys, So I stoped by the Query section and spent a few days trying to figure out how to make a query that will allow me to count how many open records I have each month. That thread can be forund: http://www.access-programmers.co.uk/forums/showthread.php?t=214642 It might be a good...

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...

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...

I want to create a highlighted effect behind my check boxes, to do that I added a bunch of boxes behind them, then added a line of code to check if the checkbox was true and change the box color as needed. The issue is that it changes the entire colume of my continuous form when I only want it...

My current project requires that my database complies with 21 CFR Part 11, it is an FDA regulation for GxP projects. I wanted to know if anyone has experience with this type of project, as this will be my first one. Any tips on how to develop a database with this in mind?

Hey guys I have done Many-to-Many forms a few times with a previous database so I understand the basic concepts but I wanted to see how you might tackle this one. I have a standerd setup: tblCQA Field1 Field2 Field3 tblJoin fk_CQAID fk_COIID tblCOI Field1 Field2 Field3 I would like...

I have a form that lets my users run querys and email them etc. The issue is that when you open a query with no tabs in access 2007 you dont get any kind of close options. Any ideas?

This is a new one for me, I have a simple line of code to open a audit log DoCmd.OpenForm "frmAuditHistoryDetail_Audit", , , "[AuditHistoryID] = " & Me.AuditHistoryID.Value The button is found on a continuous subform, and just allows the user to see a audit history for the selected record...

I have a text box thats getting just a bit more complex than I like: ="REMOVED classifies audit observations as Critical; Major; Minor; and Comment as defined below. The audit revealed " & _ IIf(fTableRecordCount("tblObservation","WHERE [fk_QualificationID]=" & [QualificationID] & "AND...

Ok I dont have a clue whats going on with this, my code is below and the issue is that when I change records my enable/disable options start getting mixed up for some reason! After a while the fields might grey out even when they should be enabled, also sometimes the spit form will be grey...

Hey guys I have the code below that I created and it works great for checking if an exact date is in the table, but what I really want is to check if there is a record in the table that matches the year. I am attempting to do this with Datepart and Like. So I change If...

I just want to get a Date back when I run the following DoCmd.RunSQL "INSERT INTO [tblSurveillance] ([fk_SiteID], [Surv_Audit]) VALUES (" & Forms!frmMain_toplg!SubForm1!SiteID.Value & "," & #1/1/2000# & ");" But instead I get 12:00:43 AM I am sure this is simple, Help!

Hey guys, I have a Report form thats got all sorts of controls to filter reports the way a user wants to. I also have a lot of things that need to be hidden or shown based on what radio button a user selects. This is the code I had before but I know some of the changes i need to make in...