Search results for query: *

When I use the below function to get the list of installed software in a computer, I am getting the product name as "?[" or some other junk character when the DisplayName is empty in the registery Private Function GetAddRemove(sComp) As String Dim cnt, oReg, sBaseKey, iRC, aSubKeys, iPN, ix...

Hi, Can anyone tell me how to disable Exit option under File Menu (Not the "X" on the top right corner) in Access 2010. Thanks Jambai

After upgrading to Excel 2010, I am getting the following error when try to open an existing excel document or generating an excel from a web page (.asp page) The file you are trying to open <filename.xls> is in a different format than specified by the file extension. verify the file is not...

Hi, How to convert Access 1.x to access 2003 or 2010? I came across few forums and they suggested to do the following steps. Use either A2 or A97 to convert from Access 1.0 Use A2003 to convert from A2 or A97. When I am doing import(Open a blank 2003 Database and import from Access 1.x...

Hello, I could open the report in Report view in Access 2007 using acViewReport, DoCmd.OpenReport "rpt_CallList", acViewReport The same code doesnot works in access 2003, instead of opening the report in Reportview, it is behaving as acnormal and tries to print the report.I believe...

Hi, 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...

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...

Hi, I have an Access Form with a details section on it. Is there a way to refer a control in the section and turn it to .visible = false if a criteria is met?. The fields are bound field. I've tried the below code in the following procedure but didn't solve Form_Load, Form_OnCurrent Dim ctl...

I have two text boxes in a form. The user can only enter text in one or the other, not both. If they enter data in one text box and there is data in the other, clear that other data. Please let me know what event should I use. Thank you Jambai

I am able to open a chm file on click of a button. But the chm files opens without the content,index option [http://www.getmedlegal.com/img1.jpg]. The content and index option [http://www.getmedlegal.com/img2.jpg] is there if I open the chm file separately. How to open the option 2 on click of...

I am trying to import tab delimited text file into a MS Access table. The below is the query I am using. INSERT INTO table1 (PName,Age) SELECT [pname], [age] FROM [Text;DATABASE=C:\Documents and Settings\MS\My Documents;].table1.txt;" The above query insert the records into one column like...

Hi, How to restrict the user not to open more than 2 copy of the same MS Access applicaion. in other words, The user should be allowed to open the application twice. Any help Thank you Jambai

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...

i have checkbox in gridview. There is status field in database how to display the checkbox as "true" or "false" based on the boolean value from the database Thanks Jambai

Hi How to start a windows service that only needs to run once a day (say I would like to run the service every day midnight at 12.00) to synchronies the SQL database with Dataflex. Thanks Jambai

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

I have two forms. Say form1 and form2. Based on the input in the form1 the form2 has to show the details. The below is the query I am using for the existing record checking and showing up the new form. Dim strChkOrder strChkOrder = "SELECT Order.* FROM [Order] WHERE ((([ORDER])=" &...

After the validation the focus was not set to the particular control. It moves to the next control. Please let me know who to set focus after AfterUpdate event. Private Sub txtName_AfterUpdate() If Not IsNull(Me.txtName.Value) Then MsgBox ("Not Null") Else MsgBox...

I 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...

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