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

  1. Maquis

    Typically British versus typically American given names

    Here's a name to add to the list...."Hermione". I've heard it's a common name in the UK, but as an American, I had never seen this name at all before picking up a Harry Potter book. At first, I thought the author had made up a unique name for the character. As i was reading the books, I had no...
  2. Maquis

    Creating an "if...then...else" in Query

    Thank you! It worked perfectly! It's embarassing how much I've forgotten. Maq [americanflag] <insert witty signature here>
  3. Maquis

    Creating an &quot;if...then...else&quot; in Query

    Hi everyone. It's been several years now since I've used Access and I've forgotten almost everything I used to know about database design. I'm trying to create a very simple database to track some statistics and I've run into a block that I hope is simple for most of you. I have a table...
  4. Maquis

    Snicker Stickers...

    This was the funniest one I've seen in awhile. "BUCKLE UP! It makes it harder for the aliens to suck you out of your car!" Maq [americanflag] <insert witty signature here>
  5. Maquis

    Mega Super Ultra Goods

    Well there's always Helluva Good Dips Maq [americanflag] <insert witty signature here>
  6. Maquis

    Poor grammar limits your job choices

    Perhaps the real question then is this: Which salad would you purchase? Orange Bliss: This salad made only at Joe's Restaurant always contains the freshest most delicious oranges you've ever eaten. The lettuce is always crisp, the almonds are great, but the apples included in the salad are...
  7. Maquis

    Poor grammar limits your job choices

    I'm relatively new to this forum, however I believe grammar and spelling are very important in the workplace. You are referring to someone's speaking ability, however I deal more with writing and spelling abilities. We had a programmer in our department years ago. This guy had no contact with...
  8. Maquis

    How do you lock all form controls?

    I don't have the syntax for looping through each control on the form off the top of my head, but basically you want to go through and set the properties for each textbox, combobox and listbox. Me!controlname.locked = True Me!controlname.enabled = false Maq [americanflag] <insert witty...
  9. Maquis

    Run Access report but suppress print

    Well, generally reports aren't used for updating purposes. They are meant to print data. If all you want to do is update a table, then I would suggest creating a query to do this. That way whenever you just want to update, run the query instead. If you want a report and update, run the...
  10. Maquis

    Original Apple Cores - Trivia Question

    Hi There, I'm currently working on a trivia contest and I'm hoping someone in this forum can help me. The trivia question is &quot;The original designation of cores of apples per Motorola&quot;? I'm afraid I don't know much about computer hardware, but Tek-Tips has helped me solve a lot of...
  11. Maquis

    UNIX - which OS

    That's just what I needed. Thank you! Maq [americanflag] <insert witty signature here>
  12. Maquis

    UNIX - which OS

    Hi there, I'm a total UNIX newbie with what I hope is a simple question. What is the command to determine which operating system I'm running on? We are currently on HP 11.0, however our system had massive problems last night and I suspect that sometime during the mess we switched to a...
  13. Maquis

    RecordSet Problem - Mismatch error

    What data type is your Quarto field? If it's a text field then you need quotes around the 102. &quot;SELECT * FROM Hospede WHERE Hospede.Quarto='102'&quot; Maq [americanflag] <insert witty signature here>
  14. Maquis

    Problem disabling the Shift F11 keys

    Wow! [surprise] Thanks for the research Rick! Matf, I'm sorry for doubting you. I've never seen this behavior before. I've since tried a few more times to duplicate it in Access 97, and I can't. Remind me never to upgrade! Maq [americanflag] <insert witty signature here>
  15. Maquis

    Problem disabling the Shift F11 keys

    I'm glad you found something that works for you. Rick, please post back after you have a chance to try Matt's trick in Access 2000. You've got me curious now. As far as preventing users from looking or updating your data, you'll have to implement Access security for that. I can't advise...
  16. Maquis

    Problem disabling the Shift F11 keys

    I've already done that. I have the shift key disabled in my databases, so it doesn't matter whether I hold it down or not. It just won't work. When I launch one of my locked databases, I don't get full menus (This is because I have unchecked the &quot;Allow Full Menus&quot; option in the...
  17. Maquis

    Problem disabling the Shift F11 keys

    I really think all you have to do is disable the F11 key, like I explained earlier. I just tried to &quot;break into&quot; one of my databases that I have locked down and neither F11 nor shift-F11 bring up any menus. You said you unchecked everything in the start up menu. Did you also uncheck...
  18. Maquis

    Problem disabling the Shift F11 keys

    Matf, I think you're mixing up 2 different database functions. 1. Entering a database with the shift key. 2. Pressing F11. The first one is basically opening a database while holding down the shift key. This will bypass the start up options and go straight to the database window. The...
  19. Maquis

    Display as a percent

    Ok, never mind. I've found a solution that works. I just simplied the formula a bit and now everything displays fine. Group Info:(100-[Form1])/100 I could have sworn I had tried this before and gotten errors on the Null values, but I guess I was hallucinating. <Need more coffee> Thanks for...
  20. Maquis

    Display as a percent

    Hi Paul, Thanks for the suggestion, but it didn't work. I get &quot;undefined function Round&quot;. (Um, did I mention I'm using Access 97? Perhaps Round didn't get invented until later in life) Anyways, the error is beside the point. I need to keep this calculation stored as a decimal...

Part and Inventory Search

Back
Top