Recent content by Noel

Thanks folks for your replies. It sounds like SQL Server Express is a good option.

HiTechCoach - thanks for the reply. The database is < 2 gigs (.bak file is ~250 mb) Unfortunately, I don't have SQL server. Is there a free alternative that has the utility to transfer/convert to Access? Presumably the database has various queries. Will those be lost? Thanks again, Noel

Hi, What options exist for opening or converting a SQL Server backup file (.bak file) into MS Access? Thanks, Noel

thanks folks, I'll continue looking with an eye toward the printer/drivers. Noel

Thanks pBaldy, but I know these printers can handle the smaller margins. In fact, they're the same that my application has been printing to for quite some time (2 ish years). Odd thing is that in the past, I was able to change the margin size to the 0.166" on a couple computers at the office...

I am able to get concurrent instances of the applications opening as Gus suggested, i.e. by first opening an Access shell and then opening the application from the Access application. The above test tell me that it's a Windows Explorer issue? and not an Access issue? What do you think...

On some computers, I'm able to set the report margin to < 0.25 (i.e. 0.166), but on other's I'm not. Anyone know what causes that? Is it an Access thing? or a Windows thing? How can I get to smaller margins? I need to set the margins to 0.166" b/c the content of the report is wide...

Thanks for the responses. I do have access to the mdbs and, in fact I test the mdbs as well and found that they behave the same way... unable to open more than one instance of the mdbs. I have not tried to regenerate the mde, but since the mdbs behave similarly, I'm thinking that regen'ing the...

THis is a shot in the dark. I have a multi-mde (frontends)/mdb (backend) applications running on a client's network server. The server crashed (a virus I think). They have since restored everything (supposedly), however, the applications (mde's) are no longer opening on more than one...

thanks I followed Wayne's advise and changed my approach to using the CreateQueryDef method and encountered no glitches when passing multiple (wildcard keywords) criteria to the query. Thanks all for the input and getting me to suck it up and claim failure with my original approach:) I think...

hmmm jal (etal?) It maybe you think I'm writting the criteria into a sql string (ala rs.openrecordset(sql)). I'm actually using the Access query objects for this. Using the OpenRecordset method will not work for me because I'm using the criteria in preliminary queries that I then join in a...

thanks, but jal/George - thanks for the input. jal - thanks, but I've tried those too. I tried to duplicate what Access does for you if you type in multiple criteria directly into the query E.g., if you enter criteria directly into the query (such as: *1 or *2), Access reformats the criteria...

thanks, but I think I tried every iteration with 'Like' and 'or'. "Like *1 or Like *2" didn't work either?? Other thoughts?

Any thoughts would be appreciated. The criteria I'm using in the query comes from a function: 'getJobGroup()' Specifically, the criteria in the query reads: Like getJobGroup() The function is: Function getJobGroup() Dim v v = Forms![frm: cfax_main]!txtJobGroupCriteria Select Case v Case 1...

thanks for the response oh well...