Search results

If you want the form to close after the user has clicked on it ( and thereby clicked off the popup menu ) you could assign a 'close' macro to the form property 'OnClick' rather than assigning it to the popup menu on 'LostFocus'. Alternatively, you could put a submit button on the form that is...

The teacher ID and class ID are different. Each are primary keys in other tables (class.tbl and teacher.tbl)

thanks for the reply, but what i REALLY need to know is if it is possible to create this query! The issues with the structure of the database are a result of the method of data capture used to update the database. I am well aware of these but there is little i can do about them!

hi everyone urgent help needed with creating a query please... I have a table with AutoNumber as primary key. The second column is called ClassID and the third column is called TeacherID. I want to run a select query that finds all records where the ClassID column and TeacherID column match...

Hi everyone, I have no idea what SQL server is! what does it look like?? do you use a management program like Access to create databases in it or is it command line? what does it have to do with using SQL code in Access? If i can use Access well will i be able to manage SQL!? Any help or links...

Hi everyone Is it possible to create a query that prompts the user to enter the search criteria (i can do that bit) to search whether a yes/no tick box has been ticked or not. What does the user enter into the criteria box to find this?? I have tried entering null, not null, true, false, yes...

Good call RCurtin... website helped me sort it James

A record in a table linked to various others has recently been corrupted in my database. When i try to delete the record an error message appears telling me that the 'Search key was not found in any record' and the record will not be deleted. This corrupted record is causing me serious problems...

Fixed It Thanks for the offer of help Keith but i have managed to sort the problem. I created the query using QBE and when i changed the table name to draw data from the crosstab table i simply clicked into its properties and renamed it, which doesn't actually work! all i did to fix the problem...

I have created 6 update queries that take data from 6 different tables (created using crosstab queries) and place it into a single table. I ran each query after i had created it. The first worked fine. However, the next five simply updated the specified fields with the same data from the first...

I was thinking a similar thing myself so began investigating. As far as i can gather, in terms of getting database related jobs, BOTH qualifications and experience are favourable. Although experience is key and carries alot of weight when applying for jobs, you need something, like a...

Thanks for the reply giovi. It is true what you say about front ends becoming web based as i have noticed this in my work place. We have recently purchased a couple of pieces of data management software which store certain data on and off site but they are both accessed through a URL, even the...

Wow! Another great reply Gizmo! You are a fountain of knowledge. I have taken onboard your comments regarding new technologies and market demand for specific skills. This brings me to another point that I have been thinking over for a long time now. If I want to become an IT consultant and move...

Thanks Gizmo, great answer! The reason I asked was that I am currently taking a gap year before university to earn some money and have managed to get a job as a schools data manager. I have created an e-learning system using access and wondered if this is how I would be doing it at university...

Do IT professionals and database developers use Access and VBA to make their databases or do they only use knowledge of SQL and Server 2000 etc?

you must be making an obvious error, like thinking your in Access when actually your in Word

Thanks Keith that would be great. I will try and get an edited replica of it online for you to see by tommorrow. i am unable to put it online now as it contains alot of sensitive data protected by the DPA. im sure you understand. ...Plus it is HUGE in size! James

unfortunately creating a query that way does not work! i have tried it many times. unless the pupilID is already in a record on the grades table you cannot link the PupilID to a Grades record through a query. the reason i need the PupilID to appear in the grades tables even if the student has...

Thats exactly what i have done! the only problem is staff will not always be entering data when a new pupil is added yet i still want the PupilID to appear in the grades tables, even if there are no grades for that pupil. For this to work something MUST be entered in the subform. Consequently i...

All data entry is through user forms as it is done by teachers, not myself.