Recent content by mudster01

Hi All i'm importing various excel files using transferspreadsheet from a network dir, & the dir filepath is defined in a form bound to general details table e.g strpath = "F:\temp\import.xls" ...however now other people are using this database the required dir may be mapped to another...

HI All - i have a number of text boxes which user can change values, however on change of value the bound table does not update until the form is exited. How do i ensure the table updates regardless of exiting form or not? Many thanks, M

Hi I'm trying to create new database but get runtime err 3204 "Database already exists" however i thought the kill removes it, also i cannot actually see the database after code runs 1st time round. Code is as per the help files: Sub createnewdb() Dim dbnew As Database Dim wrkDflt As Workspace...

ooohhh, many thanks!

Hi All i have db which compacts on exit - hitting the "x" in top right, i found the function code but cannot find the trigger - would this be in class module or is there similar trigger to "startup", and cannot trap the code cos db closes. Help appreciated. M

thanks......obv the best way is the simplest, but is there anything obviously wrong in the code which is not letting me do it this way....its quite useful to know as i want to add total formulas at the bottom which i guess will be found using the xldown?

Hi I'm a beginner at this stuff so please be patient, have exported a table using copyfromrecordset into excel setting variables: Dim objExcel As Excel.Application Dim objDAORsData As DAO.Recordset dim r as range 'when table is copied go onto do various formatting With objExcel...

Hi All I want to import file into access - could be text or excel but also the directory may vary each import so want to open the dialog box so user can find file...then begin import IF .xxx = txt import text else import excel. Any ideas much appreciated. Thanks, M

ah, someone has kindly pointed out the function "isnumeric".

Hi All Can anyone help me with code to find out whether a field consists of numbers or not i.e. similar to the excel function IsNumber. Your help is much appreciated. I assume i need to pass the field as a parameter to the function & loop through each char, but stuck on how to check each = 0 to...