Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LuckyDanger
- Order by date
-
MS ACCESS Delete Dups based on criteria
Slow but works a treat, many thanks.- LuckyDanger
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
MS ACCESS Delete Dups based on criteria
I have a table in which I have the following fields: Row Lead_Code Lead_Ref Name 1 123 123A Another 2 123 123B Another 3 125 125A OJ 4 125 125B...- LuckyDanger
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL 'Where criteria issue'
Thanks to both! PHV & Golom- LuckyDanger
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
SQL 'Where criteria issue'
The main aim of the SQL query is to show only records with 'A0' or 'A1' in a field and also only show those records in another field with 't1' or 't2' Not all appropriate records are returned with this query i.e. expected results show records missing. Here is my sql query: SELECT...- LuckyDanger
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Insert Time after Data entry into Excel
Hi All, I need some of your invaluable help. I need some vba to insert the current time (shown on PC) to work in excel. EG When data is selected in a validation list in Column D the current PC time is inserted into Column K in the corresponding row. So I really need some code to run after...- LuckyDanger
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA Code
Thanks very much. It certainly seems a long road to learn but I'll stick with it. Thanks Again for your help.- LuckyDanger
- Post #5
- Forum: Microsoft: Office
-
Excel VBA Code
Sorry new to this: After recording I only have: ActiveCell.Copy Sheets("2").Select Range("A3").Select ActiveSheet.Paste Sheets("1").Select Application.CutCopyMode = False I need to paste into the next blank cell in a row. i.e. Where the next blank cell in Column B is...- LuckyDanger
- Post #3
- Forum: Microsoft: Office
-
Excel VBA Code
Excel Worksheet: I want to copy the last data input in Column A and paste into another sheet to the next cell in column A where Column B is Blank. Can anyone help provide a vba code? Many Thanks- LuckyDanger
- Thread
- Replies: 5
- Forum: Microsoft: Office
