I have the following:
Const cQuote = ""
Const cQuotePos = ""
Me.Base_Price.DefaultValue = cQuote & Me.Base_Price.Value & cQuote

I have 1 Table "Periods" with 3 fields:
From date     -     To date      -    Period
01/01/2004-  02/02/2004 -       01
03/02/2004-  02/03/2004 -       02 ..........

Good afternoon,
I am using a VBA module to open an Access form and offer several check boxes
to offer a user to select which documents they would like to print, but I
need to know what VBA commands to use that will tell if a check box is

I need to update each record field by field when the field is null or has a
different value.  What is the best code to accomplish this task.  

We have a database that records the ship date and receipt date and we are
trying to disregard weekends and holidays.  The problem is that it only
disregards the first weekend and then the elseif is met and it quits.  If a
transit goes over two weekends (for example, takes 14 ...

I am getting back into Access development and programming and of course I'm
in over my head with no one to turn to.  
I'm creating a database in Access2000 to track an audting function.  The
data will be imported from an outside database on a weekly basis.  Then the

All I am trying to do is to copy a previous record into a new one - more like
prefilling a form based on the values of the previous record.  I added a
command button for that using the wizard and right there is the duplicate
record button.  it works fine.  however, i would need ...

I have an Access 2002 mdb that increases in size about 6-12MB when I use a
particular form that automates a data-entry operation. Highlights of this
operation are:
1) Create two temporary tables (one a subtable of the other) by using VBA to

I'm having some problems and need help.  The line below executes 1 time for
each detail line (creating distribution lines) - there are currently always 3
detail lines.
If PostDistribution(lngPostedTransaction, lngPostedDetail, TmpDetailID) Then

My Access program opens up an Excel workbook and specific worksheet.  I can't
get the Excel workbook to maximize on screen. It appears in the task bar but
it doesn't appear fullscreen or maximized over the Access program.
I've used the excel object in code with ".activate" and

I am trying to use the code below to import a tab delimted file which is
downloaded from our purchasing system. The file I am trying to import has
over 6000 records. The code runs to record 4603 and then stops with the error
Subscript out of range on line:

My problem is this: I have been programming in xBase dialects and
clipper for 15 years and keep putting off getting up to speed on OO
stuff. Anyway, my other, real problem is this:
I need to compare two tables in Access, and write any differences to a

Good afternoon,
I am using a VBA module to open an Access form. Form contains several check
boxes (made is design view, not created by code) to offer a user to select
which documents they would like to print, but

I have a form that i customized to look just like a msgbox.  It has a label
and yes/no command buttons. When I write code that calls this form to open,
how can I:
1) pause the code that called the customized msgbox so that it waits for a

I know very little about Access, but got stuck trying to support it. I
received the following email and have no clue how to help. Any ideas?
Thanks,
Carla