Recent content by edwinastono

Dear All, I was created an Microsoft Access Project (ADP) using Access 2000 and SQL Server 2005 Express. It can run well if I use Microsoft Access but when I try in Access Run-Time I can't access/use/call all the Stored Procedure. Can anybody tell me why this happen and how to solve it ? Thank you

Join Type What u have to do now is set referential integrity and join type at ur relation.

I use this code in Ms Access Dim cnn As ADODB.Connection Dim str As String Set cnn = New ADODB.Connection str1 = "Provider=sqloledb;" & _ "Data Source=ServerName;" & _ "Initial Catalog=DatabaseName;" & _ "User Id=UserID;Password=Password;" cnn.Open str Set rst = New...

Hi, Try this link http://www.businessobjects.com/products/reporting/crystalreports/editions.asp. Hope this will help you

Crystal Report 9 Dear Bob, Thanks for your answer. Do you have any suggestion so my report application still can run in Win 98 ? Should I downgrade the Crystal Report to version 9 (This is the last version that support Win98) ? Should I have to buy Crystal Report 9 Developer Edt to create the...

Dear All, I need to install CR XI R2 Runtime to my client's computer, for that I've made an .msi installer package using Visual Studio 2005. It can be installed in Windows XP but fail to install in Windows 98, when I read the log file, it said like this : "Error 1723. There is a problem with...

Dear all, I made an ADP using Access 2007. I have several question regarding the form design. 1. I found something strange at the form, I can't set the form size, it always become a full screen form. I've already set the form properties like this : Auto Center to "No" Auto Resize to "No"...

Thanks for your explanation, you help me a lot.

Dear Bob, I think you missunderstand about it. When I use mdb format I create all the tables and relationship in Ms. Access, I'm not using SQL Server at all, pure Access and it was worked, I don't have to set a primary key in the detail table. Edwin Astono

Dear Bob, Thanks for your quick answer. Then it's mean I have to "spend" one field to create primary key if I use SQL Server ? But why that problem not occured when I use MDB format ? Is it the "price" that I have to pay if I want to use ADP format ?

I'm still new in ADP development and need some advices and helps from you who has already expert on it. Fyi, I used Ms. Access 2007 and SQL Express 2005. I found a problem when working with my project. Here is the problems : I'm using form wizard to create master/detail form but why I can't...

Here are the codes, the error appear when I put my mouse in rsqrPPhKh!Bulat while I'm debuging the program Private Sub PPhSpesial() Dim PPhSetahun rsStaff.Open "SELECT * FROM Staff ORDER BY KodeStaff", CurrentProject.Connection, adOpenDynamic, adLockOptimistic rsqrPPhKh.Open...

Dear friends, Would you help me to solve this problem ? I've got an error message while I'm debuging my Access VBA. The error message is like this : The expression you entered as a query parameter produced this error : 'The object doesn't contain the Automation object 'K." I've already...