Recent content by Andromeda31

Table 'MCC' with following fields Autoid Autonumber CaseNo Number Details Memo Print Yes/No Form CaseContact filtering on CaseNo Continuous Subform CaseContactSub listing items in MCC Command Button with code on click event is at top of this subform CaseNo, Details, Print Print...

Access 2003 format database in Access 2007, I have a button at the top of a continuous subform to 'select' or (or deselect) all of a particular checkbox I am trying to get the code in this post http://www.access-programmers.co.uk/forums/showthread.php?t=208469 to work. The recordset bit...

I think it might work if I import items into an A2000 - 2003 mbd. Thanks for the tip though. At least I can get an mdb to open with the be-devilled form in it. The whole adventure started with me customising an A2010 template. Probably would have been quicker to rewrite an old Northwind mdb...

Dear Bill Gates I'd just like to invite some comments and commiseration from anybody else out there who is struggling with Access 2010 in regards to compatibility with 2007 and earlier. http://msdn.microsoft.com/en-us/office/cc907897 According to this link a form with 'Empty Cell Control'...

FieldName = FieldName & "animal" & (i + 1) & ", " starts at Animal1, whereas your earlier code: FieldName = FieldName & "animal" & i & ", " starts at Animal0 as it should... but hey.... Thanks a million

Will try that, I got it to work with this: Sub cmdAddstr_Click() Dim strSQLinsert As String, FieldName As String Dim Substr As Variant, i As Integer ' split into sub strings Substr = Split(Nz(Me!MySelections.Value, vbNullString), ",") ' build field names and...

I am attaching the file here in case it is of use, presumptious though it feels.

Unfortunately it is throwing: Run-time error '9': Subscript out of range

...all because the lady loves... multiselect boxes Thanks for that will give it a go.

the sql is: DoCmd.RunSQL ("INSERT INTO animals ('" & FieldName & "') values ('" & _ Substr(i) & "')") the error is: Run-time error '3127': The INSERT INTO statement contains the following field name: "animal1". Make sure you have typed the name correctly, and try the operation...

I select three animals in the list box to the text box. In my immediate window I get Data String: elephant,chipmunk,gecko When I comment out my sql string which is failing, I get: Debug.Print "this is the fieldname: " & FieldName and Debug.Print "this is it: " & Substr(i) Immediate...

Not using the split() function, but it does use a delimiter string: All this code came from an office help page somewhere. Option Compare Database Option Explicit ' Enter the following Function statement as one, single line: Function ParseString(SubStrs() As String, ByVal SrcStr As String...

Thought you only needed square brackets for [field names] and not for fieldnames? Split() function? dunno, I didn't write it, I only know how to plagiarize! Thanks

I am trying to enter a comma separated string from a textbox into a series of (up to 4) database fields in a table, I've called the field names [animal0] [animal1] [animal2] [animal3] am using the following code which I am adapting to my need: Sub cmdAddstr_Click() Dim DataString As...

Yep they are dependent on the preceding field being filled in. I have just cast an eye over the 6000 rows and it all seems to have worked - the new field [servicelist] in the table has everything in it from [service] [service1] [service2] [service3] I used expr1: [service] & IIf([service1]...