Search results

it is ok got it working! Thanks

Hi there, I am trying to put a condition on a find student button so that tutors can only find a student to add to a record if the record is a blank one. The easiest way to do this is to write an if statement to check if there is a studentid in the record. If there is a studentID in the record...

I have also tried the following code: Conn.Execute ("INSERT INTO tbl_Student SELECT * FROM tbl_Student_Test IN 'F:\ASK_Database_v7_be.accdb' ") But this brings up the error message 'object required'

Thanks for replying. How do I do the link part? Do I open the ASK_DATABASE right click tbl_student - import and try to link to the student table in my search database? Or should I be using the linked manager? This is a greyed out option you see.

Hi there I have a search form which works as follows: User types in a studentid and a list box refreshes and displays any matches What I need to do now is on double-clicking a match, I want that record to be copied to table tbl_student in a database called ‘Ask_dbase’. The student table fields...

The users that are using the database are academic tutors so they use it to record notes on the tutorials they have given to students. This is why they are on the form for sometimes 15 mins or longer. The reason for an autosave is because there have been some network connection problems which...

that is a good idea. Any idea how to achieve that? :)

Hi further to my original post, I decided to just put a save button on the form and explained to the users that this was available to click at any time to save the record. Some of the users would prefer an autosave, rather than having to click the button to save. One part of filling out a...

This code is exactly what I am looking for but I want to put it behind a button as opposed to the actual textbox. How can I edit the code for this? Thanks Kate

Hi there, I have a database with a form to record tutorial notes. I have autocorrect on a memo box but users seem to use the general spell check button from the main menu then wonder why this goes through all the records and checks the spelling. Is there a way to get the spell checker to just...

Hi there, I have a form in a database with a button. On clicking that button I want another database file to open. Any ideas how I can do this? Thanks Kate :)

Thanks for replying. I had a button on the form 'filter by tutor' . This then changes the listbox to show only that particular tutors records in. I wrote a simple IF condition around this and it is working!

Hi there, I have a tutorial history form which allows tutors to view their tutorials and delete any that were created in error. The trouble is, at the moment my delete code allows users to delete any tutor records when really it should just be there own. If MsgBox("Are you sure you want...

I am trying to connect to an oracle view which interfaces with an oracle database.

Thanks for replying and taking the time to look at this for me. Still no luck my side, tried to look at the reference list but this didn't make a difference.

sorry that doesn't have the module in. Another attached.

Just imported everything into a new database. Attached

Attached is the database, for obvious reasons I have put test instead of the password and username so you can see the error message. I open frm_JupiterSearch, enter a six digit number and hit 'SEARCH' this calls the connection and then this is when the error message appears, it is an ok type...

Thanks for replying. This code works fine in 2003 but the minute I try to run it in 2007 it brings up that particular error message.

Hi guys, I am trying to pull data from a database to another database through an oracle view. How can I change the code I am using for the transfer process to work with ADO?. The reason for this is because we have moved from access 2003 to 2007!