Search results for query: *

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

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!!!

ahhh, ic. thank you.

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 :(

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!!

Tried that, sorry, I should have specified that :(

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

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?

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

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!

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!

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!

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

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

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

Greetings all. Hope this is the right spot for my question. I am creating a query in access off of one table. The table I am using does not contain the required code of AB01. This code should appear on all rows of returned data. I am not allowed to add this code directly to the Access...

Hi. I'm wondering if there is an easy way to identify the items that are mismatched. The error 'data type mismatch' is vague. I know what it means, just don't know which items to check first in my query. I'm looking for general ideas, or tips/tricks that this super user community might have...

I suppose I should have specified that I'm being forced to use the ancient Word 02 :(

GREAT idea Skip! I can always count on you for results. Thank you!

PS...can't figure out how to attach a pic or file to this post. Sorry :(