Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ErnNJ
  • Order by date
  1. ErnNJ

    apostrophe in Excel cells after Export

    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
  2. ErnNJ

    apostrophe in Excel cells after Export

    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.
  3. ErnNJ

    Close Access in Code

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

    Close Access in Code

    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.
  5. ErnNJ

    Button Back Colors

    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.
  6. ErnNJ

    Button Back Colors

    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...
  7. ErnNJ

    Button Back Colors

    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.
  8. ErnNJ

    Password to view a table, run the Queries or reports?

    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...
  9. ErnNJ

    form mouse events

    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...
  10. ErnNJ

    count

    ...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: Count(*) (Count_Of_Fields is the label that will appear at the top of the result query in that column.) in the next column select the field you want the...
  11. ErnNJ

    count

    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]...
  12. ErnNJ

    Input Mask Violation Message

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

    Input Mask Violation Message

    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.
  14. ErnNJ

    Input Mask Violation Message

    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...
  15. ErnNJ

    Insert record at top of Datasheet.

    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.
  16. ErnNJ

    Search options

    Does anyone have suggestions for creating a find function on a form that doesn't involve DAO. I cannot get the Jet database engine on my computer and I have been designing everything with VBA and docmd stuff. My boss wants a form that searches for a record using a customer number field. The...
  17. ErnNJ

    Leading zeros in a field

    How embarrassingly easy. I was under the impression that Format referred only to the type of data (number, integer). That's what happens when you assume. Thanks again.
  18. ErnNJ

    Leading zeros in a field

    Does any one know a way to put leading zeros in a field automatically? My employer wants a customer number field that is 8 numbers long and shows the zeros for empty spaces ( 00000001 ). I'm pretty sure I could figure a way to do it with VBA but I would rather put in the table design for...
  19. ErnNJ

    center mouse scrolling records

    Is there a way to stop the scroll button from scrolling through active records on a form? I have a form with fields bound to a table that I want to use for updating only one record at a time. I took off the navigation buttons and the scroll button still scrolls through the records.
  20. ErnNJ

    date function on form

    Thanks Hare, I have text box on my form and the record source is a field named Month. I cant believe that would take away the month function from the Date object. I have a lot to learn.

Part and Inventory Search

Back
Top