Recent content by aubrey1983

Solved: 1) No, it can't be brought back. It can only be brought back if you recreate the view again. 2) Yes, but not the predefined action buttons (save,delete, add, cancel) 3) I did it by creating ui macros during the on click events and the On Current event of the view. to mimic the behavior.

Hi, I got 3 questions all related to action bar. 1) How do i bring the action bar back once i removed it. 2) Is it possible to link a macro once one of the button in action bar is clicked. 3) I would like to know how to copy the behavior of the save/edit/delete/cancel buttons in the action...

sorry, i haven't done it.

I see, i have not done so much development base from what you have. but have you tried using the Create Query in Design view? not the Web Query. not sure if that works for you, but after i tried using that, the Group by functions are available there. check the attachment.

Or lets just say, how do i default a value base from Username(UserEmailAddress)? I want to do this during the On Insert Event from the table. is this possible?

Thanks again. How about the other way around, from the UI macro variable, then i want to pass the values going to the data macro layer. is it possible?

For now i got the work around by using query This is by combining the two table together so the where clause will work properly, by using the field in "Short Text" data type, rather than the field in lookup data type. I hope there's a better solution. -Thanks-

I have two tables. 1st table, has the following fields: 1) EMP_ID (Autonumber, key generated by Access, which it cannot be removed or change) 2) EMP_USERN - employee username 2nd table, has the following fields: 1) DATA_ID (Autonumber) 2) EMP_USERN - Lookup field to table #1 3) EMP_HOURS -...

Hi, Try checking this video. https://www.youtube.com/watch?v=FdDlnLAGRvM hope it helps.

base from what i understand from your question, my quick fix here is to create two queries, first is to group by the two fields, create a dummy field that has a default value. then another query to group by the dummy field, then you can use a summation to count. hope that helps, if you have...

1) Setup these two fields as lookup fields 2) Use combo box as its controls and set the Parent Control property. this is where you relate the combo box 2 to your combo box 1. Hope that helps

I got it, what i need. Solution is: 1) Not to use Autocomplete but Use combo boxes instead. 2) Each combo box you can set the parent control data. There it is. it should solve it, it doesnt autopopulate it, but it controls the data combination better.

Yes, however for this one i want to implement in Access 2013 Web App. What are the steps?

Hi, just a quick question. How to setup a control(texbox or autocomplete or combo box) to auto populate its values base from another control's value. like there's a dependency between controls. -Thanks- Aubrey

Great! thanks, appreciate the details. it worked as you said.