In a query can I write in the criteria.
Not Like "NONE" And Is Not Null?
None is actually what shows up in the table i.e. item numbers
123456

I have inherited a database with an unbound form with various text
fields. This has always worked fine but since a request was made to
put an option set in - I'm confused (I have always worked with bound
forms in the past). Here is the code. I'm hoping this is really easy

I have an after event that prefills a text box with a factory number that is
on a purchase order (comes from the purchase order table).  However, instead
of the factory number I would like to display the factory name instead of the
factory number.  The factory numbers-names will ...

I am trying to implement the instructions found on Allen Brown's website that
tell how to make a combo box that will navigate to a particular record in
your form.  So I have my combo box but it gets it's information from a query
instead of directly from a form.  This way I can ...

I am interested in creating a form that includes areas in the form that act
similar to the expand and contrast buttons (+/-). The idea is to show or hide
subforms and resize the parent form each time these buttons are clicked.
I have been able to hide subforms, but I am having ...

OK I'm going to try an explain this to the best of my ability. I have
a query where I pull vendor numbers with sub vendor numbers. My report
that runs the query would look like this.
state    vendnum   vend desc     sub vend

I'm using this code with ACC2003/Vista:
Set WordApp = GetObject(, "Word.Application")
               With WordApp
                   .Visible = True

I have a form that prefills dates upon creation. For example the date().
Fills in the date. There is a projected due date on the form =date()+7.  The
initial dates save in the table and I would like when someone reviews the
form that the date in the table is displayed not the ...

When the user enters a date into a text box on a form it should only allow
Todays date or Prior to today.
The form (date text field) is created from the table not a query.
Is there somthing within the form I can do that would Not Allow Future dates?

Hi Groupies
I had an extensive thread about this on March 25 with Jeff Boyce but we
never did get this resolved. Perhaps it can't be done?!?! If you want to
check all the gory details, the thread is Repost: Saved record on other

I have a form which I can link pictures that are previously stored on my
computer, just like Northwind.
But I wonder if I can have a button which I can press, take a picture, and
instantly my pic would be linked to the record I'm on?

I have a table called [all dates], and a combobox called [combo1] on a form
called [frm scheduler wkhc].
I want to populate [combo1] with the fieldnames from [all dates].
At http://www.freevbcode.com/ShowCode.Asp?ID=184 I have found a function

Just looking for other ideas on how people handle this.
I have multiple combo boxes that are based on a query and the client
wants to be able to just type in new values, so I am limiting to the list
and am using OnNotInList to kick off the data entry behind the new

I am using an If..then...elseif statement in the VB editor to determine what
report to print. I am having a problem with the >= And <= part of my
statement. Here is my statement: When I run this statement it will highlight
the  <= part of my statement giving me a complie error of  ...

I am attempting to pull out records that have two fields identical, and
later to be based on a date filter.
The main table is [orders], and the fields I want to check are OPID and OTN
- basically if OPID and OTN are the same in any records, to bring the