Recent content by Susie

I got it to work!!!! Yippee!!!! The answer turned out to be very simple. Instead of MyDB.Execute (MyQuery.Name) I needed to have: MyQuery.Execute

Ah, I see. My query is a make-table query, so I'm trying to end up with a table which contains only the records that match. So, it looks like the difference between your code and mine is that I'm trying to execute the query after setting the parameter, thereby creating a new table, and you are...

I think you want to do a group query: column1 is CustomerNumber Total:group by Column 2 is: Count: 1 Total:sum This should give you a count by customer number.

Is that because format("YYYY") makes it text? Then I would suggest also having a column in the query that is left as a date field for sorting purposes, and then following the suggestion above.

I didn't totally follow the above. You're creating an on-the-fly parameter called MyInv, correct? What is rstInv? Where does that get defined? Or is that the table in qryMyInvoice?

I've got an append parameter query where I have [Enter Form Type] in the criteria of a field (this is the only parameter). I've also put this in Queries/Parameters: Parameter Data Type [Enter Form Type] text I'm trying to set the parameter in VBA and run the query, but...

That did the trick, thanks. I was specifying Work Offline because in the past, it tried to log into my Exchange server and would take forever to figure out there was no connection. Working offline didn't seem to affect incoming messages, but it did affect outgoing. So I set up another profile...

I get an hourglass for about a second. When the hourglass disappears, the email is still in the outbox. I vaguely remember someone saying this is a known bug in Outlook 97, but I can't find anything that backs this up. I would hope there's a way around this.

When I send an email using Outlook 97, it sits in my outbox. I have 2 information services: Exchange for when I connect to work, and Internet Email for home. I can get email fine using Internet Email, but when I try to send, the message just sits in the outbox, no error. If I choose...

Hi, I'm trying to update an OLE field in a table to be a linked object. I've gotten this far: Dim mydb As Database Dim itemset As Recordset Set mydb =...

Hi, Do you happen to know the syntax for updating the field to be an OLE object? I've gotten this far: Dim mydb As Database Dim itemset As Recordset Set mydb = CurrentDb Set itemset = mydb.OpenRecordset("t_test") 'Create dynaset. itemset.MoveFirst ' Find first...

Hi, I'm on a deadline for a project and I'm running into a big problem. I've got to find a solution to this quickly. I have a database that is used to produce renewal notices for a publication. I have a table of Renewal Text records. One field is an OLE object field linked to a Word document...

I've answered my own question, after battling this for a day and a half. The lines that were getting dropped were related to page breaks in the middle of sections. So if you set the Keep Together property to Yes in all sections, it keeps data from getting lost when using OutputTo or Save...

I'm using the OutputTo action to save a report as an MS-Dos text file. Access 97 randomly puts blank lines in (the Microsoft knowledge base which says to fix this by making the detail section height be a multiple of .125 inches does not solve it) and it also randomly loses a line here and...

Keyser, are you referring to the capitalization? Because the letters are just what I put, but with different capitalization: global stringVar fruit; I didn't think Crystal was case-sensitive. Ken, how then would I get the results I want, putting both getColorofApple and getColorofOrange on the...