Recent content by R6Flyer

Insert an unbound textbox in your form and set its control source to: =Nz([item 1 price],0)+Nz([item 2 price],0)+Nz([item 3 price],0)+....+Nz([item 10 price],0) That should get round your #Error problem

Andrew, Insert an unbound textbox in your report and set its record source to: =[squadron] & "/" & [office symbol]

To only allow a user to enter new records into a form set the Data Entry property to Yes. This will, however, lock them out of viewing previously entered information. To allow them access to view previous records (but not change the data) set each fields Locked property to Yes. You may find...

In that case change acLast to acNewRec

on the open event: Private Sub Form_Open(Cancel As Integer) Docmd.GoToRecord , , acLast End Sub

DoCmd.GoToRecord , , acLast

Change this line in your code:

Change the first line of your SQL to:

teiben The form APQP needs to be open when you hit your command button otherwise you can't set the value of the field. If the form is not open then Access will return the error message you are currently seeing. As long as the form is open your second suggestion should work, i.e. assuming...

Do a search for FollowHyperlink

I would be more tempted to create an option group on your form containing the names of all of the fields you want to search by (there is a limit to 20 options in Access). The user could then click on the option referring to the field that they want to search on and you could include code on...

You will also need to set the timer interval as Col suggested. Start off with a value of 100 and experiment with different values to get the result you require.

I would suggest having a lookup table for your authors: tblAuthors AuthorID (autonumber) AuthorDESCR (text)

OK, change the recordsource to: SELECT [Monthly Issues Data].Supplier, [Monthly Issues Data].M8 AS [Enter Relevant Graph Label], [Monthly Issues Data].M9 AS [Enter Relevant Graph Label], [Monthly Issues Data].M10 AS [Enter Relevant Graph Label], [Monthly Issues Data].M11 AS [Enter Relevant...

Can you post the record source for the graph.