Search results for query: *

Hi, This is an easy problem to sort out. You need to use the substr function which has the format substr(fieldname, character to start at, number of characters to take). So to take the left 6 characters of a field your start position would be character 1 and you would need to take 6...

Jimmy, Absolutely fantastic! Works like a dream. Thanks very much.

Hi all. I have a query which generates a table with a single field containing a list of account managers. What I need to do is sequentially read each row in this table and output the values as a concatenated string. So the table row values: Account manager 1 Account manager 2 Account manager...

Hi all, I have a query that creates a table with a list of account managers in a single field with one row per account manager. The user creates this table by modifying a query. What I need to do is to take the value from each row and concatenate them into a single string. Should be simple...

Thanks for the tip. Unfortunately, it doesn't appear to work. The full ID is put together in the Control Source of the text box property sheet which doesn't seem to like the text property. Would it be better to code the controlsource?

Hi all, I have three text boxes in my form which allocate three different parts of an ID automatically. The three parts are numeric and have the following format: Part 1: 1234 (4 characters) Part 2: 123 (3 characters) Part 3: 123 (3 characters) If the number of characters are less than this...

Rick, Thanks for the response, but its not really what i was asking. Probably my fault for not being clear! Basically, what I want to know is where a combo box has its rowsource type as a table field list, is it possible to prevent one of the table's fields being displayed in the combo box...

Hi all, I have a combo box (cboLSC2) which lists the fields from a table selected in another combo box (cboLSC1) using the following code: Private Sub cboLSC1_AfterUpdate() With cboLSC2 .RowSourceType = "Field List" .RowSource = cboLSC1.Value End With End Sub This code works...

Hi all, I have a combo box which lists the tables in my database. I would like a second combo box to list the field names contained in the table that the user selects in the first. For example, the user could select the table 'Media' in the first combo box and be given the list of magazines...

Guys, Thanks very much for the help. Hopefully my client wioll be impressed by the results

Hi all, Hopefully this problem is different to the previous combo box probs ! I have a form with two combo boxes. The first lists field names and I would like the second to list all the categories present within the chosen field. So, for example, the user could choose the field 'Gender' in...