Recent content by dtutton

I have been using a spreadsheet with vba to read from access database in all versions from Office 97 to 2013 and it worked on a 32Bit 2013 office deployment (on 64bit machine). Same routine on Office 2013 64bit fails. Fails on command: Set DB1 = OpenDatabase(mymdb, False, False) Run-time...

Thanks for this - I will give a try

Ive managed to embed media player in Excel (2010) and control the size and starting and stopping. I want to contol the speed. Has anyone done this and suggest a method Thanks

Works Perfectly - Thanks Pete

Thanks Pete, Im showing my ignorance in Access - I think VBA is easier in Excel. How to I update the field with GetUser and Now. I tried: Me![AddedBy].DefaultValue = GetUser Me![AddedDate].DefaultValue = Now in the BeforeUpdateEvent in a field in the sub-form but get an error(s). In the...

Thanks Pete, What code do I use to get the system user id name Thanks

When I add a record in an access form, how can I update a user name field and date changed field. Thanks

Thanks Ken That is what I had been trying but I get "Unknown user 'CurrentUser' in validation expression or default value on table1" when I close the design editor of the table. Thanks David

Im hoping to avoid modules, macros etc as Im a new user. Is there any way that in a table definition that I can put an expression in a Default value that picks up the current user i.e. something like CurrentUser() the same way as now() for current date. Thanks

Does anyone know of an excel addin to read a pdb file (generated by pda toolbox) Thanks David

Thanks - the indirect command is what I was looking for. However, it does not seem to work if the workbook refered to is closed or in a different directory path to the calling sheet. I guess for this one has to go to vba ? Thanks DT

Im trying to refer to data in another spreadsheet indirectly. i.e. in Book2, Sheet 1, A1 I have the text "[Book1.xls]Sheet1!D12" I want to return the contents of this refered to cell to say Book2, Sheet 1, A2. How can I do this without making a direct reference. i.e. I want it to...

Can anyone suggest a good place to start for information with linking Excel and MS Project. i.e. Do all data entry and vba code in excel and use project for gannt chart reporting etc

Paul, At present I havent found a solution and have found that Im not alone with problem. Ill give your idea a try and let you know. At the moment Ive reverted to the dBaseIII solution. Ill keep you posted. David Tutton dtmineconsulting.com

Ilse I found problem disappeared when I closed a second window referring to same spreadsheet but didderent page. Strange but resolved problem. Thanks for help David