Search results

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

"Time" consist on two fields, it´s a range really. And the problem is that the "day" doesn´t start at 00:00, so, I don´t know. But, I think that the lesser of my problems... I just can´t filter the inspections and get the one I want. I think the firts step is to get Access to give me the last...

Thank you for answering This is a duplicate of this thread http://www.access-programmers.co.uk/forums/showthread.php?p=613696 (my mistake) Every inspection have an ID, and is linked to a Business or Store. I tried the MAX in the query but it doesn´t do a thing =(

It´s ok, I don´t think I´m gonna solve it today, so I will take it again monday. Bananas, I tried adding DISTINCT after SELECT, but it didn´t affect the result... so I wonder if there is another way of using the DISTINCT... I mean, how do SQL know where he has to apply the DISTINCT, in wich...

I have to study the SELECT DISTINT thing... I think it could help. I never used it before. Something like this may help: SELECT client name, worker, `time` FROM yourtable WHERE `time` IN (SELECT MAX(`time`) FROM yourtable GROUP BY client name) (I saw it...

Right now that´s what I have, one query that filter "open" and "with irregularities"; and the other for the "max date". Thank you Brian :)