I am using below statement to get the list of all the columns by table.
Set objRs = objConn.OpenSchema(adSchemaColumns, Array(Empty, Empty,
strTableName, Empty))
This statement returns me all the columns. No problem.
How can I restrict that only columns with data type number or floats or
integer should be returned....I have hard time setting up the filter
criteria...
Re: Query to get Table schema ...Set objDB = Server.CreateObject ... objDB.Open sDBName...'Set objRS = objDB.Execute ...empty, "Y O U R T A B L E N A M E ")) ... (comp.databases.ms-access)
RE: Adding info to query ... I'll try and give you an example to what I mean, it could be that the prev... also, what if the first record is empty, there will be no previous record. ... Function LookForLastDate(IdFieldName As Double, DateFieldName As Variant) ... >>> Mike J ... (microsoft.public.access.queries)
RE: Adding info to query ... it sort of makes sense now. ... > compile error.... >>> also, what if the first record is empty, there will be no previous record. ...Prev by Date: ... (microsoft.public.access.queries)
RE: Adding info to query ... >> I'll try and give you an example to what I mean, it could be that the prev... >> also, what if the first record is empty, there will be no previous record. ... >> DateFieldName),Date) As DifferentInDays From TableName ... >> LookForLastDate = DateFieldName ... (microsoft.public.access.queries)
delete rows from datagrid ... My problem is that whatever rows I delete, dgDeleted is always empty... What should I do to store the deleted rows in a dataset so i can ...Thx...Prev by Date: ... (microsoft.public.dotnet.languages.vb)