Search results

Thanks, Greg, for the info. You're right, I should learn from it and take the best and build on it. There's no law against that. The concept is the important thing, and you can't copyright concepts and thoughts.

Hi Rob, One of my colleagues showed me his database design that is completely normalized and generic. You can use this for anything, whether a business manufacturing organization or products, or services, or non-profit. It's a sort of a "one-size fits all". He told me that it was...

Copyrighted Database Design? Hi Mark, I've looked at what you've written and found it helpful (but I will be looking in much more detail and have more to say soon.) One of my colleagues showed me his database design that is completely normalized and generic. You can use this for anything...

More "RPC server not available" problems Hi Jim and Travis! Thanks for opening this subject, I've been having some problems with it too. Travis, the code really helped. Now I can get my function to run once, but the second time I run it, I get the infamous message "RPC server not available"...

Constants Thanks Drevlin! Duh, I guess I just showed what a novice I am. Well, anyway, I guess I have to learn this a little bit at a time. I've used the bookmark bit that jwindon posted here...

Winword Macros The statements that have "wd" in them usually do not work. Is there some list of which commands will work and which will not?

Function RunWordMacro() Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set...

"I've found that the following code will allow you to copy and paste your vba macro directly from Word (or Excel) into Access and just by adding "." in front of the applications members will run the macro...Anyway, this works for me. as a note: I didn't do error checks to make sure the file...

Thank You! This worked great. I got the stupid runtime error '2293' when I was trying to send a form via email (wouldn't have worked anyway, I wanted information from a subform), but thanks for putting up this code to send this object, this works great. I'll just be sending text out using...

Thanks Rich! I'll look for sub-queries I could use the queries, but the problem is that it will be a little "ugly", using a hidden "dummy field" on the form. And I'm constantly running into limitations with this SQL query think in visual basic (limit 10 lines, for example) and there also...

Why flattening the query doesn't seem to be an option Hi Rich! These three queries, especially the first one, are extrememely long. And as far as I can tell, they cannot be shortened. The second query is a parameter query for a date. It requires one date, whereas in my modification I have...

Hi! I'm using layered queries in an application. The 2nd query uses the 1st query as its data source, and there is yet a 3rd query that uses the 2nd query as a datasource. So this thing is stacked 3 layers high! 1st query - queries a table 2nd query - queries the 1st query 3rd query -...

Thank You So Much! This last day of the month function is great! I'm replying to Raskew, above.) I really appreciate you putting this up. It is so short and simple and effective. I'm using it to set parameters for an sql query to open a report, as well as to automatically generate two dozen...