Search results

Oh that is bad... lol good... but bad..:D

... Osama Bin Laden, Hide-and-Seek Champion (2001 - 2011)

Firstly, the variables that hold the 2 values... if it were me, I would make them arrays. qrycurrent(2) That way you have a "location" in the array for each value, make seperating the values easier in my opinion. Also, let me pose a question. are there only ever 2 records in this table that you...

This woman decides to buy a self-assembly cupboard. Back home she reads the instructions carefully and assembles the cupboard in the bedroom. It looks really neat. Then, a train passes and the whole cupboard collapses. Not daunted by this she re-reads the instructions and reassembles the...

Re: There are 10 kinds of people.......... Too true... I might as well embrace it... I'm going to get a Binary clock for my desk... i'm sure the office people will appreciate that i'm as nerdy as they all think. Has anyone seen these things???? For the nerds...

Data Analyst..... BORING! LOL Senior Dossier Analyst.. Sounds WAY Fancy.. and it's still kinda correct

Re: There are 10 kinds of people.......... wouldn't 11 be 3??? hmmm.... maybe thats the joke... ? lol but then the "writer" of the joke looks silly... oh man, explaining jokes really doesn't help it much does it? hahaha ok well my vote is for the "10" variant

Nothing like a good limerick for a chuckle. I figure some people must know some good ones! I'll get things started: There once was a man from Japan whose limericks just wouldn't scan. When asked why this was, he answered, "Because I always cram as many syllables into the last line as I possibly...

What about Senior Administrator of Data Managment Senior Administration And Database managment Officer Senior Data Administration Officer Senior Database Administrator I'm a GIS/Database Specialist Though some days I feel like a "Stare at the screen aimlessly while my brain explodes....specialist"

A student, are you taking any classes in data management? or do you have a personal interest in databases such as Access?

I never had the good fortune to be helped by David in any of my posts, but that isn't to say I didn't learn anything from him. I remember seeing his name pop up many times while searching the site for solutions to problems. As i recall his advice was usually straight forward, and he seemed to be...

The lock file occures every time any user opens the database. It essentially prevents Any user from making changes to the design of the database. It is the cause of your error. if no user has the database open, the lock file should be automatically deleted. You can try this out. Make a new...

Where the database is stored, is there also a lock file in that folder when the database is NOT opened by anyone? it will have the same name as the database with a .ldb file extension. If there is one, try and delete it

My first question (which i think I already know the answer to) is do you use a front end/back end split database? If you have multiple users working on a database (Even a database with only one form and one table) You should have the Backend database on the server, and a front end database on...

To remove duplication of values in a combobox make sure your RowSource for that combobox starts with "SELECT DISTINCT" Is you only see SELECT and then blah blah blah... just add DISTINCT after the word SELECT and that should fix that issue.

It's because it's a bound combobox. I have read documents in the past in which people advise against Comboboxes on the design of the table, and furthermore advise against setting the row source on the table design. If you create unbound comboboxes on your form, and set up their row sources the...

Be sure to post an update, I'm curious to know the results of your testing.

These are bound combo boxes?? In your table design you have set them as combobox and set the row source there???? Also, do you use the requery function at all on your form?????

So what happens when 2 people add new records ?? I assume you have a Primary key.. what if they each use the same key?

Then I would simply have a table of answers.. with question ID, Person ID and Answer... Then an answer key table with a question ID that links to the question ID in the answer table.. and the correct answer. When you query out all the answers for person ID 1 (lets just say) Then you can link to...