I have a sub form that calculates the number of students enrolled in a class. The room that the class meets in has a capacity. When I enter one too...

Hello there, I need to create a comboBox named cboStatus as follow: 1) If the user is a manager, display only one status in the comboBox as "CLOSED" and the...

This shold be very easy but I cnat get it to work. I have a CBO with 4 selections. My control source and name is INSURANCE CONSULTANT, My Default is blank...

On Access Forms, how can I set (control source) of an object to more than one source (e.g. a field in a table as well as an expression). I want to automate a...

I am creating an application with a parent form and a subform that contains a datasheet. When a button on the main form is clicked I want to initialize certain...

Hi I am a newbie and tearing my hair out. How do Ai set focus to the first control in a tab. What I want ot do is that when a user finishes the last field on...

My form is little smaller than the screen. However, upon launch, the forms length becomes bigger and Access Record information on shows at the bottom of the...

Here I am reaching new frontiers and need some feedback and possible guidance. I have a situation where when inputing information, the value of certain fields...

Hi, Problem is that i would like to set parameter value in code so subform can update its contents depending on parameter value. I have a query that uses...

I am using AC2003. I need to connect to an XL spreadheet that was built in Excel 5 or 95. (I am not able to convert this file to 2003 so I have to to set...

The security settings allow me to keep data from being deleted in tables and queries, but not forms! Is there any way to do that??

I have a main form with a subform. The main form contains only displayed data; i.e., no control gets the focus. What I want to do is to set the focus on the...

Hi all, I have Access 2003. Question: I have a form and a calendar control on it. I set the Picture property of the form to a jpeg file. But I can't...

Hi, Does anyone know how to set the Check box or option button's value? In Access database, the default checked value(yes) is -1, and the default unchecked...

Hello all, I need to build a input form for 11 pages questions. There are not enought space in one page form. Could someone give me suggeston or tell me how...

I have a subform on my form and I want to set the order by property of that subform to the dateDue field (which is a date) but it won't work. I can set it to...

Hi, I am trying to use the following code to populate a combo box. Essentially what is happening here is I have a textbox on another form and I am setting the...

I am using the date and time formats to give me unique numbers which will be associated with a project name and have managed to insert the expressions for...

Thanks for your attention How can I set true a check box without click the...