Search results
-
Report Default Printer
Nice...I just used this to print a page with multiple subforms to a PDF. -
Best Edward Norton Movie
I would have trouble picking a favorite of his movies. I can't believe nobody mentioned Death To Smoochy though! :) I firmly believe that he's the most versatile actor of our time.- UniqueTII
- Post #12
- Forum: The Watercooler
-
Select query fields from combo box
The noob is back. I've been away from this board for a few years (and I've forgotten most of what little I knew) but now I'm back with more dumb questions. I want to make a search function that searches certain fields based on the value of a combo box which is a list of the fields. I'm using... -
I can't keep data from duplicating itself.
Each table has the student's SSN, work program (work study, community service, etc...), departmental earnings for that period, and work study earnings for that period. Since not all students that currently have earnings are listed in every report, the tables in the query are left joined to... -
I can't keep data from duplicating itself.
I have a query that pulls data from 8 different tables, each containing data about a student's earnings during a 2 week pay period. The tables are connected by the students' SSN's, but since each student may have more than one job, their SSN can't be the primary key. My problem is that when I... -
Setting primary key with code?
Help was no help, but a quick search of some SQL pages got me exactly what I needed. Thanks a bunch! -
Setting primary key with code?
Is there any way to set the primary key of a table using code? The reason I want to do this is to set the PK after doing an automated TransferSpreadsheet so that I never have to actually deal with the table. Yeah, I'm lazy. :D -
Combo box wizard not working
What I did is pretty close to that. Since the form will have different values for "Code" and "YearID", I made an onLoad event that looks like this: cbxSearchByID.RowSource = "SELECT tblApplication.AppStudentID FROM tblApplication WHERE tblApplication.code = """ & Code & """ AND... -
Combo box wizard not working
I have a form that's based on a parameter query, and I'd like to have a combo box on it that's based on one of the fields and filters the form after it's updated, but when I try to create one using the wizard, I choose the field and it tells me that a value for a required parameter is missing... -
Mail merge problem
Arghhhhhh! The code was fine. I found that out after I rewrote the entire thing using a new method and it still didn't work. The problem was that a date criteria in a query was static, rather than dynamic, so it was still looking for last year's results. -
Mail merge problem
Here's the code: Private Sub cmdMerge_Click() 'Written by Helen Feddema 12-30-98 'Last modified 10-4-2001 On Error GoTo ErrorHandler Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strDBName As String Dim strTable As String Dim strSQL As String Dim ctl As Access.Control... -
Mail merge problem
I have a database with an automated mail merge (through a table with SQL statements) and when I manually run the SQL, I can merge it with no errors, but when I try to run the automation, it tells me that no records are found. Any ideas of what I should check, or do you need more details? -
-
Problem with HTML email
The HTML is just a page that is stored in its own table. It's supposed to look like a webpage when it's mailed, but ended up looking like some messy text. The rest of the code just loops through the email addresses in their table. I have made a couple of mailing functions, and can help you if... -
Problem with HTML email
and here's the HTML: <HTML> <HEAD> <TITLE>MASEA Survey</TITLE> </HEAD> <BODY bgcolor=#c6b5de> <TABLE BORDER=0 BGCOLOR="gray" WIDTH=100%> <TR> <TD ALIGN="center"><b>MASEA CONFERENCE QUESTIONAIRE</b></TD> </TR> </TABLE><P> <!-- Following must point to the cgi server --> <FORM... -
Problem with HTML email
I have a sub set up to send an HTML email, and when I send it to myself on my Outlook account, it comes through fine, but when I send it to any other account, it comes through as just text. The message is formatted correctly in my sent items folder...it just shows up wrong wherever I send it... -
Count/report problem
When I tried to add the other fields of the report to the duplicate query, I got problems with aggregate functions. I ended up doing a convoluded (sp) macro that runs the duplicate query, creates a table, adds the student info, runs a couple other queries, and then makes the report. Whatever... -
Count/report problem
This problem is making me feel like an idiot, so I'll turn here for help. Here's the scenario: I have 3 tables and I need this info from them: StudentInfo : [LastName],[FirstName] EVF: [SSN],[StartDate],[EndDate],[JobTitle], [CWS Eligibility] PClerkInfo: [Department] Here's what it all adds up... -
Choose report fields based on a table value?
I have to create a matrix of information of students who get awarded certain scholarships, and I'm not sure how to do it. I have a table of each scholarship, along with checkboxes for all of the fields available. What I need to do is create a report for each scholarship using only the checked... -
Trouble with SelStart and SelLength...
I have a SelStart and SelLength setup on a combo box in the GotFocus event, and it's not doing anything...literally. I set up a message box to display every time the box got focus, and that worked fine, but the text selection would only work when the form was first opened, and then never again...