Recent content by k_heppner

Hi I need to know the answer to this one today.. ASAP if possible. When I change a value in a field, I want the whole form requeried. If I put in Me.Requery it does the Requery, but always displays the data for the first record. Is there any way to specify it to do a requery, but show the...

Just wondering if anyone could please help me with this: I have a Login form that the user logs into when the db starts. The query OpenRepFromLogin selects the User's ID (RepID) based on the username entered in the Login form. The query works - but how do I get the RepID into a text box...

Thanks - but I figured it out on my own!!

Hi, I have a form that searches the database - the user selects the criteria from one of five combo boxes, and then hits a button, which runs the query and returns the results. Right now the results are being returned in a datasheet view, and I would like to display them in continuous forms...

Hi there I'm trying to set a form value equal to the result of an sql query. I know the query works, when I run it alone, it returns the correct result. Basically this is how I'm doing it: Me.OpenRep = DoCmd.RunSQL("query") but I get the error function or variable expected at the top line of...

Thanks - I'll do that. (I am the dba)

The database I am using is running on an SQL server, using MS Access as the front end. One of the tables has a column CompanyID which is an auto-incremented primary key. I am unable to add a new company from a form unless I input the CompanyID - it isn't doing it automatically. I get an error...

I have a form that opens at startup. The user selects a value from a combo box and that populates the form's fields. I want all of the form's fields to be blank when the form first opens, (i.e. not have anything in them until a value is selected from the combo box). Right now all of the...