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?

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. M

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

    Hello, I don't know how to search for what I am looking for. I keep ending up at the 'watercooler' looking at jokes and religious comments :) SITUATION: I have a form that accepts text info for insert into a table's record. Further, there is a multi select listbox that upon completion of the...
  9. M

    pipe delimited export - not file specification

    Hello, Is there a way to do an export of a query, using pipe symbols as the delimiters, ideally using vba to do the export? When I search on this topic I only see ways involving file specifications. Sadly, to begin with there is no "File --> Export" in my Office 2010 so it's a non starter, at...
  10. M

    loop through TableDefs? (DSNless connection)

    Hello, Trying to finally learn DSNless connections... :) This works fine, to connect me to a single named table: '####### DSNless Connection ####### Dim sConnect As String sConnect = "ODBC;DRIVER={sql server};DATABASE=PrioPlansDB3;SERVER=Alex;Trusted_Connection=Yes;" Dim...
  11. M

    export to excel from report preview not working

    Hello! Happy New Year! :) Question: I have this one report (doesn't happen on others in the same mdb) that when a user (or me) presses the export to excel button while viewing the report in preview mode the process doesn't export the data to an xls file. The wizard runs, the process...
  12. M

    blank dates driving me batsh!t

    Hello, Ok, I had to have done this some time in the past... and yet I can't today, and I'm going to pull my hair out! I have a form with a series of unbound text boxes where data is entered - including two non-required dates. If I use the date picker to choose a date, this works fine, but...
  13. M

    simple report question (why am I brain dead?)

    Hello, I have a simple report that is based off a query that groups off a department code, and then sums the number of pc's in the dept. So, the records come back in pairs... Dept1, 4 PCs Dept2, 6 PCs Dept3, 10 PCs Now the brain dead part: How do I get a grand total? In this case I'd like...
  14. M

    Off2013-Cannot open a database created with a previous version of your application

    Hello, My department is rolling out Office2013 to the workstations in the next few weeks, and I was tasked with testing the various MS Access apps with the new version. I expected some normal stuff, such as files/references to be weird - normal stuff. But this is a problem I don't know how to...
  15. M

    Get other than bound column from multi-select listbox

    Hello, I have two listboxes. One for Activities and the other for Organizations. I set the Org listbox to be multi-select so I could run a loop on that listbox to join multiple Orgs to a single Activity. That part works well. To do so, I am using the bound column (which is the pkey...
  16. M

    where is Memo hiding?

    Ok I'm losing my mind... How on Earth do I change a txt box to a memo field on a form? (I need to allow for more than 255 chars...) I've already set the backend DB (sql server) to accept the many chars, and the linked table access see's the datatype as memo. But I can't figure out how to...
  17. M

    hide some warnings, but not others...?

    Hello, I have an application that I've built (2010 accdb/sql server 2012) that I'd like to reveal some 'warnings' while I hide some others. At first I was using hide warnings so that users did see inert and delete messages, but then I noticed that doing so also hid the messages coming back...
  18. M

    Does Access 2010 cache locally from Sql Server 2008R2?

    Hello, This is crazy... never seen this happen before. I have a program that beats up sql server data using a 2010 accdb using odbc and linked tables. Today I noted that some of the source data was wrong, so I changed it using tsql and sql server management studio. I could see using SSMS...
  19. M

    export qry to excel - bug? Old version issue?

    Hello, A user reported that when exporting a list of people from a query to excel, certain people/records are not contained in the export. I took a look (old db mdb v2002-2003 access) and what I found was quite odd. First, I opened the resultant xls and the first 25 rows or so are blank -...
  20. M

    use me! vs report name?

    Hello, Generally, I'm lucky enough to not need to make many reports... which is a good thing since I am fairly weak at it. :) Sadly, I must be improving since more people are asking for stuff. "Love the report, can you now sort it three more ways?" Me: OK... So I copy paste the report...
Top Bottom