I have  three applications that have a combination of linked and unique tables.
I want to merge all forms, reports, libraries, functions and procedures into
one application and redesign all tables in this single new application.
My thought is to start a new .mdb. Create all tables. ...

I have tried all the code I understand from this newsgroup and nothing seems
to work for me. I am wanting to transfer a select query to Excel format then
open the file in Excel from access. I have a command button that does the
spreadsheet transfer but I don't know enough about ...

Hey all,
 I have a tricky one here...
I'm running an access db that outputs data to excel in different tabs.  
Before it outputs the data, it needs to check to see if a tab exists with a

Hi, looking for a little help.  I'm writing some code in VBA, (database is
Access 2002).  What I want to do is a select statement where I have the
"Where" value set to a variable.  What I'm writing is this:
Dim db As DAO.Database

can anyone please tell me what is wrong with the SQL statement in the
end:
Dim AudID As Integer
Dim audit As String

i am looking to automate the import by link of Outlook contact information.  
Could anyone point me in the right direction to get started.
I would like the app to automatically open the link dialog set in Outlook()
mode so the user simply selects the folder to import.  I also want ...

I am constantly getting a "Compiler error : expected: end of
statement" error on this sql statement i am running in vba. could
anyone please guide me where i am going wrong?
Dim AudID As Integer

For some reason access isn't allowing me to select the last of the month on
my calendar initially. If I select another date, then I can go back and
select the last of the month. Maybe my code isn't right for intializing the
calendar? I want it to be set to the current month and ...

I am linking to an excel table.  When I open the table, all the data is
there.  One of the columns contains the date and time.  When I query the
table, the date column is null.  Does anyone know what is causing this
problem and what could be the solution?

I need some help with an error message I don’t understand.  
I am using the following expression to inport from an Excel spreadsheet
named BS.xls to a table called BS
DoCmd.TransferSpreadsheet acImport, , "BS", "\a path\BS.xls", True

Running Access 2003
I'm trying to loop through all the text boxes of my form to assign my user
defined sub when the dirty event occurs.  Here' what I have so far:
public sub textValue(ctrl as control)

    Hi I have the following code attached to a sub to hide menuitems
DoCmd.ShowToolbar "database", acToolbarNo
CommandBars("Window").Controls("Hide").Visible = False
CommandBars("Window").Controls("Unhide...").Visible = False

I want to create a button in Access that will allow users to browse for and
insert a photo.  I'm using the code below:
Private Sub Photo1_Click()
Photo.SetFocus

I need to calculate the date on a friday occuring before a random date
mentioned. eg.- if the date is 11/29/2007, or even 11/25/2007, i need
a way to get 11/23/2007 as the answer. can anyone help me with the
logic?

I created a field in a query that creates the date 1/1/1900.
 MyDate: #1/1/1900#
But when I paste this data into Excel, it turns it into this:
  2-Jan-00