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!

Recent content by KristieLee1

  1. KristieLee1

    Remove formatting from blank cells

    As text. Here's the code: SELECT Cremains_Table.Gender, Cremains_Table.BirthMonth, Cremains_Table.BirthDay, Cremains_Table.BirthYear, [BirthMonth] & "/" & [BirthDay] & "/" & [BirthYear] AS DOB FROM Cremains_Table; The the month, day, and year of the dob are in their own columns, so I've put...
  2. KristieLee1

    Remove formatting from blank cells

    Hello. How do I remove date formatting from cells that are blank? I have date of birth, formatted as mm/dd/yyyy. If the dob is blank, then the / / marks are still showing up. Anyone know how I can remove the / / from those folks that have no dob? Thank you!!!
  3. KristieLee1

    What does it mean when queries are 'grayed' out?

    ahhh, ic. thank you.
  4. KristieLee1

    What does it mean when queries are 'grayed' out?

    Hi. I have this list of queries from a db that I didn't create, but that I have to modify. I was wondering if anyone can tell me why the icon appears grayed out? One is not, but the rest are. Thanks as always! I'd have attached a pic, but can't figure out how to :(
  5. KristieLee1

    Can't access database objects from view dropdown menu

    I saw the switchboard. We got it figured out though. Its under the tools menu, startup, and check the display database window option. Unchecked, you get nothing, checked, you get the database objects. Thanks!!
  6. KristieLee1

    Can't access database objects from view dropdown menu

    Tried that, sorry, I should have specified that :(
  7. KristieLee1

    Can't access database objects from view dropdown menu

    Hi. Anyone know why I'd be able to see this option in all my other databases, except one? Is there a setting or code that prohibits this option? I am not the database owner, but am trying to troubleshoot it. I can not see any of the tables, queries, forms, reports, modules, or macros. The...
  8. KristieLee1

    Cant find the macro to show the forms command button error

    Ya know, now that I check the group, it appears I've posted it in the wrong one! My apologies...it is vba. which brings up a good point, whats the difference between vb.net and vba?
  9. KristieLee1

    Can't find the macro to show the forms button error

    Not split, everyone accesses it from the same location. User has full access rights. Access 2000, all on the same version.
  10. KristieLee1

    Cant find the macro to show the forms command button error

    I'm getting this error when ONE user tries to open this database. All other users can open with no issues. I've never seen this before. Anyone have any ideas on this? Thank you!
  11. KristieLee1

    Can't find the macro to show the forms button error

    I've never seen this before. All of our users can access the db, except one. I'm having trouble finding any decent info on the net. Can anyone give me some clues as to why this is happening? Thank you!
  12. KristieLee1

    Access Queries and Drop Downs

    thats what I figured. I was hoping to be able to create them in access, but I'm guessing it'll have to be done in excel. Thank you!
  13. KristieLee1

    Access Queries and Drop Downs

    Hello. I am working on a 'report' in access that will be exported to excel. The end users do not have access, hence the excel medium. I'm trying to create as much as I can in access. So, I have 30 columns of information. Each column will need a drop down box for the user to select an...
  14. KristieLee1

    Adding a column that doesn't exist in the table, to the query

    SWEET!!! I just did it. Thank you very much for your fast response. I appreciate it!!! :)
  15. KristieLee1

    Adding a column that doesn't exist in the table, to the query

    I can add it that way to the query? I can not modify the table structure.
See more

Part and Inventory Search

Back
Top