Search results

Thanks guys it works like this:- Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " & _ "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart & " AND " & _ "tblxx_Gebuehr.tblxx_Gebuehrkategorie_ID= " & Kategorie & " AND " & _ "tblxx_Gebuehr.deleted=0 AND " & _...

Nope - sorry Aman - get the same message - won't compile Thanks for the trouble

Umm.. sorry attachment - try again

Hi branston - Thanks a mill but it still doesn't work. It wont compile. Attached the message (sorry about the German!) The variables are all dimmed as Long and have the values 1 , 1, and 5

Hi All, So sorry to be back with the same theme, but somehow I just can't get the hang of these SQL Statements! I hope the kind person who helped last time is still around! Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " _ & "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart AND...

Anybody ever tell you you're a Star!!! Thanks again Marion

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