Search results

Hi Martix (a friend of Matrix?) You cannot add an input mask or calender control to an Access input/meesage box. If you create a parameter query that asks the user to enter "Start Date" or similar then you are restricted to a simple grey box with no fancy features. The solution is to create...

Hi acepayne Can't you do this calculation within the query behind the report? You can have a calculated field within a query based on the data available within each record. This is what I do, for example, with invoices that have discounts or percentage taxes to pay - the subtotals, net totals...

Hi Josh Please avoid multiple postings on various forums - it gets confusing for anyone trying to help you. If you have two or three threads running at the same time on the same topic it is impossible to see what else has been suggested/tried. See my response under General. HTH Rich Gorvin

Hi Steve Yes. Use the same names as your parameter criteria as the control source for unbound text boxes - e.g. =[Enter Start Date] =[Enter End Date] HTH Rich Gorvin

Hi Acepayne I think Drew's solution looks pretty neat. As he and you have discovered Access formats the detail section of a report (at least) once to preview it and (at least) once again when you send it to print. There is something on this in the Help File (for Access 97): You can use the...

Hi Sphere The ampersand - & - is used in VBA to join strings and coding together. If you want it to appear in a label you need to put it twice! Sales && Customers in the Caption property of your label will give you: Sales & Customers HTH Rich Gorvin

Hi Wah Aah ... now you didn't say about blank pages/blank spaces being a problem! Something can be done about this by setting the CanShrink property for the subreports (as a control/object within your main report) to CAnShrink=Yes. Similarly you can set the Detail/background of the main...

Hi Jcri I guess you have a number of options. If you are the only user of this database you could set your screen to a different (i.e. higher) resolution. You could make your header and /or footer shorter (so re-design these sections). You could re-arrange your fields on your form so that...

Hi Benwah I agree with your IT resident access expert. Autonumbers are there to automatically add one number to a sequence of already allocated numbers. Delete an earlier number and the gap is for ever. However, autonumbers are intrinsically meaningless - they bear no relation to the data...

Hi Princess I would be wary of trying to create aditional tabs for each appontment. This might be fine for someone with 3/4/5 appointments, but what happens in 4-5 years time if that person has got up to 20 or 30 appointments - is it realistic (or even feasible) to have 28 tabs? Why not have...

Hi Mcgrco I see you have already received advice and sorted out your problem, so perhaps this posting is pointless. However, I would like to make a suggestion or two about tidying up your coding and naming the objects more consistently. At the moment you have...

Hi wrek Sometimes! Have you checked using SQL view - just to see if the name/reference is repeated somewhere? Rich Gorvin [This message has been edited by Rich@ITTC (edited 07-24-2001).]

Hi wrek I would check your query carefully to make sure you have not accidently added the same field twice (it is very easy to do, especially with quite complex queries). If you run the query (not the report) and look for any fields with a column heading like Exp1001, then that is likely to be...

Hi jhansen I don't think you are missing anything! If the Control Source for that field is set to: ="my text"&[field name] you should get the following displayed: "my text my data" with no spaces etc. However, you may find that you need to do this in an unbound text box - rather than in...

Hi Mark Please see response in the General Forum. HTH Rich Gorvin

Hi kgcrowther It's perhaps worth checking the settings for the subform name. I believe that the usual syntax is as follows: Me.[SubFormName].[ControlName] though these also ought to work: Forms![MainFormName]![SubFormName]![ControlName] Forms![MainFormName]![SubFormName].Form![ControlName]...

Hi wrek I can't take credit for the Null idea - that was Rich rather than Rich@ITTC. However with a big long list of possible fields and their associated labels I wonder if you won't still get blank spaces. So here are a couple of other ideas - select the report's background - Detail and set...

Hi wrek Hmmm, that's some report you've made there! I won't even begin to try and work out what kind of data you are trying to display. I would still forget the pixels, and I would still go for the page N of M pages in the page footer but change the property setting for the subreport to...

Hi wrek I still don't understand why you can't use Pages along these lines as your control source for an unbound text box: ="Page " & [Page] & " of " & [Pages] This will mean that if a report of two pages is printed it will say Page 1 of 2 (first page) and Page 2 of 2 (second page). If your...

Hi wrek I am a bit confused by your posting. You have posted under the Reports forum yet want to find out the number of pixels. Reports are for printing out on paper so the unit of measurement should be centimetres or inches (or possibly points), but pixels don't seem to be relevant. Pixels...