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 a
stored proceture [rst.open("exec ...")]

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 things
consistent, "Meat Type" is a dropdown. I've added a button to the main form
beside the "Meat Type" box that says "Add" - I use ...

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 required me to add the ysnTax
box to check if the item was taxable or not taxable.  Previously, I had been

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 database, I have several forms similar in design to their Orders form.
I would like to limit the records you can navigate ...

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 Doe?"

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 into. The table is made up of a list of the stores ( unique) and the
regions for the stores acording to alpha order. I create ...

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 out:
=IIf([Score 9mm]>=135/180,"PASS","FAIL")
What I would like to add to this, is if there is no value entered at all,

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 autonumber, and the medications booking number is just a number.
On my form "Personal" I have a button to open "Meds" How can ...

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, with (at least) one exception: I have a second access form open,
and on it there is a Visual Basic 6 ocx with its own text ...

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 anything, is there any code i can use that when i
start entering a new record into my database the text boxes etc dont

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 form? I tried

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 ded1,ded2,ded3 and tot_ded
please help

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 depart) don't clash for 2) a room in the db,no
double bookingd. Worse even all the fields are on one form, so I'm not

I have a form that sums the total [Balance Due] for all records which
works fine. However i want a seperate total at the bottom which just
totals records from one of the customers ( [Customer ID] field). Can
anyone give me any pointers on how to get this to work please? I have

My Microsoft Works Calendar and Spreadsheets are printing uneven like ocean
waves.  It does not do it with regular documents, just charts and boxes like
calendar.  It is not the printer.  I checked that first.  It use to print
fine.  Now it has run amuck!