User Profile

Collapse

Profile Sidebar

Collapse
JAMBAI
JAMBAI
Last Activity: Dec 21 '10, 12:31 AM
Joined: Feb 15 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • WINWORD.EXE not ends in word 2007 when Embedding word document in OLE UNBOUND CONTROL

    Hi,

    I am using a OLE unbound Control to Embed the word document in the form load, event like this
    http://support.microso ft.com/kb/209990

    and When i double clicks (In Place activation), the documents gets activated (A WINWORD.EXE process is opened) and i can edit the document and in the button click event i am saving the document like this :

    http://support.microso ft.com/kb/132003

    and...
    See more | Go to post

  • WINWORD.EXE not ends in word 2007 when Embedding word document in OLE UNBOUND CONTROL

    I am using a OLE unbound Control to Embed the word document in the form load, event like this
    http://support.microsoft.com/kb/209990

    and When i double clicks (In Place activation), the documents gets activated (A WINWORD.EXE process is opened) and i can edit the document and in the button click event i am saving the document like this :

    http://support.microsoft.com/kb/132003

    and I could save the document....
    See more | Go to post

  • JAMBAI
    started a topic Continuous Form and Visual SourceSafe

    Continuous Form and Visual SourceSafe

    Recently I moved my MS Access Application (2007) into Visual SourceSafe(6.0) .

    The query based continuous form is not working if I pulled the form, from the MS Access Application that I moved to the SourceSafe. I don't have any option to add more records for the selected code. Please check the attached image. VssForm.jpg

    I've options to add more records if I open the form, from the regular version (Not from SourceSafe)....
    See more | Go to post

  • JAMBAI
    started a topic Open OmniForm from VBA

    Open OmniForm from VBA

    Hi,

    How to open an OmniForm from MS Access Form.? And i need to populate some values on the OmniForm from my MS Access Form.

    Thank you
    Jambai
    See more | Go to post

  • JAMBAI
    replied to VBA Shell in Microsoft Access
    The one I said in the second post is my requirement.

    Appologizes for the confusion.

    Thank you
    Jambai
    See more | Go to post

    Leave a comment:


  • JAMBAI
    replied to VBA Shell in Microsoft Access
    Ok,

    When a form (frm1) is opened (say in Customer.mdb) I am sending a email web link to a supervisor. When the supervisor clicks that link, i am updating a field in the database and showing the same in that opened form.

    I have to give an option in the form to open the same application (Customer.mdb), so that the user can work on something else till the supervisor clicks that link. There could be chance for the user...
    See more | Go to post

    Leave a comment:


  • JAMBAI
    started a topic VBA Shell in Microsoft Access

    VBA Shell in Microsoft Access

    Hi,

    I have form (frmOpen) in a vba application (customer.mdb), how do I add an option in that form to open the same vba application ( customerprofile .mdb) again.

    Assuming, there is a button called "Open a copy" in that Form, when a user clicks that button, I need to open the same application (customer.mdb) again leaving the opened application for some process.

    I can do this using Shell Command,...
    See more | Go to post

  • JAMBAI
    started a topic ComboBox maximum listcount

    ComboBox maximum listcount

    I have 200,000 records in database which needs to be listed in the combobox list but, when Check for combobox.ListCo unt it gives only the top 65,000

    Is there a maximum of item in VBA ComboBox?

    Thanks
    Jambai
    See more | Go to post

  • JAMBAI
    started a topic Retaining view state in aspx page
    in .NET

    Retaining view state in aspx page

    I have created a ASP.NET application and created two forms (Webform1.aspx & Webform2.aspx).

    I am displaying the Webform2.aspx based on the Webform1.aspx input,
    For example if the user didn't fill some field in Webform1.aspx then I am showing the Webform2.aspx as a alert message, and I am opening this Webform2.aspx using window.open

    From the Webform2.aspx the user may go back to the Webform1.aspx and fill...
    See more | Go to post

  • JAMBAI
    started a topic View State of a .aspx page
    in .NET

    View State of a .aspx page

    How to retaining a forms value after a postback.

    The forms control are enabled with ViewState = TRUE.


    Thanks
    Kumar
    See more | Go to post

  • Run Windows service at regular intervals (once in a day)

    Hi,

    How to start a windows service that only needs to run once a day (say run the service at every day midnight 12.00) to synchronise the SQL database with Data flex.

    Thanks
    Jambai
    See more | Go to post

  • JAMBAI
    started a topic Windows Service and Database
    in .NET

    Windows Service and Database

    Hi,

    How to connect windows services to SQL server using VB.NET.

    Thanks in advance
    Jambai
    See more | Go to post

  • JAMBAI
    started a topic SCOPE_IDENTITY in MS Access ??

    SCOPE_IDENTITY in MS Access ??

    Does anyone know how to get the @@Identity value after the insert query and use it in VBA.

    strIns = "Insert Query"
    Docmd.RunSQL, strIns

    I am using linked DataFlex table through ODBC.

    Thanks
    Jambai
    See more | Go to post

  • JAMBAI
    started a topic Pass-through Delete Query

    Pass-through Delete Query

    am trying to delete records in the SQL Server from MS Access forms. I got error 3065 cannot execute a select qury, when trying the below code.

    Dim qdfPassThrough As DAO.QueryDef
    Dim rstPassThrough As DAO.Recordset
    Dim strConnect As String
    Dim dbCurrent As DAO.Database
    Set qdfPassThrough = CurrentDb.Creat eQueryDef("")
    strConnect = "Driver=SQL SERVER;SERVER = NTSQLSERVER;Dat abase=TEST;UID= mlp;password='' ;"...
    See more | Go to post

  • JAMBAI
    started a topic Delete large numbers records from Linked Table

    Delete large numbers records from Linked Table

    Hi,

    How to delete large numbers (100,000 - 1,000,000) records from linked table.

    I am trying to delete from MS Access Forms.

    Thanks
    Jambai
    See more | Go to post

  • JAMBAI
    started a topic Uploading files using asp.net with virus scan
    in .NET

    Uploading files using asp.net with virus scan

    How to upload files in ASP.NET along with Virus scan simillar to mail attachments in yahoo,gmail or any other mailing system.

    Thanks
    Jambai
    See more | Go to post

  • JAMBAI
    replied to REPLACE in WHERE CLAUSE
    Data type mismatch in criteria expression was the error message, when I tried that query

    Yes I replaced the % with *.

    Thanks
    Kumar...
    See more | Go to post

    Leave a comment:


  • JAMBAI
    replied to REPLACE in WHERE CLAUSE
    Thanks NeoPa,

    Please let me know how to achive the same query in MS ACCESS 2002

    SELECT * FROM dbo_Facility WHERE (REPLACE([NAME],',','') LIKE 'jambai%'

    Thanks
    Jambai...
    See more | Go to post

    Leave a comment:


  • JAMBAI
    replied to REPLACE in WHERE CLAUSE
    I am using MS Access 2002 and the replace is working fine in the below query
    SELECT * FROM dbo_Facility WHERE [NAME] Like Replace('jambai ',',','')));

    I am wondering ist possible to create the below query.
    Please see the marked code, this was the one I referred as left side of the where clause
    SELECT * FROM dbo_Facility WHERE (REPLACE([NAME],',','') LIKE 'jambai%'

    Thanks
    Jambai...
    See more | Go to post

    Leave a comment:


  • JAMBAI
    replied to REPLACE in WHERE CLAUSE
    Are you talking about the REPLACE in left side of the WHERE caluse. Because the Replace in the right side of the where clause is working fine

    Thanks
    Jambai...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...