Search results

Hi, i have recently created a database on access 2002 and have been able to open an edit version by pressing shift whilst clicking on the file icon. I am trying to open it in access 2003 (office) but can't open an edit version using the same shotcut. Does anyone know the shortcut for opening...

hi I want to be able to alter my data continously :update tel numbers etc. I have tried to use a query but when i return the results in a form i can't save any alterations i make to the entry. How do i overcome this problem? Jed

I have a database of clients with their jobs, tel numbers etc. I have a form that allows me to input more people and a search form that allows me to search the db for an entry (using an autonumber id). I want to be able to amend and delete data from the entry on the search result page on a...

Hi I have created a simple template in excel that contains a freeze pane for the first row. I want to export a queries results to this template so that the first row of DATA (not the headings) of the query fills the second row of my template. at the moment i am using the "output to" macro...

i want to output the results of a query into a form so i can display the results more aesthetically. my fields from the qry are first name, last name,.....etc there are 16 of them. however i only want to display 7 of them. so i want to build a form which has 7 list boxes that will each contain...

Hi, Am having trouble with some code: i want to get a combo box to save an inputted value if it is not in the look up table.: I am using this code ########################################### Private Sub Title_NotInList(NewData As String, _ response As Integer) response = _...

please can someone help...... I have a form that facilitates data entry into a database table. I have several combo boxes that allow choices e.g. firms : ANB Amro, Merrill Lynch, etc. The combo boxes contain data that can be found in other tables ie tblfirms . I want to be able to choose...

exporting to excel hi I have created a search form that gives criteria to a query, and then runs that query. I get the results in a query box. Can i export this to an excel file automatically? Without having to view the query box? many thanks jed

Hi I have built a form but when i tab the cursor flicks from the first field to the fourth then third etc.... I want to tab so that it follows the first field to the second to the third to the fourth etc.... how can i do this?

Hi I am still trying to create a search engine for my database that will allow me to produce results according to any of the input criteria ( Lastname, Currentfirm etc). Having looked at the dynamic query post i have decided to use Vb code to run the searches according to one or many of the...

I have created a form that allows me to define criteria for a query (using a macro tied to the drop down box within the form). I now want to add another drop down box that will allow me to add another criteria to the query thus refining the results. However i would like the ability to leave...

Hi I am new to access and need to create a multiple parameter query to search one table of data (Name, Job, tel number etc). I have managed to create individual queries I.e Job or name or Firm etc But i want to create a query in which i can input parameters for, say, job and firm Can this...