Search results

Thank you so much.. A problem I have noticed.. (A/B)z1 = (A/B) to the power of z1 (A/B)z2 = (A/B) to the power of z2 and so on....

Hi, I have 2 tables TblTemp z1 z2 z3 z4 0.20 0.30 0.40 0.50 TblBusType C1 C2 C3 C4 A 1 2 3 4 B 2 3 4 5 C 3 4 5 6 D 4 5 6 7 Now, I need to compute the...

Hi, I have a message box result which is displayed as; Dim rs As DAO.Recordset, strMessage Set rs = CurrentDb.OpenRecordset("QryWSMScores") If Not rs.EOF Then strMessage = Chr(13) & Chr(10) rs.MoveFirst Do Until rs.EOF strMessage = strMessage & Space(20) & rs.Fields(0) & Chr(13) & Chr(10)...

Hi, I have a text box (txtEventdate), under this textbox there are dates populated. So on run time the report might look like, Event Date 12/12/2009 11/01/2010 Now, I want when there are no event dates the text box which contains the text (Event Date) to be not visible i.e., the user...

I dont think the problem is the application, Ok, I opened the application (mdb) by choosing shift + Open it open the application in the design view ( I could see the tables/queries, forms etc ) I can open anyone of them in the design view. Therefore, I opened a form in the design view...

yes it is the caption

Found the problem in the Debug Private Sub Form_Open(Cancel As Integer) 'this code closes projects that have not been paid after a year from their last payment run 'OR... all their patients have been paid and are not outstanding Dim mySQL As String mySQL = lblCloseOldProjectsSQL.Caption...

I dont know, this is an application I use in my work place, Can you direct me to check it please

Nop, it doesnt not please see attached the error it prompts me with..

Ok , I went to tools> Database Utilities > Compact and Repair database When I open the database no error is given (this is the mdb version). But it never opens the form. If I open the mde version I receive th error shown earlier. It will be important to rectify the mdb problem, its...

Nop same versions This application used to work before I went for my holidays when I came back it gave me the error really annoying ..

Hi, I have an access database which when I try to open it gives me the following problem; "The expression On Timer you entered as the event property setting produced the following error: The OpenForm action was canceled. *The expression may not result in the name of a macro, the name of a...

The total size is 14.9 GB, 12.1 GB has been used what is left is 2.81 GB. I have tried to convince my manager for more space, but the process is long and the table is used by an application and since it is not indexed it is very slow to extract records. No ideas, maybe to temporarily stop the...

Hallo, Ok, I'll try to be as clear as possible. I am working with SQL server 2005 which has been installed on a server and the C Drive where SQL is placed has a free space of 2.81 GB. I have a table called dbo.o_pat, which is built up of nearly 110,000,000 records. The table was not...

Re: Access very slow extracting data from Sql How do you do that? Thanks

Re: Access very slow extracting data from Sql Hallo Namliam, The tables have no primary key, and am not using any index (need some informtion here).. Please direct me where to look to fix the probem. Indexable in the Tabe Designer is set to YES Thanks

Re: Access very slow extracting data from Sql Thanks for the reply. Select * selects every field.... However, I need only select certain columns. Secondly, I think it is to do with the table indexing however I dont know where to start.... The tables contains records which have been there...

Re: Access very slow extracting data from Sql Hallo, I have an access database which connects to a Sql server 2005 via an ODBC to extract data from tables. The problem is one of the table's is built with 100,000,000 records. Therefore, just to extract 7 fields for one record it takes 20...

How can I change this code to read to the tables rather than making the cOn. Set qDF = cON.CreateQueryDef("", strSQL) Thanks

yeah but this am following it up with LPurvis