Forms

Records and Associated Notes Query
Hi, I wonder whether someone may be able to help me please. I have two tables, one showing invoice details, the other showing notes about the particular invoice, linked via a InvoiceID field. What I'm trying to do is to create a report that allows the user to select all the invoices and selected notes which ... 25 Jan 2010 12:49

use OnClick code
Hello All Is it possible to include the OnClick event code of one button as part of the OnClick event code of another button - without having to copy/paste it all? I'm sure this should be do-able, but can't quite see how! Hope someone can help. Many thanks Les ... 24 Jan 2010 07:53

automation with access
Setting up automation with access to format excel file being produced following Doug Steele's code from article Access Answers: Excelling Automatically related to formatting excel spreadsheet during export process. in this article Doug describes a process to help identify code for formatting Excel workbook by r... 9 Feb 2010 11:43

Delete duplicates from a table
I want to delete duplicate records by comparing 25 fields( basically check all the columns) . I always use distinct to check a single column but not sure how I can check all the fields!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 ... 22 Jan 2010 15:14

Accsess Form
I Have a broblem with this =[Line Total1]+[Line Total2]+[Line Total3] +[Line Total4]+[Line Total5]+[Line Total6][Line Total7]+[Line Total8]+[Line Total9]+[Line Total10]+[Line Total11]+[Line Total12]+[Line Total13]+[Line Total14]+[Line Total15]+[Line Total16]+[Line Total17]+[Line Total18]+[Line Total19]+[Line Tot... 22 Jan 2010 09:32

adding up 1 to 25 fields Line totals to a sub totals
= [LineTotal1]+[Line Total2] throught Line Total25 and Iam getting sothing only if the entire 25 field have numbers. I think if the fields are not full it brings back nothing. ... 22 Jan 2010 00:45

Current Record Source
I have the following Function in a module and using on a toolbar. It works well on the open form which the toolbar is assigned to. The current Record Source of my form is qryAll. I want to use this Function on several other forms each with a different Record Source. How do I go about using a variable as the ... 25 Jan 2010 11:41

Import - Import Specs
Is there a way to import, import specifications from another database? ... 21 Jan 2010 18:04

How force table update when no bound field updated?
I have a main form with a 'Balance Due' field. There are two balance due controls, one unbound (displayed) and one bound (hidden). I also have a subform which is a continuous form containing payment data. When payment details are entered or changed, the balance due on the main form and in the bound table needs to... 22 Jan 2010 10:40

Duane Hookom's Query By Form - question
I'm using this to give my database-challenged co-workers an easy way to run on-demand queries (so they can stop bugging me). On the query results form, I'm trying to give the option to print the underlying query. I can't get anything to work right: - DoCmd.PrintOut prints the form footer. - Tried opening a fo... 22 Jan 2010 23:03