Search results

Hi there, Sory cant remember exactly where I found it but this is how I did it maybe it will help: I used a select case : x = Forms!frm_TerminKalender!Register - this returns a the number of the tab control then: Select Case x Case Is = 0 Set insrecs =...

Aha... the "brute force" appeals to me more and more!! Thanks again Marion

Thanks Roy - will try your advice- thought there might be a more elegant version of checking! Will Microsoft not change the error codes at some stage? Thanks for the trouble! Marion

Hi all, Would really appreciate it anyone could help me here! I send out an update of my DB with conversion routine. In this sub I (amongst other things) also add fields to table. Set td = db.TableDefs("tblxx_Eigenschaften") With td .Fields.Append .CreateField("Forderungsart", dbDouble)...

Hi there . No, but if I can display a linked field, then I ought to be able to display the pat nr. The "message2 screen that displays when printing is I think windows or access itself, not a screen I've created.

I'm back again - and need help AGAIN... I want to select Patient Number from a query where the the number appears more than once. (the query is patient nr. inner joined to treatments) I want to print a report, so the number but be selected with distinct... but I would like the oprint run to be...

Funny titel I know! But couldn't think of anything else! What I am trying to do is this: When I print accounts, one after the other, by running through a recordset, then docmd.print.....where PatNr=recordset!patnr. On the screen, as it displays the print status "print page 1 of 1 " and what...

Hi there! Well I spent a very exciting weekend learning all about the split function which I hadn't come accross previously! My import work fine now ! Thank you very much! One last question if you still have a moment! I found this little example somewhere in the help dim txt,a txt="Hello...

Thank you so much for your trouble. You've just filled out my weekend!! (Ughhhhh) Will let you know how I get on! Marion

Getting the data into the tables is not really that bad - each "field" is divided by the vertical bar (char124). The problem is not knowing how many lines each record has. I've attached the code as I have it at the moment. Thanks for the help! Really appreiate it!

Hi there, Thanks for the reply - Thats more or less the idea. The individual lines, I divide into different Tables checking if they are SE1, SE2, SE3 etc. There are not more than SE4. So each record has an Identifier, then a "Kennsatz" (Description) then the data in 4 Lines SE1 to SE4. Problem...

Hi all , I have to import from a text file that has the follwing format: [1] Line1 Line2 Line3 [2] Line1 Line2 [3] Line1 [4] etc. Each number represents one record. Previously (before the exporting Program did a revamp) each record had 6 lines, and these were exported even if they were empty...

Hi Wayne, Thanks a lot. I used a normal if the else statement. Do you think the iff is faster? better? Thanks for the answer! Marion

Oh dear! I'm having problems formatting again! In my export text file I need to pass a value of exactly 20 Characters. eg. 240,25 should be 00000000000000240,25 -240,25 should have be -0000000000000249,25 (the string also only 20long including the minus sign) I have tried...

Thanks! You're my hero!

oops! another problem! If there is nothing in the field, I still need 108 spaces to be returned not a zero length string. Could one get round thid with the nz function somehow? Although I dont want a 0 returned?

Thank you very very much for the explanation - it really helps when one understands what you're doing! Marion

Thanks to both for the replies. Would the space not use the Text + space 108? That is if the text were 50 Characters long would the end result not be 50 + 108 instead of just 108 including the 50 (50 + space(58))

I'm trying to write a text file as an export spec. Can anyone help me on this: I need to export exactly 108 Characters. Left(Format(recs!(Buchungstext), 108)) works fine as long as the text is longer than 108 Characters. When it is shorter, I need to fill out the 108 spaces as blanks, so tha...

Works very well ! Thank you soooo much!