Recent content by lholgerg

Thanks it works great, but not when my tabels are a link to a MSSQL server where the Now() command does not exist.

I want to add a number to a record without using autonumber(because the tables are placed on a SQL server) but it should work just like autonumber. when I load the form the next available number should appear in a text field and when I add the record the next number should appear in the text box.

I have a rather large database whitch I am currently applaying security too, and I later want to Upsize it to an MSSQL server 2000. But what I am wondering is what happens to the security in access and can I still use the CurrentUser() command to only list data relevant to the user using the...

I have form that contains a subform where there are a lot of text fields and dropdown menues. in the buttom of the form I have a button that add's the record and gets the next one, but this button should also add a timestamp to the record. Thanks

I Finaly got it to work I´t was a little diffrent then Gord's solution In my Mainform's on load the line is Forms![NameOfMaster]![NameOfSubform].Form![Combo2].Requery In the subform's "After update" the line is Forms![NameOfMaster]![NameOfSubform].Form![Combo2]= Null...

I am not sure what you meen but my subform has the event on efter update and so does my combo1 The lines are Forms![NameOfMainForm]![NameOfSubForm].Form![combo2] = Null Forms![NameOfMainForm]![NameOfSubForm].Form![combo2].Requery NameOfSubForm = NameofSubFormASSeenbytheMainForm & the mane of...

Can I make a logon that saves the user that is currently using the database, it should not be through the windows user, but access should starts up whit a loginform, and then save the ID of the person that is logged in, that information is something that I want to use for Identifikations later...

It now want me to "Enter Parameter Value" when I want to chouse something in combo2. It does not complain whit the combo1 but only when I select combo2

DAMM - How do I make it work it in a subform The form that it works in is a subform i another, and the entyre thing works when only the subform is open but not when i open it in the motherform. Life just got a lot worse

FANTASTIC - It works Life is good :-)

No - I works fine when i select a new i combo1 the choices i combo2 canges. BUT if I want to changes it again, I change combo1 - and them the choises in combo2 have also changed as they should, but in the field there stille is the choise from before. What I want is to clear the choise in...

Hurray It works Thanks a lot But how do i clear combo2 box when i select something new in combo1. As it is now the name in combo2 doesn't update at the same time as I select a new in combo1

Yes - I've tryed that, but it still tells me that the macro me. isn't there. And Yes i am writing the name of the combo - infact i am chousing it fron a list that appers as soon as I but a . Now I can't delete the thing(the "me.") I keeps giving me the error in spite of the fackt...

Thanks it works - but the last thing you wrote doesn't. I have added "Me.TheNameOfTheCombo.requery" but I get an error that it cant fin the macro me. hope you can help

I have a dropdown menu that i want to make dependent on another the Row Source date i taken from is. SELECT [Partner].[Name] From Partner; I want to make the choices dependent on a field called partners Hope someone can help