Search results

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 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...

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

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...

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?

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...

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...

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...

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...

I have my database set up to import certain emails from my Outlook folders, and then break down the data in the emails into certain fields. This is done using a couple of queries. The problem is that the queries refuse to pass more than 255 characters of data for any of the fields. Two of the...

I'm using code to take a value from a query and add it to a table (can't use append for various reasons) and I'm hitting a 127 character limit when I pass the value. I still get the problem if I segment the string. Is there any way around this limit? It's causing me some pretty major problems.

I have a report that lists a student's Social Security Number, Name, Department, Job Title, and Work-Study eligibility, and when I view the report, everything shows up fine. The problem is that when I send the report to a mail recipient as an Excel file, some of the Social Security numbers get...

Now that I have figured out how to read and write text files, I was wondering if there was a way to read in from email. What I'd really like to do is have the code search my Outlook Inbox for messages with a certain subject and then read in the information. Is this possible, or am I crazy...

I have a TransferText macro setup that builds a text file that I need (fixed width) but I need to add a header and footer of the same width, but with information that doesn't fit into the fields. Is there any way to do this?

How can I change an export specification for a table? Whenever I try to export it manually, it says I can't define a field more than once, because some of my field names are too long, and it doesn't see the differences at the end of them.

I have two tables with identical fields and I have an append query which takes all info from table1 and archives it to table2 before table one is deleted. The problem is that I am getting validation rule errors on 15 of the records, which I don't understand, because table2 is just a copy of...

I made a macro that runs a saved mainframe query ion Excel and I was just wondering if it's possible to write some code or a macro that will save the info returned as a certain filename in a certain folder. Any help would be appreciated. The final goal is to run the query, save the...

I got the Outlook library loaded and I can declare variables as Outlook.Application, but when I try to set .Attachments, I get an error saying that "one or more parameter values are not valid" I checked the file and it's valid, and I even tried using one on my C drive with no luck (the actual...

I can't set a variable as an Outlook.Application. Any idea why not?

I am using a Mail Merge to print student's information onto form letters, and I can't get their social securty numbers to come through as xxx-xx-xxxx. For some reason, the dashes don't make it to the form letter, so I get xxxxxxxxx. I created an input mask for [SSN] in my table that saved it...