Search results

D'ow !! The formatting on my table was Number instead of Text. Thanks anyway CyberLynx (and other people who have read this)

Thanks CyberLynx, but I just found out this isn't the problem: I put a MsgBox to view the string and it seems okay just before I export it to Excel so I presume I have to format it perhaps in another way but I don't now how

Grumble..... :mad: I have a multiple select list in which I select a line that includes a telephonenumber. This telephone number is displayed okay here, like 06######## (# is a digit) Dim As String = telephoneNumber telephoneNumber = Me.List0.Column(1, varItm) later on I write this to a...

Thank you all very much for the help, I got it running with NamliaM hints (I can program but I am new to VBA so don't know where to search) Little by little the doors of VBA are opening up for me ;-)

Hello friends, My problem is that I have a string with text and a single number in it. The size of this number can variate in number of digits but is always located on the right side of the string. I want to retrieve this number out of this string. Are there any nifty functions for this ...

It works After doing some searching on the internet and the directional tips i got it working. Thanks a lot !

Selected Property Example The following example uses the Selected property to move selected items in the lstSource list box to the lstDestination list box. The lstDestination list box's RowSourceType property is set to Value List and the control's RowSource property is constructed from all...

Hello VBA Wiseguys ;-) I'm not too familiar with VBA programming (I do have Java experience) and I would like to do the following: From a multiple select listbox I want the selected rows to be exported in a Excel document. Furthermore I want to keep track of the rows that I have exported...

Thanks for helping me out here !

mmm.... now, how do I compare relation.bank2 with bank.bank when relation.bank2 is a text field and bank.bank is a numeric value ?

Sorry, posted to quickly.... It should be like this (I think): select relation.relation, bank.relation, bank.bank FROM relation INNER JOIN bank ON relation.bank1 = bank.bank OR relation.bank2 = bank.bank; Okay, I keep getting a type mismatch exception..... finally I understand, two...

Hello, I have two queries generating the following information: Query 1: bank relation bank Query 2: relation relation bank1 bank2 I want to see relation.relation, bank.relation, bank.bank where bank1 or bank2 matches bank.bank I try to run the following query: select relation.relation...

Super ! That's what i've been looking for. Couldn'd find it anywhere..... I'm glad it is working now. Thanks !

Hi, I tried to search on google for this but I kept on having problems to get it working so I hope I can get some help here. Simple question, I got 2 tables RESULTTABEL and DELETETABEL I want every row to be deleted in RESULTTABEL that matches with DELETETABEL on 2 fields (RESULTTABEL.Hks ->...