Search results

Thanks Wayne! i'll go try it out. :)

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

oh oh it working! thank you so much jon k! u r my hero! ;)

Thank you so much for replying!!!! THank you thank you. However it still doesnt work. it gives me an item not found error. and the msg box i printed out of the sql string is: SELECT [Report].[RUser], [Item].[IDevice], [Item].[IValue], [Item].[ID], [Report].[ID] FROM Report INNER JOIN Item ON...

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

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

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! :)

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