Search results

Hi I have embeded Excel 2003 sheets embeded into my form (better charts) and I have two sheets on the excel - sheet1 - chart (chart is only displayed on the form) sheet2 - external data query pulled from within the same database My issue is that I can refresh the data (Sheet2) only when I go...

I am using code from the microsoft site below to check linked tables in my database when to database opens and then prompt the user to locate the data source if it's no longer found. (not using the common dialog control though) http://support.microsoft.com/kb/181076/en-us This works great...

Can some please tell me if there is an equivalent of the excel LN() function in access. I have tried to find it all over the web and beyond and cannot :( I dont mind if there is a long winded work around for this function. I am using it in a query and it shows unrecognised function but for...

I have looked through this Forum backwards and forwards I am using the following code to open a .las file (essentially a text file) in excel and save it as a .txt file, then import it into access. I cannot get rid of the instance of Excel that open during this process The rest of the code...

I am having to open a delimted .LAS file in excel as access will not import a file that is both TAB and SPACE delimited. The following code is meant to open the delimented .LAS file in excel and save it as LasImport.txt. I am getting the following error Object does not support this property or...

Hi, I wish to use the results of a crosstab query in another query which will make table. The trouble is the field names are not always the same in the crosstab. The results are coming from a normalised table so if there are no records for a particular field then that field will no appear in...

I am trying to append record from one tables to another... sounds easy but there is a catch. The 1st table tblTexuralCode is structured: HOLE FROM TO Mj1 Mj2 Mj3 Mj4 Mj5 Test 0 1 AB Test 1 2 AC AR Test 2 3 AS AV AB Test 3 4 AB AV Test 4 5 AV AC the new table tblTexturalNew is...

I have many columns on a datasheet imbedded into my form and they don't all fit on one view. Need to slide right to see them. I would like to be able to show only selected columns at the press of a command button. I don't want to hide the other columns but just force the screen to slide to the...

Hello good people of the forum In the attached db example2 the report "report_log2" is not sorting properly for me. Ideally it would be sorted by the first field depth "from" and then by the assays "from" field. The problem is that not all of the assays "from" fields have values. The ones...

I know that this may seem like it's been answered 1000 times on this forum already but I can't figure it............. I am trying to sum some fields on my subform but it keeps comming up with #error. I know all of the reasons why it would normally do this. Naming controls the same. Not looking...

Hi I am trying to send a report to one email from form. My code is fired from a command button. It flashing up quickly saying that it's sending the report but nothing happens. We use Novell Groupwise. DoCmd.SendObject acSendReport, "StopeReport_Rise", _ acFormatHTML...

Hi Yes I know how to positon a form use docmd.movesize but I have a problem with a floating form that the user can open. On my PC it opens exactly where I want it to but on someone elses it moves slightly over and covers another form. What I would like to happen is that the popup form stays in...

Hello My databases are shutting down when I try and open any of the reports. My reports are opened using a command button and every one of them, in 3 of my non-related databases are causing me to be kicked out of the databases without warning. This only started happening today for no reason that...

Hiya I am trying to update null fields in a table with records from another field using the following code. Public Function FillFrom() Dim rs As DAO.Recordset Dim strPrevTo As Integer Set rs = CurrentDb.OpenRecordset("tblOxidation_ExprtPoint") Do Until rs.EOF If IsNull(rs("From")) Then...

Hi On my report I have the following fields: [PEOri$Cap] [PEDrill$Cap] [PESurvey$Cap] [PEStandBy$Cap] The control source for the report is a qry. [TotalPECap$] is the total for above fields. control source for this one is: =[PEOri$Cap]+[PEDrill$Cap]+[PESurvey$Cap]+[PEStandBy$Cap] My problem...

Hiya I would like to append the current/active records on one form to another open form. Form 1 [frmCollarDesign] (from tblMainCollar PK is [HoleID]) has some design information fields that I would like appended/copied to [frmDrillPlods] (from tblDDHEOM). This will save dataentering the...

Hi I am trying to create table defs for a new table called tblMainAssay and would like to know if I can create 2 primary keys. I know I can do this in the relationships window but not sure how to insert it into the vbCode. I want HoleID and Depth_From to be the P.Keys. I know it goes in the...

Hi I am trying to find multiple occurrences of a value, SizeCode. I would like to show the minFrom_Depth and maxTo_Depth for when each SizeCode occurs. Each SizeCode may appear more than once at different depths. I have the following tbl tblSampleSize HoleID From_Depth To_Depth SizeCode I...

Hi I have a report coming of off this table tblDrill_MnthCosts Year Zone Coresize Metres DrillCosts I have grouped by the Year and Year and am trying to sum([metres]) and sum([DrillCosts]) for each Year. To do this I put a control in the Year Header. It sums both fields for the Year but they...

I wish to make a new table with ID as a autonumber field. I am using the code below to achieve most of this. I can't find the right data type to get the ID as autonumber Can you? Function makestag1() Dim db As Database Dim tbl As TableDef Dim fld As Field Dim idx As Index...