Recent content by mderby

Hi, I can't find the option to save as DAP . I'm using MS Access 2000. Pls help. Derby

Hi there, Does MS Access 2000 provide an option to convert existing Access objects e.g form, report to Data Access Page format ? I had an Access application which is quite robust and now we intend to roll out to other region. So we are thinking to roll out this appl to web. Any suggestion...

Got it ! Finally I found a solution to it. I just use the ERR.Number as the status check. If there is no error with the APPEND Query which mean ERR.Number=0. This solve the problem. :D

RecordsAffected cx was correct on the data entry. I need to append the data to another table as well as the form's bound table. But CX, I am using an Update Query to append the data not through DAO or ADO will I still get to used the RecordsAffected property ? Perhaps there is other parameter...

Hi guys out there, I have a form Work with a subform Detail on it. User will entering the data on Detail and click a button called SAVE on the bottom of Work form. The SAVE button will called an update query UP to insert new records from Detail form to a table Work Order. This is working...

from Excel Thanks. I need to upload from Excel cause the source data is from another application which needs some formatting and fields before it can be uploaded to Access. Will try on the Dcount and select count(*) now. mderby

Hi all, I need to upload a worksheet from Excel to a MS Access DB. Though I have successfully to this by using the TransferSpreadsheet method, there are no message informing the total of records added to the table. Here is the code in Excel which call another procedure(ImportRem) in that DB to...

Thanks Hi Shadez, Thanks for your help. It works now. Seems like I will need to brush up my ADO skill. Any good link or book to recommend ? Cools. Btw i kind ah like that smili :D in that words OLEDB:Database Bye.

Hi all, I want to link to a table in an Access DB with DB password. I wish to use ADO to accomplish that but unfortunately there is error in my open connection declarations. The errors state : "Run-time error '-2147217843 (80040e4d)" Cannot start your application. The workgroup information is...

Hi all, Would like to seek help whether MS Access provide the tools to schedule synchronization between the Master DB and the replica DB ? I heard that we need Replication Manager can do that but we are not very keen to purchase the MS Office Developer license just for that tools. Any...

Confirmation Pat, Thanks for your clarification. Think I will drop this idea until I upgrade my DB to SQL Server later. :) Now I'm satisfied.

Hi , Currently, I am working on a MS Access application which link back to a MS Access DB through network drive. I have read some issue in this forum which say that the performance of the application will be better if we use ODBC to link back to the DB. I have try that in my application but...

Same Item hi, At first I thought that it is involving 6 different fields which is why I suggest that query path. Now I understand that you just want to select 6 records from the same field. I created a sample solution and attached with this reply. I think using the list box for...

Hi, I have a report rptASof which has a subreport named rptSubAsof. The issue here is that I don't want to print the report when there is no data in the report. I try to put this in the On NoData event of the rptASof: Private Sub Report_NoData(Cancel As Integer) Msgbox "No Data"...

Thanks all. what if I replace the #01/01/03# to DATE(). I have tried that and it will still prompt for parameter for BD and ED. I was just wondering whether this is the correct way to handle a parameter in a SQL statement in a query. mderby