Search results

Hi all, I've got a paramater query prompting me for 4 paramaters. The problem is that it prompts me for each of them two times. I've tried various combinations of parentheses, but to no avail. Below is the query. Any ideas? Thanks. Marc Here's the query: SELECT PlantTOC.TOCID...

Hi all, I have a query that prompts for a parameter, and I have a form that uses that query. So I open the form, enter the number (in this case, it's an "issue number", and then all records for that issue are available in the form. Now, here's my problem: When I go to enter a new record, I...

Hi all, I've got a button that calls doCmd.SendObject when clicked. In the resulting email that pops up, I need to insert some line breaks. How do I do that? Here's the offending code: DoCmd.SendObject acSendQuery, "qry_Jnut_Report", acFormatXLS, "XXX@ajn.org", , , "JNUT Report", "Dear So...

Greetings. I usually work on Access97, but I had to take a database file to another computer, which runs only Access 2000. So I had to convert the database, work on it, and then convert it back to Access97. Upon opening the database again in Access97, I now have trouble with any queries using...

Greetings all. I've been wracking my brains for a few days on this one, and I think it's time I ask the forums. First, the data: TABLE 1: ArticleID Issue Edit Check ProofCheck ----------------------------------------- 7687 Jan 1 KM GW MKM 7688 Jan 1 JL GW HC...

Greetings. I'm new to forms and I need a quick piece of code. I have a form that contains a bunch of data, among them is an email address. I'd like to put a button on a form that, when clicked, opens an outlook "send" box with the email address in question in the to: field. I've put...

I'm working with a DB I didn't design and have a small problem. I need to group aggregate results by a column called "Issue". Issue is a date (formatted as "Jan 1", for example), but the field is typed as a text field. Here's my code: SELECT [2002 ji papers].Issue, count([2002 ji papers].Logic)...

Greetings. I am using ColdFusion to return a recordset, but I want to turn the CF query into an Access query. My problem is that I use variables in the CF query and I don't know how to rewrite this as an access query. Here's my CF code: set variables: <CFSET TargetDate=Now()> <CFSET...

Hello all. I tried searching the forums for an answer to my question, but I couldn't find precisely what i'm looking for, so forgive me if this has been answered. Here's what I have: 5 tables, 60 or so records in each table. I have a query for each of these tables. The query returns...