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

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

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

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

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

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

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

Im trying to import data from a password protected access database from excel vba. Im using the lines: Dim DB1 As Database Dim RS1 As Recordset On Error GoTo ErrorHandler Set DB1 = OpenDatabase("c:\temp\Test.MDB") Set RS1 = DB1.OpenRecordset("Testtable&quot...

Im using a textbox to do a calculation based on on a field in a subform. The subform is in dataview format displaying several rows of data. Currently I use: =[Commodity Quotations].[Form]![price] as the control This addresses the price in the first row. How Can I address the second row or...

I have previously used good old dBaseIII as a manipulator for large data files with clipper routines. I have a geological model with 3 million records and about 120MB in ASCII format(this is a small one the last was over a GB and 8 million records). For ease of handling Ive broken down into...

Im using the MSCAL.Calendar.7 activeX control and want a form field to update on a double click of the date selected in the ActiveX control. Currently I have Private Sub ActiveXCtl6_Updated(Code As Integer) Me!Quote = Me!ActiveXCtl6 Me.Refresh End Sub But it only updates when I click on...

Can one use rferential integrity to add a record to two tables? I have tested with delete and it works fine but cannot get to add a recod to both tables ? David

I have a table with a pimary key consisting of two parts i.e. xxxYYY like where xxx is the three letter equipment type code i.e. DOZ and YYY is a numerical sequential number i.e. DOZ121 When I add a new record I wish to automatically number using to the same sequence i.e DOZ122 I need some...

Can one put conditional expressions in the Control Source of a text box. i.e. Currently =[TireCost]/[TireLife] but if TireLife=0 I get a divide by zero which I need to trap, can one do something like =if(Tirelife=0,0,Tirecost/Tirelife) as in excel ! David

Im trying to use an expression in a form text label to relate to data in a subform. Specifically Im refering to the first record of the subform (Quotes) where there is a field price. Can I refer directly to the subform or do I have to set up a query refering to the table.

I have a Dlookup expression as follows: =DLookUp("Price","TyreQuotes","DATNo=" & [Forms]![EquipmentData]![TyreDATNo]) in the Control Source of a text box where "Tyre Quotes" is a query, "Price" and "DATNo" are fields in the Query and...

I have a sub-form on a form. With AllowEdits turned on all data on the form and subform can be edited. With AllowEdits turned off, nothing can be edited - fine. So I then put in a command button on the form to AllowEdits with a on click event. This allowed edits on form but NOT on sub-form...