Search results

So, for every record, you have an "album name" and then 21 columns for songs? (Along with some other stuff, I assume.) You need to find if a title exists in any of the 21 columns of any of your countless records? If that's correct, then I would go for a union query. These are actually supposed...

First off, I recommend some development in VBA - It's pretty powerful stuff. I ran away from it forever, and it only got me lost. BUT... I know it's difficult to implement others' VBA into your own database when you don't even know what it means.. So: If you're looking for a less-techie...

It sounds like you just need a query with two tables, and a relationship set between the title fields. That would return for you any titles in your CD table that also exist in your DVD table, as well as their respected prices. If that's what you want, all the info you need will be under the...

Pat, So I'm clear, are you suggesting giving a front end database, which will have the necessary forms/queries, to each user? The tables will be held in the backend, and will be accessed from the front end via linked tables. Am I correct? Andrew

Good point... Wouldn't you need a different .eml file (Saved outlook message) for each project? And then, the .eml would have to be updated whenever the the progress on the project (Or, whatever you're tracking) changed. That sounds a bit more sound. Perhaps a lot of work, though - If you have...

How long is too long? I've designed what I would call "shape-shifting" databases, designed for the purpose of being front-ends to as many differernt back ends as needed at a time. Speed was never an issue as long as I did not have a needless number of objects... If you're worried about the...

I agree... It would be a lot of work. I imagine though... You probably don't have to worry about sending events from Outlook to Access. If you devoted an entire computer to the task, couldn't you just schedule an Access App to open every minute or so? As long as you had Outlook checking for new...

I don't know if you can...With only Access. I imagine, however, that if one had lone computer devoted to the constant checking-of-email, processing-of-requests and sending-of-email...This would be possible. Outlook stores a user's mail in a file that can be opened with Access. (I think.) If...

So... I would try a different computer, with Access2002 installed. That just might not work. If not, all might be lost. That happens to me sometimes with this forum. I don't think this is the case with yigal7 (Correct me if I'm wrong) but if one were to get this error and one needed the data...

I don't suppose you could post the error message that you get when you open the database?

Your code is in my database. I never thanked you in the previous thread - So thanks! Andrew

I realize that this issue has likely been beaten to death in past threads; my recent participation in one brought this issue to light. Can I get a general feeling from participants concerning the dangers involved in the practice of compacting and repairing databases on a server? I greatly...

Pat, May I ask the reasons for not compacting on a server? Andrew

It seems that this mystery will never be solved: I went to test all of your suggestions only to discover that the problem no longer exists. I have made several changes to the database, including deleting an onInsert event (Perhaps the event caused this, since it was a new record the button was...

I understand exactly. I'll be training this afternoon, and I'll observe the scene a bit more carefully, and report on the results

We recently put together a database for a call center. The file is located on a public drive, and all users seem to be able to access the file (at the same time) and input new information. On one particular form, I've found an interesting problem: I've placed a button at the bottom of the form...

Addressing the same problem now... Two words: Transparent buttons. Does anyone else have a better idea? Love to hear it. Andrew

I've searched, and couldn't come up with a solution for this. Let me know if you can find a thread.. I've linked a dbase XL file into Access. When a user deletes the record in Access, it is of course deleted in the dbase XL file...Only (Just as in Access) the record is only marked for...

For future reference, I may have found a fix. It seems that clearning Firefox history and cache is not the same as clearing the IE counterparts... I assumed the info was stored in the same directory. This database appears to use IE protocalls when it seeks a URL and downloads it. That would...

Leave it to me to ask a question about my own, posted advice. Is there any reason why the database I posted above will refrain from downloading a url more than once? I think this is more of a Windows thing, but you all would know the issue either way. The DB downloads the file, but if I make...