Search results

Can you concatenate LocationID-ItemID as the identifier? That would be unique, no? I'm not really looking for unique... I'm looking for the various levels. And when the level changes, as in moves or gets descendants or whatever, the formatting should go with the level, not the item.

I love your pictures. I get it. But notice your're using "nt" for nodetype.. case C, BI, SB. GetNodeLevel returns a key. I thought I understood the levels but you don't use them the way it seems like you should. Even the tag uses the node PK. I'm not being intentionally oblique... just missing...

Well, I'm definitely incorporating that into my program! :love:But, same problem. My identifiers are Location and Item. How do I tell my treeview that I want to format by level? All of your identifiers are different but mine aren't. Location has at least 3 levels. The levels change when moving...

@MajP So I'm combining your ItemGenie with my own thing and getting all fancy and such... and I added fields to the application settings and created more formatting: (the orange fields will be hidden) . But when I got to the format treeview I realized there is no tvw property for nodelevel...

Nevermind. I found another piece that works I can send my record source from the form and place the code after the open event. Thank you for your help.

I need this to skip used labels. Maybe I should go back to creating a table before printing. This seemed so much more smoother...

Yes, I know. But you can't change the record source. Which it has no record source because I want to establish it in the opening of the report.

Then I receive a "the property is read only and cannot be set" at Me.Recordsource =...

@Pat Hartman I'm trying to use Pat's label printing code. When I open the report from a form I use DoCmd.OpenReport strReport, acViewNormal, _ OpenArgs:=Me.Name & "|" & Skip The report immediately starts printing and does not hit the Open code in the report. Private...

please... where does the intBlankCount come from?

OH! YES! Thank you.

is there a way to insert blank rows into a query that printing labels can start in any label? I presently insert into a table and then insert blank rows but this seems like I may be missing an easier way.

Ok, saying you didn't know made me feel better. I went back and CAREFULLY checked my tables for Currency and formats, made a minor change and things seem to be working. The Alias is because I want the field name but a Totals query changes it to "Sum of FieldName." Thank you for taking the time...

I feel like I'm seriously overlooking something simple here. In the attached sample 3qryTransTotals has a field CAmount that is carried to 5qryRegister. In the 5qryRegister it loses its decimal amounts. This leaves the calculated field Remaining with various cents. All fields are Currency types...

So... a variant will still always be a number in this case?

Num is actually a string. It's the currency fields that make trouble.

Private Sub MatchTransfer() Dim strSql As String Dim AID As Long Dim NID As Long Dim CDt As Date Dim Nm As String Dim Mmo As String Dim TrnID As Long Dim TPay As Currency Dim TRec As Currency Dim TMmo As String Dim ID2 As Long 'New match AID = Me.Parent.fAccountID NID =...

OK. got it. Thank you all. I just wish I could have my number fields be blank instead of 0 but that's more of an aesthetic thing so no big deal. I can just format it on the form.

OH! You mean the values are not the order they're declared but the order they're written after! I wondered why I needed to rewrite them! Thank you so much. This is great!

Actually I'll probably need to create a new sub for the second insert, right?