Search results

try this - make the width of the Total field to the comined width of col1+col2.

Hello All, I have updgraded to access 2007 but all the users of my application are on access 2003.So,I thought I will distribute my application through th access 2007 run time.I have no problem in that.I also have refereces to the excel in the VBA.So,the reference on my pc is the Office 12 but...

sorry,I didnt clearly explained it.The OLE /DD property is affecting the bound forms,queries and reports.I think the bound forms,queries and reports use the Application connection .I am refering it to the built in access connection here.So it seems like setting this value has affect on all the...

I think I can change the inbuilt OLE timeout like - Application.SetOption "OLE/DDE Timeout (sec)", 1 This is working and my bound forms,queries and reports are timing out as I set the limit to one second. Actually,this is maintenace project project,for VBA they created the connection in...

Thanks for your reply.Yes ,less open connectionns on sql server is always good for performance.As I described,in our adp clients we are opening the connection through the Data Link and through VBA as well.So I have thought to change this and the VBA will share the connection that access has...

sorry i was working on other things and thanks for your reply.I understand it now that since all the properties are not exposed so its not taking the Application Name propertry. I have an adp project project but i dont want the user to enter the data base password because of two reasons -1 .Its...

here is the another post where i posted what helped me to solve this issue.Thanks for your help. http://www.access-programmers.co.uk/forums/showthread.php?p=754053#post754053

Just for information,Here is the link that helped to solve my issue.I hope it helps others as well. http://www.accessribbon.de/en/index.php

Hi Ron, I have posted another post on this issue with access 2007.Suppose I want to hide the navigation pane,status bar,allow builtin tool bars from the users.For this,I will uncheck the boxes for these properties on the access options -current data base screen. But there is a drop down next to...

Thanks for your reply.I tried to search posts on this topic but didnt find any usefull info. Could you please point me to right direction?

Hello All, I have an adp application talking to sql server 2000 hosted on a windows server.We have not allowed the end users to see the database objects.For this , we usually disable the options like -use database window,use access special keys ,allow built in tools/menus from the Tools...

Hello All, I have an adp project as a front end and sql server 2000 as the backend.I have several ASP.Net apps talking to sql server as well. I have included the Application Name in connection string on the .Net apps and when I execute the sp_who2 stored procedure ,it correctly shows me the...

Yes,its make sense to use the connection that access already opened from File-->Connection. But as i was explaining ,I inherited this from someone else and they had made explicit connection via the VBA code.There is global module that open the connection like db.open stconn. On the forms ,there...

Ok..may be I dont need a recordset here.But i didnt understand what difference these connection strings are making to the recordset when I am trying it to bind to the form. 1.Public Const strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=user;Pwd=pwd;Initial Catalog=mydb;Data...

Thanks for your input. 1.As per you the forms recordset can only be bind to DAO recordset? I checked this kb atricle from MS. http://support.microsoft.com/kb/281998/ MORE INFORMATION To bind a Microsoft Access form to a recordset, you must set the Recordset property of the form to a valid...

I have a backkground of working in asp.net and feel comfortable in writing the unbound code. Yes,I have checked-me.recoordset=sql works. But any idea why the first code snippet isnt working? Thanks!

Hi All, I have an adp project connected to sql server 2000.I need to bind a continous form to a dynamic sql query.For this I am trying to bind the form to a ADO recordset like me.recordset=rs. Here is the code- 1). Dim db As ADODB.Connection Dim rs As New ADODB.Recordset Dim sql...

Hi, I have a adp project with sql server as the back end.I dont want the users to see the database objects.Usually i disable some access features like allow full menus.But in doing this,the access disables the in built features as well as "Export to Excel". Is there any way i can restrict...

Hi All, I have one main form in which i have 2 subforms on different tabs.All the forms are unbound. Basically i am trying to assign a order to multiple persons.SO the main form has the order information.1st subform shows the already assigned persons and the second one is for assigning new...

but the form_beforeupdate event is not called when u are exiting the subform.. i tried the form_close and form_unload but these events are also not called and the problem is the data gets saved whicj i dont want. any help pls.