Search results

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

Yep the form is still open.

use a form The best way is create a form with the all the fields you want to search. Then in the query in the where clause reference this field. sample frmOne: Item1 Item2 then in the query where [TableName].[Field1] = [Forms]![frmOne]![Item1] and [TableName].[Field2] =...

Hi, I have created a parameter query and below is the SQL statement: PARAMETERS BD DateTime, ED DateTime; SELECT TM0050.Description, TM0002.[Actual Hour], TM0002.BU, TM0002.Country, TM0002.[Task Owner]...

Solved Thanks Rich. It seems like I had a few option to use. I have use the DLookup option and it's fine but I guess the whole report become slower. So I think it would be better to include this field in the report based query. Thanks again. mderby

Hi all, I have a unbound textbox in one of my group footer named TEXT16. The report is base on tbl TM0002 I have a sql string : =(Select [Description] from TM0050 where (([TM0050].[TYPS])=[Reports]![test roll]![TYPS]);) to try to get the description of a TYPE field(integer) from TM0050. But...