Search results

While that makes sense, but I wish MS gave the option to only purchase the developer extensions (with licensing options). It's getting increasingly difficult to convince those above me that this would be a good purchase, when that is all I really need. Why does this situation seem to be so all...

Question: I notice that I have ACCESSRT.msi and ACCESSRT.CAB on my MS Office Professional CD. Why would I need VSTO? For the packaging wizard? Why can't I just install these files on the computers of my users and then an .mde file? Why would they have included these files if this wasn't their...

Yes, that's what I was thinking, but I just can't get how to give them a set schedule that's daily assigned. There are days when they won't completed assignments, there are also days when they'll pick up MORE assigments.

I need some basic help designing an environment where jobs can be assigned to personnel. Typically they'll have the same "job" every day, but if someone is absent then their job must be reassigned, distributed among the others. The large assigment of job can be done automatically on a daily...

No examples, but it's turning out to be easier than I thought to do... The key is to go to the www.mysql.com page and download the ODBC driver. Once you do that you can set up your tables in mySQL (which is not too bad at all with a decent knowledge of databases). From there you can link the...

Would this be a difficult thing to do... or is there an "easy" way to do it? I'll love to turn my app into a web based app! Are there any helpful GUIs that would assist me in doing such a thing? Here am I just getting my access application to work how I want, and now I want to move on...

Yep, I just figured it out and that's pretty much how I did things. Thanks for the help...

This has been a nightmare all around. Because I can't get 40 licenses for Access I'm stuck doing transferspreadsheets every day, which has worked out mostly, but I'm reaching the absolute limits of my knowledge. I can't even think straight and need help with a solution. Here is the table data...

edit: Double posting, sorry.

Not really. I've modified what you uploaded to show... What you'll see is a list of name (sans "*") where they're assigned to team, then you'll have your list with the "*" at the end of their names as well. Then the query where I want to have each name (even with the "*") to have a Team next...

Wasn't my decision. I was brought in after any of these decision were made and believe me, it will be changed going forward. I'm basically pulling in 6,000 Excel sheets, adding a date column and a "Team." It's all worked out so far, but for some reason I can't get this part to work. I've...

I have a large database that I need to add a "Team" (Pacific, Easter, Central) in front of each entry. Each enter has the name of an Editor, which is easy enough since they are assigned teams and another table has their names with the team they are assigned. The tough part (for me) is that...

I was lucky just to get a license for MS Access myself!

I have looked at that, but don't have a developer edition. It's too bad because all I really need is a one button form that can run the query!!!

I have considered the scheduler, but anything that could go wrong in that situation probably would go wrong. If it turns out to be my only choice, then so be it, but I'd like to find a more "elegant" solution. Are there any ways to execute commands through Data Access Pages?

Is it possible to run a query that's inside an Access database from another program? Possibly excel. I continue to run into walls with the fact that I can't get my company to buy licenses for Access to put on PCs. I'm determined to work around these issues, but there are obvious limitations...

Going to try to work with this using Visual Basic Express Edition 2005 (it's free ;) ). May not be the "easiest" or the "best" way, but it's something I've wanted to learn for quite awhile now anyway. Wish me luck (I'll likely need MUCH of it).

What about using a Data Access Page, or am I just looking for trouble doing that? They have an MS Office license, just not an MS Access license. Also, it appears that you can get a Java IDE for free. Would that be an option, or will it not connect to an Access db very well. I know just...

What's the best way to go about this? Right now I have about 40 personnel using 40 different Excel files. Each day, each file needs to be copied and pasted into one large file. I've recently had luck replacing several of my personal Excel files with MS Access and now completely hooked on...

Much thanks!