Search results

Hello Everyone, Sorry for writing again, I really need it, and Do search on the internet and I tried with my best ablility, but unfortunately could not find the solution for that. There must be some one who faced to this problem or have the knowledge of this... plz some one help me

Hello everybody, plz anyone write the solution....

More Info for further information plz see the attached file...

Hello everyone, I made a userform named (frmEntry) and through this form I add my data into excel sheet. one of the colume is CODE. Want: When I click on the frmEntry SAVE button, I want to check for duplicate on column CODE Thanks all

Thnx for replying all of u, Yeah the, B17: B23 will have the days of the week which is selected from C4. also what I need else is F13, I need the F13 contains the next 20th month of the C13. Thanks all...

TimeSheet Thanks all of you, for further information you can have a look at the attachment,

for further information. I should tell u I am going to make a timesheet for the staff. actually the from 20th of the last month up 20th of the current month. and I have in list box (20/1/2007, 20/2/2007, 20/3/2007 ... 20/12/2007). What I want when the Staff select the 20/1/2007 from the list...

thnx again, I did what u say, also I use the formula =DAY(Sunday, March 04, 2007), but it gives me the Wednesday. The third of march is SUNDAY... But if I use =Day(Today()), it gives me the correct day WEDNESDAY...

Thanks for Quick Replying, I am using EXCEL, are u sure the Format works in EXCEL as formula?

Hello everyone, I want to get the DAY of the DATE like (Sunday, March 04, 2007 ), and I use the formula =DAY(Sunday, March 04, 2007), but unfortunately it return the Wednesday. but on some date it works correctly. Can anyone plz tell me How it is possible to get the exact DAY of a DATE.

Thanks Much, Yeah that is what I wanted. Thnx again much

Hello everyone, I want to have advanced search through VBA and I use the below code. "WHERE (tblPicture.PicDate) = (Me.txtDate.Value)" after the select statment, everything is ok, but it asks me for date (parameter) could anyone plz help me

Thanks very Much, Yeah that link was what I want. is it possible when we capture the Active Window, the Save dialog appear and we can save it where we want? Thanks in Advanced...

Thanks for the Replying, Ok. I will search on API, I dont like to use external tools. What I want is to do Screen Capture through VBA in M.S Access...Thanks again for the Reply

Hi all, Could any one tell me plz how it is possible to Have the Print Screen of the Current Form through VBA? not the whole window, just the current form snapshot... thanks in advanced

Hello EveryOne, Is there a way to take a snapshot of the Current Form through VBA? and save it where we want? Same as PRINT SCREEN does... Thanks in Advanced...

Thanks Much Yes, That is waht I wanted

Hello everyone, Can anyone plz reply me the above thread, bcoz I have the same problem. I want to have the file dimension the pictures in pixcels

Hi again, You said the easiest way to know the dimensions of the picture require you to import it first and then check its properties. How can I check the picture properties not the Image control Properties?

Thnx for replying, I Save the path of the photo into table, How it is possible to get the dimension of the photo after we enter it? I dont want the dimension of the Image control but I want the dimension of the Photo? Could u plz tell me HOW?