Recent content by ErnNJ

thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you,thank you

When I export a table to Excel I get an apostrophe in all of the cells. I assume this is a transition key but when I go into options/transitions the transition navigation keys box is not checked. How can I stop this? Thanks in advance for any assistance.

Great, thanks Robert. I figured it had to be that easy.

I know how to close an open database in code (Application.CloseCurrentDatabase) but is it possible to close Access as well? My users click on a form shortcut to bring up the DB and I would just like it if my app closed Access from a button on a form instead of just the database. Thanks in advance.

Thanks Sandy, thats a good idea too but I dont really have the time to play around with that kind of stuff now. I tried that and it is relatively easy but I'll save that for when I bring this DB to an interview. Thanks again.

Thanks Terry, Don't mean to rag on MS. It just seems more often than not the line between two points is never a straight line. I guess that's true of any developing. Anyway, the invisible thing is a good idea. To be honest I don't think my employer wants me to spend too much time on this so I...

O.K., why in the world can't you change the back color of buttons. I have used VB6 and done it. Do I have to do something ridiculous like create a custom button? Is it me or does it seem like Microsoft likes to have developers checking into rubber rooms? Thanks in advance for any assistance.

I'm an intermediate developer and maybe there is some way to password protect a table that I am unaware of. But if this helps what I would do is have two copies of your DB and password protect the DB that the supervisors use and for the operators DB, go to the tools menu and under start up...

Why do the form mouse events seem to take so long to respond? For example, if I put some logic on a form_mouse_down event (if button = 1 then msgbox etc.), it only responds occasionally. But if I put the same logic in a control mouse_down event, it responds instantly as it should. Even if there...

"characters found after sql statement" means that you entered something after the ; which is to be the last character of the SQL statement. But to to it with the expression builder... in the first column, instead of selecting a field from the table list, enter Count_Of_Fiels...

Go into SQL view on your query and try this to get the count of rows that have a value: SELECT Count(*) AS [Field Name] FROM Table_Name WHERE [Table_Name].[Field Name]is not null; Then to get specific values try: SELECT Count(*) AS [Field Name] FROM Table_Name WHERE [Table_Name].[Field Name]...

Awesome! Thats exactly what I needed. Many thanks Linda.

Thanks Hare, It is for a form and thats how I have it set up. I figured I might not have to go that route. I was hoping there was some property (like validation text ) I could set to make it easier. Thanx for the help.

Does anyone know a way to change the error message that you get from an input mask violation? I would like to change it to a message box that would specify the field and why it's in error, instead of the message that you get. So I don't have my end users asking me what an input mask is when they...

If you want the datasheet to show the last record that was input make a auto number primary key column, and sort the column in descending order.