Search results

it is not showing new form after saving .& also I think it works only if the changes are made to the form ,but I need to open a new form even when no changes are made to the form. Other wise I have to keep another new button ,which I don't want to.

I've written a small code to save & new button , but unfortunately it is not working. Someone please help me. #Private Sub cmdsavenew_Click() If Me.Dirty = True Then If MsgBox("Do you want to save the changes for this record?", _ vbYesNo + vbQuestion, "Save Changes?") = vbNo Then Me.Undo Else...

sir in this video it is showing sending a particular record to particular recipient or recipients .this I have already done. my requirements is : * if my 1st column in report has 2 locations say a and b it should send mail to their department heads (stored in dept heads table,1st column location...

sir, I Do not have nay code

Sorry for the typing error.. It is "I have to send".

sir , I have send one email with 4 recipients in the "TO"....

dear all, i have a table with 2 columns , 1st is status , 2nd is total qty . I now want to update the total qty of each status month on month manually. i there any way to update automatically is either a new table or report.

Dear all, I have two columns in my dept heads table ,1 is the location & other is their email id . Now in my report I have three columns,1 is location & 2nd is task name , & the other is task due date . now i have written a small program to send a mail if any one of the location is set...

dear sir , it is saving but it is showing new record after saving, Private Sub cmdsaveandnew_Click() If Me.Dirty = True Then If MsgBox("Do you want to save the changes for this record?", _ vbYesNo + vbQuestion, "Save Changes?") = vbNo Then Me.Undo Else...

it is not saving any changes & not displaying new record..

thank you so much sir....really it meant so much to me.

can anyone pls tell me how to save my report automatically in xlsx format every 7 days??

in this below code ,only equipment date is updating but not the other two, could anyone kindly solve this?? Private Sub cmdReminder_Click() Dim RS As DAO.Recordset Dim strMsg As String Set RS = CurrentDb.OpenRecordset("select * from (" & Me.RecordSource & ")", dbOpenSnapshot...

form my save a button I have written the below to show a notification & then save code but it is not working , pls suggest me the correct code: Private Sub cmdsave_click() If Me.Dirty = True Then If MsgBox("Do you want to save the changes for this record?", _ vbYesNo + vbQuestion...

dear sir , sorry the equipment number is listing & showing according to criteria(only of this week) , but agency and due date is showing same as first row.. what to do??

Dear sir..thank you so much... don't mind asking questions as all you are rendering your valuable time for me. 1.yes it will be like exactly what you said(sometimes 5 days behind too!) 2.i want list of the due for the week(equipment name, agency name,due date) 3.s it is for button click event...

Dear Sir, Will it work even if there are multiple items?

I have a query table and report (agency due)having three columns, equipment name, equipment calibration agency and due date. How to get notifications or message box saying"you have to send this [equipment] to this [agency] this week".as soon as I click reminder button? kindly give the code...

Dear sir thank you for your help, My Database is almost over now as I am a beginner I really appreciate your help and support. Can I save this report automatically week on week in my desktop?

dear sir one more doubt , if my report include both the location say "location brief" & "qc-wires", will it send to both of them ?? if not kindly suggest me a code syntax. Thank you,in advance for your help.