I would like to add a check mark in a predertimined box while in the form adding a new entry. Is this possible? Or do I have to add the yes no that I set as a...

Thanks for taking the time to read my question. I just got Access 2003 and I am wondering if I can change the colors of the forms. I can change the...

Hi Everybody, I have a form lets say frmForm1 and that form has 10 check boxes. User can select one or many. The data values in these check boxes are 0...

I am trying to print a part of a form that is not part of the table. It is a comment section. Why is it not printing this section of the form? Can it print it...

I want a subform (listing several records) to auto-expand each row to the height required to show all the text in a memo field in that row. I've looked at...

Hello; I created a form with a list box of clients. There are about 50 clients within the list box and when you click on one the rest of the fields in...

Good morning, I've built an "edit record" form. The controls are all unbound, and are prefilled with the existing data using a recordset that's opened from...

I have a database that I use to track my recipes. I have the main table as "Recipes" and a field in that table as "Meat Type". In order to keep...

I want to update a text box that will be different for each record, that is NOT linked to a table in a form. Whenever I am updating each section it shows up on...

I have hit a wall in my thinking – just can not figure out why I am getting an #Error on my subtotal box. I have an Invoice form. Recent tax changes...

How do you limit the records shown on a form to a specific subset? For example, orders placed by a certain employee? If you look at the Northwind sample...

i put this code in my close event of a report: Private Sub Report_Close() Dim msg, style, response As String msg = "Do you want to email this report to John...

I am taking a table from an other data base and using it in a new DB. This table is nothing more than our 70 stores and the 10 regions that each one falls...

Hi I have written below, my IIF expression which is working perfectly, but i would like to make an adjustment to it which I cant quite figure...

Maybe I'm thinking too complicated. I have two records. Personal and medication. both are controlled by booking number. The personal booking number is an...

We have an access form (it is MSAccess 2003), with a normal text field. With Ctrl-C / Ctrl-V I can take the content of this text field and put it anywhere,...

When i enter a new record into my database all the details from the last entered record are visable.. i tried using the refresh button but it doesnt seem to do...

I need to refresh form2 from the form1 and I do not know the syntax. When updating current form the syntax is clear Me.Refresh, but how to refer to another...

I want to update and write whatever calculated on From fileds on the field of a table like tot_ded=ded1+ded2+ded3 all fields are created in table like...

I've read all there is on dlookup but can't find any examples where dlookup has multiple expressions. Example : my db wants to check 1) If two dates(arrive and...