Hi I have a memo field which some time has a fair few note in it. I use the following to date stamp it Me.Comments4 = Comments4 & " " & Now() & "...

I'm using Access 2003. I developed a form that is designed simply to let you input a name into a table. That function works fine. Problem is, I would like...

I made Expression in form to make Calaulated bound for one feild..But after this I could not bind the result to relevant feild. What Should I do?

I have a form sourced from a linked table. I entered a subform sourced from the database using the wizzard. Everthing works great until I put data in the...

I have the following code on a form Private Sub cboSearchDonor_AfterUpdate() Dim strWhere As String Const strcStub = "SELECT * FROM...

My form is used for entering records. When a user clicks a button to submit one, I want a pop-up box to load up saying "Would you like to enter another...

I would like to make an invoice form in which, when loaded, it calculates prices. For example, the user has entered the number of products into a table and...

I have an embedded form that holds two types of records, closed (=1) or open (=2). I need a filter to display either closed, open or both. The ApplyFilter...

Hi, I have a special kind of key that is : I wanna prevent duplicate value for my key .in addition I wanna allow null values too. so I couldn't use a unique...

Hiya, What I require to do is have a email button on my frmDetails so that when a user clicks on it it composes an email which sends to the email address...

We are offering our Microsoft Access Library management & membership database 'LIBRARY SOLUTIONS' FREE of charge. To download, please visit our website...

I run A2K and created a s'board using the 'wizard'. The 3rd option label from the top of the s'board is hooked up to a 'macro1' which proceeds to run some...

Version of Access used: 2003 Hi Is it possible to make a form look different through opening it using different ways? For example could one choose to make...

I have a main form with a subform and I would like to ensure that the end user can not hide or unhide the columns in the subform. Is there a way to disable...

Hi, I have a database in Access 2003 split into a front and back-end. On the opening form of the front-end, there is a tab control that has an unbound...

Sadly, I am forced to use Access 2000, so my question applies to this version. Having deleted the label which is associated with a text/combo box, how do I...

When a form opens I want it to automatically open to a blank form so that the user doesn't have to click the add record button. How do I do that? -- diesel

I have a table called tblDeptVisits with a fields ID, Dept, Service, VisitingDate, Visiting Time. I have a form where the user just has to press a command...

In the Northwind sample database they have an Invoice qry that includes multiple tables all linked together. When I try to link more than 2 tables though my...

I used the advise from this forum to force new data entry at the top of a form. I created 2 subforms - one set to single record, New Data Entry=Yes for...