Recent content by jonnycattt

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