Search results

  1. J

    Maximum values

    Hi there If i've got the following fields and values: Cars - colour - performance Ford - Red - 100% Ford - green - 90% Ford - blue - 95% Rover - Red - 90% Rover - green - 97% Rover - blue - 95% It's possible to write a query to give me the best performance by each car? ex Ford - Red - 100%...
  2. J

    New to cristal report

    Hi there I need to use Cristal report in my work but I have no idea how it works. I would like to know if it can retrieve the information direct from the SQL database or if it needs an application built as example in vb6 or vb.net? Thanks
  3. J

    DataEnvironment1

    Hi there. I built the following code to run a report: Private Sub cmdTest_Click() If Not IsNull(txtDateFrom) Or (txtDateFrom <> "") Then DataEnvironment1.Command2 txtDateFrom.Text DataReport2.Show End If End Sub When I run it displays the report strait away but if I try to run another report it...
  4. J

    Data report

    Hi I've got an VB6 application front end with an SQL2000 database as a back end. I need to create some reports using the datareport but I don't know how to do. Is there anyone that could tell me where to find a good tutorial online please.
  5. J

    SQL 2000 Server connection

    I'm using the follwoing part of code to connect to an VB6 application to a sql 2000 server: Sconn=”Provider=SQLOLEDB.1;Trusted Connection = True; Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=PARS;Data Source=10.100.66.118" conn.open sconn The problem is whe...
  6. J

    import from txt files

    Hi there I'm new on SQL server and I need some help. I'm building a VB6 front end with SQL 2000 as a back end. I've built my tables but the information that will be feeding them It will be received weekly on text files and then I have to export manually into the tables. I woul like to know if...
  7. J

    Dates

    hi there I've got a calendar in my access Vb application and when I click the ady I want it will input that day in a text box in the follwong format dd/mm/yyyy. Then I save this with some more information into a table. The problem is when I use the following code: count3 = DSum("[Duration]"...
  8. J

    Help Please

    My access VB applications use to be built in access 97 but recently the company updated the software and is using now access 2003. My only problem so far is: my applications built in access 97 are able to be opened by over 40 users at the same time and but the ones built in access 2003 only...
  9. J

    vbOkCancel

    Hi there If i use a msgbox with vbOkCancel I get a box with ok button and Cancel button. Is there any code that I could have as example green instead ok and red instead cancel? Thanks in advance
  10. J

    Dcount

    Hi there I'm using DCOUNT to count some fields on some of my tables and I would like to know what can I do to only count repeated fields only once. By example if I've got access in two different fields it only count one. This is my code: dcount("[field]", "mytable") Thanks
  11. J

    DateDiff

    Hi there. I'm using the following code in my Access aplication: DateDiff("h", IncStart, txtrts) My problem is i need the exactly time difference and if the difference is 2hours and 15 mins it will display only 2 hours. Is there any way to do that? I've tryed in min but it display 135 mins.
  12. J

    between querie

    Hi there I've got the following query in my application: SQL = "INSERT INTO tblreport3 ( exchange, NoCustomers2, [time] )" SQL = SQL & "SELECT Table1.Exchange1, Table1.Customers1, Table1.Duration" SQL = SQL & "FROM Table1" SQL = SQL & "WHERE (Table1.IncStart Between #txtdatefrom# And...
  13. J

    Date

    Hi there In my application I've got a table1 with a field data type "Date/Time"(IncStart). On my form I've got a text field(txtdateFrom) formated to short date. The problem is when a run the following query: Set rst = CurrentDb.OpenRecordset("SELECT * FROM table1;", dbOpenDynaset) rst.FindFirst...
  14. J

    Feedback

    Hi On some of my website tables I use the "aAlign"="top" code but is not recognised by W3C. Is there any other code to do the same job and is recognised by W3C? Could you also surf on my website and give me some feedback on how to improve it? http://www.safida.co.uk Thanks
  15. J

    retreive a word

    Hi there I have a table in my database with a field called description. Imagine if one of my discriptions is "I learn a lot in access world forums". I need a query that if I look only for a word "access" will retrieve this discription. Is this possible to be done in access? Thanks
  16. J

    SQL 2000 & txt files

    Hi. I’m new on SQL 2000 and I need some help for this project at work. I’m building a database where the data that need to be inputted in come in a text file. Is any way (like a batch file or linking the database with a text file) to input the data strait away? Some files are over 100 MG size...
  17. J

    Relationship

    Hi there! I've three tables in my database, tblInfo, tblSavedInfo & tblCountry. for tblInfo I have this fields - Ref: Cost: RefCountry: for tblSavedInfo I have this fields - Ref: Cost: Country: for tblcountry I have this fields - RefCountry: Country: My problem is when I save from tblinfo to...
  18. J

    Insert & Union All Select

    Hi I've written the following SQL code that is not working: SQL = "INSERT INTO tbltest5 ( TLI, [Switch Name], NNI, [BT CB], [Time Period], Calls )" SQL = SQL & "SELECT tbltest2.TLI, tbltest2.[Switch Name], tbltest2.NNI, tbltest2.[BT CB], tbltest2.[Time Period], tbltest2.Calls" SQL =...
  19. J

    Access & Excel

    Hi there Does anyone know where can I find a tutorial for working Access with Excel? I receive regulary a spreadsheet with information that I need to copy to the access database. I can do this manualy but I would like a query that could do it for me. Thanks to your help
  20. J

    Formula

    Hi I’ve got dough and I would like to know if someone could help me. I’ve got a cell on a spreadsheet whit following values: Values xxxx,1,core3 xxxx,115,core3 Is there any formula to pick only the numbers between the comas not knowing if will be there 1 or 2 or 3 or more numbers. Example...
Back
Top Bottom