Hi  Is there anyway of setting the Default of a field so that if the current
month is < 8  the current year yyyy is entered, else if the current month is

Thanks

I've been through "Tim's" query and 69 Camaro's response for totalling the
number of records returned by a filter, but it didn't work for me. Perhaps my
situation is different enough (or I'm confused enough!) that someone can
advise how to do this.

I have a continuos form with a run query button & a check box to confirm the
query has been run for the record.
What would be the code for automatically checking off the checkbox upon
pushing the query button.

I hope some one can help i have a form thatis used for sales and i have a
total field that has the total of the sales. What i need now is a field where
i can enter the amount the customer gave me and it gives me the change amount
i need to give to the customer. But i want it to ...

I have a database that has two tables: (well, more but they're irrelevant
right now! tblRecord and tblSoftware.
In tblRecord, there is a field fldSoftware that is linked to tblSoftware. I
have set it so that it is a combo box displaying three fields from

Can I open a form in a database from code in another database?
I can open another database with GetObject
Set AccessApp = GetObject("D:\Work Data\access\Employee Frontend.mdb")
AccessApp.Visible = True

Access 2000, 2003
I'm trying to crosstab about 30 columns but the engine returns a partial
result set. I thought the cap was 256 columns? I'm pivoting a number as
column header and the column numbers seem to be automagically arranged in

Is their a way to save and then delete the form recordset so that the record
selector starts at 1 when starting a new batch defined by the user in effect
the record selector is acting as a counter.  When the "counter" reaches "x"
the user clicks on a cmd button to reset the batch ...

I would like to rename several MS Access 97 table fields from code. In
addition, I would like to increase their field size?
How could this be implemented? What are my options?

Feeling very stoopid today; help would be appreciated.
OK, I've a form with inventory information.  What I'm trying to do is code a
loop that allows the user to just enter a certain amount of items, then
preforms that many iterations of the loop which writes a new record into a

I have a main form with a tab strip control containing 3 tabbed pages.
Each tabbed page contains a subform. Each tabbed page contains label controls.
In the footer section of each subform are text box controls with sum
functions used to sum the values in particular rows of the data ...

I am trying to use a generic SQL clause to select a description field from a
table. The problem is that a lot of the descriptions include measurement
values - i.e.  ' is for foot , " is for inches. Some descriptions include
both as follows...

I'm getting an error  #Name? when I wrote a code in four text boxes for
repeat the values. the code for thses boxes are:
Private Sub BatchNo_BeforeUpdate(Cancel As Integer)
Me.BatchNo.DefaultValue = Me.BatchNo.Value

I have a continous form with a combobox on a subform.
The combobox get values from another table.
When I have selected a value from the combobox, I want to refresh or requery
the combobox so

Hello! This is only a question about coding,
how is it possible to calculate the possible combinations between a series
of members?
In addition the total number of the members of each series should not exceed