Search results

I have used the following code to do a find on a recordset and it is giving the error message "rowset does not support scrolling backwards". Does anybody know why this is? Private Sub Form_Current() Dim stID As String Dim strSQL As String Dim rst As ADODB.Recordset stID =...

Sorry for the delayed reply. That worked perfectly. Thanks

I want to do a query on a subform which picks up an ID field on the main form without using this as the connecting master, child key but finds this ID in one of two fields in the full table. My problem is, how to pass this field value from the master form to the query. I would use OpenArgs if I...

I discovered what it was eventually. I had maximized my form and on closing I had the following code put in to do what I thought was "restore" everything down to their original sizes. I took it out and the problem went away. DoCmd.SelectObject acForm, "PolicyForID", True...

my cut down version of the database does not fit. It is 900Kbytes. I removed everything out of the tables and removed most of the forms, but there it is. What i do basically want to do is hide the database window.

apologies for not being more specific. I mean that when I go into my switchboard form, which is the startup form, and then go into the main form, after I close the main form, the database window pops up.

I know this is pretty basic, but it is annoying me. Whenever I bring up a certain form in my database, it seems to call up the database form. How can I get rid of this.

Thanks. I tried to compile and got errors. I will sort that out and see how it goes.

I am having a problem getting the debugger to work. It was working a couple of days ago, but now, no matter how many breakpoints I put in, it refuses to stop. I have to resort to MsgBox to display whatever I want to see, which is time consuming. I am sure there is a simple explanation

Sorry, you're right. I left out the lines Dim stDocName As String stDocName = "frmTask" using the FormLoad event worked! Thanks a lot

I have tried to pass on a string to a new form using the OpenArgs, but, being new to all this, am unable to see what is wrong with the syntax. This is the code for the open: Private Sub cmdTask_Click() DoCmd.OpenForm stDocName, acNormal, , , , , "new" End Sub and this is the code where I...

Your idea would work ok, but I am trying to do it using just the policy table. I don't want to have to generate a family table, as this would mean a whole system of updating this, which doesn't exist at present. Thank you for the idea, however, and maybe I can adapt it. Cheers, Groengoen

Thanks very much! I will have a look and see whether I can put it into action

I am on Access 2002, but I think a solution for 2000 should also work?

I have in insurance policy with 2 ID's, ID1 and ID2, and the husband could have a number of policies with ID1 set to H001 (say) and the wife's id (W001 say) could be on the husband's policy as ID2. The wife could have policies in her own name with ID1 set to W001 and the husband could be...

If I have a set of names in a list box, how can I search the list to scroll down to a specific name?

The OnCurrent event got working but what it means is that whenever I click on a record in the main form it automatically goes to the other form (because a record becomes current in the subform). What I wanted to do was select a line in the subform datasheet which would trigger the opening of...

I have a database table which has Client Insurance policies. Each policy has the possibility of 2 ID'S (eg. husband and wife). To query this database I have a form with a list control for the Names, Policy Number, ID1, ID2 etc... and a subform which is a datasheet. When I query a policy, the...

I get the following when I put the code as above into the OnCurrent event: Run-Time error '3075' Syntax error (missing operator) in query expression '[FormNo] =' Although I have just copied and pasted the same query expression from the control to this event. I wonder if you would know what...

Thanks but that doesn't seem to work either! Groengoen