Recent content by matomo

Thanks jdraw for pointing me to the model in Access World Forum. I will study this and let you know what I can come up with. matomo

jdraw, Thanks for the quick reply. All of the questions that you raised are true. We allow referee to be unavailable for any reason Referees do have some preferences for refereeing close to where they reside. Referees can be assigned game individually or randomly. We are stranding for...

Hi all, I am attempting to create a database that an area soccer referee assigner can use to assign referee to various soccer games. The assigner has soccer referee, games and different teams. There are 3 soccer referee to each game, therefore the issue is that I need all the referees that...

VbaInet, Thanks for your suggestion. matomo

VbInet, only one table is needed in the report (i.e. tblROLLNUMBER).See the attached sample. I have tried the code below but I am still missing something. What I am trying to do as explained before is to find duplicates if the street Address is the same and hide them when printing the report...

Hi all, I have a problem and the problem is this: Is it possible to Find Duplicates and Hides All But 1 Row in Report? In the attached database report 125 Evelyn Cres appears twice one record for the Public School and the other record for the Parking. What I want to do is this Hide all the...

Thanks guys. This what I am looking for. matomo:)

Dear all, Can somebody please help in solving this problem that I am having. What I want to do is as follows: (A) Read the value from this Field FDVPDMB (Text Field) 1. When value is preceeded by an *, characters 2 and 3 should be read and Display in Application Type Field on the Form. 2...

Oldsoftboss; Thanks for your valuable help. It works perfectly. I have studied your query it is exactly what I was trying to do. Thanks again. You are an officer and a gentleman. matomo:)

Oldsoftboss; Thanks, I have tried your suggestion but nothing works. What are my doing wrong. Please explain further. Thanks. matomo

Hi Is there a way to display a text field that is bound to a numberic field in a combo box when the text field hav a numeric value of Null Table "tblOddEven Field 1 (Text) Field 2 (Numeric) 1. Both Null (Blank) 2. Even 0 3.Odd 1 If Both or Even is selected in the dropdown box on the form no...

Access Guy49, Thanks you for the fix. matomo

Hi all, In my query I can query for ODD or EVEN Street Numbers using the syntax below: OE: [PROPHOUSENUMERIC] Mod 2 This works fine returning just odd or even numbers. Now the problem I am facing now is that I wan the same query to return both Odd and Even Street numbers if I did not ask for...

Thanks AntoMark. I will try your suggestion. matomo;)

Hi all, I hope someone can point me in the right direction on what I am doing wrong here. This my first dable into puting SQL into a function module and I can only get a partial result. What I am trying to accomplish is to extract dates and descriptions from Oracle tables which I have already...