Forms

change Caption menu Items
Hello, how can i change the caption of a menu item i.e. Menu Bar shows a customized options from VBA. i.e. [Pending (x)], [New Clients (x)], etc... where x = a count of recordset. thanks Lee ... 3 May 2010 17:37

Tricky one..."Select"
This may be helpful: http://www.mvps.org/access/modules/mdl0004.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Peter" <Peter(a)discussions.microsoft.com> wrote in message news:7328FC7C-030B-4EF2-950C-D99C39E93D7C(a)microsoft.com... Hi all, i wis... 6 May 2010 15:24

Tricky one...”Select”
Hi all, i wish to solve the following,, From a continuous pop up form B...i want to select some records (unbound check box) and populate the selected records [Bananas] and [Kilogram] in the consternated textbox [Fruit_Basket] in the open form A... What code do i use in the onclick event of a command button? Exa... 3 May 2010 16:30

Filter Combo Box Listing
I have a form with the first four fields named "FirstName", "LastName", Phone", and EmailAddress". The field "EmaiAddress" is a combo box. The row source for this CBO is a table named Email. The table Email has five fields: "EmailID (PK), "FirstName", "LastName", "FullName" (first and last name concatenated), ... 11 May 2010 12:18

Is it possible to have If statements in a query?
Hello, I have a subform and in this suform I have a combobox field called "Category". In this combobox I have a select query that pulls the Category and TeamName. On the master form I have a floating combobox called Team. When I choose a team in this field I would like the subform combobox to be narrowed down ... 3 May 2010 18:44

Are If statements possilbe in Queries?
Hello, I have a subform and in this suform I have a combobox field called "Category". In this combobox I have a select query that pulls the Category and TeamName. On the master form I have a floating combobox called Team. When I choose a team in this field I would like the subform combobox to be narrowed down ... 4 May 2010 19:06

Retain combo box order
Hi. I have a 2 column combo box with a query for its row source. The query includes one lookup table (2 fields: ID and Description), with the id ascending. The bound column is one; column 1 is hidden. If I open the form, choose a value from the combo box, go to design view, then go to form view, the the comb... 3 May 2010 17:37

Opening an Access 2007 form from Word VBA
I want to use Word to open a form I created in Access. I presume that I have Word start the specific database in Access and then show the form. How is that done? ... 3 May 2010 15:23

MDE in A2003, A2007
My client distributes our Access (2003 format) application to his users as an MDE. Thus far, there has been no problem making the MDE on the (2003) development machine - it would run fine on a 2007 machine. Now, however, we've added a reference to another MDE (also created in 2003). Now, if we make an MDE... 3 May 2010 12:04

Use calculate age to write other fields automatically
Hi All i have a date field called Data_Nascita and and unbound field to calculate the age (called Anni) with =DateDiff("yyyy",[Data_Nascita],Date())-IIf(Format([Data_Nascita],"mmdd") Format(Date(),"mmdd"),1,0) this works enoght. Now i want to write automatically other two fields (Categoria and Descrizione) in... 12 May 2010 09:09