Hello All I have a text field on a form where valid entries will be a combination of alphas and numerics - e.g. re46 gt3 tr 435 frtrg 54635

I have a form based on a table, whose primary key is . The first character in the identifies which section the item is in. The section characters are...

I have a database that the user enters in information related to customer name, address, etc., along with selecting the item to purchase (a storage building...

I would like to have a control return the contents of a field, but without the internal spaces. I know the trim function can eliminate the left and right...

Hi, I'm trying to create a variable that will return a record number that corresponds to a particular value in one of my fields (Access 2003). Example... In...

I need to calculate two fields, one of which is being obtained from a SubForm where a record may sometimes not exist. Can anyone help me in doing this? My...

Hi All, I have a RMA form that I want a few buttons to be hidden until an Authorization Code is entered by a manager. Question 1: Should I use a field called...

Hai Iam trying to develop a database in access for logging flight details for a flying club and iam using Access 2007 I created a form called LogFlight ...

I have an access form. When the user leaves it to use a menu item, I need to update a label on my form when the user returns to the form. The Form_Activate...

Hi, I'm working with an Access form where, in real time, someone will observe a session, noting if specific activities occur across 12 five-minute time...

I've been tearing my hair out... no doubt a familiar situation for beginners. After much hair loss, I have ended up with a form that has three fields on it...

-- Kenny G

I've got a form with a field pulling a client list with Row Source: SELECT tblClients.ClientName, tblClients.ClientID FROM tblClients ORDER BY...

How can I display a graph on a Form all the time? I have a Pivot Table in a Form, and I am graphing this data set. Everything works fine, but when I close...

I'm trying to subtract two figures from the same column (ex: a figure from line 11 column B - a figure from line 10 column B) and then put the total in a...

How would I set a validation rule to effectively "limit to list" a combo box field, but also allow nulls? Thanks in advance.

Using Access 2003 on Windows XP SP3. I want to highlight a warning on a form if Boolean field has the value "True". I would like to get the control that...

Dell toutes nos meilleurs offres Dell all our best deals Dell alle unsere Top-Angebote Dell todas nuestras mejores ofertas Dell alle vores bedste tilbud Dell...

I have main form based on a table, linked to a sub-form based on a junction table. Everything is working pretty well except: The PK of the junction table is...

Hi Everyone There is something i am missing here. I have a sub form on a main form. I have set the combo on the main to filter the combo on the sub form and...