Hi Everyone I have a table called tblComments where I store details of any updates or news relating to the database. I would like to have a window on the...

Form: Main Menu From the Main Menu you open up the main form, “Program_services” (unbound) which serves various purposes aside from the fact that it has a...

I have a subform which has a default view of "Continuous forms". On this form I have several unbound text boxes to display data from other tables. This...

In Access 2003, I have a data entry form with a Multi Select list box. I'd like to attach a button which runs a macro or a query or a code that will create a...

Hi, I have a an unbound mainform with ActiveX calendar and some buttons. It contains an unbound subform whose record source I update from a button event on the...

I have a listbox that has it's masterfield and child field set to one query, and my subform set to another (while both queries are linked to the same...

I am having trouble trying to create a query to select the largest value in a specific field for each record in a table. I have created a crosstab query and...

I have created a button that is supposed to duplicate a record, but every time I try it , I get the following: "Record(s) that CAE Project was unable to...

I have a trendline formula that I need to use in my database so as to dynamically create some charts The formula is : INDEX(LINEST(y,x^{1,2}),1) Where...

This is a Carryover from the "Populate Subform based upon a Query" post that Dave Hargis and Rick Brandt were kind enough to try to help me with my...

I have a listbox that is populated from a sub query (qyListFEA). I have set the subform's LinkMasterField and LinkChildField to this listbox. The list box...

How do I do a “left justification� of a text title in a Command button?

Goal: : To improve an application's performance by basing sub forms and combo The application has a front and back-end. There is no SQL server involved. I use...

Improve an application's performance by basing sub forms and combo boxes on queries: Why does making sub forms based on queries rather than tables...

After creating a button on a (parent) form linking to another (child) form, I received the following error when clicking on the command button: "The OpenForm...

I have a form that looks at performace results for three products. Forecast, Sales, List Price, Net Price, Quantity. The top of each form shows the Product...

I use Pivot tables to view sales by month Jan-Dec, but can't seem to find a way for the form (or report) to automaticaly deal with the fact that in February...

I'm having a problem that I'm sure others have experienced. I have a form with a subform and I only want 1 record added in the subform. I set the CYCLE...

I have a very strange problem with a form in my database. The form draws fine if I'm in design view and then switch to view the form. But if I open the...

The following is used in a control souce in an Access 2000 Application and works fine: =-nz(!!!LineTotal,0) In Access 2003 the explicit reference alway returns...