Search results

Not sure where to put this so here it goes, Yes it is the wonderful me again and once again I hit a little wall. :banghead: I have a basic button, the button opens a word document (Code here) Private Sub Letter1label_Click() Dim LWordDoc As String Dim oApp As Object 'Path to...

I did.... My bad.. I changed it because being in the UK everything normally displays in DD/MM/YYYY so I just adjusted it to fit, never thought it'd be an issue.

You Good Sir are a damn miricle worker. Works flawlessly :) I owe you more than a few beers :D

Unfortunately the DB is currently live (the report is an after the fact modification) and as such has confidential information in it that I can not "purge or desensitise" out. Otherwise I think I would have posted it long ago. It looks like it is the date element which is causing an issue...

Okay Mr PBaldy, Thank you very very much.. it now loads the report... However (I know, I am so needy) It doesn't return results on the report, just a blank report with zero values (if I run the report without filtering it, it returns the data)

Ok I am think I am with you, alternate code from which link?

As in like this? strWhere = Left(strWhere, Len(strWhere) - 1) 'open the report, restricted to the selected items Debug.Print "Negotiator IN(" & strWhere & ") And [Date Called] Between #" & Format(Me.txtFrom, "dd\/mm\/yyyy") & "# And #" & Format(Me.txtTo, "dd\/mm\/yyyy") & "#" DoCmd.OpenReport...

Hi, I am getting a missing Syntax error (missing operator) in query expression. It's on the last line (open cmd line) Full Query is bellow Private Sub Command6_Click() Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If...

Hi, Yes of course, Luckily I have only around 15 queries, 20 reports and maybe 6-7 forms to check.. I will wait till the software is not being used. It's working perfectly, Thanks to your help. I will also mark this thread as Solved, Thank you good man.

I'll change this ASAP... but as users are in it right now I can't. I assume it I change the field name in the BackEnd the users individual access files will stop working.

Hi, Nope it is listed as ID in the Query, [Web Leads Table].ID I assume that is correct, thats the segment of the SQL code for the query relating to the ID EDIT Nevermind, found the column count. so it is displaying two columns

Tried the code above but on the select button the line in red is apparently wrong (debugging) Dim bkmk As Variant Dim strField As String Me.RecordsetClone.MoveFirst 'Find the first record that matches what 'is in the search text box. Me.RecordsetClone.FindFirst "ID=" & Me.SearchResults If...

So the current is SELECT [QRY_SearchAll].[Name] FROM [QRY_SearchAll] ORDER BY [Name]; So I would want? SELECT [QRY_SearchAll].[Name],[QRY_SearchAll].[ID] FROM [QRY_SearchAll] ORDER BY [Name];

How would I change the search result box to return the name & the ID? I've changed the button over, just need it to display the Name & the ID for each record. (and if possible hide the ID)

The problem is I have just gone live with this with a large number of users, I don't want to drastically change anything on their end. I can see that my Record Select button is finding the first record in the list that matches that name and displaying it on the form bellow, so it can be...

So I used John's guide for a name search box. http://www.access-programmers.co.uk/forums/showthread.php?t=188663 We are using the Database and have come across an error. We have two records (two names) excatly the same. When we use the dynamic search it shows both records in the results box...

Okay so the above code doesn't work.... I get this.... Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If Me.neglist.ItemsSelected.Count = 0 Then MsgBox "Please Select at least one Negotiator" Exit Sub End If 'add selected values to...

Okay, so looking at it I am trying to merge the two codes, the one I use and the one you suggested so I can search by date & by name... name of List Box[neglist] name of field [negotiator] This is how I am thinking of merging the two, does this look correct? Dim strWhere As String Dim...

Unfortunately as I was at work I couldn't download the sample (filters on downloading) will have a look tonight.

okay, I think I get it "to a degree" and my questions may be stupid BUT..... is [lstEmployees] the name of the combo box which my "users" are listed in? on the page for the form? Also, is "EmpID" ID the field name which relates to that box? The rest I do get for the more part (or I can see...