Search results

Sorry, I have added another refrence to the library, and has stopped that error comming up on that section, however, where the password is it is saying varible not defined.

Hi, I have selected MSExcelAddin 1.0 Type Library Is this the right one? As the code isnt still working :( Thanks

Hi, I have put your code within mine, and it is brining up an error saying Compiled error User-defined type not defined and is highlighting 'oXL As Excel.Application' on the 'dim oXL As Excel.Application' line would you like me to copy all of my code accross? Thanks

Thank you, I will try this and get back to you to let you know if it worked or not

Thanks for all the replies. This was used in code to try and get the date format correct, but didn't seem to be working fully! I'll have a good read through that webpage. Thanks for everyones help

Thanks, I've already experianced that send keys is very unreliable! The workbook already opens and saves just with no password on, that is what the sendkeys before, I would prefer to password protect it without, if anyone could give me some example code this would be much appriacted. Thanks

Hi i was just woundering if anyone has seen this before, and if so could you explain what it does. Thanks Const strcJetDate = "\#mm\/dd\/yyyy\#"

Hi, I am using this code to export the spreadsheet, and cannot put a password on is this way: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "filepath", "filename"

Hi, I am using send keys to password protect an excel document. Here is the code once the spreadsheet is open: With oXL .Visible = True .Workbooks.Open (sFullPath) SendKeys "(%F)(a)(%l)" SendKeys "g" SendKeys "password" SendKeys "{ENTER}"...

So from this example: StrConv ("TECH ON THE NET", 3) would return - "Tech On The Net" Could i use StrConv ("Field1", 3)

That seems nice and easy - thanks for your help

Hi, in the database I am working in, there is a function, in a moduel, which puts the first letter in the first 2 words in uppercase (used for a name), e.g. john smith would become John Smith. I want the code to work for more than 2 words (the number of words will change). How would I addapt...

I am currently running all of my databases off Access 97. We want to move all of the information over so that it is stored on SQL Management studio 2008, but will run off the access 2003 interface if possible. What is the best way to do this? Are there any tutorials, or programs out there...

Thank you very much

I am trying to convert the date in a table (table name - 2009-2011 event records) with the field name 'Date of registration' with the data type numer and layout YYYYMMDD, into DD/MM/YYYY, does anyone know the code to do this please? I have tried other codes off the internet such as...

Thanks for the help

I have wrote up an example of the problem I am having: The following forms are on the database: Frm_Main_Menu Frm_Search_Customer Frm_Customer_Details Frm_Add/edit_Customer_Details From the form Frm_Main_Menu there are links to, the form Frm_Search_Customer, and to the form...