mailing......urgent

[Tech]

Hi there.

this is an urgent request. It's for a friend of mine, I offered to help, but of course, came to some problems, I hope u can help

in this database (on my server, please download)

ftp://temp:temp@techftpserver.co.uk/radjobs.mdb


I want to be able to create a simple query that matches up a candidate skills to a skills table, eg:

candidate 1 has skills of databases, and in the skills database/table, it has a reserved job of databases. i want this query.

however, it doesn't work it worked for another SIMPLE database, this one, just shows nothing

even if I just drag 2 fields from one table, nothing!

anyway, please help me on this part, then there is another simple part which I need help with

thanks

apart from this, this is the real VBA question:

I want to be able to email a report to a person from the touch of a button, how do I do this? I know the button wizard CAN do it but doesn't fill in the TO section.......

how do I do it in vb?

please, this is urgent, suppose to be for 2morrow.

 

[bodhran1]

I can't help you with the first half, sorry!

But to send email from VB, use the command:

DoCmd.SendObject



dp

 

[WayneRyan]

Tech,

Your joins are all wrong.

First start with just the clients and vacancy tables in your
query.

Join on just the skill field.

Then double-click on the name and skill fields.

Then add the customer table and join it with the vacancy
table on the id field. Then select the customer's name
to be displayed.

Then experiment, you'll get it.

hth,
Wayne

 

[Tech]

LIFE SAVERS!!!

thank-you

Wayne, thanks for that but I don't quite follow, there is no customer table etc...

and what do u mean by join? and what about the third table that I am suppose to join to the ID? :s

bodhran1:

DoCmd.SendObject

this is the one I was looking for, what are the paramaters, if I may??

 

[Tech]

I still can't get the query to display anything, did u?

 

[Tech]

its ok..scrap the query part...

but can i still have the parameters of the docmd.sendobject please?

ta!

 

[WayneRyan]

Tech,

Sorry, got your table names confused.

Start with the candidate and vacancy tables. In a new query
bring in both of these tables. They both have a "Skill" field ...
So ... drag the skill field in one table to the skill field in the
other. They are now joined. If you right-click on the line
you can specify HOW they are joined. That comes later.

The query still won't return anything yet. We should select the
skill and name by double-clicking on them in the client's table
and the description from the vacancy table.

Now save and run the query.

Back in design view you can add the client table. Join the
client field in vacancy with the id field in client. Then
double-click on the client name field.

Run it and experiment.

Wayne

 

[Tech]

thanks a bunch, I REALLY do appreciate it, but still it won't work I saved the query and it's on the server...

it's called matching query in the MDB file..

 

[bodhran1]

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

 

[Tech]

thanks any exact URL to that info? cause I need to know what the parameters accept......

thanks

 

[Tech]

it's ok..me got it..

ta!

still having trouble with that query..

 

[Tech]

i don't quite understand the objectname parameter.....how does this work? I like to send a report with this email.....let's say it's called report of vacancies....how do I attach/use this method for this?

 

[Tech]

hello? anyone?

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

how do I use the objectname parameter? an example please!

 

[boblarson]

Tech:

It's good to try to get used to being able to use the Access Help File as well. It has quite a lot of info, and in the case of your question of what is the objectname - it tells you:

A string expression that's the valid name of an object of the type selected by the objecttype argument. If you want to include the active object in the mail message, specify the object's type with the objecttype argument and leave this argument blank. If you leave both the objecttype and objectname arguments blank (the default constant, acSendNoObject, is assumed for the objecttype argument), Microsoft Access sends a message to the electronic mail application without an included database object.
If you run Visual Basic code containing the SendObject method in a library database, Microsoft Access looks for the object with this name first in the library database, then in the current database.


Anyway, if you started by typing in DoCmd.SendObject in your code window and hit F1 then it would show you the definiitions. And if the F1 doesn't work for you, then select HELP from the menu in the code development window and go to the index.

 

[Tech]

lol. i know i know, I have that but I need an example on how that part works, I don't understand the defenition, please, help or give an example

 

[boblarson]

If you're sending a form, then you would put the name of the form, in quotation marks. If you are sending a query, you would put the name of the query, in quotation marks.


For example, if I have a query that is named qryMyQuery that I am going to send, I would go:

docmd.SendObject acSendQuery,"qryMyQuery" ... etc.

 

[Tech]

thanks!

 

[bodhran1]

Tech,

I can sympathize with you. I HATE the help files with a passion. I would have failed a long time ago if not for this group.

Here's a simplified example.

Good luck,

Dave


DoCmd.SendObject , , , "dpasquino@actechdrives.com", , , "title of email goes here" , body of email goes here, False