Search results

I know this is a very bad model but I don't have any choise. Please let me know if you know some work around for this. Thanks Ria

I have managed to compact secured and unsecured both. Here is the code: Public Sub CompactRepairAccessDB(ByVal sDBFILE As String, _ Optional sPASSWORD As String = "") Dim sDBPATH As String, sDBNAME As String, sDB As String, sDBtmp As String sDBNAME = sDBFILE 'extrapulate...

Don't know what happened. I created new form and in that DoEvent is working but update is still not working Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase strCnPDatabaseName, , strCnPDatabasePassword...

After adding DoEvents my form is not getting opened. Regards Ria

Great... You got the point. Eval is not working but second work aroud is working fine. Thanks a lot. Regards Ria

I'm trying to update one of the field after loading / importing the data in the table. But somehow that field is not getting updated. Below is the code I have used for the same. Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase...

Thanks to all. I have splitted the columns into two columns. That's the only workaround works. Thanks a lot for good suggestions. Regards Ria

Basically I want to compare each cell of the record. Any idea how to do that? Ria

I have 160 products in a table (one columns for each product). Tables structure is like: RM Customer Prd1Rev Prd2Rev Prd3Rev Prd4Rev ..... Prd160Rev What will be the query to find top 50 product's revenue? And what will be the query to find top 50 product's revenue and the RM? something...

Hi Chris, I can't change the design / normalising as this is implemented in other systems as well. I need some work around for this. I'm sure there will be some work around for this. Thanks Ria

smig You can use *, but without * also works fine. It's like when you want to count number of records instead of SELECT COUNT(*) FROM TableName You can write SELECT COUNT('x') FROM TableName and that will be faster then *.

Thanks Bob for the good suggestion :)

I really did not get you? Can you please throw some more light? Pls give me some example. Thanks Ria

When I summing up more than 100 columns then total is showing #Errorinstead of amount. Select C1+C2+C3+C4+C5+...+C100 Till 100 columns sum is ok Select C1+C2+C3+C4+C5+...+C160 but if I add another column then sum is showing as #Error instead of value. :mad: Please let me know what is the...

Thanks a lot for the help. Still did not get any solution for below issue http://www.access-programmers.co.uk/forums/showthread.php?t=205121&page=2 Really need some experts to solve this issue. ;)

Yes Khalid after all it's Microsoft product. Some time need to restart the PC. :)

Values returned by result set rsTmp!ConnectDB_String are: ConnectDatabase.ConnectBacDatabase() ConnectDatabase.ConnectBauDatabase() ConnectDatabase.ConnectCnPDatabase() So If rsTmp!ConnectDB_String() = False Then will look like after returning the value If...

Hi James, Error is at below line oJet.CompactDatabase sCompactPart1, sCompactPart2 Error: "Cannot Start Your Application" Error When You Open a Database Project That Has an Access Data Connection Regards Ria

Dear All, I'm trying to compact the secured database and wrote below code but I'm getting below error "Cannot Start Your Application" Error When You Open a Database Project That Has an Access Data Connection We have two different databases. One database contains only code and another...

Thanks for the reply. Pls let me explain the issue again: Table 1 Name: T1 (Revenue File) Columns: C1, C2, C3, C4...C200 Table 1 Name: T2 (Revenue File) Columns: C1, C2, C3, C4...C200 These C1 to C2 contains revenue by each product. At this stage it's one table cause this need to be loaded...