Can we give me the VBA coding to show the message "No record found " as I don't have much idea how to write VBA coding for my requirement.
Form name in my database: new_orders_sear ch_form
query name in my database:whole_ order_track_lis t qry
the concept is once i keyed in the data in new_orders_sear ch_form it will open up the query named as (whole_order_tr ack_list qry) based on my input . what I have done...
ESAKKI109
Last Activity: Nov 25 '14, 01:09 AM
Joined: Jul 15 '14
Location:
-
-
Hi Twinnyfo ,
thanks for the vba coding . I am not very much familiar with vba coding .but I understood the concept of your coding . my doubt is ?
Is this coding for Microsoft access2013 or MS excel ? because I don't know how to implement this code in MS Access2013 . where do need to implement these whether in MS access form or queries ??.
In my case (refer screenshot) what need is(exact wordings) throughput = RECEIVED_DATE...Leave a comment:
-
How to create message box when no records found in access form 2013
In the attached image if I give input in the search criteria form it will bring the result in the query format based on input I key in . Incase if no records found after hitting RUN button how can I bring up the message "Sorry,no records found " instead of showing blank records in query .
when I checked the properties of run button some macro is running behind it . So can we add macro program in addition to that to show... -
How to calculate number of workdays in access2013 query
In the attached image I was trying to calculate number of working days(throughput ) b/w item received_date and item_released date by using datadiff with "w" interval . but if I use "w" interval it brings value zero .but if I use "d" interval then it brings result with inclusive of Saturdays and Sundays.i don't need that.
so can you help me to calculate the number of working days exclusive of Saturdays and... -
Thank u all for your inputsLeave a comment:
-
Conditional formatting
Can we do conditional formatting in queries ? for example in the below image (customers query) can we highlight "owner" & "purchasing manger" with different color under Job title column ?
If yes, how to do it . ... -
I have created parent Form with subform without any coding . So let me know how to write coding to open a form with new record option as default.Leave a comment:
-
access form 2013:setting default record
In Microsoft access 2013 how can I set last record as a default without VBA coding and macro when form opens? -
Microsoft Access Form : Setting New Record
In Microsoft access 2013 how can I set new record as a default without VBA coding and macro when form opens? -
in the attached image can we do copy , paste and delete multiple names (ex:john,alex barry) at the same time under student name's column . If yes ,how can we do that .
becoz I can able to copy or delete one name at single time....Leave a comment:
-
Ya I am talking about Fileds in every record. I can able to copy,paste,dele te single Filed.Is that possible to copy,delete mutilple same fields in different records .Leave a comment:
-
Need Clarification Regarding Undo and Redo
{NeoPa}This thread is an offshoot of Need Clarification Regarding Copy, Paste, Delete Function. Separated because we only allow one question per thread.{/NeoPa}
Also can we do undo and redo if we deleted any row or column in access? -
Need Clarification Regarding Copy, Paste, Delete Function ?
can we do copy/paste/delete multiple cells in Access 2013 as in Excel.
{NeoPa}A separate question was split off to Need Clarification Regarding Undo and Redo{/NeoPa}
No activity results to display
Leave a comment: