I would like to add a pop-up Message box that happens in this code after the DoCmd.RunCommand acCmdSaveRecord.
"Do you want to return to the TSL?"
If Yes then then DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal
If No then the DoCmd.GoToRecord , "", acNewRec command
Any help is...
i have a control button named "button 61" and a macro is assigned to it, within that macro there is a code : Worksheets("4_Lift Plan").OptionButtons("Button 61").Visible = False which esentially tells to make this same button invisible if certain condition is met and when i run it there is error...
Is there a way to move the selection to the second column of that same row.
Like if the selection (target cell) is lets say column H32 then I would want the code to make the selection to B32 or if the selection (target cell) in on A15 then i would want the code to make the...
In my data, I get only the date-of-birth. I made a formula to get the age- =INT((TODAY()-C276)/365) and then I
make an age category: =IF(D2<12,"Child",IF(D2<18,"Adolescent","Adult"))
The summary data is done by the pivot table so I show all therapy service hours by age cat.
I would like to...
I have created a multi-sheet workbook with several VBA codes running and I want to make sure people can't mess it up. Is there a way to make sure people can only input information into certain cells and run the codes from the buttons?
i have a formula "=MIN(D5:SJ5)" but D5 starts at 11/02/17.
Now I gotta change it to 11/01/18 since it's a new fiscal year for us....is there a way to make this dynamic? that is, make it such that I dont have to manually look for where 11/01/18 (which is currently cell IS5) and change the...
i know veritfically (ie offset($a$1,0,0,counta(....)
but how do you make one horizontally for 2 rows.
also, is it possible to make a dynamic range formula that expands BOTH veritically and horizontally?
I have been looking for my original post or the post that I think I thought was mine but was someone else's.
Anyway, we have an access tool that someone else built. Each day I press a "Run All" button and 20 mins later I finishes and I continue. We are trying to have this run automatically a...
I have a sheet where I have a checkbox that is entering TRUE or FALSE into a cell. For some reason I can't seem to get those values to control the conditional formatting for that row based on those text inputs. I have a rule already setup when that cell contains "n". Is there a way I can...
I am looking for macro to do the following
Input numbers into one specific cell and get a running total in a different specified cell.
This is for a scoring sheet where the result gets displayed on a monitor. it would make the computer operators job easier if the figures could be entered into...
If i have a series of numbers as per the below, how do i make the lowest value return a 0?
A1 - 25
A2 - 36
A3 - 14
A4 - 20
A5 - 6
In B1:B5 i need
B1 - 25
B2 - 36
B3 - 14
B4 - 20
B5 - 0
I have an exported excel file from MS ACCESS that is fine but some don't have email addresses, But they are all the same that is, Lastname. (put in a '.')Firstname@dcf.nj.gov
How can I make a formula that will do this?
Lastname Firstname email
Smit Joe currently...
Using Excel 2000</SPAN></SPAN>
To get final result in the column K, I am using 2 more formula in the column E & G, please can someone make a single formula in the column K. </SPAN></SPAN>
<b></b><table cellpadding="2.5px" rules="all"...
If I have numbers in a cell "1294392393", I want the 4th from the right side (the thousand number), I want a "color/border" on the whole columns.
"1294392393" = 12943393 ----- the nr "9" shall make a color blue on the whole column.
In a row below the "12943" = 1943...
I'm brand new here, and I just joined a few minutes ago. I work at a prison work release and we have to sign prisoners in and out of the facility, and sometimes it gets pretty overwhelming. When you work 12 hour graveyard shifts, it's kind of hard to convert, calculate and subtract...
I have a list of stock codes in randomised say A's ( out of order) , then B's etc and want to convert it to a
strict A--Z list
within each letter
in other words, make it a proper A--Z list
can some assist please