Search results

Mile-O-Phile, Where am I asking it to prompt me twice? I have four paramaters, and so I should be prompted 4 times. Instead, I'm prompted 8 times. Is this a result of all the joins? Marc

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

For future information, I found an answer at this address: http://support.microsoft.com/default.aspx?scid=kb;EN-US;210236

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

Excellent. Thanks!

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

Perfect. Thanks all.

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

OK, figured it out with the help of a friend: here's the result: query 1: select a.Issue,a.Edit as EdInitials,count(*) as EditCount,0 as CheckCount,0 as ProofCkCount from [2002 ji papers] as a group by a.issue,a.Edit UNION select a.Issue,a.check as EdInitials,0 as EditCount,count(*) as...

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

OK all: it works. I guess I should've posted the entire command. See I was using the Mouse UP event, not the click event. When I changed it to the click event, it quit hanging. thanks for all your help!

Thanks all. It's still hanging. I can type and use the keyboard to switch between fields, and I can use ctrl enter to send the email, so it's workable for me. Annoying (because i can't figure it out!), but workable. Thanks for all your help. Marc

I tried what you suggested, but it's still hanging. here's my code: DoCmd.SendObject , , , FEB_2002_Form.Email, , , FEB_2002_Form.LogicID, "insert text here", True FEB_2002_Form is the form name, and Email and LogicID are the field names, respectively. Is this the correct naming convention...

OK, thanks for your help so far. It's almost working. it pulls the right data from the fields, but when the email box opens, the cursor remains an hour glass....the whole thing just hangs. Here's my code (Email and LogicID are names of fields on the form): DoCmd.SendObject acSendNoObject, , ...

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

Too easy. Thanks! Marc

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

use the sql aggregate function "group by" in your sql statement. your asp books should tell you what to do with this when you output it. it's probably something like #RestaurantName# #Restaurant Value# where the # represent whatever asp's variable naming convention is.

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