Recent content by mishmish

Hi, Thanks for your response. I did consider using a subreport. However, I really need to have two columns in this parts list. I tried setting the column settings for the subreport to 2, however, these settings didn't carry over when I ran my main report. I could have set my main report for...

Hi, I posted another question earlier about this topic but I think this one might be more clear. I have a report where I only want a subreport to print with two columns. The rest of the report I want to print with only one column. Does anyone know if it's possible to change the column settings...

Hi, I have a screen where a user can select to print out a range of catalogs. The catalogs are printed out in a main report with this statement in the open report event of my report: DoCmd.ApplyFilter , "[BillofMaterials.Catalog]>=""" & StartingCatalog &...

Hi Paul, Thanks a lot for that. That worked great! mishmish

Hi, Does anyone know how to use the GetDriveName method in VB? The help files on this aren't very extensive. If you know how to do, can you provide an example? I'm trying to get the drive letter for a user's cd rom drive. Thanks, mishmish

Hi, Does anyone know how to determine in code the cd rom drive letter of a user's machine. Thanks, mishmish

Hi "Stressball", I sent you that attachment. Thanks, Francescina. I'll take a look at it. mishmish

Hi, If I'm understanding your question correctly, it seems like you could just apply the filter in your openreport statement like this (the filter comes after the acViewPreview). This is an example from a report I was trying to open where I was trying to filter based on a starting and ending...

Hi Rick, Thanks for responding to this and my other packaging question too (I posted the answer to that packaging problem I was having). This packaging stuff is really all new to me. Anyway, the problems I had was that I was using a "Direct" cd burner (called "Adaptec...

Hi Rick, Well, the problem I had was that I wasn't trying to access it from a code window. You need to access it from any code window. Then you can go to Tools/Add-In Manager to access it (as long as you've loaded it onto your system from the Developer Tools cd #2). Hope this helps. Sorry for...

Hi, I just put together an Access project using the package and deployment wizard. I burned it onto a cd and when I tested the cd on several pcs, I kept getting a "device not ready" message (referring to my cdrom drive). Does anyone have an idea(s) for why this is happening? Does it...

Just to keep anyone from wasting their time on this one, I figured it out. Thanks, mishmish

Hi, I just installed MS Developer's Tools 2000. Specifically, I installed the Office 2000 Developer's Tools (not the Developer Applications). Anyway, after I did my install I restarted my computer and tried to add the package and deployment wizard to my Access Add-In manager. It wasn't in the...

Hi Sure, That would be a big help. It's tmurphy_80@hotmail.com. Thanks, mishmish

Hi, I'm trying to create a run time for a 2000 Access application. Eventually, I'm going to need to put it on a cd, but I just want to create this on my own Windows 98 PC for now (for testing). I've never done this before so I'm just wondering if someone can point me in the right direction. I...