Hey! I am building my first 'major' database, which i did to improve an existing database that my employer was already using but wasn't designed logically. ...

Using Filter By Form on a particular form, some fields only show "Is NULL" and "Is Not NULL" in the pulldown. I've already set the Filter Lookup option to...

Howdy. I've got a couple of checkboxes on a form that displays in datasheet view. I want to change the captions - the column headers - for those yes/no...

Howdy. I've got a number of subforms displaying in datasheet view. I want to get rid of the alternate row color scheme. I've set both the back color and...

Howdy. I'm using Filter-by-Form for searching. For each field, when in FBF, the pull down shows a list of distinct values for that column. One field on my...

Is it poss to print a report using the information in a pivot report

Can some please help me on the following I have a form which opens up by entering a paramater - with taccontrol that has about 10 pages each page, each page...

Hey, I am trying to use this expression to find the matching records from the value entered in the datalabel. =DLookUp("",""," = Forms!!") However, it...

Hey, I am using a primary key to select records. But i am tyring to figure out that when i enter an invalid key how can i get it show an error msg instead of...

I Have the following code for a command button to open up multiple instances of a form Does any one know how I can set the name of the new multiple insatnce...

Continuous form putting incrementally larger vertical space between controls as form expands downward. I know some people are leary of following links in...

My Mother passed away leaving me as ececutor of her estate. I have 5 siblings. I have her sizable checking acct. and 10+ annuities/life insurance/stocks that...

I'd really appreciate help with a subform problem I'm having. I know it's a basic problem but I've looked at the Northwind and other sample databases and...

I am sure this is a common question...but I could not find the answer. I have a form where purchases are recorded (stock table) and it has a supplier name...

I have a database which i have inherited from someone who has now left the company. There are 2 versions of the front end an mdb and an mde version and the...

Using Filter By Form on a particular form, some fields only show "Is NULL" and "Is Not NULL" in the pulldown. I've already set the Filter Lookup option to...

Howdy. I've got a form based on a query, with a column in that query using the DatePart function. Here's that field definition: WeekDay: DatePart("w",) In...

I'm trying to use Filter By Form in some applications for several projects, and the more I use this functionality, the more it baffles me. For instance: -...

All, I have a few tables in Ms access 2003. Timesheet tbl, Employeetbl, Payperiodtbl, Sickreasonstbl . Employeetbl fields Empid (primary key) however...

I was curious if this is possible. I have approx 4 or 5 forms that update different tables in the database. Is it possible to establish a sub form on these 4...