Search results

i don't need the row numbers, what i'm doing is writing a procedure that will upload invoices to QB. QB tables are not easy to work with (jmo), too many weird limitations (jmo again) so for invoices, if i want to create an invoice with multiplle line numbers i have to upload invoice lines with...

No, it does something more I thought, it actually numbers them. I haven't used it yet but I tested it and it looks fine. Am I wrong in thinking that I will just replace numbers that are not 0 with 1.

thank you so much!!!!!!!, this is perfect. this does even more than i need so you're saving me future questions as well thank you))))))))))))

hi, how do i add numbers to row in the following manner: if 4 rows have the same number then one of them should be 0 and the rest 1, same for all others. basically, the code should look at the value in the table, if it's the same as the row before add 1, if not - 0 (i think i got the logic...

i guess i'm afraid because in my mind AutoID is not really data. and i will try to use the migration tool however, last time i migrated to sql it gave me and error (don't remember what it said, not too informative). so i ended up migrating by hand. ETA oops, forgot to say thank you)))))))))))))

when migrating from access backend to the sql servier, do the AutoID numbers stay the same? or the numbers will be random autoid numbers in order? for example, in access, if i was to append a table with AutoIDs into another table with autoids and actually append the autoid field - it'd accept...

hey, in case anyone needs it, i think i got it it's an ugly solution and i'm sure it could've been done much more elegant so if someone has a minute whenever - i'd love to see how they'd do it so i can compare it to what i did and learn something Public Function getField(inputString As String...

sorry, problem, look what happens if there's only enough text for one field Sub Dec2TEST() Dim strtest As String strtest = "Big Bad Commercial Compa" Debug.Print getField(strtest, 1, 36) Debug.Print getField(strtest, 2, 36) Debug.Print getField(strtest, 3, 36) Debug.Print getField(strtest...

wow!!!!! of course it worked, not that i doubted))))))) in case someone else needs it in the future, Dim i As Integer is missing from the ClosestChar function thank you so much!!!!!!!!!!!!!1

no, i can't do it the ugly way either, overestimated myself can someone help? it's not THAT important but if it's something easy and someone has a minute i'd appreciate it thank you

I knew it was me, thank you again!!

and another tweek that i need for this code. i have a very ugly way of doing it in mind, but figured i might ask and learn something again from here Public Function getField(inputString As String, FieldNo As Integer, FieldSize As Integer) As String Dim intBreakPoint As Integer Dim strW As...

on change didn't work for me but the example from AllenBrowne did i probably did the onchange wrong but i got it to work so thank you, both of you, very much!!!!!!!!!!

thank you so much, i was trying on dirty, key down. i don't know the events that well. i tried reading the help file and don't get some of them still)))) so thank you and thank you spikepl too)))))

hi, how do i limit the number of characters in a field in vba. limiting it in a table doesn't work for me because the same field has to accept different number of characters depending on a value in another field so for example, if the value in that field is 0 then the field should accept 40...

ETA never mind, i said something stupid as usual.

wow, thank you again. i can't believe the pain i've been going thru))))

can you explain the file dsn please? you mean creating a connection in the window above on the server and link my tables using that dsn file????? that easy?

thank you so much!!!!!!!!!!!!!!!

i have more than 1 question and not sure if i should open a thread for each question or if combining them is ok. if i shouldnt've combined them - i'm sorry. 1. is there a way to create an ODBC connection by code? so that i don't have to go on every computer and create the ODBC connection (I'm...