Recent content by tmar89

Well, I think there's something buggy with Access then. I can't explain why this is happening here. If I create a report based on my query and do absolutely no sorting or grouping with the report, it opens up my query as is. If I change the sorting in my query by the ORDER BY statement and...

Got the article, thanks.. but here's what I notice. The query generated is sorted exactly how I want it and I just want the report to do no such sorting or grouping. I want it to just open the query as the query is. How come when I open a report linked to a query, it reorders the data around...

How do I search for a particular article on this forum?

In my form, I generate a query that is dynamic. I can select any of the fields I want to sort by. So for instance I could have a query that has: strSQL= "... ORDER BY LastName ASC, FirstName ASC;" The query generated is sorted however when the report open it up, its not sorted. I don't...

I am writing an SQL statement to generate a query and then open a report: ' Run the query and report MyDB.QueryDefs.Delete "qryCustom" Set qdf = MyDB.CreateQueryDef("qryCustom", strSQL) DoCmd.OpenReport "rptCustom", acPreview my SQL statement ends with an ORDER BY statement...

Weird.. I have Access 2002 and it wasn't showing up as a member so I rebooted the computer, started access and there it was. hmmmm

How come when I try to declare a DAO object, the member type 'Recordset' is not there but there are other members? I included the reference for DAO too.

Wayne, Thank you so much for your help! I have been messing with it and I now have a user defined field based search and they can sort the data based on any field they choose! Im learning as I go with this but you were a big stepping stone with this. Tommy

its getting there. i still need to figure out a way to dynamically link the t fields in the report to only 5 field I select in the query

Private Sub Command5_Click() Dim MyDB As Database Dim qdf As QueryDef Dim strSQL As String Set MyDB = CurrentDb() strSQL = "Select * " & _ "From tblX " & _ "Where " & Me.Combo0 & " = " & Me.Text0 & ";" MyDB.QueryDefs.Delete "qryX"...

one quick question.. i created the SQL statement and when I click the button it pops up a box asking for the criteria that I entered. So for instance, my combo box is "Lastname", my textbox is "Jones" and then when I hit SEARCH, a window pops up and says "Jones" and I have to type in the...

Thanks.. i will play with this concept!

It's a good suggestion but I would need to add all 25 fields in the query then. Any other thoughts?

I'm pretty new to Access and I was asked by my department to write a program to store alot of data, which I did already. They want to be able to do many types of reports based on many more combinations of data than I could set as static queries. For instance, we have 25 fields and we could...

I am trying to implement an email function that goes through a query with email addresses and sends a mass email out using Netscape 4.7. Unfortunately, the lab doesn't use Outlook which would allow this code to work. Does anyone know of a way to have Netscape 4.7 Mail work nicely with...