I have an excel spreadsheet with a field with the time format  "7:00:00 AM".
When I import this spreadsheet, the value showing in the Import Spreadsheet
Wizard is .29166666667.  Each time value has a different number similar to
this representing the cumulative percentage of the ...

Is it possible to create a combo box within a message box i.e. when
the user clicks on preview report a message box appears and says
"which report do you want to open?" and a combo box displays the
different reports available with the user clicks, upon clicking the

I have a report that I want to transfer to an excel spreadsheet from Access.
I need to make this a macro or vb code on a button on a form, but cant seem
to find a way to do it.  I'd like to use the "Analyize with Excel" button,
but cant see how to use it.  Thanks in advance for ...

I'm fighting an issue with my department's new database that has my
head hurting.
Here's the general layout: we just installed a new medical records
database with a web-based frontend, and a SQL Server backend. I've

In Access 2003 if you changed the name of table it updated the queries
automattically that were associated with that table.  Today I changed the
name of a table in Access 2007 and the query did not update with the new
table name.

when I go into my access database and want to print I have to always remember
to click on selected record for it to print only that page or it will print
the whole database.  How can I set the database to always print only the one
page?

Is it possible to reset the toggle button by pressing another command
button i.e. press Button1 and the toggle button restores to its
original state i.e. not depressed?
Thanks

I'm trying to link two tables in Access...both tables contain the same
fields with YTD totals.  I need to subtract YTD Total between the two,
to determine the difference.  I have the tables linked via 2 fields.
I group by the two fields, and sum on YTD.  It is multiplying the

I created an Access ADP using SQL Server authentication. Now (of
course) whenever the application starts it prompt me for the user name
and password (the desire behavior in my case).  I want to know if I
can create a custom logon form to replace the one that access shows me

I've encountered a puzzling problem.   I'm testing database referential
integrity.   I've read where the program won't permit entry of a record in
the "many" table without a record being entered in the 'one" side table of a
relationship.

Please help.  I would like the Start Date to be automatically entered.
i.e.   SHIP DATE - TOTAL DAYS = START DATE
I can do this with the formula dateAdd("y",[SHIP DATE],[TOTAL DAYS])  and
this works but I need it to exclude weekends (sat / sun).

I am new at this but I downloaded the Issue Tracker template and it works
great but I have renamed it and everything in it. Now when I open it the
Access name changes to Issue Tracker and I get an error message of "The form
name 'Issues' is missspelled or refers to a form that ...

I have a report with a field called "Tasks". The fields Tasks is in the
Detail section of the report. It is grouped by the Client's name.
In that field there are a number of codes that could appear in the field.
"FF" and "EP" are two of them.

I'm trying to launch a process from a Windows service that runs a Microsoft
Access macro.  I'm having some trouble and wondering if anyone knows whether
this is technically possible (since a service does not have a UI).
Thanks in advance.

Here’s my dilemma:
I’ve created a form as my switchboard, which isn’t loading properly.  
Instead of seeing the switchboard form when you open the database, I’m seeing
my report criteria dialog form associated.  When I close this criteria dialog