Search results

Hi, I had an application developed with another developer in Access 2003, our company has upgraded our laptops to Microsoft Office 2010 and now when I open a form (frm_Enq_Address_Dialog) I receive an error on Form load as "File Path not Found (You entered an expression that has an invalid...

Hi, I have a query which arranges the following businnestypescombined; SELECT QryCalcWPM.A.BusinessType & "/" & QryCalcWPM.B.BusinessType AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Results: BusinessCombined Score KIOSK/MPESA1.03...

Hi, I am working with Access 2003. I have the following select statement; SELECT QryCalcWPM.A.BusinessType, QryCalcWPM.B.BusinessType, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Result A.BusinessType B.BusinessType Score A X...

Hi, I am working with Access 2003 and when I try to write this SQl query I receive the error; Invalid bracketing of name [SELECT (Select Count ([BusinessType.. SELECT A.BusinessType, B.BusinessType, MPESA.Cri1, TAXI.Cri1, MPESA.Cri1/TAXI.Cri1 AS MTCri1, MPESA.Cri2, TAXI.Cri2...

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...

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...

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 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...

Hallo, Please could anyone tell me what the following highligted in red codes means; Option Compare Database Option Explicit Public qDF As QueryDef Set qDF = cON.CreateQueryDef("", strSQL) Set rST2 = qDF.OpenRecordset() This code is inserted within an ODBC connection as shown below...

Hallo, The application I have is dependent on a database which will be shut down this weekend, therefore I was instructed to check this specific module and determine how it is connecting to the database and how it fetchs the data. Then I have to take the table from the database and make it...

Hallo, I am new to access please could anyone tell me what does this two line of codes mean; Set qDF = cON.CreateQueryDef("", strSQL) Set rST1 = qDF.OpenRecordset() Thanks

Hallo, I am working on an old developed Access database. One of the changes I have to make is to change the export from drive a: (disk) to drive d: (CD). I noticed that on the Export click button it calls the following module (see below). I have tried to change to d: drive by changing the...

Hallo, I have the following formula which works fine. However, when I select ALL the records are not sorted in ascending order as per the drop down list (i.e., ?Practice). Is there a way I can display the records in alphabetic ascending order? Thanks (if {?Practice} = "ALL" then TRUE...

Hallo, I have this code of line which works fine if the field is populated with NULL but doesn't work if it is an empty field, please can someone tell me how I can modify it so that it can recognise an empty field too, Thanks isnull ({QryQuarter2.address1})

Hallo, I have the following table (Table1) ename salary a 100 b 200 c 300 d 400 and am supposed to bring the minimum salary value and ename, when a query is run. The following SQL syntax brings...

Hallo, I have a checkbox on a datagrid and on loading the form is set to True (checked) with the code below which works well. For irow = 0 To DgvToPay.Rows.Count - 1 DgvToPay.Rows(irow).Cells(3).Value = True Next irow What am trying to do is when the checkbox is unchecked then the next...

Hallo, I am working with VB.net 2005, what am trying to do is insert fields into a table in Sql database. The table name is TblQuarPay The following code works perfectly well but it doesn't populate the field ToPay in the database. Quoting Error encountered can't change varchar to numeric...

Hallo, I have a checkbox which I called ToPay (design name), this checkbox is unbounded with other bounded fields in a datagrid called DgvToPay. Also note, When the form is loaded the datagrid is populated and the checkbox checked always (i.e,. threestate set to True). What I want to do is...