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: *

  • Users: leicklda
  • Order by date
  1. leicklda

    Print various external files from within Access

    ...Example: dim rst as dao.recordset Set rst = currentdb.openrecordset("tblAttachedFiles") do until rst.eof Select Case rst!Filename Case "*.doc" Word doc printing instructions Case "*.xls" Excel doc printing instructions Case "*.pdf" PDF printing...
  2. leicklda

    Print various external files from within Access

    Does anyone know code that will work to print out a series of non-access files, regardless of what type they are? I have a table structure where people can "attach" various documents to their record. Really the table just stores the directory of the file they've attached. I would like to run...
  3. leicklda

    Records missing from listbox but present in underlying query???

    Thanks - that worked. Now I need to go and change my VB code which constantly updated that SQL as a series of variables to instead change a querydef. Strange problem, but your solution worked great. Thanks!!!
  4. leicklda

    Records missing from listbox but present in underlying query???

    Very strange problem... I noticed that one of my listboxes is missing some records, and so I checked its underlying query (which is assigned through the listbox.rowsource VB property) to find the problem. The strange thing is that the missing records ARE present in the underlying query results...
  5. leicklda

    Organizing records in Detail section into different columns

    Also I wanted to add that even if had seen this cool concatentate function, I probably wouldn't have thought to put it in a crosstab to accomplish what I needed to do. The crosstab and conc. function work great together. I learned a lot from this exercise. The query field: OptionNames...
  6. leicklda

    Organizing records in Detail section into different columns

    Thank you both for your suggestions! Duane - you are brilliant and you saved my butt. I ended up using your concatenate function (the one that separates "records" with a line break within the field)with the crosstab and it works great. Your function ended up being: Function...
  7. leicklda

    Organizing records in Detail section into different columns

    ...actually is a new record and so it goes on a new line. My data ends up looking like this: Structural Bay Windows Garage ********************************************************* Sunroom Side Entry Loft...
  8. leicklda

    Setting $0 for a month with no amount specified

    ...& "') AND ([expected close] between date()-395 and date())" Set tdfOpp = tdfOpp.OpenRecordset DoCmd.SetWarnings (False) DoCmd.RunSQL ("delete * from chttblsales") DoCmd.SetWarnings (True) Do Until tdfOpp.EOF tdf.AddNew tdf!Date = tdfOpp![expected close] tdf!GP = tdfOpp![gross...
  9. leicklda

    Setting $0 for a month with no amount specified

    I have a line graph that charts Gross Profit $ earned each month. In some months, there was no GP reported, so technically the value would be "$0". But since nothing was entered for the $0 months, the value is just skipped over in the chart. My data is like the following example: DATE...
  10. leicklda

    Possible to dynamically call to and define a variable

    ...to change has a prefix 'cond' & and a suffix that is the text of 'Me.ActiveControl.Tag'". I just can't find the right syntax. Here is my code: *********************************** ButtonTag = Me.ActiveControl.Tag sqlCond = "AND (qSearchCust." & ButtonTag & ") like '*' &...
  11. leicklda

    Have to resave Excel files when importing w/ DoCmd.TransferSpreadsheet

    ...Sub ImportCDR() Dim strFile As String Dim strFolder As String strFolder = "\\Officehp\my documents\Customers\Requested CDR's\Viewed\" strFile = "*.xls" strFile = Dir(strFolder & strFile) Do While Len(strFile) > 0 MsgBox strFile 'temp error checking to verify loop is working...
  12. leicklda

    Cannot change focus to a list box after running loop

    I finally got it -- I have to set the dest listbox to null: me!dest = null in order to requery it and set focus to it. Don't really know why, but it works!
  13. leicklda

    Cannot change focus to a list box after running loop

    TheAceMan1 & lastout Thanks for the info on the bang. I revised my code to have the ! instead of . where pointing to a control. I also simplified my example code even more to eliminate anything extraneous to describing this problem. (like the variables you were asking about why I didn't pass...
  14. leicklda

    Cannot change focus to a list box after running loop

    TheAceMan1, No, they are not on a subform. I even tried making a dummy form from scratch, putting generic listboxes on them with very simple data, and got the same problem after running my highlight procedure.
  15. leicklda

    Cannot change focus to a list box after running loop

    Hi Aceman1 I have a requery right at the end of the highlight procedure. I can see the new records just fine, I just cannot click on them on the first try.
  16. leicklda

    Cannot change focus to a list box after running loop

    Hi PH, I've tried that in many places, and it generates various errors. Access won't let me change focus with that command after running the loop.
  17. leicklda

    Cannot change focus to a list box after running loop

    Hi everyone, I'd be grateful for any assistance... I have 9 listboxes ("list1", "list2", "list3", etc..) that are lined up on a form. When a user clicks on one of them, I need all the other listboxes to have the same index value be selected as well. This works well with a for...next loop, and...
  18. leicklda

    Loop through table and update date field with increments

    Thanks gol4! Just had to add a rs.edit and rs.update and it worked great. Much appreciated!
  19. leicklda

    Loop through table and update date field with increments

    ...up of repeating chunks of 112 records. Each group of 112 records is a pattern that establishes a class scheduling system. It is made of 14 weeks * 8 class types = 112 records. tblClassSchedule ID WeekNum ClassID LocationID StartDate...
  20. leicklda

    3 IIF conditions with OR

    Works like a dream... thanks!

Part and Inventory Search

Back
Top