Recordno
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 45 articles for 0.303 sec
Hi I've got a module that is very complex. There's a sub (ProcessRecords) that's called to validate and do all sorts of things to a group of records. The sub then calls many other subs/functions to do the job. The problem is that I'm using one transaction for the sub, so all the processing/changes/queries that are used within the other called subs functions are not committed until the     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Recordno in microsoft.public.access.modulesdaovba
Author: Julia B
Date: Jun 19, 2008 06:56

Dave Firstly thanks for pointing out the glaring clanger with the recordset opening and closing. I've changed that! I've also changed the SQL syntax to replace + with &. Unfortunately the other problem is still not solved. I originally had the code written as you have: If IsNull(rs!fldName) Or rs!fldName = 0 Then and changed it to If rs!fldName = Null Or rs!fldName = 0 Then - got the
Show full article (5.78Kb)
Here is the problem in your code: If rs!fldName = Null Or rs!fldName = 0 Then It should be: If IsNull(rs!fldName) Or rs!fldName = 0 Then Or If Nz(rs!fldName,0) = 0 Then You can't compare anything to Null as you are doing. Even Null = Null will return false. (I should have seen that the first time) But still, reviewing your code, I don't see why you are getting a duplicate key with     

Group: microsoft.public.access.modulescoding · Group Profile · Search for Recordno in microsoft.public.access.modulescoding
Author: Julia B
Date: Jun 17, 2008 08:41

The original error occurs here: If rs!fldName = Null Or rs!fldName = 0 Then FYI, this is a snippet from the procedure that calls the function, if that helps: 'loop through each line and get the data Do While Not ts.atendofline strLine = ts.readline MatlDoc = Trim(Left(strLine, 10)) MatlDocYear = Trim(Mid(strLine, 11, 4)) MatlDocItem = Trim(Mid(strLine
Show full article (11.21Kb) · Show article thread
On Jun 16, 3:33 pm, "Isaac J." <m...@privacy.net> wrote: > On Mon, 16 Jun 2008 13:26:47 -0700 (PDT), alkami...@hotmail.com wrote: > > On Jun 16, 3:16 pm, Paul C <p...@thersgb.net> wrote: > >> On Mon, 16 Jun 2008 12:07:26 -0700 (PDT), alkami...@hotmail.com wrote: > >>>On Jun 16, 1:18 pm, alkami...@hotmail.com wrote: > >>>> On Jun 16, 1:09 pm, Paul C <p...@thersgb.net> wrote: > > >>>> > On Mon     

Group: microsoft.public.access.modulescoding · Group Profile · Search for Recordno in microsoft.public.access.modulescoding
Author: Klatuu
Date: Jun 17, 2008 08:29

On Mon, 16 Jun 2008 13:26:47 -0700 (PDT), alkamista@hotmail.com wrote: On Jun 16, 3:16 pm, Paul C <p...@thersgb.net> wrote: On Mon, 16 Jun 2008 12:07:26 -0700 (PDT), alkami...@hotmail.com wrote: On Jun 16, 1:18 pm, alkami...@hotmail.com wrote: On Jun 16, 1:09 pm, Paul C <p...@thersgb.net> wrote: On Mon, 16 Jun 2008 11:04:20 -0700 (PDT), alkami...@hotmail.com wrote:
Show full article (10.11Kb) · Show article thread
It isn't that it can't find the table. You successfully opened the table UnmatchedDocuments, or you would have and an error on the OpenRecordset line. It is you are not finding anything with the Seek method. The Seek method only works for table recordsets. That is, local tables, not linked tables. For linked tables you need to use the FindFirst method: It would be MySet.FindFirst     

Group: microsoft.public.access.modulescoding · Group Profile · Search for Recordno in microsoft.public.access.modulescoding
Author: Julia B
Date: Jun 17, 2008 07:58

Function UpdateUnmatched(WordDoc) Dim RecordNo As Long Dim myDb As DAO.Database Dim MySet As DAO.Recordset Set myDb = CurrentDb() Set MySet = myDb.OpenRecordset("UnmatchedDocuments", dbOpenTable) MySet.Index = "WordDocFile" MySet.Seek "=", WordDoc.Value If MySet.NoMatch Then MySet
Show full article (6.49Kb) · Show article thread
Paolo, thank you for your answer. It works now. Btw, I checked the content of the variable m_mabc by looking into the table and except from a few records, all records are alphanumeric. Thanks again for the quick and reliable solution. "Paolo" wrote: > Hi Amduke, > perhaps till record 2366 m_Mabc is numeric so your search criteria could > work and then in record 2366 there's something     

Group: rec.sport.soccer · Group Profile · Search for Recordno in rec.sport.soccer
Author: alkamista
Date: Jun 16, 2008 13:43

Hi Amduke, perhaps till record 2366 m_Mabc is numeric so your search criteria could work and then in record 2366 there's something alphanumeric that make your criteria unaccetable so try to initialise your criteria in this way: SrchStr = "[CART] =""" & m_Mabc & """" HTH Paolo "Amduke" wrote: Hello all, hoping to find some solutions over here. The problem I encounter
Show full article (1.79Kb) · Show article thread
    

Group: rec.sport.soccer · Group Profile · Search for Recordno in rec.sport.soccer
Author: Isaac J.
Date: Jun 16, 2008 13:33

Show full article (1.43Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Recordno in microsoft.public.access.modulesdaovba
Author: Klatuu
Date: May 22, 2008 15:14

Show full article (2.32Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Recordno in microsoft.public.access.modulesdaovba
Author: metalicsillver
Date: May 22, 2008 13:53

Show full article (1.19Kb)
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Recordno in microsoft.public.access.modulesdaovba
Author: Amduke
Date: May 20, 2008 01:00

Show full article (2.72Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Recordno in microsoft.public.access.modulesdaovba
Author: Paolo
Date: May 19, 2008 23:48

Show full article (2.33Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · next