Search results

Hello, I searched but didn't find exactly this. I have a query that should show me this: Customer Location Division Corp_Parent xxx.........xxxx.......xxxxx....xxxx yyy........yyyy..................yyyy zzz.........zzzz aaa........aaaa..................aaa...

Hello, I have multiple columns that look up values from othe tables, but I need them to be dependent, as: I have these tables: corporate division location Individual_Customer After a corporate parent is selected in that column, only a handful of divisions should be available. Then after...

Hello, I have a web database in which one of the tabes has a number of events related to each employee. I would like to show a report of all events for any employee, by allowing the user to select Employee from a drop-down box. I can't figure out how to allow filtering in a web query? Or...

Ok, I have the macro up and running well. It works on insert (new rows) as well as update of existing rows. However, I'm having a little trouble with reverting to the old value if a value is delete. Let's say a new row is intered because a promotion is supposed to happen, but for some...

Ok, I have a marco in SalaryChange table to write the new value to the TeamMember table. I also entered an AfterInsert macro in the SalaryChange table to run the macro when a new value is entered. At this point, it would not let me enter new records in SalaryChange table. Which has me...

Can anyone help with this data macro to pull the latest value? I haven't been able to make it work still, and I need to have it up and running today. After I get the macro to work I have to do the same thing for other properties, and generate all the reports, etc. Thank you!

Ok, Here is what I have as a macro (attached as image). As I understand it, when the TeamMember table is opened, that field would set the field Current_Salary to the first value in the SalaryChange table which has an TeamMemberID matching the row in the TeamMember table. So as long as the...

It looks like this might be the right thing? I'm going to give it a try now and see. http://blogs.office.com/b/microsoft-access/archive/2010/03/02/access-2010-data-macros-to-create-aggregates.aspx I am having a little trouble following this, so if anyone has basic tutorial or anything, it...

Paul, I uploaded a screenshot trying that method, with my tables. I believe it's right but I could be wrong. Access tells me that this is not compatible with web databases. Is this right? If so, do you have a link to anything explaining "One is to use a data macro to keep a...

Paul, That mentions using the grouping column but there is no grouping in Web queries either. Is there a way around this or a way to still use it. I think keeping one table of all salary changes and one table of just the most recent change for each employee is the exact correct approach...

Is there any creative way to do this, with sorting or anything? Or some way to write the salary change as a new record in the tbl_SalaryChagnes and also to a field in the tbl_Employees?

Hello, I am using web forms for use with Access and SharePoint 2010. I need to write a form in which, when a user's new salary is entered, that information is stored as the user's current salary, but also put into a table as a salary change. (so that all salary changes can be viewed later)...

Chris, The issue that remains is you used the Max function to return only the last record for each employee. Web Queries can't use the total line (Max, Last, etc). How can I get around this and show the last record? Thanks, Alex

Paul, Web queries don't allow the option of using the "Totals" row in query designer, so you can't do group, last, etc. It seems there defiantely has to be a way to find the last record, as it would be a common requirement. I'm just not finding it. Thanks, Alex

Hello, I need to query the last record in a table in a web database. I cannot figure out a solution to this. tbl_Employees EmpID EmpName EmpPhone.... tbl_update updateID EmpID "applies to" EmpID "approver" NewInfo qry_LatestUpdate UpdateID EmpName (applies to) EmpName (approver) The...

Boyd, I will have to give that a try. Right now nothing is on a LAN. the SharePoint site is accessed via HTTPS. Is there any other way to share the back end, aside from setting up a LAN? I would use the Access Services built into SharePoint, but they don't allow for the Total/Group/Last in...

I want to publish the entire back end to a SharePoint document library. It would sit there on the server inside the document library. The users would have edit rights on the file. It would not be a web database, but a standard database hosted on the SharePoint site instead of a Windows Share...

I won't be using SharePoint Access Services. The back end will reside on the SharePoint site so that all users have access to it. But it won't be integrated into the site. The file will just sit there, on the server. Is that an issue? Thanks

I didn't see how to attach a sample DB. I see that now. Chris, That looks like exactly what I was trying (unsuccessfully) to achieve. I'll study that and see if I can replicate it on my own. This was a major hangup because I'm going to use the same procedure for change of jobTitle, change...

Ok, so I have qry_LastChange. This returns just the primary key from this table, along with the affected employee. the affected employee is grouped, and the key field is set to Last. This works, only returning the Key of the last change for each employee. The issue becomes getting the next...