My NotInList combo works almost perfectly (no error message) except that the
record stored in the table is weird.
My NotInList code is :
  Private Sub cboScoreBand_NotInList(NewData As String, Response As Integer)

I am using Access 2003 on Windows XP machines.
I have a button that opens a form.  When I put the database (.mdb) file on
my coworker's machine, she clicks the button and the form is NOT full size,
i.e. there are scroll bars and she has to manually resize the window every

I am monitoring a sales incentive program at work, and I have to create a
spreadsheet with quarterly sales from last year, quarterly sales from this
year, and a percent increase/decrease for each state. I am using this formula
for the % Change field with I2 being 1st Qtr 2008 ...

I have this code which is for a button on a form with just one unbound text
box.  The idea is that the user types in a name of a client and this name is
added to the table.  Here is the code:
Private Sub Add_Click()

By using a command button on a certain form I am oppenig an other form at a
cetain record by using some criteria.  I am using the command button wizard
to do that.  When the form oppens however, I want to be able to move to other
records of the form record source. Is there an ...

I am trying to implement the following code but cannot get it to compile. It
errors on the line lst.AddItem varItem with the message Compile Error: Method
or data member not found.
Public Function ListFiles(strPath As String, _

I need to assign a formula to a string variable and then use the string
variable in my code as though it were the formula itself.
I've found reference to the .Formula Method for some applications, which
seems to be what i want to do.  But this Method doesn't seem to apply in

I have an Access 2000 database that has numerous forms.  Is there Access  
program or script that will display every form and the tables and columns the
form uses?
Please help me with this issue.

I have a vba code to print file to default printer.  It works great to all
printer installed in my window XP except "adobe pdf" printer.  It pops up a
dialog box and ask for file name.  Does anyone know how to suppress the
dialog box and provide the file name via vba?  Please ...

I cannot find how to prevent a message to be displayed when I try to insert
a record with the following command:
DoCmd.RunSQL strSql, UseTransaction:=False
Would anyone know some way to bypass the alert message?

I am trying to make a public sub that advances to the next record in a
subform. In the following code, I get the error "method not available" on the
"application..." line.
The function to check if the record is the last is working fine.

I have a mainform CashSales (TransactionDate as short date) and subform
CashSalesDetails (stockid, unitprice) bound to their respective tables. I
have also a SalesPriceList table (SalesPriceListID,
StockID,StockName,StartDate and UnitPrice) where a stock can have many prices

I'm trying to put a SQL statement into VBA using a string variable.  The
variable will only hold 256 characters of my SQL statement, so it's chopping
it off.  I know I can work around this in several ways, but does anybody know
why a string variable will only hold 256 characters?

I have 2 questions i need help with
1) How can i get code to run as soon as the database opens, is there an open
datase base event? I know how to get a macro to run i.e. by making it
autoexec but not code in a module

Here's the mystery:
I have code that creates a series of worksheets in an Excel Workbook, one
for each of a team of employees.  The code typically creates 5-6 worksheets
for employees that are specified by the db user.  For about 1/2 of the db