Search results

Great!!! Thanks a lot!!!

Hi All, I have a text box. I want to display "First Word" and "Second Word" in two separate lines. If I use Chr(13), it simply adds a small box between the two words. Is there any way I can have them on two diff lines. Thanks in advance, Jatz

Thanks Pat, I used a function to get my job done. But i'll definitely learn normalization to make my software more efficient. Regards, Jatz

Hi All, In order to determine the minimum value for a field in a table, we can use MIN() function. BUT, is there a way that I can find minimum value in a particular row of a table. For Eg: I have 5 date fields in the table & for each row I want to display minimum of all these dates. Thanks...

Hi all, Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop? I know how to do for the files in explorer, but can't figure out how to do from outlook. Thanks, Jatz

can somebody pls help me Regards, Jatz

Hi All, I have a access code that is working fine on 5 machines. But when i try to run it on my 6th machine, I get all kinds of errors, such as : "The expression On Click you entered as the event property setting produced the following error: Sub or Function not defined" Similarly I am getting...

Hi All, Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window. Thx, Jatz

Thanks Mikk, I used Microsoft TreeView Class on form to get my job done. I used two panes - one for the Folders & one for the files thanks all, Jatz

Try the following code: File = "c:\temp.xls" If Shell("excel.exe " & Chr(34) & File & Chr(34), 1) then ' Success else 'Failure Msgbox " error opening the file" endif

Actually I am writing an Access application that will store links to all the files in a particular folder. In adddition to storing the links, I want it to save information such as "Last Saved by" or "Author". the files could be any file (text, excel, word, mdb) Thanks, Jatz

Thx for the reply, BUT FSO does not have the function to extract the "LAST SAVED BY" data. It can extract most of the other data such as "Last Saved"..... Thanks, Jatz

Hi All, Is there a function using which the "Last Saved By" attribute of a file can be determined? Thanks, Jatz

Hi All, Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form. Thanks in advance, Jatz

Hi All, Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form. Thanks in advance, Jatinder Kalsi

Hi All, Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form. Thanks in advance, Jatinder Kalsi

Hi, I am trying to email a table in text format using : DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts" It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple...

thx a lot Jon.... its a great solution & works great !!!

Hi, Is there any access formula that can calculate the net business days between two dates. Regards, Jatz