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!

Register Log in
  • Congratulations derfloh 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: *

  1. MacroAlan

    Empty recordset stops

    Thanks, I am on to something with the DCount() G = DCount("[Name]", "qryAllJudgingResults", "[ShowMedalLevel]='" & Medal(0) & "' And [Class]='" & ExClass(0) & "'") If G = 0 Then GoTo Med2 Counts the people based on the 2 criteria I need and uses the items from my 2 arrays
  2. MacroAlan

    Empty recordset stops

    I am building a query and then opening it in a RecordSet. Most of the queries bring back one or more records, but some will only infrequently have records. The variable QUO brings the " character. SQLstr = "SELECT ExhNameFirst([tblExhibitors]![ID]) AS Name, tblExhibits.ExhingYr...
  3. MacroAlan

    set nothing form1

    I think it would speed up if you reverse the Unload and set to Nothing. Really cannot unload something that is set to nothing.
  4. MacroAlan

    Navigation Bar is too short to read

    Like setting scale to 125%? Only way I can read my screen Alan [smurf]
  5. MacroAlan

    Navigation Bar is too short to read

    Yes, and tried magnifying the screen. Did all the obvious stuff Alan [smurf]
  6. MacroAlan

    Navigation Bar is too short to read

    My buddy asked me to look at an Access Form on his computer. The Navigation bar at the bottom of the form is too short to read the data. Thinking maybe it was an anomaly in his database, we closed his database and opened mine. My database forms showed the squashed navigation bar on his computer...
  7. MacroAlan

    Transfer Query Results to Excel (Office 365)

    Never mind! Figured it out CurPath = "C:\USERS\" & Environ("USERNAME") & "\Desktop\GPS_Printer_Export_" & Format(Now(), "yyyymmdd") & ".xlsb" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryMailing4Printer", CurPath, -1 Alan [smurf]
  8. MacroAlan

    Transfer Query Results to Excel (Office 365)

    Been a very long time since I tried to do this. Every time I try to open the exported workbook, it is corrupted. Are the spreadsheet types changed in Office 365? Private Sub cmdMailPrinter_Click() On Error GoTo cmdMailPrinter_Click_Err ' DoCmd.OpenQuery "qryMailing4Printer", acViewNormal...
  9. MacroAlan

    Insert results of huge query into my table with Stored Proc

    Spent the last 2 weeks creating and tweaking a 150 line query pulling stuff from all over the place. My internal customer kept changing his mind what he needed. Found that I need to write the whole thing to a table on SQL Server; so created a table this morning. Started a stored proc and put a...
  10. MacroAlan

    Disappearing Toolbar Excel 2013

    I have built an Add-Ins toolbar in Excel VBA. Sometimes when I open a spreadsheet the ADD-INS heading is missing. I go to DEVELOPER and Add-Ins and see that my add-in is checked. Is there a setting I need to do? I am about to share this with the rest of my workgroup and want to make sure they...
  11. MacroAlan

    Creating Outlook Meeting from Excel VBA

    I'm sure that I solved this problem years ago but I cannot find my old code. :-( My customer has a spreadsheet with rows for multiple meetings to be scheduled. I've captured all the elements I want to put into the meeting notice but need some code to help me build the messages. I pretty sure...
  12. MacroAlan

    Need to update a checkbox on another table

    ...is an update process for tblMaster i.e. it is not a bound table, run a recordset to update to change Done from False to True. sqlStr="SELECT * FROM tblRequest WHERE RequestID=me.cmbRequestID.value" Set RSreq=db.openrecordset(sqlStr,dbopendynaset,dbseeChanges) rsreq.edit...
  13. MacroAlan

    Lost ACCDB VBA Password

    So the programmer that left last year put passwords on the VBA of various ACCDB databases. I've been looking online for Recovery or Deletion tools and found lots that will seemingly work with MDB but nothing for Access 2007 or later. Anybody got ideas for me? Alan [smurf]
  14. MacroAlan

    Understanding OPENQUERY and ticks

    OK, my date in DATE_HISTORY is expressed as YYMMDD or 160421. The code below works perfectly and returns ~6000 rows. SELECT * FROM OPENQUERY(GLOBALCUB,'select * FROM GLOBALCWF.Inventory_Hist WHERE DATE_HISTORY=160418') Thanks, looks like I have a bunch of new terms to...
  15. MacroAlan

    Understanding OPENQUERY and ticks

    ...([DATE_ACCT_YR],[DATE_ACCT_MO],[PART],[LOCATION],[DATE_HISTORY] ,[COST],[JOB],[SUFFIX],[SEQ],[DEBIT_PROD_LN],[A50_CUSTOMER]) SELECT * FROM OPENQUERY(BALCUB,'select * FROM BALCWF.Inventory_Hist WHERE DATE_HISTORY=''''''+@yesterday+'''''' ') It compiles but never shows...
  16. MacroAlan

    Move between Separate Instances of Excel

    ...Me.cmdTabs.Clear End If cont: Set xlAp2 = GetObject(Me.cmdFileNames.Value).Application Debug.Print xlAp2.ActiveSheet.Name & " *" 'gets name in THIS workbook For Z = 1 To Sheets.Count Me.cmdTabs.AddItem Sheets(Z).Name Next Z End Sub What do I need to do to select...
  17. MacroAlan

    Operation must use an updateable query

    In the end, I built pass-through queries and set up connection strings like the online samples. I was then able to disconnect the linked tables.It runs quickly. Alan [smurf]
  18. MacroAlan

    Operation must use an updateable query

    Now I remember! The BA said that the customer would not be able to delete; only add to the table. It precludes my app from making updates. [hammer] Alan [smurf]
  19. MacroAlan

    Operation must use an updateable query

    My form is displaying the results of a search and the user has indicated that the data is wrong and typed the new stuff in another field. I try to update based on the old information: upSQ = "UPDATE dbo_DMPlatform SET " upSQ = upSQ & " dbo_DMPlatform.Program = " & Chr(34) &...
  20. MacroAlan

    Access 2010 Report does not have Focus

    That is what they try to do but it prints the Form Alan [smurf]

Part and Inventory Search

Back
Top