Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hsingh1981
  • Content: Threads
  • Order by date
  1. hsingh1981

    Loop through and get each cell Data

    Hi all, I have a problem, I can open an excel sheet and retrieve a paticular cell data and store it to my table. How do i tell it to go through each cell and move down and store it excel table? eg. a9 a10 a11 and retrieve the data in each cell and save it to table? This is what i got so far...
  2. hsingh1981

    Update Datagrid

    Hi Everyone, I'm having trouble or finding an easy way to update my datagrid back to the sql table 2005. I can pull the data from sql to datagrid....but when i change the figures in datagrid....i would like it to update the sql table afterwards? Could someone give me an example? This is how i...
  3. hsingh1981

    open table and copy selected records to excel sheet

    Hi all, I have this table which collects certain data table name "temp_KPIData". I can open the table and copy the first row field to the excel sheet. My code for this is this: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Temp_KPIData"...
  4. hsingh1981

    Loop not entirely working

    Hi all, i have several excel sheets in my folder. I tell ms access database to open each file and copy the data in to the access table. This only works for the first file...i can't seem to copy the data and append to the table. I seem to going wrong somewhere. Could some one have a look and see...
  5. hsingh1981

    lookup table using a in(select.....

    Hi all i have this query and in the criteria i have put this Like "M30*" Or Like "M77*" Or Like "E36*" Or Like "J43*" Or "Q189" Or Like "T43*" Or Like "W87*" Or Like "W88*" Or Like "E51*" i've changed it to a.... look up table which uses a in (select ....statement eg In (SELECT opcodes FROM...
  6. hsingh1981

    Use a look up table in IIF statement

    Hi Everyone, Is it possible to use a look up table in the Select IIF statement. I have reference table which contains the field OPLines. In that i have the following data K572,K618, K636 etc. look up table is like this: OPCodes OPLines K491 C27 K572 C07 K582 C07 K618 C19 K636 C24 What i'm...
  7. hsingh1981

    Linking to txt file from access db 2003 date error

    Hi All, I can link to text file as table in ms access. The problem am getting is that the date comes up with an date error: #Num! #Num! #Num! #Num! #Num! #Num!etc in the date fields. The format of the date is yyyymmdd e.g 20081106 in the text file. i've seen another database that has link...
  8. hsingh1981

    Display null values with multiple field and count

    Hi everyone, I thought i posted this question before, but my computer crashed soon after. So my apologies if i have. My question really is....I know how to show null values by using the criteria is "is Null". My problem is i have several fields in the database (about 15) where i would like to...
  9. hsingh1981

    Query to show records who haven't had paticular training

    Hi all i have query which shows all staff who had training using the course id. How do i find staff who haven't had training on a paticular courseid...such as course id = 5? my current sql statement is: SELECT dbo_Staff.Firstname, dbo_Staff.Surname, dbo_T_MandatoryTraining.TrainingDate...
  10. hsingh1981

    map network drive with password

    Hi all i have this code which i got from this website was really helpful. How do i tweak it so that if the drive requests for username and password? Set WshNetwork = CreateObject("WScript.Network") On Error Resume Next WshNetwork.RemoveNetworkDrive "L:", True On Error GoTo 0...
  11. hsingh1981

    Dynamically linked combo box fill another combo box

    Hi all, I'm fairly new to asp.net. Am using vb.net in my asp pages. I have combo box named location, if a user selects London or edinburgh. I would like it to populate the other combo box called destination. How do i do this? I can fill the combo box using this code sub...
  12. hsingh1981

    cross tab query

    Hi all, I'm try to show query which have staff names and there grades and show all the equipment they used. I can do that with this code: SELECT Staff.Surname + ', ' + Staff.Firstname AS StaffName, Staff.Grade, R_Equipment.Equipment FROM R_EquipmentArea INNER JOIN...
  13. hsingh1981

    IIF equivalent in SQL 2000

    Hi all, I have this iif statement but i can't find the equivalent in sql.... Action: IIf([Action] Is Null Or [Action]='',Null,'Action: ' & [Action]) What would that be in SQL Programming? cheers
  14. hsingh1981

    show records who haven't been trained last year.

    Hi all, I'm doing query and i can show records who have been trained.....how do i show staff records who haven't been trained. Not done query like this before? This shows all records who have been trained with paticular date and course criteria. SELECT R_Area.Area, R_TrainingCourses.Course...
  15. hsingh1981

    display brackets

    Hi all i have this sql code (access 2003), am trying to convert it to sql 2000 compatible. my output of the sql will look like this for one of the columns eg. (1) Apologies [0] Am having problem including brackets "(" and "[" to be displayed. I know how to do it in access 2003 and the code...
  16. hsingh1981

    Sql insert not working

    Hi all i get an error msg in my vb.net 2003. can anyone see problem with my sql statement? sql = "INSERT INTO T_AnnualLeave (StaffID, LeaveStart, LeaveEnd, Notes, LeaveDays) " sql = sql + "VALUES('" & staffid & "',#" & startdate & "#, #" & enddate & "# , '" & notes & "', '" &...
  17. hsingh1981

    complicated query : Show weekday with time criteria and group

    Hi all i am trying to do query which shows counts the number of records where the date is > then 01/02/2008 onwards. But show data for only weekdays (monday to friday). With a time range off 08:00 am to 20:00. eg. NumberOfRecs DateInserted 6 Feburary 20 March 13...
  18. hsingh1981

    Retrieving Identity :(

    Hi all i've just migrated from access 2003 to sql server 2k. I'm having problem retrieveing the StaffID after i inserted the record. Is there an easy way to retrieve the staffid? And can some1 show me quick example? my code is this Private Sub AddStaff() Dim sql, sql2 As String...
  19. hsingh1981

    Identity column gives me error msg SQL 2000

    Hi all, I have just migrated all my access tables to sql 2000. However when insert a new record it doesn't auto increment my record in the id field. So i went in design view of the T_Equipment table and Set the identity to yes and this technically should auto increment a record. The identity...
  20. hsingh1981

    attempting to create crosstab sql

    Hi all am trying to create a cross tab query. What am trying to show is list of staff and the equipment names next to them as columns. If they have the equipment then and display it as 'X'. Can anyone take look at what i've done so far and give me little pointers to achieving my goal? SELECT...

Part and Inventory Search

Back
Top