Search results

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!

Thanks a lot, will try in the morning! Have to leave now.

Hi there, I do save the record first -I've tried now putting the requery in the "on Current Event" of the sub form - it works as soon as I leave the record (by enter or tab), but not when I docmd.gotorecord, nextrec in the procedure in the "on delete". It looks a bit untidy when I have to...

In a sub form I don't want any records to be physically deleted to maintain data integrity (foreign key) therefore I have a field "deleted" (boolean) in the subfrom. In the "on delete" of the subform, I set the "deleted" field to yes, and docmd cancel Event, to stop the record being deleted...

Thanks a million!!

Hi all, I am having a problem opening a form and displaying certain LinkCriteria. I need to combine and and/or clause. I need to select all records where the patient Nr is the same (me.patnr) and the category is either "P" or "S" I've tried different variations but cannot get it to select the...

Help! I need somebody! Background: I have 4 different .mdb on my system, running Office 2000. In all of these I have built menu`s called "FormMenu". I bought and loaded Office 2007. As these Menu now show as "add-Ins" and cannot be changed, updated in the normal way in Access 2000 - I...

Thanks so much for the answers. The problem was as you say, a variable that was not set to nothing. It took time and patience, but I found it. Thanks for the code anyway... a handy quick fix to know !

Thanks for the reply Peter. I've got it working now!

Hi again, I'm getting there.. the line I need is Application.CommandBars("Formmenu").Controls(1).Enabled = False Now I need to take this one step further... This disables the main menu point, but how do I refer to the "sub menu options" e.g. I dan't want to disable the main option "File"...

Hi there, Can anyone tell me if (and how!) I can set entries in a customized menu bar to "enabled" true or false. Users login to the DB with a password, and I would like certain menu items dissabled for certain users. I've been trying along these lines but no joy yet! Set menubar =...

Hi tehere - thanks a lot .. this looks like the solution I've been looking for. Will test after Christmas.. off on holiday in South Africa till the 19 Jan! Merry christmas!

Thanks Rich!

Hi there, I'd like to write a function that puts the visble property of all loaded forms to False when a report is opened (on the on open of all my reports) and sets the property back to visible=true when the report is closed (the on close of all reports) Can anyone help me here? Thanks...

Hi again anf thanks for all thhe replies and suggestions! soo.......... this is what happens.. I assumed that when a main form with different subforms is opened, the on open of the main form is executed before any sub form routines. This is incorrect. I stripped the form piece by piece until I...