Search results

My Access project includes producing a comma-delimited (CSV) file for later presentation to an email program (LISTSERV Maestro). I'd like to be able to incorporate unicode control characters (e.g., CR/LF, etc) into the file to format the email. How do I do this? Here's the line that produces a...

I have a query that produces a table of courses for which a student is registered, but in order to export it for email merge as a csv file it needs to be in a different order. Now each course for which a student is registered gets a different row, using the following SQL: SELECT...

I am using Access to send emails, but the computer I am using has more than one email client (specifically Firefox and Microsoft Outlook). Normally Firefox is my default client, but I would like to have Access use Outlook because the third-party application ClickYes works only with it. My...

I am sending emails (with pdf attachments) from my Access 2010 database using Mozilla Thunderbird. However I have several accounts in Thunderbird. Is there a way to have Access choose the account to use for sending? I've searched Thunderbird to see if there is a way to choose the default account...

I need to update a table that exists in Access with new data. The easiest way for me to do it is to run a deletion query that removes all the data from the existing table and then to repopulate the table from an Excel table. This works fine except for one thing: the table in Access has a...

I am trying to use an update query to update several fields in a table. The following code works fine for one field: UPDATE [Trip Registration] SET [Trip Registration].[Trip1 Confirm] = "C" WHERE (([Trip Registration].[Trip1 Coord])=True); but the problem is that I'd also like the same...

I am using the following code to read a series of records from a table and use the names included in each record to print a form. Private Sub Command0_Click() Dim rst As DAO.Recordset Dim printout As Integer printout = 0 Const MemberQuery As String = "SELECT StudentName FROM...

I have a small but annoying problem that I'm hoping someone can help me with. I've attached a file containing some code that's activated when the user clicks on a button on a form called DistributeLetters. The code is supposed to get some information from a table and use it to fill in a report...

I have a table listing organization members and the various trips they have signed up for and would like to make mailing labels based on that list. The problem is that any one member may have signed up for multiple trips, yet I'd only need one mailing label for that member. So a simple query...

This is no doubt a dumb question, but when I first was learning Access a few weeks ago I followed a procedure which now forces me to use the SHIFT key every time I open the database or I can only have access to a restricted set of commands. I can't for the life of me remember what I set to...

I'm trying to format a report so that it will come out in print form as a series of individual letters. The table the report is based on consists of one field for the name, several fields for the address and another field for some data text. The same name may appear from one to six times, each...

I have a table which contains the choices students have made from a list of 40 courses. Each record consists of a student name followed by 40 fields, each designated by a course code. Each of these 40 fields in the record contains either a preference number from 1 to 6 or a blank. I'd like to...

I have a report which sorts a list of names into two groups based on one field ("confirmed" or "waitlisted"), but I'd like to sort the confirmed names alphabetically by name and the waitlisted names by a different field ("draw number"). I seem to be able to sort the entire list by one key or the...

I have a report which lists the names of students enrolled in a class based on a query which finds them in a table listing all classes. However I'd like to be able to put an entry box next to the name on the report which allows me to change a datum (for example, GRADE) in the original table...

I'd like to be able to assign a value to a cell in a table by putting a command button on a report and having it place the value in the table when the button is clicked. I can get the macro associated with the button to do various things but not what I want. I've tried Set, but I get an error...

I can't seem to sum across the fields in a query. Each row consists of a name followed by ten number fields, and I'd like to get the total of the ten numbers in the row for that name. I've tried using an expression like check:field1+field2+field3..., but the sum is not displayed if any one of...