I've started new job on Access linked to sql server.
The access is realy work slow. one of the "simple things" i've seen is that
almost all the modules and from modules aren't working witn option explicit,
and many of the variants don't have decleration.

I'm trying to delete a file programatically, its set as readonly, I can't
find the fso option to do this can anyone help please?  This is what I've
got upto now.
thanks

I was hoping someone could help me out here with some code.  I need to
take a starting number and an ending number and produce a list of all
the numbers in between.
Ex:

Using MS Office XP on Win XP Pro
I'm using info from a sample program that my prof. was walking us through in my Programming Fundamentals class several years ago.
I set a reference to the "Visual Basic objects and procedures" library (c:\Program Files\Microsoft Visual ...

The LDB.exe only tracks the list of User's computers name.  I need to know
who is logged into my database not just their computer or machine name.
How can I take a persons machine name and find out their user name.
PLEASE HELP!!!!

i have a form, that has a button.  when the button is clicked, a sql
statement is formed.  the onlly part of the sql statement that changes is a
where clause.
i have a date field on the form (medium date format)  this is used to

I am looking to see if I can update a field, based on conditions from 2 tables.
tblCustomers [CustomerID], [Status]
tblBid [BidID], [CustomerID], [BidDate]
I need to run a DateDiff to find out if between Today and BidDate has been

All,
I was hoping that somebody might be able to help me figure out how to correctly reference, the individual rows within a groupheader.
Me.GroupHeader2.BackColor correctly references to right section of the report and changes the background color for that section to White, ...

I have a family photo montage video on dvd, how can I save it on my pc?

In a form view, what is the best approach to locking a record. I'm
anticipating having a toggle box that can be selected.
I'm new to access so any detail on how to approach this is appreciated.

My Access app which ran FINE until yesterday is now throwing a "missing DLL"
error.  The code that is now failinig is in a button that uses the common
dialog control and opens Word to complete mailmerge execution.  It fails at
getobject().  

If a table field is configured to ALLOW zero length strings and NOT ALLOW
nulls, then you would think that a DLOOKUP function that successfully finds
the appropriate record would return the zero length string rather than
convert it to a NULL.  Why the function converts the found ...

Access03/WinXP
I have a very simple query that I need to rework via another query or VBA
that takes multiple records of the same CompanyID and arranges the data into
a single row.

I made all my forms modal to prevent a problem when shutting down the app,
but I know there is a way to get past it. Scenario (much simplified):
Form1: main menu, with button that runs DoCmd.Quit & a button that opens
Form2 (among many other buttons that open other forms)

Hello, I want to set up a "trial" version of my database and therefore only
want the program to open (and load) a maximum of three times. How can I
accomplish this?