Recent content by adgjqetuo

I created a database which when macros are enabled the only thing visible on the screen is the forum. All tables as well as the ribbon bar is disabled. I also disabled right-clicking. My issue is, for those who do not have macro's enabled, it opens up in design view and allows access to the...

That would be great. Can someone here help me with that or should I reach out to the function / module section?

How will that solve my problem? The sequence needs to reset at each ID number. Looking at my sample data above - ID 1 has 1-4 and ID 2 has 1-3, etc.

I have two tables - one with parent Records, the other with child records. The ID links the two tables together. I want to add a sequence number on the child table which resets at each ID change. What would be the best way to accomplish this? PC_ID ID Name Address P...

Thanks for the help - after writing this, I just decided to write the thing in SQL and save it for future use. SELECT f.* FROM Keywords k, Main_Tbl f where (f.address1 like '*' & k.keyword & ' *') OR (f.address1 like '*' & k.keyword & ' *') or (f.address2 like '*' & k.keyword & ' *') OR...

Hi - hoping someone can help me here. I'm looking for some type of custom function that will search a specified column for any keywords listed inside another table. I can run a query on each keyword individually, however there are 50 and it takes a long time each time I do it. I was hoping to...

I think I finally got it working with CJ_London's suggestion! I have to conduct through test later on this evening though. select u.* from( select v.* from ( select w.* from( select x.* from ( select y.* from ( select z.* from( select distinct e.empl_last_name & ', ' & e.empl_first_name...

Hi - thank you! I think you may be onto something, but i'm getting a syntax error when trying to implement - maybe i'm not correctly joining in the new "T" sub query?

So is there another solution to make my query work? And to clarify, I need this to work in Access 2007, not Oracle. My current query above works as-is in Access, I just need it to partition by each empl_id.

Hello, If I was using Oracle I would typically use a "ROW_NUMBER () OVER PARTITION BY" function, however it doesn't appear access supports that. I created the below query which works great, except it doesn't partition by the empl_id field. I get that is the function of "Top 1", but I really...