Recent content by Maggs

I know this is an old post but I have ms access 2016 and would like to try your form that replaces the navigation pane. Thanks

I decided that LeavingDate was not needed

Hi Galaxiom changed Name to Employee_Name and still the same problem

I have entered the following VBA in the on Current event. Private Sub Form_Current() cboEmployee.RowSourceType = "Table/Query" If Me.NewRecord Then cboEmployee.RowSource = "SELECT [Employees].ID, [Employees].[Name] FROM [Employees] WHERE [archive] = FALSE ORDER BY...

Hi Ridders I already have a boolean field called archive but I the LeavingDate is a nice touch that I could also use. Thanks

I will try what you have suggested Galaxiom as I think this is exactly what I am looking for

Hi I have a time sheet form associated with employees. The form uses a drop down list to select the employee. I want to the ability to hide old staff in the staff field for the time sheet but still have their name displayed in old time sheet records for when they were employed. When I change...

Hi I have migrated a access 2007 DB to SQL Server. The Access front end links to the SQL Server. In SQL Server the dates were converted to DateTime2 from Date in Access. In SQL Server the Date Time is shown in international format and in Access the same. Now the Date picker does not work. For...

Thanks Hi Plog Thanks a lot, the reports are populating with the correct data!! This is a short term fix. You did say that this was a messy way of doing things. How would you recommend that I proceed to do it in a "less messy" way. again thanks, I appreciate your help. Maggs

not appended Hi Plog At the moment the table in the first post is dropped and then recreated by using the query mentioned in one of the other posts, with the terms being separate as displayed. Data is not appended. The combining of Term1 into Term 3 data is just done once, that is after...

how did it get there Hi plog This table was populated from table called Assistance using this query: SELECT Assistance.Term, [SysRound]![Round] AS Round, Assistance.AreaID, Sum(Assistance.Encounters) AS TotEncounters, Sum(Assistance.AssistanceCount) AS TotCount INTO AssistanceTot FROM...

query instead of a table Hi After looking at the code and the report I have found out that there is no reason why this table could not be a query. so does anyone have any ideas on how to pull the required data as a query. thanks Maggs

Hi Plog The old data for term 3 will get cleaned out and replaced. This table was created from a query and then parts of it populate a graph in crystal reports. This table is used in several different reports. The query that creates this table is run at the start of each round so populates the...

Hi plog the final result go from: Term Round SourceID TotalEncounters TotCount 1 ____45 ____1 ___1200 ____________ 9 1 ____45 ____2 ___1200 ___________ 10 2 ____45 ____1 ____30 ____________ 19 2 ____45 ____2 ____30 _____________4 3 ____45 ____1 ___316 ____________ 10 3 ____45 ____2 ___316...

Hi I Have a table as below Term Round SourceID TotalEncounters TotCount 1 ____45 ____1 ___1200 ____________ 9 1 ____45 ____2 ___1200 ___________ 10 2 ____45 ____1 ____30 ____________ 19 2 ____45 ____2 ____30 _____________4 3 ____45 ____1 ___316 ____________ 10 3 ____45 ____2 ___316...