Search results

Hi All This works fine: [Forms]![qry x main table subform master]![MainDetails].Form.Filter = "[paytyp] like '*" & FilterString & "*' " but this does not (i.e. the filter returns no records): [Forms]![qry x main table subform master]![MainDetails].Form.Filter = "[pay memo] like '*" &...

Hi JHB Thanks for that - I've made the change, and a couple of other changes - and now have it working! Thanks again Les

Hello Bob I appreciate your intention to help, but am not sure why you need to know the underlying reasons for the requirement that we have! But since you ask, it's so that we can present certain reports sorted by employee according to the order requested by the client: some clients want first...

Hi Bob [bank ref order] holds the sequence number that I now need to assign! There are some legacy values in there for some records, but these need to be updated. Hope that answers your question, and thanks for any help. Les

Hi All I have a table [staffs] with a string fields [staff_name] and [practice] and another field [bank ref order] (integer). I need a function that will assign values to [bank ref order] according to thre alphabetical order of [staff_name] - so [staff_name] of Andrew Smith gets a [bank ref...

Plog Perfect!! I am so grateful: I think I had the right idea, but was a million miles from getting the syntax etc. Your method has the added advantage that I can now see how to set up the loop, so will use that elsewhere. Thanks also for not telling me off about the field names, db design, ...

Hi All I have a table [staffs] with fields [staff_name] and [leaving_date], and another table [sickness absences] with fields [employeename], [absencedate] and [DD]. [staff_name] is related to [employeename] - with referential integrity enforced. For many records in [staffs] there are no...

Hi Peter Many thanks for that - worked perfectly (once I'd added the '&' before the first 'chr(34)';) Hi Dave Unfortunately not - I've yet to get down to the job of actually creating the recordset and assigning all the fields (but I'm confident of my ability to do so:)). Thanks for the...

Hi All I have a function that creates an xml file in CurrentProject.path, which works fine. After creating the file I want to open it. I've tried Shell ("c:\program files\internet explorer\iexplore.exe CurrentProject.path & ""\"" & ""xmldemo.xml""") and I've tried fname =...

Hi Pat I appreciate what you're saying about the spaces etc. My excuse is that I inherited this accdb, and that correcting the naming convention is a long job (which I'm tacking steadily:o) I will try to do this with a joined query to see if it workes that way:) Hi 'DrallocD' I'm not sure...

Hi Pat Many thanks for coming in on this ... but now I'm confused:confused: When you say This definitely works fine as a query, and gives the expected results: SELECT [qry x all staff].practice, [qry x all staff].staff_name, (SELECT sum([amount]) from [qry x main table next mth] where [qry...

Hi Dave Thanks (again!) for your help. Unfortunately replacing strpractice with a function readpractice() didn't work - still getting "Too few parameters":( The replacement of with '" & strPractice & "' generally works - eleswhere I have 140 Set rsStaffNormals =...

Hi All In a module I need to open a dataset that includes 2 subqueries. I created the main query - with the 2 subqueries - using the querybuilder, and this all ran perfectly, so I then went to sql view to get the sql, and pasted this into the OpenRecordset statement. The initial query had one...

Hello 'AccessMSSQL' That's it - swapping the order of Chr(13) & Chr(10) did the trick perfectly :D Very many thanks for your help. Les

No:banghead:

Hi 'speakers_86' I'm still not getting this:( There's obviously quite a lot to it, and I may well have to persevere, but ... where is the sub forum? Thanks as ever Les

Hi 'gemma-the-husky' Many thanks for coming in on this. I'm obviously a bit out of my depth here, but why might it be preferable to write the xml file directly with code, rather than using the method suggested by 'speakers_86'? Would it be because it would be more flexible, or quicker? To...

Hi 'speakers_86' Many thanks for your guidance on this - it's very much appreciated. I certainly accept that some of our field names are not ideal, but my excuse is that I inherited this accdb and it's extremely complex and I am getting round to things like fieldnames, etc. Believe it or not...

Hi 'speakers_86' You're right about that schema document - so much detail - but I'm sure that if I can get to the point of being able to generate, from our data, an xml file that 'matches' the sample xml FPS file, it will be relatively simple to add further fields/elements, and validation...

Hi 'speakers_86' Ok - I appreciate your offering to help for free:) I have tried to upload the sample xml files with this post, but it seems xml files are not permitted as uploads! The sample xml files are available from the HMRC website, at...