Search results

I believe you can. If you have created 'Groups' on your report then you will have a group header and group footer. If so then this is the plan: Inset a text box in the group footer. Let us say you need to total the 'quantity’ from the group. (Make sure you know the name of the text box you wish...

You may need an "=" sign after MyCalc: (Can not remember)

As long as you actually have a field called "WHSL Price” then just go to the first empty query cell and type in the top row: Mycalc:sum(iif([WHSL PRICE]<10,[WHSL PRICE]*4,[WHSL PRICE]*2)) (I did not actually check to see if this works. I am going on memory and at time that fails me too!!) Sam

I had never used the UpDown button before so thank you for pointing out the differences. Have fun Sam

Post your DB and let us tinker with it. Sam

Try this. (Attached) Sam

Sorry but I forgot to mention the reason your New Student form is replicating students. You have the main form linked to the student table but you also have the subform link there as well. From my quick look I saw other problems as well: 1. Main form should not be linked to new students except...

By the look of the database this would require a complete rewrite. The table organization is very poorly planned and the forms are a mess. If you are fairly competent with access design procedures then plan on days if not weeks of work to repair this. If not then consider hiring someone to sort...

I am surprised that you say it does not work because that is exactly how you have access set a default value. Sam

I would suggest you use the Microsoft Forms 2.0 Spinbutton. It seems to be exactly the same as the one you talk about except that you can size it both ways. Sam

Look at the join in your query. If it does not have an arrow on one end then you have the wrong one. Right click on the join and choose edit. Sam

Look and see if the query itself is giving you what you want. If not then the problem is probably in the query and not the report. Sam

I would suggest you zip up your access database and let someone give it a go. If you are concerned about security then delete and data you do not want others to see. Sam

I might be wrong but try this instead: Dim CritText As String CritText = "[ID1] = " & Me.ID1 DoCmd.OpenForm "frmTestAll", acFormDS, , stCritText

Is this Text Box that needs the default setting on a different form than "myfield"? And is there only one record on that form with ID=1 or is this a bunch of records with different ID's and other info? Sam

Yes there is a way. Let us assume the field name is: My Field First you must make the field "Required" Then in "Validation Rule" type the following: Len([My Field])>1 And Len([My Field])<5 Then in "Validation Text" type the follwing You must enter at least 2 and no more than 4...

I also notice you are missing the "!" in your Me![CustomerID]

Sorry but I missed a closing ")" on the end of the last message Sam

You might add a bit of coded as below to see if CustomerID is valid. Private Sub cmdNewSupQuery_Click() On Error GoTo Err_cmdNewSupQuery_Click Dim stDocName As String Dim stLinkCriteria As String msgbox(Me![CustomerID] DoCmd.OpenForm "frmSupplierQuery", , ...

Does it have to be a query or could it be done in code? Sam