Search results

Brilliant, Thanks JR, that solved the problem and I can now import the data. I have one last problem (I think !) The existing table (RCO Data) that I am importing into has named fields e.g. DDI, Extension, FirstName etc. When I do the import I get an error message saying " Field F1 does not...

HI Sean, I tried the code that you suggested (included the Option Explicit statement) but when I run the code I get an error message saying: 'Compile Error: User-defined type not defined ' with the ' Dim fSearch As FileDialog ' statement highlighted. Do I need to define this somewhere...

Thanks for this, I will give it a try. for reference, the error message that I get is 'data has NOT been imported" i.e. my error message at the bottom of my code. Thanks again for the steer.

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

Cheers Bob, Easy enough to create my own 'menu'. At least I'm not going mad (thinking that there should be a second form) Thanks again for the info

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

Thanks All, I have solved the problem (with your help). For reference:I created a VAT field in the finance table and set the default value to 17.5%. Created a 'VAT form' so that different VAT figures can be added. Added a 'VAT' drop down Combo box to the Finance form so that different...

Thanks Neil If I added the VAT field to the Finance table would that not mean that I would have to enter the VAT rate for every record I created? It's no big deal if I do but it would be nice to be able to set it once (until the rate changed)

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

When extracted the file is placed on the local PC not on a file server. To be quite honest I don't think that the file properties have been checked i.e. is the file marked as 'Read Only' after it has been received. It is not marked read only when it is sent so I assumed ( I know that is...

Hi, thanks for the reply, I do send the DB as a zipped file and when received the file is extracted (not opened from the zip folder) but the DB still comes up as read only. I should have said that the DB was created in Access 2003.

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