Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 & "', '" &...

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

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

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

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