I've converted a bound Access 2000 form which displays data retrieved from
an Access 2000 database to an unbound form.  Now my hyperlinks don't work.
I'm assuming it's because the form isn't bound anymore.  I didn't even have
that field's data type as hpyerlink - just test.  I did ...

At work we had a problem with the domain, so we ended up with a new one.
I had a access 2000 database that has user security on it.  Now I can't open
it, it tells me that I don't have nessacry permissions to open it, and that
I should contact the person that created it..that was ...

Is it possible to change table field lookup properties in code?
I've been able to change other field properties in code, however so far
no luck with field lookup properties. What I've done for test purposes
is use a text input file for the table field lookup properties. I

I posted this a few weeks ago. We have tried a few more things. Any
other thoughts?
A client has about 15 workstations, all running an Access 2000
application we wrote for him. Three WinXP workstations have a problem

I  have a form with a  subform.  The latter contains a calculated field,
[TotCost], derived from a query.  In the footer of this subform  is an
unbound text box [FootSum] whose control source = SUM([TotCost]) .  works
fine

i'am working at a project in an ac2000 enviroment. I need a function to
calculate the difference between startt and end-time. I want the reuslt in
the followed format " d  "days and " hh " hours" and "nn" minutes
I the difference is smaller than 24 hours, the format should be "" ...

how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up.  i've been trying to find a way to format the onprint event in the
detail section but i can only change the font size, ...

I have a access based guest book. I want to create a validation rule to
block certain words or parts of a srting. How do i do this?
ie: this is a nice site. come visit my porn site at www.abc.zy
If the message contains the word porn, can I block the whole message

this one has been annoying me and i know it *should* be simple, im
creating a database that has users, and every user will have an
administrator in charge of them, so one user will have one
administrator and an administrator will have many users. The

I'm trying to set up an Option Box in a form to feed a Parameter Query
to be used as a filter. That field I want to filter is a Text field and
has two posible values: "A" and "B". So my Option Box should have three
options: "A" ; "B" : and "A" Or "B" (any). Pretty basic stuff.

I am working on a database for my employer.  I'm not new to Access,
but I haven't done much VBA programming (although I have written some
apps in regular VB).
I am trying to run a query (that takes parameters) from code via a

Is it possible to refresh the SQL of a query in access using VB. The
code i already have takes the text from text boxs on my form then
writes it to a varible called strSQL and turns it into a SQL statment,
that works fine but its just getting the VB to write that String to the

Hi to all,
I have the following problem:
In a database we have put e.g. TIF-Files into OLE-fields. Through the
years, the OLE-Server has  changed, for example from Photopaint 6.0 to

I am trying to save my database as an MDE file but get an error message
saying the following:
"This error is usually associated with compiling a large database into
an MDE file.  Due to the method used to compile the database, a

Is it possible, within Access, to create an update query that replaces
all spaces with underscores for text data in a given field?
I am aware that it can be done by going into Edit -> Replace, but an
update query would be much preferred.