Forum: Programming

Access programming discussion.

  1. VBA Data Import Routine (multipe XLS into Access) with duplicate fields/values into DISTINCT tables

    skydivetom
    4 Pages •
    1 2 3 ... 4
    26 Attachment(s)
    • Replies: 53
    • Views: 8,585
    orange
    06-24-2021, 10:49 AM Go to last post

  2. Msgbox to include **Counter** as part of DELETE TABLE ("Success" or "Failure")

    skydivetom
    2 Pages •
    1 2
    12 Attachment(s)
    • Replies: 24
    • Views: 4,255
    skydivetom
    06-25-2021, 06:08 AM Go to last post

  3. Need to INSERT default value into multiple tables

    skydivetom
    2 Pages •
    1 2
    3 Attachment(s)
    • Replies: 18
    • Views: 3,164
    Gicu
    04-10-2021, 04:48 PM Go to last post

  4. Auto-generate queries via VBA

    skydivetom
    2 Pages •
    1 2
    11 Attachment(s)
    • Replies: 26
    • Views: 3,843
    skydivetom
    05-24-2021, 08:56 AM Go to last post

  5. Rename field names (multiple tables) based on lookup table information

    skydivetom
    2 Attachment(s)
    • Replies: 1
    • Views: 750
    Gicu
    05-20-2021, 04:27 PM Go to last post

  6. Error "Duplicate declaration in current scope"

    skydivetom
    1 Attachment(s)
    • Replies: 7
    • Views: 2,517
    skydivetom
    05-20-2021, 04:25 PM Go to last post

  7. Auto-generate queries via VBA (need extended capability)

    skydivetom
    5 Pages •
    1 2 3 ... 5
    37 Attachment(s)
    • Replies: 62
    • Views: 7,409
    skydivetom
    06-10-2021, 06:10 AM Go to last post

  8. Need a more efficient way to generate *data analysis* queries

    skydivetom
    2 Pages •
    1 2
    10 Attachment(s)
    • Replies: 19
    • Views: 3,534
    skydivetom
    06-16-2021, 07:33 AM Go to last post

  9. strWhere syntax error

    skydivetom
    3 Attachment(s)
    • Replies: 8
    • Views: 1,377
    Minty
    06-11-2021, 09:17 AM Go to last post

  10. Need assistance with correcting dynamic SQL

    skydivetom
    2 Attachment(s)
    • Replies: 1
    • Views: 1,027
    skydivetom
    06-12-2021, 08:18 AM Go to last post

  11. Exporting tables starting with "tbl_" into Excel. Need to delete XLS file prior to execution.

    skydivetom
    • Replies: 8
    • Views: 1,821
    skydivetom
    06-22-2021, 05:54 AM Go to last post

  12. Challenge! Streamline process by *removing* need for CASE statements

    skydivetom
    2 Attachment(s)
    • Replies: 12
    • Views: 1,877
    skydivetom
    06-22-2021, 01:58 PM Go to last post

  13. VBA to sort fields within tables in ASC order except 1st two fields

    skydivetom
    2 Attachment(s)
    • Replies: 7
    • Views: 1,518
    skydivetom
    07-01-2021, 05:30 PM Go to last post

  14. CASE Statement(s) to Update RS... works partially

    skydivetom
    3 Attachment(s)
    • Replies: 13
    • Views: 1,753
    skydivetom
    07-10-2021, 12:22 PM Go to last post

  15. VBA routine to rename fieldnames based on a lookup table

    skydivetom
    1 Attachment(s)
    • Replies: 1
    • Views: 772
    skydivetom
    07-12-2021, 06:54 AM Go to last post

  16. Update VBA routine to process fieldname changes for *multiple* tables

    skydivetom
    1 Attachment(s)
    • Replies: 10
    • Views: 1,806
    skydivetom
    07-13-2021, 10:08 AM Go to last post

  17. Dcount results in error "Overflow"

    skydivetom
    2 Attachment(s)
    • Replies: 5
    • Views: 1,047
    skydivetom
    07-14-2021, 09:53 AM Go to last post

  18. VBA *batch* routine to import tables (NOT using a stored procedure as part of "External Data")

    skydivetom
    2 Attachment(s)
    • Replies: 4
    • Views: 961
    Gicu
    07-16-2021, 11:36 AM Go to last post

  19. DoCmd.TransferDatabase with wildcard (*) to ignore last 2 characters in filename

    skydivetom
    2 Pages •
    1 2
    11 Attachment(s)
    • Replies: 20
    • Views: 3,520
    skydivetom
    07-22-2021, 04:26 AM Go to last post

  20. VBA function that will compare a BEFORE/AFTER table (with same record counts) and output any change

    skydivetom
    2 Pages •
    1 2
    6 Attachment(s)
    • Replies: 15
    • Views: 2,905
    skydivetom
    07-29-2021, 03:33 AM Go to last post

  21. Rename tables -- strip off "suffix" (right)

    skydivetom
    • Replies: 2
    • Views: 706
    skydivetom
    07-30-2021, 09:15 AM Go to last post

  22. Value comparison -- VBA run-time error '3163'

    skydivetom
    3 Attachment(s)
    • Replies: 4
    • Views: 936
    skydivetom
    09-04-2021, 06:54 AM Go to last post

  23. CASE Statement not working

    skydivetom
    2 Attachment(s)
    • Replies: 4
    • Views: 880
    skydivetom
    09-15-2021, 04:55 AM Go to last post

  24. VBA routine requires small modification (record set)

    skydivetom
    4 Attachment(s)
    • Replies: 5
    • Views: 1,015
    Gicu
    09-16-2021, 10:50 AM Go to last post

  25. Requery controls on subform #2 when making a change on subform #1

    skydivetom
    1 Attachment(s)
    • Replies: 2
    • Views: 743
    skydivetom
    10-09-2021, 07:15 AM Go to last post

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums