Search results for query: *

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

Im trying to link a check box to a cell but no LinkedCell shows up in the property box. Using Excel2k. Do I need an addin or additional reference. Thanks David

I split this way as certain tables are specific to specific users and come from separate sources via excel. Only common field to each table is the "project"

I guess thats part way there but after finding the record in each table, I want to copy it and then paste append it and then change a field name before updating. I dont have a problem finding the record but as each record has about 200 fields, I dont want to have to copy each field to a default...

Matt, I found one solution to same problem was to put a command button on the first form to call the others. i.e. from Command button wizard, choose form operations open form the 'Open form and find specific info to display' then choose the common field to each form etc. On clicking on...

From one form, Im wanting to set a command button to duplicate specific records in multiple tables. i.e. I have about 9 tables with up to 150-200 fields but all with the same primary key. The data is for specific properties. So for example, I want to establish a duplicate set of records for...