Recent content by Trachr

which way would you reccomend learning first? I'll be honest Im releativly new with VB so Im learning as I go... I know a few other languages so I pick things up as I go but I still need to learn lol I of course plan on learning both methods since Im sure it will help me later but just...

its not really needed just was trying to find out if it was possible for both my learning and cause it would be convenient Im reusing some snippets of code a few times and the only thing that would change from time to time would be the variable name So I was trying to find out if one of two...

hmm time to learn something new lol Never done this before :)

Ok this is probably a stupid question and not something Id want to do everyday but Ill be reusing some snippets of code a lot with a few key things changed here and there, so I was considering just making the parts that change variables... This in itself isint hard however theres 1 spot Im not...

ok good to know, thanks again

ah thank you :)

on one of my forms I want the option to change the backcolor of a label and no matter what I try it wont work right. Ive simplified the variables out of this code to try to figure out what im doing wrong but even the most simplified way it wont work so I figured Id ask here what Im doing wrong...

This is what Im doing if you were curious... the 2 forms that end in list are functional, the other is definitely not yet. My code probably looks like it was written by an amateur, thats because it has been :) But Im learning as I go and thats whats important

ok I think I got it all set up right... heres how it looks Option Compare Database Option Explicit Private ctlListBox As ListBox Private StrTextName As String Private StrRecordTblF1 As String Private StrRecordTbl As String Private StrRecordTblID As String Private Sub Form_Load() '...

it points to 1 field in my tables and ya thats the next part I need to work out how to do what you said with the listbox

LOL never mind Im a moron I set it for on form load, and forgot to close my form and load it again :) my bad lol Thanks for the help :)

hmm just tried it and got Run Time error 91 Object Variable or With Block variable not set So obviously I dont have proper error handling in place lol Private Sub Form_Load() Set ctlListBox = Forms!frmCollectorList!FrmListBox 'Point this at ListBox End Sub

if I did the setting of those variables with the loading of the form would they stay throughout every subroutine of that form?

So I changed my top to this: Option Compare Database Option Explicit Private ctlListBox As Control Private StrTextName As String Private StrRecordTblF1 As String Private StrRecordTbl As String Private StrRecordTblID As String ' Edit the Lines below Set ctlListBox =...

ok, Ill do that Thank you :D