Recent content by Mariot

I created a new .mdb, exported all the objects, did a new module with the last code, and voi-lá! I don´t know, I think the old .mdb had digital dirt or something (!?). Well, thank you for the code Keith!!!!

I mean, in your example, with my table (omitting the errors caused by empty or without number records), it works perfect.

I detected the following, I get error when the field is empty or it hasn´t any number (I think I can include a filter for that with some "If"). The thing is I don´t understand why it works different in my original .mdb, just getting "#error" in all the field, what am I missing?

I export my table to your example and tried it, it worked just fine, but when I scroll down a error message appear, number "5", in this line lngnum = CLng(Mid(sText, iStart, (iEnd - iStart) + 1)) And the error keep showing, I think I have to finish the application from the task maneger to...

I appreciate very much your help! Is a relief. Ok, I tried it and I got "#Error" in every field.

Another case: "Record Re37978/AAA/01" (with no space before the number)

In most cases, in other cases (sorry I didn´t put a example of those), you can find something like this: "Rec 23605" What I need is "(from left to right) the firts set of number in the field"

Hi! The function I need is similar to the solution of this thread . But I need to addapt it to my own string field. I present some examples of the data I need to manipulate: "Record 12345/AOP/2007" "Record 0123/2008" "Note N° 56478/DDD/2008" "Data 1114/2007" etc I will highlight the number I...

I´m also leaving, so I´ll try that tomorrow. About the english, I´m know quite enough, I studied at school, assisted at english courses, read a lot in english, listening a lot, etc. But I´m not that confident when it comes to writing. It´s like I´m trap in certain structures and is hard to...

Exactly =D Where do I apply or use that criteria? Thanks again Bryan PS: what about what I said in post #22?

No, there can´t be superpose inspections. Well, they can enter superposed time (it was to difficult to block that), but they shouldn´t. I should be something like 7/31/2007 > From 23:00 to 23:30 7/31/2007 > From 23:45 to 01:54 7/31/2007 > From 02:10 to 03:45 and there is the other problem...

And about me being a bad DBA :P: this thing wasn´t working at all so I was happy with something that worked partially. But I mean not that reckless, I try to respect the all the normal forms and other Access commandaments lol.

Yes, date and time are in two separated fields. Time is a range, i.e. "from 23:00 to 01:00" EDIT: forgot what I just said. The possibility of more than two success inspection in one day exist, I just check. I thought it was the other way around.

You are right, but is also a little severe also... Ok, I tried filtering by date instead of using the ID, using Bilbo model. It works if I use this: The first column should be the unique store identifier Field: idBusiness Table: tblInspection Total: Group By Sort: (blank) Show: (CHECKED)...

Wooooo that works!!!! Thank you, you good hobbit ^_^ Yes is a good and easy method of filtering the "last", working with the ID. The only problem I can see about it is the following: somebody entering a new inspection and later an old one. Because date doesn´t count, that can be the only...