Search results

Give this Sql a try: SELECT [dup donors no zero zip].LastName, [dup donors no zero zip].FirstName, [dup donors no zero zip].DID, [dup donors no zero zip].Title, [dup donors no zero zip].Init, [dup donors no zero zip].Sex, [dup donors no zero zip].SSN, [dup donors no zero zip].DOB, [dup donors...

Using the OnCurrent Record event of the many form have it filter the subform based on the companyID.

You could setup a query that would copy the existing record into a new one and then get the record ID of the new record and move to that ID.

In the double-click event of the field: Me.Filter = "Where clause" Me.FilterOn = True

That was a good attempt and certainly you can go about it that way. But the simplest way is using the update query and calling it the way Surjer suggested. I find the simplest way is best. Less chance of errors and more efficient.

It's DLookUp("FieldName","TableName",Criteria is optional)

You need to create an update query that joins those two tables on both fields.

You need to add a reference to Microsoft.ScriptingRuntime Then in your sub Dim fso as New FileSystemObject If fso.FileExists("Full Path") Then

If you've got some button on the main form that's calling this code then do this: Me!subformName.Form!RecordSource="" Update the table Me!subformName.Form!Recordsource = "TableName"

Well the first form needs to be open to call the sub. But at the end of the code you can write a line to close the first form or hide it. If the 2nd form is bound to a source then it will be added to the table. You might want to write a line in to have the 2nd form move to a new record before...

In the first form where it opens the next form setup code to first open the form and then you can set the field values to equal the current form. Here's an example to follow along. Private sub Dim frm as Form Docmd.OpenForm "2ndForm" Set frm = Forms!2ndForm frm!textbox1 = Me!textbox1...

Sorry, got mixed up with some other things. Alright I've got your db open. Where do I start?

I'm sure that is the problem. I know access gets bogged down the more users are connected but it doesn't prevent more users after a certain point unless you want to call crashing preventing...

Ooh that's the problem. Many-to-many are not updateable if you have all the tables as the source.

I don't have any advice for you but I'm going to subscribe just to see the responses. Never seen anyone getting frustrated over having a non-corrupted database. ;)

This will create more overhead but it can work. I've setup databases that basically copy over the data the user needs into a local table for them to view. This way the connection is only open briefly to pull the data. But you need to write code to write the changes back to the source. Like I...

You need to create a query on that table with a sort order. Then use the query as the rowsource for the box. Tables don't have sort properties. You can sort them if you open them directly as a datasheet but that's the only time.

Copy and paste the SQL here. I'm guessing from the different relationships you have you've created a recordset that isn't updateable.

Based on what you said it sounds like you need to make sure your relationships between the tables are set up good and then your forms need to be based on queries that join these tables. Can you post your db?

Yep. When you put in on the same line it looks for records with that criteria in all columns. With it on different lines it looks for records with it in any one of the columns.