I have a Microsoft Access database with all the research capabilities
of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search

I have 10.0 I need to have 11.0 Object Library in References in VB.  How
do I do this?
Thanks
DS

I have read the previous entries for this subject and I think one is very
close, but I am not sure if all of it applies.
I have an addition only form that I want to use to be able to "goto" specific
records that show up in my combo box.  I have got that to work, if I allow

I have a query that has a date field.  I also have a form that has two
text boxes to enter a date range.  In the criteria section of the query
when I enter the following it returns the expected number of rows:

Is there a way to change/set a reports printer assignments and margins
programmically?  
I have several database  systems that have an Access front end with a SQL
datasource.  When updates are made to the front-end users will copy the file

If you enter data into a form, and then close that form, the data is saved
into the underlying table.
I would like to force the users to use the 'save record' button in order to
save the recird, and have all changes to the record cancelled if the user

I working with an employee time entry database.  I'm entering time week-long
sheets.  As the database is set up now, I open one form, enter the employee
through a drop-down and then enter A date.  I then have to open another form
and enter all of the work for that date, then ...

My code:
Private Sub Command12_Click()
Combo6.SetFocus
Combo6.AddItem , 0 = Val(Text10.Text)

Access 2003: I want to use the Form_Dirty event, but find it is not firing.  
I have checked all the help pages and searched all over the net.
The form IS a bound form.
Any suggestions?

I get a Syntax Error on this code.  It's the last part CDSub >=2.
Any help appreciated.
Thanks
DS

I would like to do a case statement, like the one below
Private Sub cboPersonID_BeforeUpdate(Cancel As Integer)
   Select Case grpSelect.Value    
       Case 1

Access 2000
I've got Form A, which has a combo box with a list of items from Table B.  
The combo box has the focus when I open the form.  If the item I want isn;t
in the list I can use the bottun on the form to open Form B, which allows me

I'm trying to set the value of a field.  TxtTerminalID with this coding
but it's not grabbing the terminalD.
I tried the default Value and the onOpen event, neither works.
Environ("TxtTerminalID")

I'm using Acces 2000.  I have a listbox populated with values from a
lookup table.  (It is part of a form with many other text and
listboxes.)  Multiselect is set to None.
As they are navigating through the whole form, the user is allowed to

I am having a textbox that saves its value in a field on a table.
I am wondering if there is a way that i can detect the entry of two words so
i can save them into two separate fields based on the first and second word
CurrentDb.Execute "UPDATE Values SET [ID] = '" & (first word ...