Search results

so i spent another 1 or 2 hours and found out that @isladogs ' function gives error when i use " in text. Public Function FormattedMsgBox(Prompt As String, Optional Buttons As VbMsgBoxStyle = vbOKOnly, _ Optional title As String = vbNullString, Optional HelpFile As Variant, Optional...

thank you, it helped !

so original stable which works fine is Private Sub CmdMap_Click() Dim strMessage strMessage = "Ensure both a Risk Code and a Location are Entered." If IsNull(Me.RiskCode) Or Me.RiskCode = 26 Or (Me.locationID & "") = "" Then MsgBox strMessage, vbInformation, "Required Fields" Else...

but i dont need this window \ pup up. let me describe it in another way. i would like: if l click on "map" it checks if RiskCode =0 or RiskCode=26 or Me.locationID & "", then msgbox "critical data are missed" if riskcode has some value from 1 up to 25 (can't be any different number) and...

hey guys ! so i have Private Sub CmdMap2_Click() Dim strMessage strMessage = FormattedMsgBox(DLookup("nonEnglishText", "Tmsgbox", "msgID=7") & vbCrLf & vbCrLf & DLookup("nonEnglishText", "Tmsgbox", "msgID=8") & vbCrLf & DLookup("nonEnglishText", "Tmsgbox", "msgID=9") & vbCrLf &...

it worked ! thank you very much !

so i have 2 continues forms and their data source is a crosstab query but one shows locations without specified records and another form - doesnt. this doesn't work for me , as those forms are in my main menu and both located next to each other and location data should be exactly next to...

looks like a wrong query was attached in record source. sorry.

so i have 2 union queries. 1. SELECT * from qryCountSiteActions UNION Select * from qryCountSiteOverdue UNION Select * from qryCountSiteStatusNew Union Select * from qryCountSiteStatusInProgress UNION Select * from qryCountSiteStatusCompleted ORDER BY 1, 3; 2. SELECT * from...

oh got it ! , just need to & in prompt string after dlookup ends

btw, if there is a way to move part of txt which is in NonEnglishText to 2nd line ? like & vbCrLf &

@isladogs thank you for your help, Sir!

oh.. .i didn't ! damn. i feel so dummy right now. now i did and everything works like magic !! thank you very much guys ! !

it was for standard got it now! thank you. for some reason it doesnt work for me... my data source once i remove the word "formatted" it works , but can't display unicode. so the problem is ... it just doesnt like when i add "formatted".

i thought it could read non-unicode... :(

Tmsgbox

i've looked at it and either i didn't find it or just simple didn't get it. isn't the simple way to do something like this ? If Me.DueDate < Date Then rtn = MsgBox(DLookup("nonEnglishMsgBoxTxt", "Tmsgbox", "ID=1"), vbOKCancel, "Verify Date") but for some reason it doesnt work

i would really like to take a minute and honorably thank @MajP this man has helped me so much. i would like to ask AWF reps to give him some kinda MVP. well , if u have such though :) thank you VERY MUCH @MajP. hats off. wish u good health to you and your family. there are so many amazing ppl...

hey guys, hope u r doing well today. i have a vba code with dialog pop up like If Me.DueDate < Date Then rtn = MsgBox("Due date is in the past. Verify this is correct. If correct select OK if not select CANCEL", vbOKCancel, "Verify Date") so i created a table how do i vlookup...

is there a way to make pup up goes in front of cell where i click instead of below? like if i click at 12 and this button pops up just in front of cell with 12 number x coordinates = y coordinates