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...
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...
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...
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...
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...
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...
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)...
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...
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...
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.
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...
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...
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.
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...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.