Search results

Hi Guys, I am tryingto get a split form to filter from a drop down and have tried various ways to get it to work but just cannot seem to work out what I'm doing wrong. The issue is on the form called 'Courses Completed'. I get a VBA error. I have done some extensive Googling but whatever I...

I'm using the following code to try and get an unbound combo to filter a split form: Private Sub filterCombo_AfterUpdate() Me.FilterOn = False Dim strFilter As String strFilter = Me.filterCombo.Value Debug.Print Me.filterCombo Debug.Print Me.FilterOn, "[Course Name] = " & strFilter & ""...

Hi Guys, I've been getting some help on this code from Stack Overflow but work doesn't let me acces that site. My code is as follows: Public Sub CloseAllExcel(Close1 As Boolean) 'On Error GoTo handler Dim xl As Excel.Application Dim wb As Excel.Workbook Dim strPath As String...

Hopefully a nice, easy one: Private Sub Toggle183_Click() Do.Cmd.OpenTable ("Baseline") Do.Cmd.GoToRecord actable, "Baseline", acNewRec Table![Baseline]![Select Baseline Month] = Forms![Baseline Hours]!newRecordName DoCmd.Close actable, "Baseline', acSaveYes Me.newRecordName = "" End Sub...

I have had some help building the following query: SELECT [RICT Weekly Baseline].[Week Ending], [Open NPS Tasks].[31 date], Sum([Open NPS Tasks].[Total Effort]) AS [SumOfTotal Effort] FROM [Open NPS Tasks], [RICT Weekly Baseline] GROUP BY [RICT Weekly Baseline].[Week Ending], [Open NPS...

What is the correct syntax to validate if a date has been duplicated in a table? I know I can't set the index as no duplicates as the date is also seen as a time. I only care if the date is repeated, not the time.

I have setup the following query: RICT Month is a date set as dd/mm/yyyy (e.g. 01/12/2016) while Week Ending is the same format but as the label suggests is a week ending date (e.g. 10/12/16) The above query is not returning anything. but if I leave Week Ending out I get the following: As...

I am using the following to update a field: Private Sub RICT_Month_AfterUpdate() If Not IsNull(Me.[RICT Month].Value) Then [RICT Month].DefaultValue = "#" & Me.[RICT Month] & "#" End If End Sub 1. How do I make it see the date as 1 August rather than 8 January? 2. When it carries over how...

I'm trying to add [RICTweek]![NPS Per Week] to the query [Weekly Predicted Effort] but as soon as I do it throws all the sums out. Is there a way I can add this column so I can graph it? Thanks!

I have a table called RICTweek and am trying to multiply by a value that I queried from another table. It looks like it is multiplying by the ID number rather than the returned value. How do I get it to multiply by the returned value? A second question on the same table; how do I make the...

Hopefully an easy one - why on my yearly planner form is the DSUM working in some fields and not others? The formula is essentially the same all the way down. Thanks guys.

Hi Guys, I'm trying to make a query (or formula) that will show the total effort expended each week for 52 weeks. I have 2 fields I am interested in - [Total Effort], [31 date] which are part of table [NPS Tasks]. I plugged in the following into a form field - =(DSum("[Total...

Hi again, I'm using the following expression in a query: Expr1: (DSum("[Total Effort]","[Scheduled NPS Tasks This Month]")) Problem is, when I go to graph it I get told it is not seen as a number and only comes through as 1 (it is considerably larger). How do I make it so the...

A bit of a funny one. I have a form where number of hours forecast (hoursF) and number of hours used (hoursU) needs to be added to a table each month. What I would like to do is have Access add the records for me automatically. Ideally, each month a record would be created with two fields...

Hi Guys, I am running the following in a calculated field: IIf((([Today]-[Start Date])/(([Due Date])-[Start Date]))>1,"Failing",IIf([Amount Complete]<(([Today]-[Start Date])/(([Due Date]-28)-[Start Date])),"At Risk","On Track")) The actual formula works fine but the issue I have is...

I have this code giving me a runtime error 2501: Dim outputFileName As String outputFileName = CurrentProject.Path & "\" & Format(Date, "yyMMdd") & " SE Region Project Status Report Summary" & ".xls" Debug.Print outputFileName DoCmd.OutputTo acOutputReport, ActiveReport, acFormatXLS...

Hi again fine peeps, I am having my first real crack of VAB within Access to export and format Excel. My current code is as follows: Sub ExportToExcel() Dim xlApp As Object Dim xlSheet As Object Dim oBook As Object Dim stamp As String stamp = Month(Date) & Day(Date) &...

Since my last thread I have another question. Is it possible to have Access automatically calclulate the amount of checkboxes selected? I have a feeling it has something to do with grouping but really am not sure. As a follow-on to the above; is it possible to do conditional formatting in...

I hate being new to Access! Anyway, I have downloaded the Task Management template from within Access as it is very close to what I want but I do need to alter it a bit. Anyway, I managed to add some tabs to the Task Detail form and that's where I got stuck. I am after a few things: A pic...