Search results

Are you talking about using the tab key to move through the records? Or are you talking about the RecordSet? How big is the database? Could you compress it and post it?

Let me see if I'm understanding your original question... You have a table for your quotes (we'll call it tblQuotes) which you display in your main form. In that main form you have a subform that is pointing to the tblQuoteLine. You want to verify the data in the subform before writing it into...

I don't see how that is possible. You could try to compact the database by going to: Tools --> Database Utilities --> Compact and Repair Database

I would copy the database, then remove some of the data from it.

To reiterate what KevinM says from this post: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=17229&highlight=total+number+of+records To show current record... in the control source put =[CurrentRecord] For Total records use... =Count(*) Or to show both in one text...

Cool, thanks jfgambit. I'll take a look at it.

I have never done this, but you could try using a GridControl instead of a sub form. GridControls can be set to RecordSets and then written into a table.

I believe that you are refering to the DoCmd.OpenQuery DoCmd.OpenForm and DoCmd.OpenReport methods. Do a search for "DoCmd" in the Access help file. HTH, Jason

Add this code to the last field in your main form (in the KeyDown event): Private Sub lastFieldInYourMainForm_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 9 Then Me.subfrmName.SetFocus End If End Sub KeyCode 9 = the tab key Change subfrmName to the name of your...

I have a form that shows my tblCompanies. I have a field in tblCompanies that sets the lngCompanyType (supplier, customer, etc.) Also on the form I have a "filter" comboBox (fltrCompanyType) that allows the user to filter by lngCompanyType. This works fine with the following code: Private Sub...

Hell Yea! That's what I'm talking about Brad. Works like a charm. Thanks!

Hi all, What is the best way to do the following: I have a form (Companies) with a subform (Contacts) in it. I would like to open up a new form (SingleContactInformation) that displays information for a record that was double clicked on the subform. I know that the code will have to be in...

Try adding this code to your form: Private Sub cbocomplexId_Change() unitId.RowSource = "SELECT tblUnits.unitNum FROM tblUnits WHERE tblUnits.complexid=" & cbocomplexId.Value End Sub