Recent content by smellyalater

Thank you arnel it works perfectly! Have a great day!

I don't arnel but it will be easy to add so I will try this code. Thank you very much!

hi arnel I want to remove the 'main' from any unique ids that have any more than one so it would look like this after running the code: +-----------+--------------+--------------+ | Unique ID | Product Cost | Product Type | +-----------+--------------+--------------+ | 62208 | £89.99...

Hi Guys I am wanting to remove certain parts of data from a table. Here is my data: +-----------+--------------+--------------+ | Unique ID | Product Cost | Product Type | +-----------+--------------+--------------+ | 62208 | £89.99 | Main |...

Hi Guys Is there a way to append a record multiple times, if some fields have different values? EG. Title | Name | Surname | Q3 | Q2 | Q1 -------------------------------------------------- Mr | Test | Test | Yes | Blank | Maybe I want to append this record twice but seperate it...

Hi FoolzRailer This link here will help you achieve the prompt for saving to a certain location: http://access.mvps.org/access/api/api0001.htm

Try a compact repair as that should work fine.

Hi guys Getting to know access and already learnt a lot browsing this site, signed up to help others and go gain more knowledge. Thanks in advance!

Thank you for the replies guys, I will give it a shot today once I get home! Again many thanks!

Hi If a 1 is in the unique field the number is unique, if it is 0 then it is not. Thank you

Hi guys I was advised to come to this part of the forum as |I would love to do this through VBA: These are my before and after code is ran table: ID, mobile, datetime, unique 1, 07712312312, 14/04/2016 13:02:34, blank 2, 07712312312, 14/04/2016 13:21:13, blank 3, 07712312312, 14/04/2016...

I think I will do that Plog, thank you for you help but I would rather do it through VBA. Thanks!

Sorry Plog I just wrote that up quickly. The table names are: tbldata and the actual field names are ID, mobile1, dtm tbldataunique and the fields are ID, mobile1, dtm, unique I want to do something like this: If datediff(minute,previousTIME,currentTIME) >15 Update table Set unique = 1 Else...

Hi Plog Thanks for the fast replies. Here is what I am going to start with in my table: ID, number, date/time, unique 1, 07712312312, 14/04/2016 13:02:34, blank 2, 07712312312, 14/04/2016 13:21:13, blank 3, 07712312312, 14/04/2016 13:23:56, blank 4, 07712312312, 14/04/2016 13:02:34, blank I...

There is no real big picture. There is just multiple mobile numbers going into a table loaded every hour and I just want to run some code to put a 1 beside the first unique one and 0 beside the rest if that makes sense? Thanks