My database is for conference registration.  I have just learned how to write
the code and call the procedure to calculate the registration fee based on 3
variables.  Now I want to do the same thing for the preconference fee but it
does not work and I get an error message saying ...

I have a general question and wasn't sure which area to place it.  In an mdb
that I am working on I will have 2 separate groups using the same app.  The
app is tracking clients.  Group 1 does the implementation and enters the
initial record for each client in all areas.  So each ...

I came across a problem that I have set the sub form to addnew and continuous
form, however when entering data in the subform and reaching the last field
the next tab takes me to the beginning of the line I just typed ( I checked
the sub record and it gets written). I really want ...

I am trying to give an option for the user to send an e-mail thorugh a form.
To send the mail I am using a code which is very familiar to the
sbSendMessage sub given by msdn (can be found at
http://msdn.microsoft.com/library/default ...

I need to calculate the days between two date fields and display it in a
text box.  I doesn't have to be in days.  Can be in years, months, weeks,
days format.  Anyone have any code for this?
Thanks!

Is there a way to find by vba what is the system (win xp) Default input
Language  ?
and also is there a way to change it from access ?
Tnx, Eyal

I have a check box with a label in a form. All I want to do is to keep the
label text consistent with the checkbox state. (Say label should say
"checked" if the checkbox is checked and "unchecked" if it is unchecked).
I've put code in the Form's CURRENT function and the check ...

Is it possible to stop a query being run other than being run via a button
on a form.  I have a query that only returns the correct result if certain
dates are entered via a form.
Thanks, Rob

I have 3 labels that I refer to individually using VB. But then I discovered
that labels can grouped together so I grouped the 3 labels into one stack.
Consequently though, I discovered that once they're grouped the properties
for the group are different.

Suppose i have a combo box for every column on a form (say 5-6 combo boxes)
which filter the records acording to combo box values. I tried to methods 1.
use comboobox values as filters and use "form.filter" property and 2. use
these values in SQL statement as where clause and ...

I just took this code over and tried to make changes, but it's not working.
Scenario: I'm on a blank form with a company name drop down.  I pick a
company name from the drop-down and the first record populates the form and
the label reflects the company name.  I now decide to pick ...

I have a simple form that takes a date and on clicking the OK button passes
this to a query which is then run (the button simply opens the query).
1. I'd like to either close the form immediately the query has run or;
2. leave the query open and if the date is charged on the form ...

I would like to set a textbox forecolour and backcolour in a report. This is
easy enough by using the property settings in design view for the report but
this is not the way I would like to do it.
If possible I would like to open a form, frmSetUp, and would like to two

First let me give the create to Luke Chung  for this code.
I was checking out this website (http://www.fmsinc.com/tpapers/queries/)
when I saw this code and I wanted to use it.  The question I have is on the…
…Debug.Print part.  He said it would display in the immediate window.  Is ...

I have two forms
1) text box (txToteLkUp) on it, once populated with search criteria the user
clicks the text box and opens:
2) form )fmQry) with list box.  This listbox Row Source is a query