FileNum = FreeFile()
N = "C:\SelfAud\ROMStL.mdb"
Open "C:\SelfAud\ROMStL.mdb" For Input As #FileNum
FileLength = LOF(FileNum)

In Access 2003, I could sort on memo fields.  But in Access 2007, when I'm in
a memo field, the sort buttons are disabled.  Is there anything I can do
about this?

I use Access 2000 at work and bought the software to practice at home. The
purchased software lets me use the Count function to know the amount of
records in a table. I use =Count([table name]) and the result is there. When
I use the same method with the same (supposedly)  ...

This is probably not an excel problem and I'm not sure if this is solvable.
I pasted some information into cells but they when I pasted, it included a
typing space at the end of the information, something I don't need.
Is there anyway to get rid of this space?

First, let me say, I have learned a tremendous amount about Access
from everyone on this board.  I wanted to thank everyone because it
has taken my Access abilities to a new high and I love it.
On to my question.. I work for a company with 12 employees.  I am

I run the following append query from a button in a form.
Unfortunatly this query doesn't populate the Table on the first click.
I need to run the query twice. Is there any reason?
Private Sub InsertOrderDetails_Click()

I have an unbound OLE control on a report. How do I by code change the
path/filename that is the source for the control?

I set up a project and have to make weekly changes to it.  I also set up
copies of the file for 2 of my bosses on the community drive so they can
access the report.  But I noticed when I make the changes on my computer,
their files also change!  How do I keep their files from ...

mail test.

This is the Test mail.

this is the test mail

Hi I am a Network Admin (not a programmer) who started creating a Company DB
programs with Access. I want to be proactive and understand why and when I
should consider moving from MS Access to MS SQL. Can somebody tell me what
limitations Access has? When I should be ready move ...

I am trying to read from table (A) which contains sequential data loaded
into access from a flat file.  I am then using VB to copy each set of data
from one recordset to another recordset - I keep getting run-time error 3021
- can anyone advise what is going wrong?

i need help. i just learn Access, using Access 2003.
After create new form and save it with name is sfrm_noname. Then i
right-clicked on it => Properties and checked Hidden.
So, how can i show form to unhide it ?

I have purchased a version of office 07 enterprise, but since I have to
reformat the hard drive on this computer, I was wondering whether I can
install office on the newly formatted hard drive with no problem.
Thanks!