Search results

I have got a excel spreadsheet, which has got 5 macro's on - due to the size of the spreadsheet. These macros are on an PERSONAL.XLSB, on I can run these on either a different spreadsheet or a form in access.

I have got a excel spreadsheet, which has got 5 macro's on - due to the size of the spreadsheet. These macros are on an PERSONAL.XLSB, on I can run these on either a different spreadsheet or a form in access.

A big Thank you. Another question I have got a excel spreadsheet, which has got 9 macro's on (due to the size of the spreadsheet). Is there a way of either linking these macro's together on a spreadsheet or can I link them to buttons on a form in this database?

Hi Isskint Thanks I will try that later today. Please see attached a copy of the database.

So is there anyway of fixing this macro??

Sorry at the moment I'm just testing to see if it works. Then I plan to put a button a main page (form) and then link it to this macro. Both opengrn1 & despatch are tables within the database.

This is using the Expression Builder and selecting the tables and the columns for it.

I have tried this again, as per the attached macro. But the attached error message appears.

I have just tried this and i get the following error, when using the Access Macro - as I'm sure what the full coding is for the VBA way. Microsoft Access cannot parse the experssion: 'If{opengrn1]![STK holding] / [Despatch]![Cartons Despatched] <=2. Click Ok to return to the action argument or...

Hi Is it possible to import an excel spreadsheet which contains some merged cells. What I have got is a spreadsheet (like Raw Data in the zip file) and I need it looking like (Finish Data) but in a access table. I have attached a copy of the spreadsheets.

Hi I wondering if somebody could help, I would like to use a IF macro to display two different reports if possible? This is what I want to do... If [Opengrn1]![STK Holding] / [Despatch]![Cartons Despatched] <= 2, then display a report to show all stock that won't last two weeks. OR If...

Thanks for your help, all sorted.

Hi I need some help with uploading a excel spreadsheet into Access 2010 1.Need to add an Browse button, so that the user can find an excel spreadsheet 2. I want to add an upload button, so that the user can upload the spreadsheet to a specific table 3.It also needs to overwrite the original...

Just saying hello to everyone.