Search results

So.... does that mean I need to put the SQL text of my query in the code? I think that's what you're saying, Dan.

Still trying to write 1215 page rtf file I'm new at this VB stuff...but, would a For...Each...Next statement fix this problem?

Okay...here goes... Thanks, Mile-O. A couple of things you should know. First, the query results contain records for all the countries in our database. Secondly, the recordset contains multiple records for each country. For instance, there is a record for popluation and another record for GDP...

Hmm...you said "uncheck" Microsoft ActiveX Data Objects 2.x Library...that made a difference. However, now the report seems to be in an unending loop.

Aye, I've used both...the error message is the same.

Type mismatch Hmm...now I'm getting a type mismatch error on: Set rec = db.OpenRecordset ("QRY_COUNTRY_REPORT") It is now recognizing the "Database" element, however...one small step for man...still smaller step for mankind. Any help on this one?

Access 2000 All right...now I'm gettting an error message when I try to compile the procedure. It is on the phrase: Dim db As Database It says: Compile Error User-Defined type not defined Any idea why Access 2000 will not let me use "Database" Thx

Query vs Table dan_kat, another question. Your event procedure showed the following declarations: Dim db As Database Dim rec As Recordset Dim qdf As QueryDef Dim strSQL As String Dim intId As Integer dim strPathCountry As String Set db = CurrentDb() Set rec = db.OpenRecordset ("tblCountry")...

Hi, all...here's the deal. I have a report that I can run that creates a very long report organized by country names. What I would like to do is write a script that will export the report into rtf files by country. In other words I would like a module that would write a separate rtf file for...

Born in Dallas texasalynn, Are you using the query to generate a report? If so, the sums could be calculated fields on the report itself rather than in the query.

Grouping Shiner, I 'presume' that your report is grouped on player. Try putting a page break in the group footer. That should do the trick.

Attach a query to the report The way that I have done this is to base the report on a query. The command button simply opens the report in acpreview. The query contains all the fields that I want in the report. The key is to use the primary key field to determine the scope of the report. My...

Great minds think alike, I think Colin put it more succinctly than I, but you get the idea, right?

Sequence Field Steve, Try using an additional field called 'shiftsequence' and assign the first shift of the day the sequence number 1...the second, number 2 and so on. Then sort on the sequence number rather than the shift number.

Border Style Open the form in design mode and set the Border Style to NONE.:D

Wizards John, I know this flies in the face of logic...but do you use the wizards to build your forms? You can add a button with the toolbox and when the wizard comes up choose record operations. The first option there is Add New Record... that should work. :)

You can still use 'Briefcase' to transfer the files...just put the mdb file in the briefcase and then copy it to a floppy...you should be able to zip up the file if it is too big for a floppy. The advantage of using briefcase is that it will work to sync up the multiple copies of the database.

OS? Marty, Are the users ever directly connected to the server? If so, are you running on Windows? You might be able to use Windows Briefcase to sync up the databases.

don't know if this will work...how about putting the code in LostFocus? That way when you leave the field it will update...as I said, not sure about this. I'll look into it some more.

Is the field a primary key? Kidzmom, Is the field you are trying to update a primary key field? Is it set to autonumber for a datatype? Dennis