I need to set up a MS Access Database that stores test data that was
performed at certain times (rounded to the nearest 15 minutes).  
I need to produce a query that shows each 15 minute interval within a 24
hour period.  Any 15 minute increment that doesn't have test data needs ...

After I split my database into a front end and a backend, I wanted to create
an MDE from the front end for distribution to the client desktops. Yet every
time I run the MDE wizard, the Access crashes. I'm using Access 2002 with
A2000 data format, but even converting the db to ...

I am trying to import an Excel spreadsheet. The headers in the spreadsheet
match the same thing that is in my Access table, name and order. Everytime
I try to import, it gives me an error message. Is there something I am doing
wrong?

Ok, I've read several articles, help files, yadda yadda but I can't seem to
make this work.  What is the proper way to get information from two tables
into one Query or form?

I have FSX Deluxe Edition along with a pc that can run the program at full
capicity.
When I try to get multiplayer share aircraft it wont work. I have switched
hosts and tried every thing that the instructions say to do. Can anyone give

I am trying to send a report using an email address in a DB. I wrote the
following code for it.
Private Sub Reminder_Letter_Command_Click()
On Error GoTo Err_Reminder_Letter_Command_Click

I have a table that has a year field and day field. I only need to convert
the day field which is a Julian date to Gregorian. If possible in a query. If
not then in a module, but, I'm real rusty with access so please give explicit
instructions. I have found some codes but have ...

I took over a database in which the last person created a new table for
everyday worth of data (ie. Feb-21-08 is named 022108).  There are over 100
tables in the single database with the same columns and table attributes, I
would like to combine all of these tables into one where ...

Dear Sirs
How can I do, if I click to open a database, that immidiately my main Form
is opening.
Thanks

Using Access 2000.
Users have restricted access to B/E files in the server based on the VB
Script associated with their UserName. For example USERr 1 has access to
files in dirve Q only, or USER 2 has access to drives Q and R. No problem

I want to get a list of all unresolved references in the code in all modules
of an access database (without having to find a way to execute all code
paths). How do I do this? Thanks.

I have a problem with my query which shows week numbers on a column. Week
numbers derived from date field of table. Column has below string:
WEEK: Format$([Table1].[Date1];'ww')
Above equation gives next week number for Sundays. On my computer date

I have a large group of cells (48) whose format is text, with data that looks
like a date (1-9-01) but is not actually a date. When I use the replace
function to change -9- to -10- it changes the format of the cells from text
to date. How do I keep the replace function from ...

I've imported some data from a spreadsheet and the table looks like this:
tblZipTerritory
ztID (PK)
ZipCode

Trying to change the alignment of dates in a column from right justify
(which is apparently the default) to center. In form view, right-click
the date column > Properties > Text Align > Center.  But this has no
effect.  Must be missing something?  Thanks!