Is the Advisor CD from Access Advisor Magazine worth the $50?  It is
supposed to have "The best advice, the best ideas, the best how-to, the best
designs, the best explanations, the best tips and tricks, the best
strategies, and the best code"

Hm. If anyone knows the solution to the situation I posed earlier, please let
me know. But here's another workaround that would work (I think).
I have 250 entries, each has a matching picture named primarykey.jpg, (not
that all pictures are actually called primarykey, but that the ...

Hi, I have a database of about 250 entries. Each entry has bitmap or jpg
image embedded that ends up making this database huge. I have the images
seperate also, each jpeg file has the same name already as the primary key
that it is being linked to.

I have on Access 03 mdb application that I would like to call up a separate
Access 03 adp project.  I used the wizard to set up a button to run another
application, but when I try to open it I get a message "improper function".
Can someone help me with this.

having seen the example of the northwind database...
i am trying to build the same program.but with little change .
the order entry form has a sub form order details .
now when i select the name of the company from the order form i want it to filter the respective nsme of ...

I am trying to make a field search these fields and one more called
"Company".  I orginally had the second and third FindFirst lines the same as
the first, but I got a type mismatch error.  The problem is that nothing
happens.  Is this the correct way or should I do something ...

hello..
I have a report that I would like users to have the option to filter if they
would like. I have been reading about using a Pop Up form with Option Groups
that would allow me to do this. I know how to set up the Option Group, but am

I was wondering how i can insert values from the previous record in a form?
This is what the subform must do when a new record is being inserted:
- set the default value for example 3 textboxes
- then when another record with differtent value than the previous one, the

I am tiring to close the switchboard when I open a form. in the event (on
open) I put this code
Private Sub Form_Open(Cancel As Integer)
   DoCmd.Close , "Switchboard", acSaveNo

Is it possible using vba to make the property sheet in a form visible?
Thanks

Hi to all,
Can anyone explain to me why I am getting a compile error on the following
SELECT statement code:
Forms![Copy of frmOwnedProperties].RecordSource = CurrentDb.Execute_

I need to update values in a field in a table on a quarterly basis.  
Currently staff are doing this manually.  I'd like to automate this process
for them by supplying a button on the switchboard that when clicked would
update all the records.  I have tried a hundred combinations ...

I am working on a purchase system. we hope we can keep all PO and other doc.
into the access application.
the doc. can be in word, excel or rich text format. any suggestion how ?
TIA

I have a form and subform in a 1 to many relationship. The main form is
called frmMain and the subfrom is called frmSub. frmMain is linged to tblMain
and has 2 fields, CustomerID as primary key and the second field is
CustomerName.

I would like to create a [Colour] field, that upon exit the text in it will
change to the colour specified in it.
Meaning if the user type Blue in the Colour field, the word blue will be
show in colour blue. And if the value is Red, the word Red will be show in