Search results

I know that for 1 column in a combo box you can say cboBox = a;b;c;d;e;f; But for my situation i need to have multiple columns... Does anybody know what the string should look like for multiple columns of values ?

Not a problem, What goes around comes around :) apply's to Help, These forums are a life saver for me

Assuming that your pictures are regarding their rank I would populate a "rankID" field with numbers ( ID's) representing a Rank, and then make a separate table with all the possible rankID's then a field listing the corresponding rank titles, and another field called rankAvatar which holds the...

Well i know how to do this when i get my values from a table/query, but i am specifying my rowsource in VB, since the rowsource is a filelist... so how do i specify multiple columns for rowsource in the VB code?

I have created a combo box that simulates browsing, but limits it to a single filepath. I would like to store this file path along with the filename into my database in a field. There are two ways of doing this that I have found work, but i need a less cluttered way. 1) My rowsource string is...

Thank you Jon K! Works great :D

Ok so I am making an application which requires me to add a record.. ok fine, but then i also need a cancell option, which would delete the record... np, BUT if the user cancells, I don't want my Auto number increasing... So I am writing to a temporary table which mirrors the original one, and...

Yes that was a very helpful link :D

Now that I solved that... The next thing i need is the ability to add pictures... but i want the users to be able to browse for the filepath rather than have to type it in themselves... is there a way to browse the contents of the computer through some method/object etc ?

Perfect!~Thanks

ID |Comment| |List1ID | List2ID | Image --------------------------------------------------------------------- 2 |Comment for Data ID 2 |2 |3 |Z:\CustInfo\SamplePhotos\S.... 3 |Comment for Data ID 3 |3 |2 |asdfdasfa 4 |Comment for Data ID 4 |1 |1...

the msg box says "show picture at []" when i check column(0) it says "show picture at [That record's ID]" so i know its picking that up ... so why is it picking null up for the other fields... i even tried filling in every record with something.. and setting the default text to " " but it still...

I have made up a "testing DB" for now and this is what i currently have: Sub Combo4_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo4] Me.Bookmark = Me.RecordsetClone.Bookmark 'imgBoom.Picture =...

no .... wait i faked myself out and had the direct link in there still :( it's still saying i have a null reference now

SWEET DEAL thx a lot ruralGuy

i used the "build..." function for row source lol so i don't know either

SELECT tSample.SamID, tSample.* FROM tSample;

Private Sub cboSamID_AfterUpdate() [Forms]!fSampleView.Requery imgSample.Picture = [tSample]![SamPhoto] End Sub That is what i have where cbuSamID contains a list of the record ID's but i keep getting this error "Run time Error '2456' Customer Info System can't find the field 'tSample'...

I would like to somehow put the link to the picture in a field in a table, and then have the picture change depending on the record I am viewing (which is altered by the combo box pertaining to another field) ok thanks!