Search results

Open your form in design view and open the properties box. Go to the Cycle line and select Current Record. That will produce the result that you want. Good luck

You should not be able to in a one-to-many relationship which is what you have here. The best way to achieve what you want is to change the layout feature of the subform so that it appears as though it is part of the main form. Click on design view of your main form and click on the subform...

You would require an outside "Help" software program, such as WinHelp .Access Developer also has the full capabilities of creating help files.

Make sure that your StartTime and EndTime are formatted to Short Time. Create an unbound text box and in the control source of this text box place the following: =[StartTime]-[EndTime] Make sure that this unbound text box is also formatted for short time. Good Luck

Open the report in design view and select Sorting and Grouping. This will list all the report groupings and whether the fields have Headers and Footers. Adjust as necessary, but remember that any fields or detail information contained within these headers and footers will also be deleted if...

Do a compact and repair on your database and see if this helps.

Can you send a small sample? Should not be too hard to locate the problem.

Once the project gets selected, then you would have the combo box requeried to reflect only the subprojects connected to the main project. On the On Enter of your subprojects combo box, include this Event Procedure: Private Sub SubProjects_Enter() On Error GoTo SubProjects_Enter_Err...

In your query, start with your base table and add each table and run your query. If your query does not return any results with the joined table then I would suggest going into your relationships and deleting Referential Integrity on the join between the two or more tables that are giving your...

In the On Click in the properties for the cancel button, make an Event Procedure and have the following: Private Sub Cancel_Click() On Error GoTo Cancel_Click_Err DoCmd.Close acForm, "MessageBoxForm" Cancel_Click_Exit: Exit Sub Cancel_Click_Err: MsgBox Error$ Resume...

You will have to set up your recordsource for your report by making a query. Your query should include all the related tables that have the fields that you need to be in the report. Then you can have the report print off a selected purchase order by specifying a unique ID field, possibly the...

In reports Access will group by your 1st selection first, 2nd selection, second and so on. Try having your first grouping by Employee. Failing this - there is something wrong within the setup. Can you send a sample. [This message has been edited by Carol (edited 04-27-2000).]

Run your query and see if you get the results that you need. If the query returns the correct data then the problem lies within your report layout. Report back if you have further problems. Good luck.

For your information: I have contacted Microsoft about formatting individual fields within individual records within a continuous form. It cannot be done. All records will change. This is something that they are aware of and maybe with the next release (200...) Access will be able to handle...

The answer that Pat Hartman gave is correct. Go back into your table and move your RecordID field and your DateField to one below the other. Highlight the first line and while holding the mouse button, move down to the next line and create 1 primary join key field. This will solve your problem.

Create another field within your query as follows: Name: [First Name] & " " & [Last Name] and use this new field in your report. Change your field names as required. This will merge both names within 1 field with a space between the first and last name. Good luck.

Put this code as an Event Procedure behind your drop down in your main form on the On Enter in the properties: Private Sub MainFormFieldName_Enter() On Error GoTo MainFormFieldName_Enter_Err DoCmd.Requery "Table/QueryName" MainFormFieldName_Enter_Exit: Exit Sub...

Set your form to add new records only. Select "No" to Edit Records and "No" to Delete Records. This will allow new records to be placed.

I have a form that prompts the user for a production date that will display the reworks on a part-by-part basis. If the rework % is greater than 1% than a label is displayed (Called Troubleshoot) and a Command Button (Called: TroubleshootForm) is also displayed which when clicked takes you into...

As long as your datasheet is set to Edit Records, Add Records, and Delete Records you should be able to do so as long as it has the focus. Your problem lies within your query and your relationship. Go into your query set up and check out the relationships between the other tables/queries...