Search results

  1. A

    Make the text in a textbox scrolling horizontally in a form

    I have made the textbox wider as the form width but it still its scrolling not to the whole width defind. I think its just scrolling to the total number of characters in the textbox .
  2. A

    Make the text in a textbox scrolling horizontally in a form

    Thanks Ridders, Its working now. The only thing is as I am trying to scroll project name (which has just few letters) on the form. so txtMarquee stores "Recorded Delivery System" and it keeps on scrolling in a small place .. i want it to scroll from far right end to far left end so that its on...
  3. A

    Make the text in a textbox scrolling horizontally in a form

    Hi Ridders, I have tried the same code. Infact I have put a button named cmd10 , a textbox named txtMarquee and a label names lblflash but the text is not scrolling on the form.Please see below the code I have put on the HomePage: Private Sub cmd10_Click() ResetDisplay...
  4. A

    Make the text in a textbox scrolling horizontally in a form

    Ridders, its not working foe me. Text is not scrolling on the page . I have written the following code on Homepage: ResetDisplay MinimizeNavigationPane 'Sets the timer in motion for case 10 - scrolling text N = 10 Me.TimerInterval = 100...
  5. A

    Make the text in a textbox scrolling horizontally in a form

    Yes I want this on the home page. How can this be done? Thanks
  6. A

    Make the text in a textbox scrolling horizontally in a form

    Hi Guys Just want to try something new in Access , to scroll the text horizontally in a form. It could be project name on the home page or any information in a textbox that keeps on moving across the form. Can this be done? Any help would be much appreciated. Thanks
  7. A

    Connecting databases stored in different networks

    guys i'm back again . I got some clarification of requirements now. Hope to receive some help from you guys on this: Company A: has got Access front end and backend linked together . ' Not sure of this middle layer (is there anything like email fiunctionality that will send data from company...
  8. A

    Make a file read only when stored/opened from access database.

    Ridders, I can't see security option in folder properties. I think this is hidden because of security restrictions at work.
  9. A

    Make a file read only when stored/opened from access database.

    Ridders , The code i posted in my 1st post does the following things 1. Makes a copy of the file selected in a secure folder . 2. Opens up the file when double click event occurs on the listbox from the secure folder. The only thing i want to do is make the file read only when its copied to...
  10. A

    Make a file read only when stored/opened from access database.

    What if i need to write down the vba code to open the file as read only when double click event occurs on the listbox?
  11. A

    Make a file read only when stored/opened from access database.

    It could be any file like excel,word document ,pdf or any scanned document. So how can i make them read only so that users are not allowed to edit the data ? Thanks
  12. A

    Make a file read only when stored/opened from access database.

    I am writing the following code to link a file to Access database. The link gets stored in the table and also appears on the listbox but when i double click on the listbox to open a file then it is opened in a compatible mode . My question is how can i open the file in read only mode? Following...
  13. A

    vba code to print off the files stored in listbox

    Or i can save a word document somewhere with merge fields which can be opened,printed and then closed and then the files get printed ?? can this be done?
  14. A

    vba code to print off the files stored in listbox

    Arnelgp , thanks for getting back. It will be nice to create word document on the fly? Word document basically is a header page that gets displayed before the files related to that Activity ref get printed. So basically create word document and display Record ID (ActivityRef), Form name...
  15. A

    vba code to print off the files stored in listbox

    Arnelgp, any update on this?
  16. A

    vba code to print off the files stored in listbox

    Arnelgp, to ellaborate please see attached my table. So I want to buid a form so that when i click print button then it checks ActivityRef and FormRef in the table . The table can have same ActivityRef more than once because that means more than 1 file is attached to that ACtivity Ref . SO...
  17. A

    vba code to print off the files stored in listbox

    Another functionality I want to add with this is print off a word document that will display "Form Name", "Unique Reference " , "File names attached". This word document needs to be printed before the files stored in the listbox get printed . Any suggestions are welcome . Thanks
  18. A

    vba code to print off the files stored in listbox

    I have changed the code as below and it started printing Public Sub PrintAnyFile(ByVal strPathFile As String) Dim TargetFolder Dim FileName Dim ObjShell As Object Dim ObjFolder As Object Dim ObjItem As Object Dim ColItems As Object If InStrRev(strPathFile, "\")...
  19. A

    vba code to print off the files stored in listbox

    Also I just found out ObjItem.Name contains the file name without extention anf Filename stores the name of the file with extenstion . I amended the code below to display what values do they display and that's why its not printing For Each ObjItem In ColItems MsgBox "Object name" &...
  20. A

    vba code to print off the files stored in listbox

    I amended the code as below and it displays "Hello" message . For Each ObjItem In ColItems If ObjItem.Name = FileName Then ObjItem.InvokeVerbEx ("Print") Exit For Else MsgBox "Hello" End If Next
Back
Top Bottom