Search results

i want to EDIT the file I have transfered a database i wrote on access 2002, in the format of access 2000, to a computer running access 2003. I can open the file perfectly well but i can't edit anything (tables queries etc) as i stipulated that you shouldn't be able to. On my computer i can...

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 = _...

Frustration It is so frustrating: I know what i want to do: I want to add code to the AfterUpdate row in the Combo box properties that does this ###################################### IF ' name typed ' is in tblfirm then goto to next box, however if ' name typed ' is not in tblfirm then...

Not sure Hopefully it will stabalize but there may be times when the required firm is not availible and instead of adding it to the tbl it would be easier to just add it to the combo box, I might add a msgbox that will appear if there is a new name added that will say something like : Are you...

Update tbls? Will limit to list update the combo tbls? I need to have an entry that is not in the combo box to appear in future combo boxes on the other forms. Jed

First timer... As a newbie i am just following what would be useful.... however this is my first db andso i am really trying everything out. What would you recommend i do? The only reason i'm doing it is so that i don't have to constantly update the tbls for the drop down menus when i get a...

Yes!!!!! Thankyou soooo much, that is perfect, didn't realise that output would run the query as well. Forever in my debt..... Jed

Solved one side not the other!!! Solved the mulitple searches using OUTPUT TO thank you very much, but i still get the white query box for about a second, instead of OPENQuery is there another command to run a query? Jed

I want to run a query and then export it to excel, at the moment i am using this code: Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim stDocName As String stDocName = "qrySource" DoCmd.OpenQuery stDocName, acNormal, acEdit DoCmd.RunMacro...

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...

Many excel files thank you for pointing me in that direction i need to find my way around the macros. I have implemented the export macro, but i have two problems. 1) i must specify a filename for the file it is exported to, within the macro. If i run more than one search that file will be...

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

Thanks for your time Thank you for taking time to look at this prob, Have actually just created a query in which the criteria are all LIKE "*" & [Forms]![frmsearchcandidate][cboclient] & "*" It works but will only find files that have data in all the search catagories. am debating whether...

Opening a query's results as a form I have created a form that contains drop down boxes that are criteria for a query. When i press the command button the critiria in the form is sent to the query and the results are shown as a query window. Is there any way that i can get the query results...

Have found it Found it doh am so stupid!!!!