Search results

You can't put any queries in a report. You can make a reports from queries. If you want to make a subreport. Ex: Make Report1 and Report2...open Report1 in design view...drag Report2 in Report1... hth, Michael

Make a header for HCPCS and footer for Total Price...Go to Sorting and Grouping..select HCPCS for Group Header..Say Yes to Group Header..Place HCPCS field in Group Header...Total Price...Say Yes to Group Footer...Make a blank field for sum total. hth, Michael

If you have a date field run this in the criteria Between #1/1/04# and #1/1/05# <--- Example ( you can use any date you wish) hth, Michael

Thanks alot man. The whole time my claim rep field was causing duplicate. I knew I was on the right track. Thanks again, Michael

I have a query that I would like to put in a report. Before I do that I have an expression that runs stolen car make and car model. How do I get rid of duplicate and put car make field and car model field together? I attached a sample database. If you run the query you will notice I have lots...

Try pasting this code below by making a command button in form for sorting. FieldName.SetFocus DoCmd.RunCommand acCmdSortAscending hth, Michael

Try pasting this code in a command button (on click event). On Error GoTo Err_Handler Dim strFieldName As String Dim strForm As String strForm = "Form Name that you wish to open" 'Open a form with specific record strFieldName = "[FieldName]='" & Me.FieldName & "'"...

Post your database. Michael

I'm a little confuse what are you trying to do get all your records in a combo box? If so, make a blank combo box in a form. Row Source Type: Table/Query Row Source: Table Name Another way to do is the Combo Box Wizard. hth, Michael

Try ghudson sample This will stop the user from going to a new record till your OrigProcDt field is completed. Be sure to paste the code in Form Before_Update. hth, Michael

My guess is you dont have a new version of access. I attached a 97 version. hth, Michael

See attached file.. hth, Michael

Try pasting the code below in After_Update Combo Box Me!ComboBoxRequery.Requery hth, Michael

Paste this code below on After_Update Combo Box... Me.RecordsetClone.Findfirst "[field name] = " & Me![ComboboxName] Me.Bookmark = Me.RecordSetClone.Bookmark hth, Michael

Requery is the keyword... Try this Forms!FormName!SubformName.Requery hth, Michael

You can also right click on a database, go to property, and check the Read Only. This will prevent user from making changes. hth, Michael

Check out the attachment. hth, Michael

Try searching the forums for Close Database on Timer. I found couple of examples that might be useful. hth, Michael

Try pasting the sql below on row source combo box. If it doesn't work, you might want to attached the database. (I'm guessing Functiona_Areas is not a primary key) SELECT [tblFunctionalAreas]. [Functiona_Areas] FROM [tblFunctionalAreas] ORDER BY [tblFunctionalAreas].[Functiona_Areas] hth...

What does your row source say in the combo box property? Try something like this...SELECT [YourTable].[name of Functional Area Field] FROM [YourTable]; hth, Michael