Search results

thanks. thanks a lot.

Hi: I have a query, I will add a extral coloum expression like: % of Boys: ([numOfBoys]*[numOfTotal])/100 Now I want to show the result like this: % of Boys: 30% 40% ... I want add the sign of " %" hehind the number. How can I do this? Thanks JT

Hi: I am trying to insert a Excel Sheet into my MS Access 2003 form, I find this link to tell how to do it: http://msdn.microsoft.com/en-us/library/aa190078(office.10).aspx But after I add the Excel sheet small icon to my toolbox Window, it grey out, I can't select it. Would you please let...

Thanks bob Thanks bob, really helpful. Jt

Hi; I can access my SQL table using MS Access "Linked table manager" in my home. But in my office, the MS Access doesn't install that wizard, I can access my office pc using remote desktop, what is the best way to install it to my office pc? Is there any download site from internet? Is it...

Hi: bob Thank you very much for your help. After another hrs of trying, I found the problem is: I need to refersh the linked table by using: Linked table manager. In my home, I can access the wizard:"linked table manager", but the wizard is not installed my office. now, sitting in home, I need...

Hi: Bob Larson I am trying to do a simple test here: create another combo box, put the combo box Control Source = codAction!actDecsription (using expression builder), when I open the form, the combo box has values, but if i select one of them. on the bottom of the statuse bar says: "Control...

Hi: Bob Larson Thank you very much for your reply. I checked the table in SQL, it has primary key. I am using this connection: strSQL = "SELECT actDecsription FROM codAction WHERE actActionID = 3" '(actActionID is the primary key) rst.Open strSQL, strCnxn, adOpenKeyset, adLockOptimistic Set...

Hi: I am experencing very strange case. I have two identical MS access application, only difference is one backend is MS database, another is MS Sql database. When I run the application with the sql backend, one form just doesn't allow me to edit, even I can select value from a comboBox...

Hi: After migrate mdb database to sql server, I have created .mde and installed in each user's pc. My question is: if I modify .mdb file later, and re-create a new .mde from my pc, can I copy the .mde to each user? The main concern is: do you think those table links (tables from sql tables)...

it works, thanks Hi: TehNellie Thanks for your post, it works now, the main reason is: I need to set the ODBC setting correct (from each user's pc, in Control panel ->Administrator Tools), but before that I need to go to SQL server to set the permissions or roles for those users. Cheers. Jt

Hi: I have migrated MS Access table from .mdb to MSsql server, from my computer and my administrator's pc can run the new Access application without any problem, but another user just can't run this application (before the migration, she runs the .mdb without problem). error: The Expression...