Search results

Thanks a lot Baldy, I wish that made sense to me. I am reading through it and get the general jist but am quite lost.

Okay... So now I have a list of the results, I have no idea how to make the result I click load on the form listed bellow.

Hi, Sorry yes my table is called Dunmow but the search box doesn't search a table, it searches through a query (as the query will order it) I just followed the guide posted in the link http://www.access-programmers.co.uk/forums/showthread.php?t=188663 This uses a listbox which source is a...

EDIT: Sorry, this was my mistake, my row source SELECT [QRY_SearchName].[Address 2] FROM QRY_SearchNAme ORDER BY [Address 2]; Works perfectly (except I accidently put it in Row Source Type. QRY_SearchName is the query used for the search (not a table) All works.. Thank you very much...

This whas the guide I was using http://www.access-programmers.co.uk/forums/showthread.php?t=188663

Row source: SELECT [QRY_SearchName].[Address 2] FROM [QRY_SearchName] ORDER BY [Address 2]; Basically an edited version of my old one I used which was SELECT [QRY_SearchAll].[Name] FROM [QRY_SearchAll] ORDER BY [Name]; (the bottom one worked perfectly

Hi guys, I have a load of reports which I currently filter down by date by using the following on the macro to run the report. It runs absolutely perfectly. DoCmd.OpenReport ReportName:="Tenancy Agreed", View:=acViewPreview, _ WhereCondition:="[Date Created] Between #" &...

Table is called dunmow and field is [Address 2]

I had thought I had done that. It should be a field called "Address 2" it searches through and then display the matches so the user can select the record they want which then loads into the form bellow. It works perfectly on my other DB when searching for a name, I guess I am changing it...

Thats my mistake... SearchResults is suppose to be a list box not a text box. New issue now. It isn't displaying any results in the listbox :/

Hi all, Me Again!!!!... So I had a search query I was using for a previous DB which worked perfectly. I am trying to use it for a new DB but the Macro for the search box doesn't seem to work. I can't remember where I got the search code from originally (might have been here) but it worked...

Thanks. I will experiment with the Autofill.

Wow.. Thanks for that. I am sure it would have... I did just use the following though. Private Sub Branch_Change() Select Case Branch.Text Case "Billericay" Me.BranchID = "BIL" Case "Braintree" Me.BranchID = "BRA" Case "Brentwood" Me.BranchID = "BRE" Case "Chelmsford" Me.BranchID =...

Hi, I hope I can explain this if possible. I (will have) a form which a user fills in to enter new data. I have two fields, "Branch" and "Branch ID" (Branch ID will not be on the form, just in the table) Branch will be fed by a combo box with seven choices. I would like it so that when...

Okay... I think I probably bit of WAY more than I can chew here, it's all blowing over my head.

Hi, So I have the following query which works perfectly (and will be use to create a report) but when the query runs to create the report I also want it to mail merge some of the items into word to be used on address labels. SELECT Dunmow.Date, Dunmow.Undeliverable, Dunmow.Duplicate...

I got the update one working though. thanks. Okay so I am going to stop using this thread as it is asking for different things (some reports, some queries etc) so I will create a thread for each item. Thanks

EDIT TO DELETE = ME BEING A MORON. Still trying to work out the update formula

Do you mean use a seperate table to process them, then move them back to the original table? The reason I say this, because if you mean having a "Main" table, then having a table for "Letter 1" (once letter one has been sent) I'd have to do the same for all the other letters (up to around 50)...

Thanks. Will try and see what I get. the #'s were part of the code from the suggestion of the website you posted for "DateAdd". For Feature 3, you said you I would need a different table, could I not use a query to do the following in one go. Select records using the Date Add above DateAdd...