Search results

Hi Gurdeep Saini Why not use a command button that directly runs the query? From the toolbox in design view for the switchboard you can select a command button and draw it in your form (with the wizard button on the toolbox being depressed). The Wizard then has "Other" as one of the choices...

Hi Rachel Have you checked the property FAST LASER PRINTING on the Other tab - Properties (with the report itself selected)? If this is set to Yes then with some Laser Printers lines can mysteriously disappear. Try setting Fast Laser Printing to No. This might help - we had a similar problem...

Hi Twin Have you tried referencing the fields on your subform? Let me assume certain things. You have a subform (frmInvoiceSub] with a text box called [txtCost](based on the query field [Cost], but named with prefix txt) on a main form called frmInvoice. Note that the field name and text box...

Hi emcc You will probably have to reference the complete calculation that Outstanding is based upon. If your calculated field - Outstanding - is based say on two fields (Cost and Received) then your total will call upon them eg: =Sum([Cost]-[Received]). If these values are on a subreport...

Hi Zharia Sorry, but your description of your problem is a little confusing (perhaps you are confused by Access!). Your form will have the fields available in the Field List - the button to the left of the "Hammer & Spanner" aka Toolbox button is the one to use on the Toolbar when in Design...

Hi Zharia Are you sure you have these fields, from the Employees table presumably, in the underlying query that the form is based upon? You can check by going into Design View for the Report and selecting the whole form and checking the Record Source. Click on the ellipsis at the end of the...

Hi Lee You need to add the following code to your "Datasheet" or Form 2 (for whichever field, or all fields, that the user can double-click on). Private Sub txtYourField_DblClick(Cancel As Integer) On Error GoTo Err_txtYourField_DblClick Dim stDocName As String Dim LinkCriteria As...

Hi Yankee You've probably got your Report Footer too large/high to fit on the end of your (currently) penultimate page. Reduce the height of the Report Footer and see if this helps. If not, see if your detail section has excessive "White space" at the bottom - if it does, reduce the height of...

Hi Marrett Have you made sure that you text box is not called Sponsor - if your text box is named with the same name as your field from the table this will cause a conflict? Is the text box set to a particular format (e.g Currency?) - perhaps a "" value is not acceptable to the format setting...

Hi Kieth Without coding - I don't think it is possible. Coding is a bit daunting initially but if you give it a try it will usually prove worhwhile in the long term. If your option group has Yes or No, then probably the value is either 1 or 2. Select your option group in Design View. Click...

Hi again Keith! Don't know why I thought you wanted to use a combo box ... but the same applies to an option group I think! The techinque definitely works ... you would just need to change the control. HTH Rich

Hi Kieth Yes it is possible. In the "AfterUpdate" event of the Combo box put coding along these lines: If cboMyCombo = "Value1" Then Me![pagMyTab].Visible = False Else Me![pagMyTab].Visible = True End If Me.Refresh If your Combobox is bound to a field then you would need...

If you do not want to do what Travis suggests (using SubForms) then maybe you should combine all three tables via one query. The form would then draw upon the query (but it could be a very "busy" form with all the fields from three tables). HTH Rich

I do not think there would be a problem with what you want to achieve if the users each have a front-end database on their workstation and a back-end database on the server (with only the tables stored here). Each user would then be running their own version of the form (and underlying query)...

Yes you can change the font colour based upon a condition. You would need to decide what would trigger that change in colour (what value in a field would do this) and what numbers represent the colours you want. Below is an example from a form (that I quickly put together and tested) that will...

Hi Rasa I agree with the suggestions made by Richie and Mike. You do not want to store the total cost because (as you know) it contravenes one of the normalisation rules, and those rules are based on very sound, logical principles. Imagine if you did store the total cost somewhere in a table...

Hi Robert C Try similar coding to below Dim DocName As String Dim LinkCriteria As String DocName = "frmDeliveryDetails" LinkCriteria = "[OrderID] = Forms![frmOrders]![OrderID]" DoCmd.OpenForm DocName, , , LinkCriteria This works for me in similar situations. HTH Rich

Hi AndyH Please see posting under General Rich

Hi Robert C Does the query that this PopUp form draws upon have all these other details within it? If the query does not contain Address1, Town, ZipCode etc then the PopUp form cannot display this information. HTH Rich

Hi Lily Thanks for your e-mail. Usually we try to continue the correspondence via the Access World Forum (in case others want to follow the thread). Try setting to Yes for Can Shrink (sorry that I suggested True before, but I was doing it from memory). HTH Rich