I'm trying to use the code posted at http://www.andreavb.f2s.com/tip070012.html, but am having trouble with the reference to "pictObj" and "Printer". I am not new to vb, however I have never worked with the controls referenced in this post. Does anybody who has worked with...
Probably not the "right" way to do this .. but what works works, right? Here's what I'd do:
Create a select query grouped by State - Location - Person against your original table (query, whatever) - What this does is in essence create 1 record for each person within location
Create...
This isn't all that pretty, but it works and it's easy:
set the default values for the fields on your form to "*". That way, if they aren't entering data into the field, the query will return all results for that field. Then, in the where portions of your query, change the criteria...
Not sure why you would want to "prevent" users with Office 2000 from using your database, except that you don't want them converting the database and maintaining redundant information in 2 different db's. Assuming that you would like them to be able to use the db, here's what I've...
Here's the short .. try this (and see the MS Outlook Help for more info)
try this: (Assuming the text file you are looking for exists already)
dim EmailApp
Dim TheEmail
set EmailApp = createobject("outlook.Application")
Set TheEmail = emailapp.createobitem(olmailitem)...
I feel your pain .. I was just there a short time ago. Here's what I can suggest from what I've learned.
1. Any of your queries should be based on a form that is not based on a table (i.e. if you're looking to search by product #, then create a from with a text field called "product"...
I have an Access database set up to use the source code from a web page to build a table within my database based on portions of the HTML. For this to be effective, I need the source code to be updated every couple of minutes. Simply downloading the page (which is about 2 Mb), converting it to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.