Hi For Acess 2003. In designing Forms: 1) How do I ensure only number is entered into a control box? 2) For a Bound Control, I wish to set the Default Value...

My organization is moving to Office 2007 in a few weeks. Being the closest thing to an Access expert that we have, I got an early install to help work out...

I have cboVehicleMake on my frmVehicle which is based on tblVehicleType. tblVehicleType has 3 fields: VehicleTypeID, VehicleMake, VehicleModel. Because...

Is there a way that a user can enter information on a form and those text boxes be used as the parameters for a query? If so, how would I go about doing...

How does one create the hide control click box on the Northwind Sample startup form?

Hi, I have a Form with a Sub-Form. Is there a code to disable the Sub-Form OnOpen Any help would be greatly appreciated. Thanks,

I have two fields in a database that I am trying to combine into 1. The firs is a date fiel that I am only interested in the year. The second is a number that...

Hello I have a many-to-many relationship and have therefore defined 3 tables: Table Students (1 to many to Table StudentsSports) Studen_ID (Primary...

Hi, I am doing a bit of late binding, and raising an event to set the recordSource property in my forms depending on data entered in a Dialog form. The code...

When my database is open how can I restrict the Menu Bar so that I can block out the commands under File - ie - Print Preview - Print - Page Setup. Also...

When trying to add a new graphic to a command button other than the pre-set ones in the 'Picture builder' the background is not transparent it seems to set the...

Gostaria de saber como faço um formulario para abrir uma consulta, colocando no formulário os critérios a serem pesquisados, através de caixas de...

Please do not post the same question to many groups. You lose out by the fragmentation of replies. Those who could answer your question may not bother. If...

Hello, What could be the code for onlostfocus of a MaindDate field to create a new record in the child form and fills the ChildDate text with the...

Hi, I've got a form with button on it that opens a second form. The second form displays all the child records from the first form's selected record. ...

Not sure what category this should be in - I have a query that lists projects by year. Example- Project A - 2004 Project B - 2004 Project C - 2005 I want to...

I have 3 Pages (Tabs) on my form. If i am on page 2 or page 3 and click on ANY command buton, after executing the code, the focus goes to page 1. My command...

I have a table with 5 fields. The first field has name thes second which is and the primary key, is a ID, and the rest are empty. I would like when the user...

I want to make a report based on the users input on a form. I would like them to be able to design there report by either choosing a location from a list, or...

Can someone help me. I am new at access. I have a form, which was created from a query that has several text fields whcih I use for...