Thanks in advance.
This is driving me crazy.
All i want to do is
in a datetime fiel of a table of an api sql I want to hard code the default

I have a form that I use in 2 ways in my database.  On this form I have a  
command button used to find clients by last name.  Depending on how the form
is opened, I want the command button to be either visible or invisible.  In
one instance the form is called in order to add a ...

I have a Microsoft Excel 2007 file and I have three columns (1=Code 2=First
3=Last) that I want to import   to my table called Names where I have the
same fields like the Excel file in my Access 2007 database, what code do I
write to import this Excel file?

I have written an Access VB module that, when I try to run it, reports
"Run-time error '2482': Microsoft Office Access can't find the name
'LSAYCollVars_ACIS' you entered in the expression." and highlights the line:
par.Value = Eval(par.Name), which I realize means that the ...

Hi all, I hope I have this in the right place;
I have a table in a database with a simple alpha-numeric text field for
'Location'.
This field will have locations entered in one of 2 possible  types: DLS

With a field set as combo box, the option exists for a "Not In List" event.  
I wrote some code to pop up a message, but when the user closes the message,
the generic access error message also pops up.
How do I stop that from happening?

I am having some trouble trying to automate a table save as.
Currently we import a table everyday and then rename it.
I would like to automate it so we do not have to do that.
Original Name: TC340

I open a connection in an Access module.  I then want to create a recordset
and populate it from a view that I am linked to through Access.  While the
table behind the view is quite large in both fields and records, the view
limits it to the last 2 months and only the 2 fields I ...

I did a logon form with password and usernameI.  have a question how to make
password for the logg on form secured *****?
I have to write some expression to hide the password letter/digits?
Please, help me!

I have a access database and in a table a have french words.
I would like to translate them and store them in another table.
Using the word interface there is the standard option to translate words
from one language to another using the research tab.

can someone help me out with a "Find" problem.
Hereafter you find the code I've written to check wether an article is
already in a table or not.
Therefor I've used the "recordset.Find" object.

I have a question that you may or may not be able to help me with.
I have a database with Autoexec Macro in it (which would run when a user
opens the DB) I dont want to open that particular DB manually. So I have a
script that would open the DB and the macro will run (macro just ...

I have a database that is just an advanced lookup for prices. When a user
enters the part number it launches a new form with the price and the current
inventory. My users aren't familiar with access as a result aren't using the
database. My boss has asked me to add a counter just ...

I received some great help here and I am trying to do a few more things now.  
I have the Access 2007 Bible, which is great, but is doesn’t seem to answer
my questions so I have returned here once again.  Just yesterday I got some
help with the code below (with modifications…which ...

Hi
I have been trying to create a query that will find the duplicates accross
and number of fields to bring back the values that need checking for example.
I have a table with the following fields