Search results

Hello I have just started using Access2010 or at least upgraded from a previous version. The previous version had a custom toolbar with various links to external websites / folders/ excel spreadsheets on upgrading this toolbar is available in the add on menu , however, some of the links have...

Have you tried looking at the northwind database. This will show you code which updates your stock automatically as orders are created and new stock comes in

Hello I think i'm really starting to understand your code here. Its just the first few lines i'm unsure of in terms of understanding assigning a database to a spreadsheet Also "You can start exporting your records to the first empty row by applying the AddNew method." I guess i would just use a...

Hello Thanks for your help on this matter. I'm trying to understand the listbox to excel transfer. I don't actually need this at this time as i have already done this through transferring the listbox selections to a temp table and then using DAO to transfer to excel. Yours is a quicker method...

Hello I have an excel/Access automation questions. I have produced a recordset from listbox selections which i move to a temporary table then i have an excel template which i export the data to starting at row17. The field names in the access table and the column headings in the excel sheet...

Hello I have an excel/Access automation questions. I have produced a recordset from listbox selections which i move to a temporary table then i have an excel template which i export the data to starting at row17. The field names in the access table and the column headings in the excel sheet...

Hi Can no one help with this?

Automate the transfer of multiple excel files to one Access table. Hello. I'm new to this forum and whilst not a complete newbie to Access or excel or basic VBA programming i didn't have a clue how to do this but i did find some code when searching for answers through google However, i want...

Just like to introduce myself. I'm clifton and i joined this forum because i have decided to give Access another try . I used access before but never got round to do any but the most basic programming but now i have taken on a project to automate some daily tasks i do at work. This involves a...