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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DSaba10

  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.
See more

Part and Inventory Search

Back
Top