my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal...

I can't quite figure out the syntax of what I need. I need IIF(= "12/31/2012), "2011-2012","2012-2013") I think it can be done with dateserial but I can't...

I'd like to grey out a button on my form if there are no records saved in the database. Is there a way to do this?

Repost - I originally posted via Outlook Express newsreader, but my post apparently did not show up here and did not get a response from a Microsoft Engineer...

Is there a way to set the default parameters when searching on a form to default to the form in the Look In box rather than the current field control and to...

I added a lookup box on my form and it works fine, except I have to close the form and reopen it to see the names I just entered on the form in the lookup...

I have a mainform called production machine and then a subform that lists the employees. I would like to have the subform values default to the same names...

I want a bound combo with only one listrow. Is there anyway to make the blue dropdown arrow go away since I only need one? Thanks -- Milton Purdy ACCESS...

I have a form that is bound to a table (tblSchool) as a record source. This table mostly includes a primary key and foreign keys from other tables. For...

Hi I have a form with a button on it that initiates a command that launches an inputbox. The user then inputs the required value to the inputbox and...

In the form properties I'm trying to reduce the form's width. Width property seems to be locked. Changes are ignored. What is locking this? Pete

I need a form to only be read-only once all the fields in the form have been completed to allow users to go back and view the history, but not edit. Would...

I've got an unbound text box, txtLatestDate on a main form intended to show the latest date from a series of dates in a subform. Using comboboxes, the...

I ahve a complex form that takes about 20 seconds to run the queries. I need to display a 'Please Wait' type message whilst it loads.

I have a main form, with a subform on it. I want to program one of the text boxes on the subform, so that if it is left empty, it will tab to the close form...

I have linked to which has field I would like to conditional format field (on ) if ! matches any field in I tried using Dlookup in the...

Hi, I have a form that is opened in Read Only to allow the user to view history data so it cannot be changed. I am using the same form that allows the...

Access 2007 split FE/BE, each user has their own FE. Combination of TS and local LAN users. System worked fine when the BE was on the server. A few hours...

I want to open a form using a command button and have that form open within the margins of a subform. Every time I try this the form opens full screen view....

I have a form with three fields. We will call them BillingID, ClientID and ClientName. I want to lock the second and third fields unless something in entered...