Recent content by rizabdullah

It works fine from another pc. Many thanks for you assistance guys

The file is not is use. I will try this from another pc.

Just tried that, still same error. It's failing on: Set objXLApp = CreateObject("Excel.Application")

Many thanks for the response. I have VB for application, MS Access 15.0 object library, MS DAO 3.6 object library, OLE Automation, MS VB basic for app extensibility 5.3, MS ActiveX data object 2.1 library & MS outlook 15.0 object library

Hi Guys I am trying to open .XLSM excel file from Access module but I am getting error message "run time error -2147417846 (8001010a) automation error the message filter indicated that the application is busy". My code is: Function runExcelMacro(wkbookPath, macroName) Dim objXLApp As Object...

Hi Guys I have a table, as below. What I would like to do is to be able to create a query and list values and table2 below. Any assistance please. TABLE1 Test 10101 10105 Test2 10500 10505 Here is how I would like to see final output: TABLE2 Test 10101 Test 10102 Test 10103 Test 10104 Test...

Excellent, it works many thanks

Union query I am ok with,any hints about the function please.

That's correct.

Hi Guys Seems like my brain is not working today. I have a table, as below, with 3 columns. All I am after, through a query if possible, is to list the range between FROM & TO fields by ITEM field please. Any suggestions: Item From To A 2 10 B 1 5 C 4 7

Hi Guys How do I format numbers to text in SELECT query. My query is: SELECT Qry_Cognos_Stores.el3_cmpcode, Qry_Cognos_Stores.el3_code, Qry_Cognos_Stores.el3_name, Qry_Cognos_Stores.StoreId, ("Store" & [Qry_Cognos_Stores]![StoreId] & "@mothercare.com") AS Email FROM Qry_Cognos_Stores; Many...

Many thanks, it all worked :)

Apologies, I guess I am not good explaining scenarios. Advise on how do I transfer comments from excel to access table (like to preserve old comments) Actual make table columns COMMENTS is blank; users will populate this column based on invoice number. I need to be able to append/update this...

Hi Guys I am fairly new with Access. I have created a database :p After running some queries, a table gets generated with invoice details. What I am trying to achieve, with no luck :banghead:, allow my users to update COLUMN field within this table. They have a form, on which, they select...

Hi Guys I have a make table query, on which I have created an additional field called COMMENTS. I would like to update COMMENTS field on this table via form depending on other other dropdown criterias on the form. Hope I am clear and you can help :) Many thanks in advance.