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!

  • Congratulations strongm 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. DSaba10

    Creating a log of SFTP Uploads

    Hello Everyone. This is likely the wrong forum to post this. If there is a better one I will happily move my discussion there. I'm currently looking for a way to record (possibly as simply as storing data in excel, data on files uploaded via SFTP. I have a server with various users, but I'd...
  2. DSaba10

    'str' object is not callable

    BAH! It was my code to fix the column typings! for col1 in sql.columns: if ((sql[col1].dtypes != np.int64) & (sql[col1].dtypes != np.float64)): sql[col1] = sql[col1].fillna('') I pulled this code from elsewhere and didn't rename the "col" variable. This was then causing the col...
  3. DSaba10

    'str' object is not callable

    Please pardon my newbie-ness to this thread. I've had to figure out on my own how to create a test environment for a spark server my company is using to handle data. I've jumped through various forums and have had to intall python itself using scoop via powershell, and set up PyCharm, spark...
  4. DSaba10

    Creating a form to handle insert multiple ids into a single table

    That was it. That was all I needed. I really appreciate your help.
  5. DSaba10

    Creating a form to handle insert multiple ids into a single table

    Quick update, I fixed the automation object issue. Now it's just not saving the value(s) selected by the combo box. I do have it bound to pieceid, but the only thing it's adding is the propertyID to my propertypieces table. I'm also seeing that when I move to the next record on the main form...
  6. DSaba10

    Creating a form to handle insert multiple ids into a single table

    Thank you so much! I'm getting close, I think, but i'm getting this error: "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'Property.'' I thought it might have been because I had just used a "select Property.*" type of start, but...
  7. DSaba10

    Creating a form to handle insert multiple ids into a single table

    I'm not terribly great with access, so I don't know if I'm even starting this off correctly. Here is the relationship of the tables: What I'm wanting to to is create a form that will update the "PropertyPieces" table with the id from Property and id from Pieces. The pieces table contains a...
  8. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    My solution was a two parter: Conditional Format 1: =COUNTBLANK($B2:$F2)=5 Each cell has 5 options for criteria, so if all 5 are blank this will make sure the row has no fill color. Conditional Format 2: =COUNTIFS($B$2:$B$5, IF(ISBLANK($B2),"", $B2), $C$2:$C$5, IF(ISBLANK($C2), "", $C2)...
  9. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    I'm not sure if that's some kind of swipe at me, but I'm thinking it is and not really appreciated. I understand your examples and the use of COUNTA() functioning. Per my OP I've tried using COUNTIFS as I'd like the values to be compared not just whether or not it has a value or not, but if the...
  10. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    This looks like your previous example except instead of duplicates in a row it's now duplicates in a column. I want both row and column. It needs to take B, C, D, E and F all into consideration at the same time and validate it against all subsequent rows of B:F EX: Group 1 has B, D, F checked...
  11. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    That's correct. No two groups should have the same criteria.
  12. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    Close, but not quite what I'm looking for. I want to cross reference B2:F2 against every other row. If the entire set of values in row 2 is duplicated again on row 3 (or 4, or 5, etc), I need them both to highlight. Not just one row at a time.
  13. DSaba10

    conditional formatting on criteria in multiple columns with nulls

    I'm attempting to create some conditional formatting for the example screen below: What I'd like to see is if I accidentally enter duplicate criteria marks (with any value) in any of the cross cells for a particular "Group" B-F will highlight with a color. I was able to create something...
  14. DSaba10

    Excel 2013 VBA Moving ActiveX checkboxes

    That was perfect. Ran through the debugger and also noticed that using TypeName was completely wrong, changed that to chkBox.Name and everything evaluated and worked as planned. I agree that it'd be easier to just use something simpler that isn't an activex control, but I'm confined to what the...
  15. DSaba10

    Excel 2013 VBA Moving ActiveX checkboxes

    I should clarify... I want the checkboxes to remain locked to their row. So if rows 11 and 12 have a selected box, rows 13-16 are unselected, and row 17 is checked, it will hide the appropriate rows the checkboxes will stay aligned with their row when hidden and when not.
  16. DSaba10

    Excel 2013 VBA Moving ActiveX checkboxes

    I'm having some issues with some VBA code. I've got a checkbox list and a button at the bottom that hides all of the rows/checkboxes that are not selected. The problem is that when I hit the box to view all again, the checkboxes are then all piled on top of each other rather than where they...
  17. DSaba10

    Issue with max results from multiple tables

    I've found a solution to my problem: select distinct p.CycleID, isnull(d.SegmentCode, 'No Segment') SegmentCode, dbr.RuleName, pc.HeliosKey, P.recordtype, case when CellPhone is null then 'N' else 'Y' end CellPhone, case when BusinessPhone is null then 'N' else 'Y' end BusPhone, case...
  18. DSaba10

    Issue with max results from multiple tables

    I tried your solution, but it wasn't the issue. Here is a mock table structure hierarchy: Prospect SegmentProspect ProspectDeleteBlock Segment...
  19. DSaba10

    Issue with max results from multiple tables

    So I'm trying to pull data from a few tables which require a max function to pull the proper information out. The query I have works wonderfully except that there is a certain set of records it's not returning. Those records would be ones that are actually in the ProspectDeleteBlock table, but...
  20. DSaba10

    Creating an instance of a class in VFP 6

    Thanks Dan! That indeed worked. That is going to be a tremendous help. It also helps to make sure I have my .prg with the defined class closed when attempting to run another file that uses it :) Custom classes here I come.

Part and Inventory Search

Back
Top