Is there a easy way to set a Command button to be disenabled once it has been clicked on and keep it that way until a text box or combo box has been updated?...

Hi, I have a form called Contracts Entry, when I open this form I get anerror message "Field cannot be updated" then a help screen comes up and says the...

I'm not sure if this can even be done, but knowing Access, there is probably a way as it is so awesome... The best & easiest way I can explain what I'm...

Hi All, I have the following dmax on my form in the before insert event: Me!vdrid = Nz(DMax("", "tblNewVendor") + 1 The vdrid field is a text field. After...

Hello, I have a simple database to track my CD collection -- two tables, tbl_Albums and tbl_Artists. Tbl_Artists contains one field, the artist name, and...

I've set up a few option groups on a form using checkboxes. The dataype for the checkboxes is Yes/No. I noticed that when I'm on a new record, the boxes are...

Hi. When I select a row in a list box to filter records on a form and another list box on the form. The records get filtered but I want the selected item in...

I have a calculated control in the detail section of a form with the following formula: =IIf(=0,0,TaxSupport(DFirst("CPP_Rate","tblTaxRates"),)) Key: CPPFlag...

Is it possible to have a small form 6cm x6cm that stays open in the top left corner no matter which form you select. Thanks for any body's help..........Bob

I am new to developing Access 2003 databases (first attempt�) and have encountered a problem using the StartDate and EndDate boxes on my form. Please...

There is a template in the access templates downloads that I was quite impressed with. He has a form tab in a contact management database called "Calls"...

Hello, I need to be able to sort the underlying records by a variable (TableName). I have tried simply going into the table, sorting on that column and...

After executing an "Action" query like "Update", "Insert" or "Delete", the default Access generated message saying "x record going to update" and "x records...

Hi to all Access Experts! I have a Main form with one subform. The subform is bounded to a linked table but i added two unbound fields. My problem is that...

Hi I created an XY (scatter) pivot chart . I would like to put an overlay on the chart by plotting lines at certain locations. I don't seem to be able to do...

I would like to simulate the form that appears when you run the unmatched query wizard. Part way through running the wizard a screen appears with what looks...

**how to make good security in my database i have database put in it password and make all table and form and Report and Module and macro not Visible and...

I currently have combo boxes with code similar to this below in the on click section: If Me! = 0 Then '-- CheckBox is unchecked! Me!.Enabled = True Else...

Hi, I have a form with 2 combos; second combo value list depends on the value of the 1st one. It works fine in single form view. But I want to display data in...

Jeff, I was able to make the subform and this isn't exactly what I am needing. While it does away with the duplication of fields, it doesn't fit the...