Can Any body help please............
On Wed, Apr 14, 2010 at 9:27 AM, ayush jain <jainayus...@gmail.com> wrote: > ANju, It is better if you share your query with group.....not to specific > people. > > It will help you. > > BR, > Ayush Jain > > > On Wed, Apr 14, 2010 at 12:58 AM, Anju <anjulav...@gmail.com> wrote: > >> >> Hi Vikas , >> >> Its a split database & i ve attached both the front end and the back end. >> >> To access the database which i ve attached, if your computer name is not >> VIKAS then >> >> Start > Settings>Control Panel>User Account>Create a new account with Name >> Vikas >> >> >> >> *How it works :* >> >> Its bascially a workflow tool...Indexer assigns the request from the >> Indexer tab to the User..the user picks the request from the user >> view...view task allocated. (By double click on TP Doc No).. does the >> request, enter the details & update the status of request. >> And there are some reports created on this basis. >> >> *Issues :* >> ** >> >> - *When the *user double clicks on TPDoc a new form opens & on load i >> ve wriiten an event to caputre the time...(start time of the request) >> >> Me.label_user_id.Caption = UCase(brw_user_id) >> >> Dim db As Database >> Set db = CurrentDb >> mSql = "Update tblBookings set telex_started_date = # " & Now() & " # >> where telex_ref = '" & Me.Telex_Ref & "' and tpdoc_no = '" & Me.TPDoc_No & >> "' and User_id = '" & Me.label_user_id.Caption & "'" >> ' MsgBox msql >> db.Execute (mSql) >> >> >> >> But sometimes start time is not captured....i tried to debug but not able >> to find the reason why its happening.....???? Please help >> >> >> >> - Secondly m facing performance Issues....Its working quite slow >> - Also please looking into the coding and suggest any improvements can >> be made to enhance the performance and also let me knw if there is any >> flaws. >> >> Let me knw if you have any issues >> >> >> Like Hex Editor for Excel .....Can we crack the password for Access ? >> >> I wud request not to copy ur group id as the data is bit >> confidential...please >> >> Thanks to you in advance >> >> >> >> On Tue, Apr 13, 2010 at 10:18 AM, Vikas Chouhan <vikask...@gmail.com>wrote: >> >>> Hi >>> >>> Wht type Help u req in access (Query,Form.....) >>> >>> >>> >>> On Mon, Apr 12, 2010 at 11:47 PM, anju <anjulav...@gmail.com> wrote: >>> >>>> Can we use wildcards with instr function.....If yes how ? >>>> >>>> >>>> I also need help in MS Acsess ? Can u pls guide me to the right way >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our Facebook Group @ >>>> http://www.facebook.com/group.php?gid=287779555678 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,800 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> >>> >>> -- >>> One Team One Dream One Goal >>> >>> Warm Regards, >>> Vikas Chauhan >>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, >>> 9911868518, >>> "We can't Spell S_ccess without U" >>> >>> Life is Very beautiful !!! >>> ¨`•.•´¨) Always >>> `•.¸(¨`•.•´¨) Keep >>> (¨`•.•´¨)¸.•´ Smiling! >>> `•.¸.•´. >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our Facebook Group @ >>> http://www.facebook.com/group.php?gid=287779555678 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> > > > -- > Best regards, > Ayush Jain > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.