Search results

I have a report schedule that displays various information for our production dept. The underlying query for this report returns a number of fields from a handful of tables. I now need to add an additional couple of fields to this report that will detail the appoximate time to complete the job...

Please help - cant seem to get this query right. Basically, I have two tables : one table containing time stamped log entries for 10 machines, the other table contains staff identifiers. When a user uses that machine, a log entry is filed in the machines table where with the user id as the key...

For the sake of example/clarity here follows a much simplified version of a crucial reporting function on my DB….. I have a contracts table represented by the fields : Contract No. / Size / Qty I also have an assembly parameters table represented by fields : Machine No. / Size / Param1 /...

Hi Chaps/Chapesses i have a report that presently incorporates an embedded Excel OLE object. The Excel detail is simply a set of boxes/text, used as a template for handwritten entry when the report is printed off. However, I now wish to populate the cells in this Excel OLE control at runtime...

I have written a query that returns data from a number of tables and one table in particular is preventing the recordset from being updatable. This is a pre-requisite! To get around this issue, I have decided to remove the problem table from the query and use text fields on my form to display...

I have Access 97 (Prof. edition) and have just purchased the 2002 upgrade that I thought would give me the use of the active X components offered by way of the Tree and List view controls. However, although I can place the controls on my form design and I am able to set the control properties -...

I am using a switchboard similar to that used in the Northwind sample database. What I need to do is restrict access to certain buttons on the switchboard. To do this I have a table that lists all switchboard captions, thus the form structure is built 'on-the-fly'. The table also specifies the...

For printing labels I have a form bound to a table. I only ever need 1 record in this table. This record holds the label data I wish to print on the label. On the form is a print button that calls the Label report. I do not have / wish to have, record navigation buttons and therefore I am...

I have a requirement to create a labelling facility in my database. On the old DB - an AVERY label sheet is manually fed into the printer and we are able to print off exactly the right number of labels by entering the start / end positions on the sheet (working from left to right) 3 columns / 7...

I have come across a confounding problem....!!! i have an invoice form that displays the sub-total / VAT / and Total fields. All of these are text boxes having the 'Fix' format type and 2 decimal places. Using the following values : Sub total = 4547 VAT (@17.5%) = 795.725 this displays as...

I have a textbox on a form that calculates VAT for transactions whose controlsource property is : =([txtSubtotal]*0.175) The trouble I am having is with the rounding that seems takes place in the control. If the fractional part of a value is calcuated it is rounded in accordance with the...

Hi I want to 'cleanly' be able to print out multiple instances of a report with a small variation between each print. eg. I need to print an invoice report and also an advice note. The advice note mirrors the invoice in all ways except that the header reads 'advice note' as opposed to...

I have a contract number which is a five digit code. For phased deliveries i.e. where items in the same order are to be delivered on different dates, the contract has an additional identifier (1-9) to identify the batch. i.e. 31022 (Base contract) 310221 (1st phase) 310222 (2nd phase) etc...

Hi My PC configuration for the printer is such that for individual print jobs I can preview each item before spooling to the print queue. (for long e-mail correspondence this is handy because I am able to print only the most recent page of communication.....). However, from my Access DB - the...

I have a Stock record form where material items are recorded along with their costs. The subform lists all contracts that are allocated units of this material. The subform has a Value column that is an unbound field ie. calculated from : QtyIssued * [ParentForm]!UnitCost. I now need to store...

I need to create a query that will return from the table all Id records that do not exist from a run of 1-n ...... i.e. for 1-10: the table contains the following Ids 1,3,4,5,7,8,10 The query will return : 2,6,9 Has anyone done something similar? Thanks Guy

I am still looking into the mist that is rollback using a replicated database........ What I need to do is to signal to the parent form when its subform has been updated. When the subform is updated - the underlying tables immediately reflect the data that has been entered. I propose to use a...

I have found this link referring to Form - Subform rollbacks. this is fine when working with a standard Form / Subform setup, my database however is replicated and when I run this code to enable me to rollback the changes,I get : Error code : 3666 You cannot modify the replication system...

I have a Closeform() function......when the user clicks this button - the Form_BeforeUpdate event gets called. Here I have a call to a SaveChanges() where the user gets the chance to Save / Cancel changes. The dialog box is Yes/No/Cancel. Hence : Yes - default action i.e. Save No / Cancel - do...

In my application I use extensively Form/Subform relationships and have realised a common problem throughout.......if the user makes changes to the form and then tabs onto the subform changes are made immediately to the main form record. Further changes to the subform are made when the user...