Search results

Fizzo I am getting an error message that From cannot be a Zero length string and in most cases it is Public Sub Oxidation_Click() On Error GoTo Err_Oxidation Dim rs As DAO.Recordset, strPrevTo As String Set rs = CurrentDb.OpenRecordset("tblOxidation_ExprtPoint", dbOpenDynaset) Do Until...

Bit confused Thanks for the reply Fizzio I understand how the code you gave me works..... but (always a but in there somewhere) I am not getting any result with it. I have put code behind a command button, after it runs a couple of other queries to get as far as the table I showed it then...

Bit confused Thanks for the reply Fizzio Oops sent it early

2:confused: I have a the following table tblOxidation_ExprtPoint HoleID From To Feat All new HoleID's should begin from 0 metres. The from should be equal to the prevous To ie. hole_id From To feat AFC0001 0 38 BOCO AFC0001 38 73 TOFR AFC0001 73 100 PRED AFC0002 0 43 BOCO AFC0002 43 65 TOFR...

perfect Thanks Again Calvin Exactly what I was after Cheers Cress

Thanks Calvin I got rid of most of the code as you suggested. The only problems now it ends up opening 3 different instances of excel, one for each file. This would be fine but I have a hidden file in excel containing a heap of macros and this file is set to open first when you open excel. If...

Hi I would like to be able to open multiple files in excel. The user has the option, after exporting the tables, to view them in excel. I have the following code behind a command button which open one of the files. Private Sub OpenVulcanWorkFiles_Click() Dim oApp As Object Set oApp =...

I have a form that has many tabs the control source for the form is tblEOM_Selection and this table is populated by a query qryEOM_SelectionAD. the on change event for the Tab control is set to Private Sub TabCtl0_Change() If TabCtl0.Value = 1 Then DoCmd.Openquery...

I am importing tables from another database that have the same names as tables in my database. My tables have existing relationships. I am using vbCode to remove the relationships, delete the existing tables import the new tables and then reinstate the relations after the new tables are...

wrong post sorry nothing to see here I am importing tables from another database that have the same names as tables in my database. My tables have existing relationships. I am using vbCode to remove the relationships, delete the existing tables import the new tables and then reinstate the...

Does anybody have a clue?? Is my question stupid or just hard to understand or nobody knows? not getting tetchy just need help, bad.....:D

Thanks Guys beats me how it ran, just did. I'll put your suggestions into action and see how we go. Thanks heaps

Sorry, It's always hard to explain something you do and understand as if by second nature to some one outside. The mining industry by its nature is never consistent. Engineers are in control, or out of control depends which way you think. Hope this clarifies Controls: FaceNum = 01 FaceID =...

Hi I have a Form [frmDetails], which is bound to a table [tbleHeader] and contains a sub form [frmSubSamples] which is bound to a table [tblSamples] both forms are linked by [FaceID] primary key. On frmDetails the user enters the header information for each FaceID and on frmSubSamples enters...

First problem solved, created another Thanks Rich and dcx693 It seems that my code it becoming defunct When I wrote this most of it I got running by trail and error and with the help of a couple of thick books (mainly used to bash the monitor). Since it ran I didn't question if it was...

:confused: I have recently changed to 2000 and am experiencing probs with my code This code calclulates Samples and sample intervals, well it used to but now it prompts the message: User defined type not defined Im' guessing it is something 97 did and now 2000 does it differently. The red...

:confused: Forgive my gibberish I have recently converted my database over to 2000 I have started getting an error message. "The search key was not found in any record " I have a master form linked to a table and an imbedded subform with child links to the master. It has been running fine...

Thank you that worked perfectly ;)

I have set the primary key in my table and set the indexes to Yes(no duplicates) and this work fine. When the client enters a duplicate value the standard Access msg pops up. Now what the client would like is for the msg to be something that they understand not a big paragraph. As they have...

I am trying to return a confidence interval for a population mean and am having touble writing it into my report as a calculated field. please help....going insane :D