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...
User Profile
Collapse
-
JAMBAI started a topic WINWORD.EXE not ends in word 2007 when Embedding word document in OLE UNBOUND CONTROLin AccessWINWORD.EXE not ends in word 2007 when Embedding word document in OLE UNBOUND CONTROL
-
JAMBAI started a topic WINWORD.EXE not ends in word 2007 when Embedding word document in OLE UNBOUND CONTROLin Visual BasicWINWORD.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.... -
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).... -
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 -
The one I said in the second post is my requirement.
Appologizes for the confusion.
Thank you
Jambai -
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...Leave a comment:
-
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,... -
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 -
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... -
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 -
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 -
Windows Service and Database
Hi,
How to connect windows services to SQL server using VB.NET.
Thanks in advance
Jambai -
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 -
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='' ;"... -
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 -
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 -
Data type mismatch in criteria expression was the error message, when I tried that query
Yes I replaced the % with *.
Thanks
Kumar...Leave a comment:
-
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...Leave a comment:
-
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...Leave a comment:
-
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...Leave a comment:
No activity results to display
Show More
Leave a comment: