Search results

understood but I obtain this: <Field1>content</Field1> <Field2>content</Field2> <Field3>content</Field3> <Field4>content</Field4> <Field5>content</Field5> so without the break that I need. The goal is to obtain that list cut with that <manual> and </manual> stuff that I cannot incorporate...

actually, my fields are extracted with that query already but my For Each...next does not Join the queries (I need information in another query or table) So I wanted to make only one SQL with all the datas already joined but then I cannot incorporate that manual line I was showing in my previous...

For...each .value on selected columns SOLVED Good morning/afternoon, ... everyone, and happy Australia day to Australian people Trying to make a self-made XML export looks like I must amend this code without touching my database this is just an extract of course, you don't need everything I...

good morning Europe, crazy man I am, just logged in even without a Hello to my colleagues because I wanted to test your new code. Well, It looks like we have a Null problem: "Invalid use of null" highlighting the "Loandate = ... " line Never had a problem like that before, my expectations on...

I understand how it works it is just that 'if not' line is in red in my visual basic window :( Error message: Compile error : expected then or goto will give it a go for tonight, tired, cannot think anymore

Sure! oh and are you able to give me the lines to convert a Null value into a "never" print? it should be something like ... iif dlookup .................. is error then else loandate = dlookup ................ end if ... but i'm not familiar with this

wow didn't think of that i am like a blonde with these subs/functions/procedures Looks like I have to work on it anyway thanks a lot! It works! A new scale for you :) Chris

The DB weight 30Mb (compacted) so I don't think so, but here is a bunch of screenshots in attachments. You need the vba code that I pasted in an earlier post. Chris, burning :eek:

yes, your description is right, table, fields, etc. are well named at the right place (I do agree I would need to change the name though, but it is not the point here) I have only one Query value "Loan1FR" so should get one and only one result in my dlookup I'm trying another way: the...

Well tried :D but no have copy-pasted your correction, and checked my links to the table but it doesn't work. So I have tried using some vba function. And there the dLookup is working in step-by-step (name of my sub = loan1FRdate() ) Then I have linked that variable from that textbox but i...

dlookup in a form, must display a table value SOLVED hello, just joined this forum as it sounds to be the most efficient today :) I found a lot of solutions just surfing your posts. But this new problem is annoying me. I do have, among others: 1 table "LastPrintDate" where I'm looking for...