Search results

Hi Brian I have no personal experience in this area ... but I do remember seeing an article in Smart Access on the subject. February 2001 - Build Gantt Charts with MS Graph - Doug Den Hoed "The MS Graph engine that powers charts in Access and Excel is extremely flexible, but it often requires...

Hi Paul OK here is some advice. Create a table of current prices, with product ID, descriptions, etc. This table is used as a lookup table to give you a default price when creating your quotation and/or invoice. Create a table for storing overall quotation/invoice details - customer ID...

Hi PTaylor-West I am not sure if I classify as someone new ... so maybe my advice will be old hat to you! I wonder why you are printing a form. Apart from very occasional planning/design work (when I show the client a screenshot of a form) I never print a form as forms were never intended to...

Hi Ian How have you set up the dates that the users have to enter to get the form open? Are these dates parameters in your query behind the form? If so, you could change the reference to a stored value (i.e. in a temp table) that your report could also reference. At the moment it sounds like...

Hi Donny You could create two unbound text boxes on your form, formatted to Date/Time and with an Input Mask: 99/99/0000;0;_ Then reference these two fields in your criteria row within each query: Forms!frmMyFormName!txtStartDate Forms!frmMyFormName!txtEndDate Then when you run your...

Hi GRW I assume you mean two lists, one of available records, the other of selected records. When the form first opens, the available records is populated, the selected isn't. User can select all records (double right arrow command button) to transfer from available to selected, or can select...

Hi Mike I take your point about usually only needing one table, but what about the situation where you want to keep some areas of information confidential? For example, each member of staff is only on one pay scale and has given me only one set of account/bank details ... but the other staff...

Hi Karatelung I have made some assumptions ... 1.Your subform is based upon a query 2.Your value "client" won't be a variable criteria (i.e you will only ever want to count up those records with "client" in them) In the query make a new column - a calculated field called Client, for example...

Hi Moose Isn't it more usual to email a report (which can be based on a form). I don't understand how you can email a form as it is an object within a database (it is part of a .mdb file). A report could be saved as a Word document, as a SnapShot file (and the SnapShot viewer can be...

Hi crosmill Dare I ask ... if you have two tables that basically have the same data then surely one of these tables should be deleted (as it only contains what the other table already has, in theory). If you are designing a database from scratch this situation (the same data being stored in...

Hi Joe Try to avoid duplicate postings in different forums at this site. It makes life difficult for those trying to follow the chain of advice offered. If you are not sure which forum is best for a topic go for General. Rich Gorvin

Hi Gord Yes lines can grow, but ... it is not all that straight-forward to work out how! Unfortunately lines do not have a "Can Grow" property. You can have a border around your text boxes on a report and this (the text box) can be set to can grow and the border will naturally grow too...

Hi PistolPete I agree with Rich above (not surprising, given the shared name!) but I would add one thing that could help you explain things to others. If you have a total (a calculated field) that is made up of the combination of three other fields then you have automatically stored the...

Hi de049 If you want the value over four weeks why not have a query that searches through a period of four weeks (not one week at a time) - eg Between #03/09/01# And #28/09/01# (using UK dates - dd/mm/yy) or ... >=[StartDate] And <=[EndDate] (as a Parameter query ... this could also call on...

Hi PearlGI I can't give you an answer as to why you get this warning message ... though I do sympathise with Access as you seem to have query after query after query - very confusing to follow how you have put all this together! In fact, your warning message could be a bit of a red herring ...

Hi de049 You could use TotalW: (IIf([Mom am]=W,1,0)+IIf([Mon pm]=W,1,0)+IIf([Tues pm]=W,1,0) and so on I would build this up bit by bit - try it out with 2 periods, then with four etc. However, it isn't a very elegant way of doing things ... having 12 fields to store the different...

Hi keybs Why not do away with the criteria within the query and use a Link Criteria in the DoCmd OpenReport coding behind the button you click on your form. ------------------------------------------------------ Sub cmdJobReport_Click() ' Comments : ' Parameters : - ' Returns : -...

Hi de049 I think it might be better to split up this information into two tables - the employee and another table for attendance. In the attendance table you need only to store the employee ID and the date he/she attended. You can then in a query (or in a form or report) use the Count...

Hi de049 Well let's start by checking a few things. You need to have surname, firstname, department as textboxes/fields on your form. Then elsewhere, normally in a form header, you add a combo box (like a list but a dropdown version) created with the Controls Wizard selected. This will give...

Hi Mike How are you keeping? Well I hope. So you want to open another form by clicking on a subform. Is your subform viewed as a datasheet or a single form view (or continuous view)? If it is single form view you can use the Detail section and that has an OnClick and an OnDoubleClick event...