Recent content by mcollins

Forgot to mention, I tried to run the WRKGADM.EXE utility, but I wasn't sure what to put in the fields, especially the 'WorkGroup ID' field. And I wasn't sure if this was the correct way to recreate the SYSTEM.MDW file. Thanks

When I try to open a particular (unsecured) Access 2000 database, I get the error "You do not have the necessary permissions to use the EmpTrk.mdb object. Have your system administrator..." Other people are able to open this database fine, so the only explanation that I can think of is that I...

Hi Duane, I've got all that in my code; I was just explaining my reason for not using a regular text box. I only need further assistance if someone has another idea of how to get the output of Me.Print to wrap. Thanks, Mike

Hi Duane, What I was trying to do was to add formatting to the output. Like Me.Print strPart1; Me.FontUnderline = True Me.Print strPart2; Me.FontUnderline = False Me.Print strPart3 Thanks, Mike

I am trying to output a long text string in the Detail Band OnPrint event of a report using Me.Print. When the text is wider than the width of the page, however, it just gets cut off at the end of the first line. Is there any way to get the output of Me.Print to wrap? Thanks, Mike

Thanks PH. Sounds promising. But I still am not quite sure how to do it. But just having you say that that is a way to get it done, gives me a reason to pursue further in that direction.

Hi, I have an application that uses VFP 9 data. I tried to create a link from Access using ODBC, but I get an error. I read that the VFP ODBC driver doesn't support the latest VFP features (I suspect that this database may use new datatypes) and that it is recommended to use the VFP OLEDB...

Thanks Zameer. That might be what I need to do. I would have thought that there was a way to write code for events of the standard menu, but I guess that replacing it with my own is just as easy. Mike

Thanks Duane.. Again I see I may be looking in the wrong direction to do what I need. Is there any way to tell from the On Current method that it was called from the user choosing Insert | New Record? Mike

What I am trying to do is run some commands when someone chooses Insert | New Record from the Access main menu when a form is open. Then I would like to return control to Access for it to do it's normal function. Is this possible? I have searched around and can't find any info. Mike

Thanks powella. That is what I ended up doing and it works well. Mike

Thanks Duane. That sounds like a good approach. But would there be any way to let the user preview the run, and cancel if they wanted? Mike

I need to print a batch of checks, and also update related data in the database. For example, for each check that is printed, I want to create a record in the checks table. Also, each check may be paying for multiple things, and I want to record the 'Paid with check Number' info. I am trying...

Roy-Vidar, This approach works fine. Thank you! Every time I think that I need to directly access the data from a form method, it turns out that I didn't need to after all. Thanks again! Mike Collins

Ok, that is encouraging. But I don't know how to do it.