Search results for query: *

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

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

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