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...
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...
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>
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...
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...
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...
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...
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 "The original designation of cores of apples per Motorola"?
I'm afraid I don't know much about computer hardware, but Tek-Tips has helped me solve a lot of...
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...
What data type is your Quarto field? If it's a text field then you need quotes around the 102.
"SELECT * FROM Hospede WHERE Hospede.Quarto='102'"
Maq [americanflag]
<insert witty signature here>
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>
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...
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 "Allow Full Menus" option in the...
I really think all you have to do is disable the F11 key, like I explained earlier.
I just tried to "break into" 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...
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...
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...
Hi Paul,
Thanks for the suggestion, but it didn't work. I get "undefined function Round". (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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.