Search results

  1. E

    open excel through user browsing?

    with a command button, i m aiming to open up a csv file in excel. make the necessary changes to it and then import the data into access my code to open .csv in excel is as follows. Set oApp = CreateObject("Excel.Application") oApp.Visible = True Set wb = oApp.Workbooks.Open("C:\WORK\Software...
  2. E

    LIKE operator in SQL query

    here's my sql statement. condition = txtQueryBySoftware strSQL = "SELECT [Report].[RUser], [Item].[IDevice], [Item].[IValue], [Item].[ID], [Report].[ID] FROM Report INNER JOIN Item ON [Report].[ID]=[Item].[ReportID] WHERE (((Item.IPage) = 'Installed Programs') And ((Item.IDevice) Like """ &...
  3. E

    repeated prompting

    Hi Everyone, 1st, just have to say that this forum is extremely helpful! even for a newbie programmer like me. =) my question is: i wish to create a report which shows a summary of the details at he beginning in fact i have achieved the output i require. however, i think because of the manner...
  4. E

    Import CSV file

    Hi! how do i import CSV files into access? it seems to be able to import .xls files only. and also, is it possible to create a command for importing? so the user can browse and choose which files he wants to import? Thanks! :)
  5. E

    parameter query

    i have done a simple parameter query SELECT....... WHERE ((([Item].[IPage])="Installed Programs") And (([Item].[IDevice]) Like "*" & [Enter Software:] & "*")); so if i enter "microsoft" upon prompt it will return all data containing microsoft and if i enter "microsoft office" the correct data...
Back
Top Bottom