Search results

Yes I would do this through a form. Here is some excellent code for how to have the user browse to a file: http://www.mvps.org/access/api/api0001.htm Look carefully at the code and you will be able to figure out how to only show them zip files. Then, after they have selected a file, get the...

Just check the last three characters of the file name before you insert it into your database . . . should be simple enough.

Yeah, it sounds like you may have to resort to setting it in code. Sorry I don't have any easier suggestions for you.

Yes you are right Banana, there are plenty of work arounds. I meant in the literal sense, there is no setting in Access where you can choose save automatically or don't :)

Wouldn't we all . . . Unfortunately, it is impossible.

Personally, I hate 2007. My point is that you need to consider the environment that the end product will be used in, not just how easy it is for you to develop it one way or another. If your end users are (or will be) using a Vista/Office 2007 combination, you are just creating headaches for...

Yeah, you need to check out the references on their computer, not yours. Good luck.

In the code window - open one of your modules, then you can get to the references through the tools menu.

Sounds like it could be a missing reference. Check to see if any of the references say MISSING on the person's computer who is having the problem.

Access is the clear choice unless they want to invest significantly more (like twice as much) in development time. But I would hesitate to start a new project in 2003 at this point unless you know for a fact that the users of the new system have no plans to upgrade to Office 2007 (or the next...

I have fought with this before. It seems buggy. I am not entirely sure I understand your description, but have you tried going into the report and under page setup change the printer to default and then save it? I don't know if it will help, but I have a vague memory of trying that once...

Nope, I just got laid off. Whatever you do, KEEP YOUR JOB. The competition out here is fierce. I have seen people with more experience than me working for $18/an hour on contract.

http://www.mvps.org/access/api/api0001.htm This link will show you how to allow the user to browse to a file.

Sounds like you need to do a crosstab . . .

Sounds like you've solved your own problem, but if you also want to avoid the configuration message when switching between different versions of Access, you can get SageKey StartAccess which protects the registry (different versions of Access all share the same registry key).

Or you could also do the report based on year, and then do a subreport based on semester.

Sure, just make a query that groups by year, and then based the report off of that.

Seems like you would need a different data structure so that you could have a one to many relationship between "year" and "semester". If you already have that, it should be simple enough to group by year and then by semester . . . If you don't, and you don't want to change your data structure...

It won't show with no data at all, but if you make sure that there are placeholders when your fields are empty, like nz([Your field that is empty],0), etc., then the subreport should show.

Lucky you!