Search results

You must have creted databases before which needed to be populated with dada from another source. I have a database with three tables. People Organisations Employment I have two spreadsheets - one with organisations and one with people. Approximately 700 records for each - how will I upload...

Any ideas on this boys? - please ask if I havent explained this properly

I have created my database - I now need to upload data from my old database. I have the old data in an excel spreadsheet and have edited the data so that it matches the coloums in the new database. I have one problem, I can upload all the person data into the person table and I can upload...

thanks, thats sorted.

I have a form which has a combo box, the dropdown list in this combo box is populated with surname, givename for each contact. When user begins to enter surname the list pulls up the record - user presses enter OR selects value from list and the text boxes on the left are populated with data...

Hi Colin, Thanks that looks really useful. I have copied and adjusted the form. But when I try and open it I get a messgae saying. "The record source 'tblCompanies specified in this form does not exist" Except that I have removed all traces of table companies from the form?? What am I...

Hi, How do you normally prevent duplicates being inputted into you forms. My Idea is this The input text box doubles up as a dropdownlist of current values held in the database for that field. So when you access the organisation form and go to the first text box as you enter the 'I' for IBM...

Thanks Micheal thats sorted.

Sorry to keep bothering you Mike, but when I click display, nothing happens

I changed it but now its doing something wierd

Okay, MJR I have taken all your advice and the result is attached. Problem is when I click display nothing happens. What do you think?

Sorry - found it, let me try. Thanks MJ

Thanks, I have changed to onclick event to open the search role macro (which opens the query). But I still dont understand where you want me to put point 2.??

Thanks MJ I have done all of what you said apart from this last bit (above) Can you give me more guidance on this? how do I do it? where do I put the [Forms]![nameofformyoucreated]![nameofcomboboxyoucreated] information I have attached the file - would it be possible for you to check if I...

But if you look at my forms section there are no additional forms for the other search boxes, how comes I have to have a form for this.

I want the query searchbox to be limitied to seaches on the following: I would really appreciate your help Placement (u/g only) Internship (p/g only) Project work only (i.e. not linked to placement or internship) IT role HR role Senior management role

Hi All my queries are working apart from the last one - I think I have forgotten how to do do it,can someone please help. On my main menu form I have a query labelled 'Search By Role. I want to have a query input box to appear when I click 'Run' But instead of opening a input box, it opens...

I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?

why not just copy and paste the details from one spreadsheet to the access tables.

I am really sorry But I dont understand what you mean bythis, when I click on events, the onclick ... links to a coding page, where should I put the code that you said above?