Yeah, Access will let you get away with spaces in such names. But we almost never do it, as you never know when it's gonna cause an error or problem.

The only time we might do that is if the results of a query are being directly exported to a spreadsheet or somesuch, and the customer wants an easily-readable header for each column.

OK, OsX 10.3.9. USB external drive moderate weirdness. Sometimes it doesn't appear in the finder automatically, though it is definitely there (going to the terminal and cding to the right place shows it's there, and files on it are accessible.)

By going to Recent Folders under Finder/Go, I get it to appear on the desktop (and in the folder display thingie, but not on the side that lists the HD, network and users.) In any case, then I can eject it.

Anyone else run into this weirdness?

It's work-aroundable, obviously, but...weird.

Slipping in with a question about jerky video. Not like "Crankyankers" or anything like that...just stuttery playback on cbs, cw and pretty much any other 'watch full episodes on the 'net!' sites.

It's weird because tonight, when I went to the cw front page, their previews worked fine...click on an episode though?...stuttering sound (a sentence, then a pause) and choppy video.

Mozilla help is giving me no love in re increasing memory to Firefox.

What shall I do? t /damsel in distress

eta specs: emac running 10.4.8 with 1GB sdram

Sometimes I like to come into this thread just to read all of these posts that make absolutely no sense to me. I find the technobabble soothing.

Thanks tommy and Gud. To be fair, Kristen, I have no idea what I am posting either!

Is there some easier, better way to do what I am doing? I am trying to make something easy for my boss-- so she can do a report (get a class list) on mulriple variables-- That is, the only real way to know you are getting the correct class is with one field, the course ID number. I was hoping she could do something like type in the name of the course AND the start date, and come up with the right course. Or if she needed to see just the courses offered in a certain year, she can do that. I could force her to use the course ID number, but this works against the ides of convincing her that one large database is better that doing a flat database in datasheet view for each class with their contact information , keeping an excel spreadsheet with their payment information and hand-typing the reciepts. Which worked fine when there were 2 classes with ten students each, but not so much with 70 classes with up to 60 people each.

I sort of want the solution to be quick, because the database can do all I need it to right now (reciepts, deposit reports, form letters to students) but I need it to be easy for her to find this info so I can test the database out with some classes we are running now. The other reason for not spending much time in it is that this is an interim solution, as in about a years time, we are probably going to have something built for us by an actual database designer.

I have a friend involved with a small non-profit mag who can't pay for assistance.

They are having to raise subscription prices. So as an inexpensive way to provide some value added, they are putting their content online, but they want to limit access to subscribers only (accepting that some of it will then be forwarded). They want to do it cheaply, with off the shelf software. Right now they are looking at a "merchant" package that will require logged in subscribers to put articles in their shopping cart and check them out for $0. That is a really kludgy way to do this. I'm sure there have to be off the shelf access management systems that are not full blown merchant systems. Anyone able recommend a good one? Failing that anyone know a good source for software for the tiny end of the publishing spectrum?

On Edit: I think I've figured out the buzzwords. They are looking for a web site content manager that includes password management as well. Can't find one, but maybe that will help you help me. Or at least maybe someone can suggest alternate search terms for google. So far "Website content management" comes closer than anything, but does not quite hit what they want.

Sophia,

Here is something simple to try:

Create a new version of your query without any criteria. Create a new form. For the form's record source, select the new query you just made. Change the Default View of the form to Datasheet. Click on the Field List icon on the toolbar (if it's not open) and then drag every field (that you want to see) down to the form. Since the form is in Datasheet View you don't need to arrange any of the fields. Save this form.

Now when you open the form, it'll sorta' appear like a table or query view. You can right-click on any of the fields in order to sort or filter by that field. You can also enter wildcards. You can filter on one field and then filter on another and it will then use both filters at once. You can also select and move columns, and select more than one column at a time and sort by all the columns you've selected. And you can do a bunch of other stuff.

You could also create a report that will only print the records that you've just filtered for - ask me how!

Thanks tommy and Gud.

Thank Tommy, I haven't been helpful. I don't know enough about Access to offer any advice. I only use Access databases through ODBC.

Access makes a pretty good front end, in our experience. (If you don't mind a thick client.) Generally we use SQL Server as a back end. We will generally create most of the queries in Access, but if a query is too slow we'll convert it into an SQL Server stored procedure or view.

I think I've figured out the buzzwords. They are looking for a web site content manager that includes password management as well.

Could you just use some Wiki software, I'm pretty sure most, if not all, provide user management to read / edit articles. I've used docuWiki and I know there is user management to limit the ability to edit articles and I'm pretty sure you can limit reading as well.