Search results

I have a report that aggregates information on an individual from a table. Basically the report has three columns, each is averaging information. Column1 *If assessment type field = "Lead", average score field values Column2 *If assessment type field = "Self", average score field values...

Hi guys, I have a simple IF statement that combines First with Last names: IIf([PositionIncumbentLastName]<>"",[PositionIncumbentLastName] & ", " & [PositionIncumbentFirstName],"Vacant") How would I modify this to check if Last Name was empty, or First Name was empty, to only take the other...

Hi guys, I have a form that goes (in simplified way) something like this: Field1 - Position Field2 - Option1 Field3 - Option2 I know this is not ideal but constraints force me to do it this way. I want a rule that basically turns my field red if Option2 has the same value as what is in...

MS Access Database engine does not recognize " as a valid field name or expression? Hi guys, I have a report, pulling off a crosstab query that works fine for awhile, and then stops working and throws this error: "the microsoft access database does not recognize " as a valid field name or...

Hi all, I have a report like in the screenshot below and would like to add a sum row below each Candidate Grouping level to show a roll up of their +-. I want to achieve something like the grey shaded row in my screenshot, is this possible? I managed to get this working for the Assessed Score...

Hi guys, I have a report that shows a gap score between desired score and expected score. Negative values indicate they are not meeting expectation, positive means they are meeting/exceeding. Is there a way to add a + symbol before positive values so that they line up with negative values?

Hi guys, I have a query running with the help of some helpful people on this forum, but it is not in the format my users want. Is it possible to change the layout to the way I have diagrammed? Thanks!

Hi guys, I have read a very good guide here http://www.fontstuff.com/access/acctut10.htm I think I fall into scenario 2. I have tried putting this code into the AFTER UPDATE event of the "parent" combo box: Private Sub Position_AfterUpdate() On Error Resume Next Slot1.RowSource =...

Hi, I have a table that houses employee evaluations. There can multiple reviews per employee (from manager, colleagues, etc.) but I only want ONE per person to be able to be identified as Lead Reviewer. This is in it's own choice field, called Review Type. How would I do this?

Hi guys, I have a standard duplicate button on my form which works well. However, this form has a subform. Is there any way to create another button on the page that would populate the subform with "placeholder" data. This data would always be the same 10 records and i'd want the score to...

Hi guys, I have a form which currently allows me to pick from a Combo Box from a list of candidates. When selected, if they have a record in another table, it will show those records in the subform. Problem is that subform has LOTS of fields, some of it is tombstone data, the other is...

Hi guys, I need help with the Validation Rule expression. I have a table like follows: ID Position (lookup to position table) Slot1 (lookup to employee table) Slot2 Slot3 In the field "slot1" I want to lookup a name of a person in the Employee table, but ONLY IF, in a third table...

I have some tables in an Access database linked to SharePoint. Is there a way to automate having to right click on each table and refreshing the data? Thanks!:D

Hi all, I want to keep my users out of the Access tables as much as possible, and instead keep their interactions with the forms. That being said, I'd like someone with more experience to give me some guidance on best practices when it comes to form design. What is the suggested approach when...

Hi all, I am going to be setting up an Access DB with linked tables into SharePoint. I want to be able to setup data macros but came across this note on a Microsoft page: "Data macro logic only works with local tables; not linked tables although you can work around this when you are using an...

Hi everyone, I have an HR scenario here and wondered how experts would approach it. Suffice to say I am using Access on the back end (to be used by HR admin) and SharePoint on the front end (to gather data from users). SETUP -Let's say I have a table in Access which has a list of the positions...

Hi guys, I have looked and looked and seen various threads like this but none that really answered my question and I want to determine if i'm doing something that is not recommended in some way. I am doing a simple mockup of an HR solution where I have two simple tables: -Positions (where I...