Search results

  1. M

    send CREATE LOGIN to SQL Server via VBA?

    Hello, If I could wave a magic wand...? :) I'd like to use VBA to send back CREATE LOGIN statements for a new domain sql server user and add db_datawriter & _reader to this new user. I found this link here, and I think this got me pushed in the right direction, even though it's for azure...
  2. M

    DoCmd.OpenTable without column headers?

    Thanks for the information folks! I'll take a look at the idea of pushing the info in the file myself, and removing the header record. The headers should always end up on the same row, so this should be doable... Thanks!
  3. M

    DoCmd.OpenTable without column headers?

    In short: Is there a way to DoCmd.OpenTable without column headers? In long... I have MS Excel template with fairly complex header info I want the users to stay away from. If I could wave a magic wand the user would "Press this accdb form's button, ctrl-A, ctrl-C, open the excel file, drop...
  4. M

    SQL Server view exported to MS Dynamics CRM cloud?

    Thanks buddy! I'll take a look at the skyvia stuff and see what/how it may help... I'll circle back when I know more! Thanks again, -Matt G.
  5. M

    SQL Server view exported to MS Dynamics CRM cloud?

    Hello, First, I apologize, I don't speak cloud. But I'll do my best - I'm a database guy who makes Access apps, too... In short, I have a sql server 2012 view that I need to get to a cloud based MS Dynamics CRM system, so this system can this data as reference data. In early talks with...
  6. M

    insert VBA not working - GAH!!!

    ...Doh!!! I wrapped both YesNo and TF in brackets and she works. One of those fields must be a reserved word. Thanks for looking!!! -Matt "Now off the Ledge" G. Edit: It was YesNo...
  7. M

    insert VBA not working - GAH!!!

    Hello, Ok, I imagine I am overlooking something... why on Earth doesn't this work? It's Access 2016/ODBC/SQL Server, *should be* simple insert, but I get syntax error... strSQL = "Insert into dbo_OccurrenceMetrics (ActivityOccurrenceIDf, ActualCosts, ActualStaffHours, ActualStartDatetime...
  8. M

    this Snowflake is "Triggered!"

    Previously I've always done things in the VBA area on form's events, so triggers and SPs are new to me... I was just looking at calling SPs from a form. This is interesting! Thanks!
  9. M

    this Snowflake is "Triggered!"

    ...sorry, I forgot to include that the backend is sql server (2012 in this case, but originally developed for v2005). It would be neat to raise errors with messages from the backend - less checks to manage on the front end. Thanks for any help with this! -Matt G.
  10. M

    this Snowflake is "Triggered!"

    Hello, I had a user call me saying that her off-the-shelf access app is broken. Basically, there is a trigger that checks on several relationships before deleting a contact record so as to not strand orphan records. Ok, cool... but? The below code in the delete trigger ends up with the...
  11. M

    how to make main form notice changes in subform(s)?

    The application is a person/org contact/list management tool. The main form is the person/organization details, with two subforms being contact info (phone/email instances), the other is land address instances. The datasheet subform houses dropdowns that contain instances of lists that the...
  12. M

    how to make main form notice changes in subform(s)?

    Me.Parent.txtUserName = Going the above route worked! Before I was trying to do something like forms!frmName!txtUpdatedBy = etc on the AfterUpdate event for the subforms, and that caused the app to freeze up, which I didn't understand. Going the me.parent is route working! THANK YOU ALL! :)
  13. M

    how to make main form notice changes in subform(s)?

    I have some fields that track what user created the record, and when. Further, I'd like to train the form to know when any fields are updated (both main form and subforms) so I can update the two fields that catch last date and user who made the changes. I can prepopulate the new record...
  14. M

    how to make main form notice changes in subform(s)?

    Hello, I inherited an older access db (I think it is currently using 2002 container/mdb) and it is done in a style that I am not familiar. The previous developer was fond of subforms, and uses them often. I on the other hand struggled to make them work for me when first starting out...
  15. M

    How to get a current user from a custom login form

    Oddly this doesn't work when the username has an underscore in the string. Does anyone understand why? I'll admit... I don't. It returns blank.
  16. M

    not sure how to approach this - preselecting items in multi select listbox

    Mr. The Doc Man, thanks again! Your last post gave me a few ideas. I really appreciate your push in the right direction! Thank you, -Matt G.
  17. M

    not sure how to approach this - preselecting items in multi select listbox

    Hello, Thank you all for your responses. I gave this some more thought based on your comments... Yes, I do have a ER diagram/data model. I won't start anything without it. (attached) :) Yes, with my previous thinking, I would have to not only manage to reselect the previously selected...
  18. M

    not sure how to approach this - preselecting items in multi select listbox

    Hello, I'm grinding my brain on how to approach this application challenge. (Please see attached image) The form works like this... #1, select a parent record (strategic priority). #2, select second parent record (committee/department), step #3 select appropriate additional properties...
  19. M

    (how to?) Confirm insert succeeded, then do more...

    Oh, I see what you mean. So I did this: Set db = CurrentDb() db.Execute strSQL If db.RecordsAffected = 0 Then MsgBox ("Insert of Objective Failed.") Exit Sub Else '...carry on inserting children records... And I think I'm all...
  20. M

    (how to?) Confirm insert succeeded, then do more...

    pbaldy, Ok - I'm getting there... For the parent/initial insert I replaced: DoCmd.RunSQL strSQL with: On Error GoTo Err_Execute CurrentDb.Execute strSQL, dbFailOnError and added: Err_Execute: ' Notify user of any errors that result from executing the query. If...
Top Bottom