Good Morning All.
i don't know whether it is logically possible or not but, what i am trying to do ..
i am making a dashboard for senior management and currently we are handling more then 150 clients. There is a specific location where all the files and folders are saved. A folder (org name)...
Hello All,
i am in dilemma for this thread from around more than an year. i already read http://chandoo.org/forum/threads/requesting-help-on-data-validation-based-on-information-from-a-different-cell.4529/#post-23667 link on chandoo.org website but sorry, my Requirement is little different...
Hello Luke!!
Sorry for delay...formula suggested by you works perfect :)... but just a slight confusion here.. should we use "<" function with lookup condition..or "<=" let eg,
Arrival Departure Room type Rooms
20-Jul-13 21-Jul-13 Standard single 1...
Perfect Luke... Thank you so much...Kindly suggest one more thing.. just add No of Rooms also..
Arrival Departure Room type no of rooms
17-Jul-13 18-july-2013 Standard single 4
17-Jul-13 18-july-2013 standard single 5...
just select the tab1.emp_code and drag the same to tab2.emp_code.. then you will be able to see the line, which called Inner Join.
https://www.dropbox.com/s/aiswifqwc4y8bed/Reservation_master.accdb
link is attached here. just open and try too read Booking_cancellation Query in Design View
Hello Jitendar,
You can apply vlookup in Access with the Help of Joins...Let me explain.. you have two tables with same fields (Vlookup criteria).. just select the field of 1st table and without droping match the same field in second table.
now, a join is exists and when you double click on...
Hello,
I am creating a booking engine module for a hotel website. As every hotel has defined number of rooms with defined room category, the concern is in checking the availability of a particular room type for a particular date.
The purpose of the module is that if a user enters arrival...
Thank you all for suggestions,
Thanks SirJB7..i was not aware about this option (search part). Will do it and if not get the appropriate result.. will get back to you
Good Afternoon all,
can anyone please suggest the VBA code to automatically create a master from another excel tabs. i dont have any idea regarding same. :(
Thanks to all in advance.!!
Gud Morning All,
i request you to please confirm whether it is possible to use pictures in automate email through VBA.
Many thanks in advance for same.
Good morning to all,
i have used below code for same... please suggest what should i change in same to get the picture download in automate mail body:
' Don't forget to copy the function RangetoHTML in the module.
' Working in Office 2000-2010
Dim rng As Range
Dim OutApp As Object...
Hi,
can anyone please suggest VBA code to automate mail that supports pictures also. a link is attached here in which i want add picture in outlook body well but its not supporting.
https://www.dropbox.com/s/98jk411zod6uea6/Ajanta%20confirmation%20voucher.xlsx
please suggest the code for...