Search results

Hi, I need to import data from a specific Excel worksheet (RCO Survey) into an existing table (RCO Data) but I want the user to be able to define the range of the worksheet that is imported. The also determine where the spreadsheet is (e.g. which directory on their own PC) I am not too good...

Hi, I have a database with a Main Switchboard, one of the options opens a second switchboard (for pre defined reports). I want to change the design (not the content) of the second switchboard slightly, but in design view I can only see/change the main switchboard and not the second one. Is...

Hi, I have created a simple invoice database that works fine, however, I if the VAT rate changes I want to save the existing records with the old VAT rate (for audit purposes) and let any new records reflect the new VAT rate. The VAT calculation comes from a 'Company Details' form (and...

Hi, I have created an access database which works fine on my laptop but when I email it to a friend, it opens in Read Only and they cannot change it. I have got rid of all restrictions (I had limited menu's etc) and I have checked the Access settings (that the database is shared etc). I have...

Hi, I have a spreadsheet with multiple worksheets that I import into MS Access. I'm new to VB but I can get the import to work fine using the 'TransferSpreadsheet' expression i.e. (TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA) (I've...