Recent content by breadcrumbtrail

Hi there! I have a form that is used to enter data to a table. It is a form that was created by the Access wizard, so there is no command button to add the record to the table. Basically, what I'm trying to do, as the subject suggests, is that everytime a record gets added to the table through...

I'm really not confident enough with my ability in access or as a programmer to design one from scratch, and with the timescale available, its going to be very difficult. If there is anyway to define a password from the switchboard manager, then I will glady use that over desigining a whole new...

Hi, thanks for your reply. I have created my switchboard using switchboard manager. And I'm a complete Access n00b, so I'm a bit slow on the uptake when it comes to all this... When I right click on Switchboard in my forms list, and go to design view, there are a number of buttons and no text...

Hi there! Is it possible for me to request a username and/or password before a user can click on a certain button in an access database? The reason being I have been assigned to create an end-user database, but have buttons regarding staff-only actions which I wouldn't want customers using. I...

Hey, thanks for your reply again, sorry about the delay in getting back. Thank you very much for your assistance. Its now finally working! Many Thanks - John

I've looked in the tables, and there are currently 3 questions, 1 unanswered. If I expand the unanswered question, the relationship to the answer table is displayed, with every field empty apart from Answer ID which has (AutoNumber). Would this count as a result when running the query? I'm...

Ah ok, I see. But still, when I try this out, no records are returned. I'm still not understanding how Question ID in the Answer table could be null. Sorry, I am a complete newbie when it comes to access, I really appreciate your help. Many Thanks, - John

Thank you! Yes, my form was set to data entry, i've changed that now and its all working. Thanks very much, you've saved me a huge headache! Many Thanks, - John

Hi, thanks for your help. When I do this, and run the query, it simply presents me with the response (autonumber) in both columns, and that is it. The tables are populated with answered and unanswered questions, so there should be at least one record being shown. The answer ID that you...

Yes, but when I try to run the query, it says it needs the Office CD as the component is not installed. So i'm really looking to do it manually, even though it is harder and I don't really understand it! Thanks for your help anyway. - John

I've created the link through the switchboard manager, i'm not even sure how to pull up the actual macro or code. On switchboard manager, the particular item has the properties Open form in add mode, and then the Answer Question form to open, which as far as I can tell is correct.

Hi, Yeah, I searched for some help on this subject on google and that wizard was mentioned, but it doesn't appear to be installed on my version of Office (which is 2000 by the way) and I have no idea where my original disk has gone! Thanks for the suggestion though. - John

Hi, thanks for your reply! I'm finding it a bit difficult to understand the last paragraph, i'm not too fluent in Access. Which field should I search for for answers equal to null? In the Questions table, I have the fields 'ID', 'Product ID' and 'answered', and in the answers table, I have 'ID'...

Hi, thanks for your reply! Record Source has the table name "Questions", which is correct. I'll put in a bit more detail about the form to see if that helps. The form itself refers to 2 tables, "Questions" and "Answers". When the form is opened (in database view at least), a particular record...

Hi, I'm perplexed. I have a form designed to access a certain table, which it does absolutely fine when I'm looking at it in the database view (if thats the correct term... I mean where the objects are listed down the left, 'tables' 'queries' 'forms' etc.). Seeing that it worked, I linked it in...