123

the msgbox hides behind other forms . and doesnt show up in the front. can
anyone help?

I'm new to access and could use some help.  I'm importing data into an access
table.  the TXT file displays the date as 032807 however when it is imported
into access I want it to display in the table as 03/28/07.  I have the Imput
Mask set in the table as "mm"/"dd"/"yy" however ...

I have a table of data and want to SUM() a column of values but based
on the values in another column:
Val1    Val2
1          2

I have a database and was wondering if it was possible to disable the
user from deleting anything at all or any objects whatsoever from the
database.
Maybe if the database requires a password to delete objects, or

I know you can convert a number into a monthname easily or a full date
into a name easily but can you convert text like Aug, Sep etc back to
8,9?
The reason I want to do this is because I want to show Aug 2006, Sep

Here's what I have:  \\lavaur4\PHIWEBEurope\SWAN_Swissco\Default.htm: 754
And here's what I'm trying to get back:  Swissco\Default.htm
The number of characters from the left will always be the same, 28.  And the
string will always be trimmed after the ":" (colon).  

I am struggling to animate GIF files in access. Anyone Help

I have an excel spreadsheet where I have a lot of values in coloumn A.
I want to split this into A and B. ( like a snake )
Coloumn A have: 1000, 1001, 1002, 1003 etc
I want to have A: 1000, B: 1001, A: 1002, B: 1003 etc

This maybe a bit of a long shot but last year I downloaded via a link on the
forum a bit of access software that listed all my pronters in a list box and
then allowed me to select a printer from it and set it as default.  Does
anyone know where I might have got this from?  I have ...

I am a new user
What are the usability issues for new users in using Microsoft Access

I am definitely the administrator  The 'me' sttement tells me so.  So why do
I get something like 'you do not have permission to perform this operation?
dennis

OK, every post I've seen on this error has involved apostrophes, but mine
doesn't.  I am using a combo box to look up members and the bound colum is an
autonumber field, so no special characters!
On de-bug I mouse over the cboFindmember in the code and it says

i wrote expression in query and i work fine.
when i import this  query to another (but the same) application
it gives me the error statment above.
what can be the reason ?

what is the way to aforce commit in that situation?
strSQL = "insert into invoice (Invoice_Num,Supplier_Id)
strSQL = strSQL & " values (" & Me.Invoice_Num & " , " & Me.Supplier_Id & ")
dbs.execute strSQL, dbFailOnError