Search results

Hi all, I'm afraid I'm back with another question! I have a formular with a tab control on it. ( I hope that is what it's called in English!) I would like to stop my users changing from one tab to another, without first selecting a record. I'm not sure where to put my code... I have tried...

Hi there! I tried to select the records where there is a date in the end, but it is in the past .. if I just use where Berechtigungsende < date() it also gives me the records where no date is entered. I tried: where (not isnull(berechtigungsende)) or (berechtigungsende < date()) but this...

Great! I have now managed to select the "reverse" records i.e. where there is a date in the 'Berechtigungsende' but it is less than the current date. "nz([berechtigungsende],0) > #12-30-1899# and ([berechtigungsende] < date())" This gives me only the records with a date less than current date...

Thanks so much for taking the time to reply - it's great that I've been able to learn from both of you. Will try this option in the morning! Marion

Thank you sooooo much - works like a charm!!

Hi all, Hope someone can help me... I just cant get this little bit of sql to work! sqlBerechtigter = "SELECT tbl_Berechtigter.ID, [vorname] & ' ' & [nachname] & ', ' & [strasse] & ' ' & [hausNr] & ', ' & [plz] & ' ' & [ort] AS RE FROM tbl_Berechtigter WHERE ((tbl_Berechtigter.tbl_Grab_ID)="...

Hi all, I have a list field in my main form, giving an overview of records in a subform. The sub form calls a Public Function in the main form, whereby I set the row source of the list field, to include the record I have just entered in the subform. My problem ist that the moment I set the row...

Thanks a million - I think i'll add the extra field as you suggest - I think thats the best solution - otherwise the list looks to confusing. Thanks for the help - not a good way to be soending Sunday afternoon! Bye for now

Thanks for the reply! If I use the got focus to filter the Records, the field is empty as soon as I enter the field. I want it to stay set to "all records" unless I click the dropdown to make a selection. You say you don't think you would do it this way --- I'd be very happy to try another...

Hi all, I have a combo box on a sub form. In this combo box I choose certain items to be added to the account. From time to time these items (in a table) are "deleted". When an item is no longer available - i set a flag in the table - "deleted" =yes. These Items must still display on previous...

Thanks for the answers. The code is placed in the form itself - not in VB but in the properties in the control source of the control. That's why I've used semicolons and not commas. Commas only work in VB It's a German Version. The Db is in a trusted file. Grüße from Germany!

Hi there, I used this statement in a control on a main form to establish if there were records in the sub form. If there are, I display the name on the sub form, if not the field should remain blank. It works perfectly in 2003 but if I run the DB on 2007 I just get "name?" displayed in the...

Hi there, Hoping someone can help me solve my problem! I have a form and containing a subform. On both the formand sub form I have user defined context menus (right mouse click) The context menu is displayed by right mouse click on the main form, but not in the sub form. In the settings in...

Hi there and thanks for the link. The only problem is that once you've converted to 2007, the option to select your menubar doesn't exist anymore. Only the select Ribbon and select shortcut options are there. In the 2003 version running on 2007, the option is there and selected. It all works...

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