Search results

Thanks bob, much appreciated. Reckon i'll give my dodgy uncle a call, se if he can get me some kind of pre-release ;)

Doh, the MS guys need to get working on something for this issue! Thanks for your reply.

Hi, I have a database (.mdb file) which includes a table, forms and VB code. I intend on putting it onto a CD and then opening the form on another computer which may not have Access. Is this possible? Can I convert the file or can I attach some type of reader to the disk? I have seen some...

(I deleted it as resolved...sorry thought i was doing a good thing. Nevermind.) That simple? I'll give it a go! Edit: That works. Thanks. All my Q's resolved now :D

Hi, I have a combo box acting as a filter for a form with the following row source: 1;2;3;4;5;6;7;8;9;10;11;12 It is related to a field which has the following VB code: If Not IsNull(Me.cboFilterPeople) Then strWhere = strWhere & "([AvailableNoTickets] = " &...

You absolute legend! It works perfectly! I owe you one cos I been trying to get that sorted for a while now. (I do have another quick question regarding a different box but i'll post that as seperate.) Thanks again.

Ok, you mean edit my SQL to read: SELECT tblData.Field1,Field1 FROM tblData GROUP BY tblData.Field1 UNION SELECT tblData.Field2,Field2 FROM tblData GROUP BY tblData.Field2; ...and then set 2 columns? Im a bit rusty with this, sorry. I do understand how that VB would work though.

Yes they contain the exact same information. I will try and see if I can do this hidden column. This may work. Edit: I have no idea how to implement this...any help? The data is cities and areas for example Tbl Field1 | Field2 City1 | North City2 | North City3 | East The combo box is...

Pauldohert: Sorry I should of specified that I wanted Field2 seperate as opposed to a column alongside. If I dont manage to get it right I may have to use the column approach but it isnt really ideal for this type of data. Thanks for your response.

Hi, I have a combo box acting as a filter for a form which contains data from 2 seperate fields using the following SQL code: SELECT tblData.Field1 FROM tblData GROUP BY tblData.Field1 UNION SELECT tblData.Field2 FROM tblData GROUP BY tblData.Field2; This combo box works fine in showing the...