Search results

Hi all, After searching through the "search" field, I realize lots of us are having problems with the menu's in access 2007. After converting my 2003 DB to 2007, my menus are still there, but displayes as Add-ins instead of as the menu bar. I can't find any options to change during the...

Hi there again, I use this little function to change the allowEdit Property on forms by clicking a command button. Can anyone tell me how I can also change the property on sub-forms at the same time? Public Function Toggle_Forms() Dim frm As Form For Each frm In Forms frm.AllowEdits =...

this is adrenalin pure!! (when the plan comes together!!)

Thanks a million - took a while to work out, but I got it right!! Yoohooooo- I love it when a plan comes together!

Hi All, I'm trying to set the visible property of some controls on my menubar. This works fine if I refer to the control by name.... can anyone tell me how to refer to the control by it's tag? CB.Controls("Datei").Visible = True CB.Controls(TagNr).visible= true??? thanks in anticipation...

thanks for the input! Marion

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...