Search results for query: *

I think my answer is to use multiple queries or a report, but figured I'd ask the experts before giving up on the single-query idea. I have a table that has 11 fields in it. Field1 is used for grouping. Fields 2-11 are called "Level 1", "Level 2", "Level 3", etc. What I am trying to do is...

Okay, a while back I was able to use code to send automated emails. This code works wonderfully for what we are doing. Unfortunately, we've expanded our needs and now I need a more complex email. What I am trying to do: sqlstr2 generates a list of each person that we need to send an email...

What I am trying to accomplish is creating XLS files based on the field [Reporting Level3]. All records will have a value in this field (something like "Doe,John Q.") and there are a total possibility of roughly 10. I want 10 files with each file including only those records. I really don't...

I know I am missing something simple here, but I can't seem to put my finger on it. I have a form with a combobox. When a user selects from the list in the combobox, it should refresh the subform data to limit the results to the selection from the combobox. If I hit <shift>-F9, the subform...

I have a query that has the following fields: Name TestType Count(tblAnswerKey.QID) AS QsRight Is it possible to create two new fields, within this query, that are the contents of the 'QsRight' field based on TestType (there are only two test types). In otherwords, I want pre-QsRight and...

I haven't a clue how to do this, if it is even possible. I have an existing query that generates a large report. This report then gets split into smaller files based on the field [Reporting Level3]. If it is possible, how would one go about creating the various .XLS files based on the results...

I have two tables. Table1 is tblAnswerKey It has the fields ClassName, NumQs, A1, A2, A3-A20. The data in this table is each Class with an online test, the number of questions on that test, and then the approrpiate answer for each question in fields A1-A20 (or however many questions are on the...

I have a Function SendEmail(strTo, strMessage, strAttach, strSubject, strBCC) defined and works just fine. I have previously created functions that ran against the SendEmail function and they have worked just fine. I have since written the following Function and am getting an error and don't...

I have a table with the following fields: FieldName:Data Type Emp#:Number OrigCourseComplete:Yes/No NewCourseComplete:Yes/No DateAdded:Date/Time I am trying to make an update query that will "check the box" in NewCourseComplete if it meets the necessary criteria. Here is what I have, but it...

I have a form with a combobox in it that works as expected. I can select a record from the box and the drop-down goes away. I have created a button next to the box that I want to append the record from the drop-down box to a new table, but can't seem to make it only send a single record...

Ok, I searched for posts and found very little actual code to give me an idea on how to do this. I have several spreadsheets, all with different names, all will be generated multiple times and have new names each time. All spreadsheets have the same column headers and columns. I need a way to...

I've got a working function that obtains the values necessary for this within the following: Set rst = mydb.OpenRecordset(sqlstr) I know this works as the function works. Now I find out I need to write into a new table several of these values for tracking purposes. Since this function will be...

Hi there, Recently, I had some help with generating emails from my database. Now that I have tested and played around with the previous email, I've run into a new hands-tied problem. I need to run the email code against Status = "Attended" and EventID is equal to the current EventID on the...

Okay, I looked through the forums and I'm left scratching my head in confusion. I've never written any VB script and have had very little exposure to it. Here is what I want to accomplish: Send email to anyone listed as having a class tomorrow. I've setup a Query that takes the three tables...

I know I should probably scrap this macro and write the VB code, but I was hoping not to have to do that. Here is the problem: I have a form called OriginalForm with a button and a field called "EventID" (and other stuff that is not relevant here). When you click the button, it executes a...

I am having problems with a query. When I run my query in View mode, it reports exactly what I want to delete. When I run it in delete mode, it says it can't delete and recommends I don't have access to do that, but I do. Here is my SQL of the query. Am I trying to do something Access isn't...

I have a macro that is causing me some headaches. The macro is accessed by pressing a button on a form. The form contains a subform which has data from Table1. At the bottom of the form are some data fields with data from Table2. Here is the macro: OpenQuery Query1 (updates Table1) OpenQuery...

I have never done a form before and have been asked to set one up. I figured, complex queries are pretty easy, how hard can a form be? Riiiiight. Here is what I have to work with: Table with 20 fields. Important ones for this question are Name, Month, and Date. No fields are unique in the...

I inherited an Access DB with tons and tons of stuff in it already, so I am still figuring out what everything is and does. Here is one of the current problems I am looking in to: I have a query that brings up all of the information I want written into a new table. One of the fields is a MEMO...