I have a field in which I would like to record the date a change is made to a record. I have such a time/date field, formatted like this: dd mmm yyyy ...

Hi, I use but I notice that the memo box has a limit when I add more notes each time. I put "after update". Me.Comment = Chr(13) & Chr(10) & Chr(13) &...

I currently hide a combo box using "Check2" on "Form1". "Private Sub Check2_AfterUpdate() Me!.Visible = Me!Check2 End Sub It works fine. How can I hide...

I have built a form (a menu, really) for our construction managers. By pushing a command button area A manager can access his 4 forms, same for area B, C,...

Hi, I have a form from a crosstab query. On that form, I've added some fields to make "on the fly" calculations but they remain blank if one of the values...

I have a form with a field called Proceed (Y/N) I need this field to complete automatically based upon the values in other fields on the form. e.g. if...

Can someone tell me why this expression always returns the same number? =IIf(IsNull(),Null,DMax("txtrefnbr","tblcomplaints")+1) I have the expression in the...

Hello, Istead of making form query for Oustanding Supplier Invoices for Year End 2007, I plan to attached the Grid Query to the reports. My question is...

I'm trying to link one form to another by a reference number which is in both forms. I've used the command button wizard which takes me to the other form but...

Hi All, I worked it out by myself after trail and error using DLookup in a independent control (named it getrate) and then using the setvalue...

I know that there is no connection between the unique ID no and the record number. I have set up a membership data base and use the unique ID No as the...

Hi, need help from u guys, i'm new with access03, i created database which contain table Patient, Case, SurgeryDetails. i''ve created relationship between...

I should know this but I'm brain dead. I want to simply open a form or subform with my onclick control on a command button. Please help a brain dead old man....

Today my database which has been working fine for 10 years quit working. I have tabbed controls of which some are subforms. All of the subforms work fine,...

I have a continuous form that has an on-click macro associated with one of the fields in the form. The macro opens another form based on the data in the...

Hi, need help with what I am sure is a simple problem. I have a form and wish to find records using a combo box. Which I know how to do. The problem is it...

I use MS Access 2003. I would like to create a Purchase Order form that is similar to the one in the sample Northwind Database. The difference in my form...

In my database form I have two combo boxes, one will select warehouse number (for which there are 7). The other combo box I need to update and give me...

I have two separate forms that are based on the same parameter query, frmSOR and frmQuote. I am using the following criteria for the query WHERE...

I have an unbound combo box that I would like to be able to use to auto fill a for when a choice is made in the drop down. Any help would be appreciated --...