Search results

I have a table identifying termination dates of a contract. I need to identify which fiscal year the date falls in - (users can't seem to figure this out on their on)....So I have another table listing fiscal years and the corresponding periods..... how do I query so that field is added to show...

here is the code i am working with now: Private Sub Command21_Click() Dim dbs As Database Dim rst As Recordset Dim intRecordCount As Integer Dim qd As QueryDef Dim strEmail As String Set db = CurrentDb Set qd = db.QueryDefs!QRY_SERVICE_by_category qd.Parameters![CategoryID] =...

Not offended! I though that was funny - I wish that was the problem. Still not working - grrrrr.....frustrated, that's all.

I know that much!!!! :*) I am reading the info about parameter queries now - that seems to be the problem.

Thanks, but still not working....it is hanging when opening the query.....at: Set rsEmail = CurrentDb.OpenRecordset("YourQuery") Any Other Suggestions Appreciated

It's not working - getting this error message. Runtime 3061:Two few parameters. Expected 1. The query I am using is a parameter query, including a selection made from a combo box on a form. It doesn't seem to be reading it. Now what?

Okay experts - I need to send emails to people that have an email stored in the database, some do, some don't. query says to return not null, then i want to write code to send one email to all of these people......how? I don't want to send anything from the database, just need their addresses...

I have a report based on a query that is sorted by a user selection in a frame on a form.......make sense? here is the problem. On the report, I want a text box to show what the user selected as the sort order and display it. I used a text box to look at the frame on form as follows...

Thanks all......I switched it to reference the combo box. Learned two things this time!!! 'Tis my quote I always use at an interview.......Woodrow Wilson: 'I not only use all the brains I have, but all I can borrow.' Thanks for the brains.

THANKS JATFILL. WORKED GREAT.

My problem, any suggestions appreciated: I have a table, tblFiscalYears, 3 fields: FiscalYear, FYBeginDate, FYEndDate. I have a search form that lets users establish criteria for a query against another table. On the search form, I have a combo box,cmboFY, that is populated by tblFiscalYears...

Thanks. This worked great.

I am sure this is an easy one for the pros. I am new at this and love these forums, I have learned so much. Here is my newest stumbling block: I am using a form to allow users to identify criteria for a query. When the records are returned,(using a form)I want to give them four sort options...

How do I hide all standard toolbars and menu bars in my application using vb? Any suggestions appreciated.